Export/Import Account Rates

This option is used to export account rates, modify them in Excel or other third-party program, and import the changes back into Circulation.

To export or import account rates:

1. In Graphical Setup, select Accounting | Account Rates | Exp/Imp Acct Rates.

2. Click Add.

   

3. Complete the fields described below.

   Field	Type	What to enter
   ACTION	predefined	Select Export or Import. If Export is selected: • Specify the Product, Rate Type, Search Date, and Rate Code(s) to export. • Enter file names for the export files in the /dti/exchange/cm directory. • If a single Rate Code is linked to multiple Products, and multiple products are selected, all active data for that Rate Code will be exported. • Press F2 in the Rate Code field to display valid rate codes. If Import is selected: • Specify the file names to import. • Files must exist in the /dti/exchange/cm directory. • If running in Edit mode, changes are validated but not updated. • If running in Commit mode, changes are updated in Circulation.
   READ OPTION	predefined	If importing, select Edit to validate only, or Commit to update account rates.
   PRODUCT	setup	If exporting, select the product whose account rates should be exported. Multiple products may be selected.
   RATE TYPE	predefined	Indicate whether the account rate is Per Copy or Per Period.
   SEARCH DATE	date	If exporting, enter the date to determine which rates are active. Only rates active on this date will be exported.
   RATE CODE	setup	If exporting, select one or more account rate codes. Press F2 to view valid rate codes.
   FILE NAMES	open (20)	Enter the file names for the data to export or import. Leave a field blank if no data should be processed for that category.
   UPDATE DESCRIPTIONS	yes/no	Select this checkbox to update the route rate class descriptions with the descriptions contained in the imported file. Applies during import only.

4. Select OK and continue processing.

   

Note:

1. The formats of the files that are exported and imported are given in Appendix B of the Circulation User Manual.

2. For each imported rate, the start date you have defined will be the effective date of the changes. When the records are imported back into Circulation, the old records are end-dated one day prior to the start date you defined.