User manual

Table Of Contents
The file must be a CSV (comma separated value) file with one header line (the
contents of which are ignored) and must be UTF-8 encoded. Columns should
be separated by a comma and column headers should be in double-quotes.
Here is an example of what a CSV file looks like prior to import:
These column headers correspond to the fields in the Company Information
tab in the New/Edit Company dialog box. After importing your CSV file, it is
these fields that will be populated. Not all fields will be applicable to your
business needs. Use the fields that are appropriate for your business. When
importing, the columns should be in the following order using the same
column names.
NOTE All columns can be empty but they do have to be in the order outlined
below.
"Company Name"
"Vendor ID" if the Vendor ID exists in the site then it is updated upon
import.
"Company Type"
"Rating"
"Trade (Primary)"
"Trade"
"Services"
"Project Types"
"MWDBE"
"Contract Limit"
"Contract Limit Money Type"
"Sales Tax Rate"
"Sales Tax Exempt No"
"Address1"
66 | Chapter 6 Site and Project Administration