Import Samples Descriptions

These sample import maps are provided in the DEMODB database. If you do not have these samples, please contact Collect! Member Services by email at support@collectsoftware.cc and ask for the latest Sample Import Maps.

The data files used for each import map are located in the Import subfolder of your Collect! application directory, that is, c:\CV11\import.

Please especially note fields that import dates. Dates can be formatted in many ways in a data file. To import correctly, use the Date Options form. To open the Date Options form, select the button labeled Date Options in the Import Field Specification Form.

Imports using *.csv files must map in the same order as the fields occur in the data file. Leave the field empty to skip that data when importing.

Import Record Samples

Debtor
Uses the debtor.csv file. Please refer to Debtor File Format for details.

Client
Uses the client.csv file. Please refer to Client File Format for details.

Transaction
Uses the transaction.csv file. Please refer to Transaction File Format for details.

Attachment
Uses the attachment.csv file. Please refer to Attachment File Format for details.

Debtor Cosigner
Uses the cosigner.csv file. Please refer to Debtor Cosigner File Format for details.

Technical Notes

By default, Collect! interprets the Name field as Last Name, First Name and the Contact field as First Name Last Name. When importing to either of these fields, Collect! will flip the name into the other field correctly. (i.e. if importing into the Name, Collect! will flip the name correctly into the Contact field.)

When setting interest on accounts, a principal transaction must be created in order for the interest to calculate correctly.

Third Party Import Samples

Sample EDIs
Several import samples are included from common skip tracing and check processing providers.

TCN Imports Several import samples are provided for use with TCN Service for processing call campaign.

Additional Import Samples are available at our Member Center web site.