Importing an ASCII contacts file
Trackbase Pro can import companies (and optionally people related to these companies) from an ASCII format as specified below. To do so, prepare the contact information in the defined format, then click "Data Manager" (pull-down menu) from the main menu and select "Import contacts from ascii...". This is import data from the files c:\cy.txt and c:\pn.txt. The latter file is optional, so the message "People Import file not found ('c:\pn.txt') can be ignored if this file is deliberately missing.
Company File Specification
| Field | Data type | Description |
|---|---|---|
| id | number(9) NOT NULL | Company identification number |
| userid | number(3) NOT NULL | User identication number |
| name | varchar(200) | Company name |
| address | varchar(1000) | Company address. See note 1 |
| phone | varchar(40) | Company telephone number |
| fax | varchar(40) | Company fax number |
| geocode | char(10) | Location of company. Download codes |
| geo2 | char(10) | Normalised postal code. See note 2 |
| empty field | reserved | Reserved |
| ud | date | Date of last updated |
| empty field | reserved | Reserved |
| empty field | reserved | Reserved |
| rd | date | Date of creation |
| varchar(100) | Company email | |
| empty field | reserved | Reserved |
| empl | number(4) | Number Of employees. Download codes |
| turn | number(4) | Company turnover. Download codes |
| empty field | reserved | Reserved |
| empty field | reserved | Reserved |
| empty field | reserved | Reserved |
| empty field | reserved | Reserved |
| rptr | number(4) | Reported by |
Note 1: Address lines should be delimited by \x0d\x0a
Note 2: This is a normalised version of the post code, used by selections.
e.g. CH64 7UX would be 'CH64', L1 1TT would be 'L-01' and LL1 1TT would be 'LL01'
Person File Specification
The optional file containing the people (c:\pn.txt) should be comma delimited, with quotes (") around the text. The fields must be as follows:
| Field | Data type | Description |
|---|---|---|
| id | number(9) NOT NULL | Person identification number |
| userid | number(3) NOT NULL | User identication number |
| cy_id | number(9) NOT NULL | Company identification number |
| cy_userid | number(3) NOT NULL | User identication number (for the company) |
| lastName | varchar(100) | Surname |
| firstName | varchar(100) | Christian Name |
| design | varchar(50) | Mr, Mrs etc. |
| title | varchar(50) | Job title |
| phone | varchar(50) | Telephone number |
| ud | date | Date of last update |
| varchar(100) | Person email addres | |
| jobfnc | number(4) | Job function. Download codes |
Example files
The links below provide examples of the ASCII files, complying to the specification above. The company file contains two companies. The person file contains two people relating to each of the two companies.
