# Export/Import Subscription Rates

This option is used to export subscriber rates, modify them in Excel or other third-party program, and import the changes back into Circulation. For example, you may want to create a new promotional rate structure that is similar to an existing promotional rate structure.

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

#### Keep the following tips in mind when modifying rates:

* When importing new rate information, be sure to include all files that pertain to the rate. For example, if importing new auto pay terms for a combo, include both the Auto Pay Terms and Auto Pay Terms By Product Mix files.
* 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.
* For flat rates, you need to change only the Total Amount figures.
* For amount-by-day variable rates, ignore the Total Amount column and enter information only in the weekday *amount* columns. The Total Amount is ignored during import, and will be recalculated in Circulation.
* For percent-by-day variable rates, enter information in both the Total Amount and *weekday* percent columns.
* Day pass rates will be ignored by Export/Import Rates.

### Import or export subscription rates

1. In Graphical Setup, select `Accounting | Subscription Rates | Export/Import Rates` to display the Export/Import Subscription Rates window.<br>

   <figure><img src="/files/3LS0eBg0ufOTmbyvOPZG" alt=""><figcaption></figcaption></figure>
2. Click **Add** and enter import/export information in the fields described below.<br>

   <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p>When exporting rates, you specify the rates you wish to export, as well as the names of the files that will be created in the <code>/dti/exchange/cm</code> directory. For example, location rules associated with the selected rates will be exported to a separate file, whose name is specified in the Location Rule field. When importing rates, specify the files to be imported from this directory.</p></div>

   <table><thead><tr><th width="165.33333333333334">Field</th><th width="118">Type</th><th>What to enter</th></tr></thead><tbody><tr><td>ACTION</td><td>predefined</td><td>Indicate whether to import or export subscriber rates.</td></tr><tr><td>READ OPTION</td><td>predefined</td><td>If importing rates, indicate whether to run the import in edit mode (rate changes will be validated but not updated) or commit mode (rate changes will be updated in Circulation).</td></tr><tr><td>PRODUCT</td><td>setup</td><td>If exporting rates, select the product whose rates should be exported (you can choose multiple products by selecting “*” in the pull-down list).</td></tr><tr><td>RATE TYPE</td><td>predefined</td><td>If exporting rates, indicate which types of rates should be exported (Balance Forward, Normal, Reduced, Retail, Promo), or multi-select types.</td></tr><tr><td>SEARCH DATE</td><td>date</td><td>If exporting rates, enter the export date. Only rates active on this date will be exported.</td></tr><tr><td>RATE CODE</td><td>setup</td><td>If exporting rates, select the rate code to export, or multi-select rate codes.</td></tr><tr><td>FILE NAMES</td><td>open (20)</td><td>If exporting rates, enter the names of the files that should be exported for each category of rating information. If importing rates, enter the files that should be imported (they must exist in the /dti/exchange/cm directory).<br>In either case, if you leave a field blank no data will be exported/imported for that category. For example, if exporting rates and a file name is specified only for RATE TERMS, only rate terms information is exported.<br>Note: The Auto Pay Terms by Product Mix and Rate Terms by Product Mix fields pertain only to combo rates. The amounts assigned to each component product in the combo is exported/imported in these files.</td></tr><tr><td>FILE DELIMITER</td><td>predefined</td><td>Specify the delimiter used in the import or export file. This field is required when <strong>ACTION</strong> is set to <strong>Import</strong> or <strong>Export</strong>. Supported values include <strong>Comma (,)</strong>, <strong>Tab</strong>, <strong>Semicolon (;)</strong>, <strong>Pipe (|)</strong>, and <strong>Space</strong>.</td></tr></tbody></table>
3. Select **OK**, and then select **Continue** to begin the process.\
   A report displays the files that were exported or imported.\ <br>

   <figure><img src="/files/qmKevGa9ST04aJs8UEAQ" alt=""><figcaption></figcaption></figure>

   <figure><img src="/files/6kVJDC2AeVCXe1PAMe8v" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.navigaglobal.com/circulation-setup-manual/accounting/subscription-rates-menu/export-import-subscription-rates.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.