- ContentsQuick LinksAccount Analysis landing page Accounting landing page AIM help AIM Receiver help Arrangements landing page Batch Processing landing page Custodian help Dashboard help Data Exchange landing page Dialer Campaigns landing page Exchange Manager help Invoices help Latitude help Latitude Console help Letter Console help Letters landing page Link Console help List Builder help Portfolio Manager help Reporting Console help Reporting landing page WorkFlow Designer help Work Queues landing page
AIM Help
Export File Layouts
Use the Export feature to export files to agencies or attorneys to use to update accounts. If records exist that are ready for export for the specified file type, you can create the export files.
Note the following:
-
Export files use the letter "C" as the first character in the export file name to indicate that the file originated in AIM. For example, CXXX. AIM uses this same format in the record type name in delimited and fixed files.
-
ASCII flat files are fixed length or delimited (comma, tab, or pipe).
-
Excel file names have the ".xls" extension.
-
If a date field contains "19000101," interpret it as NULL.
-
Dates must be blank or contain a valid date; AIM doesn't allow zero-filled date fields.
-
AIM formats date fields for delimited and fixed-length files as CCYYMMDD and for Excel and XML files as MMDDCCYY.
-
AIM expects a decimal point before the last two digits for monetary fields.
-
For agencies and attorneys that use the YGC file format, see YGC Export File Layouts.
Related Topics
Demographic Export File Layout
Miscellaneous Extra Data Export File Layout