Importing Route Table Entries

If you have a route table requiring a large number of entries you can use any text editor to quickly create the entries and then import them into a Route table in ClientView.

 

Summary of Steps

  1. Create Route Table template in ClientView
  2. Export File
  3. Add Entries to File
  4. Import File into Route Table

 

Procedure

Create Route Table Template in ClientView

  1. Right-click Routing Configuration and select New Routing Tables.

    sc_tree_rt.png
     

  2. Right-click Routing Tables and select New Route Table.

    sc_tree_routetable.png
     

  3. Name the table and change the default ID and Routing Criteria Order if desired.

    sc_rt_import_example.png
     

  4. Commit the configuration.

    sc_commit_rt.png
     

  5. Right-click on the table name in the object tree and select Add Route Entry.

    sc_tree_route_entry.png
     

  6. Configure the entry to closely match the requirements of all of the entries you will be creating. When you export the file and use a text editor, you will be creating multiple versions of this entry and then changing fields, such as Router String, in each entry as required.

    sc_rt_entry_import_ex.png
     

  7. Commit this configuration.

    sc_commit_rte.png
     

 

Export File

  1. Right-click the Route Table in the object tree and select Export To CSV.

    sc_tree_export-to-csv.png
     

  2. In the Export to CSV dialog box, name the file and click OK. The file is saved to the opt/dialogic/common/import_export folder.

    sc_export-to-csv_dialog.png
     

 

Add Entries to File

  1. Locate the *csv file and open it in any text editor.

  2. Select the row containing the entry that you configured in ClientView and select File - Copy

  3. Paste the number of rows for the entries you require.

  4. Edit entries as required. Make sure you give each entry a unique Entry ID.

  5. Save and close the file.
     

Import File into Route Table

  1. Return to ClientView

  2. Right-click on the Route Table you are adding the entries to and select Import From CSV.

    sc_tree_import_rt.png
     

  3. In the Import From CSV Dialog Box, browse to the file, select it, and click Open.

    sc_import_rt_dialog.png
     

  4. In the next dialog box that appears, select Use Import File Entries.

    sc_import_rt_dialog1.png
     

  5. In the next dialog box that appears, select the desired action if errors occur during the import process.

    sc_import_rt_dialog2.png
     

  6. A dialog box will appear indicating the records were successfully imported. It will also indicate the location of the report file created during this import process.

    sc_import_rt_dialog3.png
     

  7. Click OK to proceed.

The Route Table will be populated with the entries you added to the file.