A/J Transaction Import Process
This process is especially useful for importing payroll transactions from
other systems—avoiding time-consuming manual re-entry into Contract Collector. The
system validates CHART OF ACCOUNT numbers and dates before accepting each transaction. If an error is detected
during the import process, the process stops at the last valid record and
invalid records are not processed.
Import files must be comma-delimited ASCII files with carriage returns and
line feeds. The required order of the data in the file is controlled by an ASCII
text file named AJIMP.CFG, located in the same sub-directory where you
originally installed Contract Collector (usually CW).
The default field order of the AJIMP.CFG file is as follows:
DATE, AMOUNT, DESC, DBACCT, CRACCT, COMPANY ID, ENDREC
You must either match this default field order when exporting the data from
your other system, or you can edit the AJIMP.CFG file to match the order of the data as it is exported from the other system. ENDREC (for multi-line adjustment imports) indicates the end of a record with a zero
(0). A one (1) indicates a line in a record. It's end is the next line with a
zero (0). To change the field order of AJIMP.CFG, use any text editor (such as
the Windows NOTEPAD).
The format of the data in the import file must conform to the following
specifications:
Date Formats
Enter the date as either MMDDYY, MM-DD-YY or MM/DD/YY.
Description Annotation
The DESCRIPTION ANNOTATION can be any length, but the import process truncates any description over 30
characters long. If the description contains a comma, it must be surrounded by
double quotation marks.
Amount
Do not include commas or dollar signs. Numbers without decimals are assumed to
be whole numbers. For example, 210 would be read as 210.00.
Debit Account
This number must be a valid debit account in the Contract Collector CHART OF ACCOUNTS file of the company receiving the import.
Credit Account
This number must be a valid credit account in the Contract Collector CHART OF ACCOUNTS file of the company receiving the import.
Company ID
This number must be a valid company ID of up to four alphanumeric characters.
Enter Import Transaction File Location
In this field, type the complete DOS filename—including the complete directory
path if necessary—of the file containing the data to be imported into the ADJUSTMENTS JOURNAL.
EXAMPLES: C:\PAYROLL\AJS
D:\CW\IMPORT.TXT
A:\DATA
Audit Report Output
Choose a printer to print an AUDIT REPORT. This report lists any errors encountered during the import process, such as
incorrectly formatted data.
Report Type: 
Summary 
Detail
SUMMARY reports provide the overall status of the import process. For example, the
report may say TOTAL RECORDS TO IMPORT: 12 TOTAL RECORDS IMPORTED: 12.
DETAIL reports provide information about each record you have imported. This
information is provided with each record. Because it takes longer to run, only use the DETAIL report if you are having trouble with the import process.
Preview Pass
Turn this check box on if you want to do a test run of the import process.
When this check box is on, no data is actually imported, but the AUDIT REPORT (see previous field) is printed so you can test for any problems. This
checkbox is set to off by default.