Detailed Field Information Related Information Examples & Tutorials
Do you need a special functionality, process automation or report? Check out the Collect! customization services. Available to all but rates are discounted for Members. Membership has it's perks!
“ Its features in grouping debtors/persons are very helpful for our business. ” Ken W.

Import Record Options

This form controls some key factors when performing complicated importing and exporting procedures. This is an ADVANCED feature. You can choose data based on additional identifiers when importing, and can control some output options for exporting. These options apply to fixed length files only.

Id2

ID2 and ID3 are unique identifiers used in the same way as the ID field in the record form. In fixed length files formats, you can use this additional ID to further examine and choose data.

Top of page.

Id2 Offset

Offset specifies the position from the first column where the identifier is found. Since the primary ID is usually at offset 0, normally you will need to enter a number here.

Top of page.

Id3

ID2 and ID3 are unique identifiers used in the same way as the ID field in the record form. In fixed length files formats, you can use this additional ID to further examine and choose data.

Top of page.

Id3 Offset

Offset specifies the position from the first column where the identifier is found. Since the primary ID is usually at offset 0, normally you will need to enter a number here.

Top of page.

Default Terminator

This causes a line feed character (0xA) to be inserted at the end of each exported record.

Top of page.

Null Terminate

This causes a NULL character (0x00) to be inserted at the end of each exported record.

Top of page.

No Terminator

Do not append any character at the end of exporting the record. This also stops the line from being padded to its defined width if the line width of the fixed length export is specified.

Top of page.

CR/LF

This causes a carriage return (0xD) and line feed character (0xA) to be inserted at the end of each exported record.

Top of page.

Header

This switch causes the data in the record to be placed at the top of the file when exporting. This is usually only set on the Accumulator record type for managing some complex export file formats. This is used in conjunction with the Accumulator field in the Import Field Specification form.

Top of page.

Help

Press this button for help on the Import Record Options dialog and links to related topics.

Top of page.

Cancel

Select this button to ignore any changes you may have made and then return to the previous form.

Top of page.

OK

Selecting this button will save any data you have entered and return you to the previous form.

Top of page.

See Also

- File Format Specification
- How To Use Import/Export
- Import Menu
- Export Menu
- Import/Export Topics

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org

Collection Advisor Veracode Verified RMA ACA Member