Flat file (Media 40)

This format is ideal for importing into systems that are unable to accept data split over multiple files. Such packages include Goldmine, Act and Maximizer, Microsoft Access and other database systems.

The information included in the file is a cut-down from the full set that is available. This ensures the size of the file is manageable. The project information is duplicated for each company working on a project (i.e. three companies working on one project would create three lines in the data file).

The file is a comma-separated format; strings are enclosed in double quotes. Records are separated by new-line. All date-types have the format ‘DD/MM/YYYY’. The first row contains the field names.

Company File Specification in ASCII Format
Name Type Length Description
Cyno Number 9 Company id. This uniquely identifies a company.
Role String 20 Role company is playing on a project.
Design String 10 Designation/salutation for contact person.
Title String 24 Title for contact person.
Fname String 20 First name for contact person.
Lname String 40 Family name for contact person.
Pnphone String 32 Telephone number for contact person.
Email String 60 Email address for contact person.
Cyname String 40 Company name.
Cyname2 String 40 Company name [extended].
Cyaddr1 String 40 Company address.
Cyaddr2 String 40 Company address.
Cyaddr3 String 40 Company address.
Cyaddr4 String 40 Company address.
Cypcode String 8 Company postal code.
Cyphone String 32 Company phone number.
Cyfax String 32 Company fax number.
Cyurl String 60 Company URL.
Ptno Number 9 Project id. This identity stays with the project throughout its lifetime.
Reportdate String 8 Report date. Equal to system date at time of generation.
Pttitle String 80 Project title. Brief description of project.
Ptsite1 String 40 Project site address.
Ptsite2 String 40 Project site address.
Ptsite3 String 40 Project site address.
Ptsite4 String 40 Project site address.
Ptpcode String 8 Postal code of project site.
Value String 16 Project valuation.
Stage String 20 Stage of project.
Devtype String 20 Development type.
Tenderclose String 10 Tender closing date.
Contracttype String 60 Contract type.
Startdate String 30 Contract start date.
Finish String 30 Construction completion date.
Period String 4 Length of works.