Feedback

  • Contents
 

Configure a Maintenance Import File

Use the Maintenance tab on the Import Files tab to configure an import file for account maintenance.

To configure a maintenance import file

  1. In the Navigation pane, click Clients.

Clients pane

  1. In the Clients pane, expand the appropriate folder and then double-click the client. The tab for the specified client appears in the Information pane.

General tab

  1. Click the Import Files tab and then click the Maintenance tab.

Import Files tab - Maintenance tab

Modify File Source Layout: Opens the Define Import Layout window to allow you to define the layout of the import file. For more information, see Source File Layout.

Modify File Mapping: Opens the Data Translator window to allow you to map the source import file to the Latitude database. For more information, see Import File Mapping.

Uses Excel: If selected, the import file is an Excel file. Each row in the Excel file contains one record only.

Customer:

Prompt: If selected, Exchange Manager prompts you during the import process for the client to associate to the accounts.

Predefined: If selected, allows you to specify the client to associate to the accounts.

[Client]: Name of the client to associate to the accounts. If you selected Predefined, specify the client name and Exchange Manager associates it during the import process.

Use From File: If selected, Exchange Manager associates the client specified in the import file to the accounts.

Note: If you use Number as the Unique Account Criteria, select Use From File, even though you don't have to map it.

Split File?: If selected, Exchange Manager splits the import file based on the number of rows and the regular expression that you specify.

Number of Rows: Number of rows to include in the file split.

Regular Expression: Regular expression to use to limit the file splitting.

Configure Service History: No longer used.

Update Linked Accounts: If selected, Exchange Manager updates customer demographics for linked accounts. Applies to the primary customer (debtor0) only.

Process Opened Batches: If selected, Exchange Manager applies the payments in the import file to the accounts. Exchange doesn't include adjustments created from reopening accounts and resetting balances.

Pre Account Procedure: Stored procedure to call before processing each account.

Post Account Procedure: Stored procedure to call after processing each account.

Execute this stored procedure before processing the first record: Stored procedure to call before processing the first record in the import file.

Execute this stored procedure after processing the last record: Stored procedure to call after processing the last record in the import file.

Current Account Values: If selected, Exchange Manager adds the field to the Source tab in the Data Translator window. Exchange Manager uses these fields to determine how to process an account based on a current value. For example, if current0 > 1000, update the value.

Configure Duplicate Handling: Opens the Duplicate Config dialog box to allow you to specify how to handle duplicate records. For more information, see Configure Duplicate Handling.

  1. Complete the information and then, in the toolbar, click Save. The Update Comment dialog box appears.

  2. In the Update Comment box, type a comment regarding your changes and then click OK.

Related Topics

Source File Layout

Import File Mapping

Configure Duplicate Handling

Import Process Configuration

Import a Maintenance File