Exporting/Importing Carriers

This import allows you to import Carriers. Use this import to create or update carrier information. Delivery and Will Call are read only and cannot be modified.

Formatting the Data

You must create a CSV file formatted in a way that Fishbowl knows what to do with the data. This is easiest to do with a spreadsheet program.

Each row of data should look like this:
Name, SCAC, Description, Active.

There must be a header row detailing which columns have been specified so Fishbowl knows which columns were entered. Name is the only required field, all others are optional. The Name column must be the first column listed, but all others may be in any order.

All fields will be one of two types:

Text - A textual value. May contain any character, but if it contains a line break, comma or double quote, it must be wrapped with double quotes on both ends. If a field is wrapped, all text must be inside the double quotes. Double quotes in the text value must be doubled to import properly
Numeric - A decimal number greater than or equal to zero.

CSV Fields Used to Export/Import Carriers

Column Name	Type	Description
Name	Text (60 chars)	The Carrier name. *Required*
SCAC	Text (4 chars)	The Standard Alpha Carrier Code (SCAC) for the Carrier.
Description	Text (256 chars)	The description for the Carrier.
Active	Text	Whether the carrier is active (true) or inactive (false).
ServiceName	Text (256 chars)	The name of the service.
ServiceCode	Text (15 chars)	The code for the service.
ServiceActive	Text	Whether the service is active (true) or inactive (false).

Format of the CSV file

In order to import your data, you must first export it to a comma separated values (CSV) text file. All major spreadsheet programs can export data in this format. If you do not know how to export your data to a CSV file, please refer to the documentation of your spreadsheet program.

When exporting to CSV format, make sure to verify the following:

The data is formatted properly (see the first section)
The file must contain column names in the first row, using the column names in the table above.
Commas are used to separate fields
Text values are surrounded by double quotes