TARGET Sales Management System - Application Notes

Exporting data - file layout

The file (normally called prospect.txt) produced by the TARGET data export mechanism is a standard DOS text file; each record is terminated by a carriage return-line feed pair. Each field is enclosed in double quotes and the fields are separated by commas. The fields are also fixed lengths so they may be opened by programs that require that format. Details of the data layout are shown below. Note that byte offsets are relative to zero and do not include the quotes or commas. The first field starts at offset 1 because offset 0 is the opening double quote on that field.

Byte offset(s)     Field content     Notes
001-040 Company name
044-083 Address 1
087-126 Address 2
130-153 City
157-158 State/Prov Applies only to D/C
162-171 ZIP/PostCode Applies only to D/C
175-178 Country code Applies only to F - dialing code from US
182-211 Contact name
215-226 Telephone
230-269 Email address
273-312 URL (web address)
316-327 Fax number
331-331 Mail code D=domestic (US), C=Canada, F=other
335-335 Prospect type D=dealer, E=end user
339-378 Country Applies only to C/F
382-385 Area/region Local meaning
389-392 Salesman
396-401 A/R cust code
405-410 A/P vendor code
414-423 Selection codes
427-430 SIC
434-434 Bulk mail OK If Y, bulk mail allowed
438-438 Bulk fax OK If Y, bulk fax allowed
432-432 Bulk email OK If Y, bulk email allowed
434-435 Terminators CR/LF character pair
Total record length including terminators is 436 bytes

Return to exporting data | Return to topic list | Return to TARGET page | Return to HSI homepage