Detailed Field Information Related Information Examples & Tutorials
Want new features? Check out the news on the latest version of Collect! available. Members can download new enhancements FREE! Interested in new features available but not currently on a Membership? Please contact us for pricing. Enhancements may be purchased separately.
“ We have been using Collect! since the inception of our business back in 1999. ” Corey B.

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 RMA ACA Member