Mail merge file (Media 43)

This format that is ideal for performing mail merges and 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 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
Ptno Number 9 Project id. This identity stays with the project throughout its
lifetime.
Reportdate Date   Report date. Equal to system date at time of generation.
Last_report String   Date previously reported (null, if new).
Pttitle String 60 Project title. Brief description of project.
Ptsite1 String 60 Project site address.
Ptsite2 String 60 Project site address.
Ptsite3 String 60 Project site address.
Ptsite4 String 60 Project site address.
Ptpcode String 10 Postal code of project site.
Value Number   Project valuation.
Stage String 60 Stage of project.
Devtype String 60 Development type.
Gridreference String 32 Grid reference.
Status String Long Status of project.
Scheme String Long Description of project.
Details String Long Details of project.
Program String Long Timing of project.
Contract String 60 Contract type.
Role_n
 String 70 Role company is playing on a project.
Cyno_n
 Number 9 Company id. This uniquely identifies a company.
Design_n
 String 30 Designation/salutation for contact person.
Title_n
 String 60 Title for contact person.
Fname_n
 String 40 First name for contact person.
Lname_n
 String 40 Family name for contact person.
Pnphone_n
 String 32 Telephone number for contact person.
Pnemail_n
 String 60 Email address for contact person.
Cyname_n
 String 182 Company name.
Cyaddr1_n
 String 60 Company address.
Cyaddr2_n
 String 60 Company address.
Cyaddr3_n
 String 60 Company address.
Cyaddr4_n
 String 60 Company address.
Cypcode_n
 String 10 Company postal code.
Cyphone_n
 String 32 Company phone number.
Cyfax_n
 String 32 Company fax number.
Cyurl_n
 String 60 Company URL.

Indented fields are repeated for each role/company.

By default, the Roles can appear in any order. If you wish to ensure some roles (e.g. client, architect and contractor) consistently fall in the same columns, please inform Barbour ABI when selecting this format. These roles will always appear first and null if not available. The remaining unspecified roles will follow in any order.

Microsoft Excel is limited to 256 columns, so you will be warned “File not loaded properly” when trying to import projects containing more than 14 roles. The data will still import, but the fields beyond number 256 will be missing.