Router Import

Note: The Router Import option is a licensed add-on feature. You must license and activate the “Router Import” add-on record before you can use it.

This option imports router changes from an external file in the RouteSmart format. To export Circulation route information, you generate the Route Delivery List report with a report type of “Export.”

The basic process is as follows:

• Export Circulation’s route information to a file that can be read by RouteSmart. The Route Delivery List report, which is run as an export using a predefined “RouteSmart” file map, accomplishes this.

• Import the file into RouteSmart and make the necessary route-boundary modifications. Then, export the route information from RouteSmart. Be sure to export all of the addresses for each route that was changed.

• Using the new Route Import option, import all of the route information back into Circulation.

• Run the Route Reassignment option to create reroute transactions for subscribers who are now on different routes.

To use this option, you will need to create a new file map with a usage of “RouterImport”. The data elements that can be used with this file map include AAM Zone ID, Address ID, New Route ID, Old Route ID, Product ID, and Record Identifier. All elements except AAM Zone ID and Record Identifier are required.

Note: If a route was changed in RouteSmart, all addresses on that route should be exported from RouteSmart and re-imported into Circulation so that the router is rebuilt completely. The Router Import utility will not append routes; it will replace them completely.

To import router changes:

• Select Utilities | Import | Router in Route Service to display the Router Import window.

• Click Add.

• Complete the following fields:

  • Read Option—Select Edit to produce a report of the router changes that would have been made if Commit were selected. Select Commit when you are ready to update the database with these changes.

    • When run in “Commit” mode, the Router Import will

      1. make a backup copy of the current router tables (i.e., Router, RouterRoute, RouterPublication, and RouteAddress) in the default exchange directory,

      2. delete all of the router-related records for both the old and new contained in the input file,

      3. build a new set of router-related records for the “new” routes contained in the input file, and

      4. produce a report of the new router segments that were created.

  • File Format—Select the file map that you created for this import.

  • File Name—The file name will default from File Map setup, but it can be changed. The file must be located in the default exchange directory.

4 Click OK to run the import.