CSV file operations

Lab vendors can be added, updated, or deleted using a CSV file. To add a lab vendor you must create this CSV file from scratch. For existing lab vendors, you can download the CSV file from the Lab Vendor List to make edits or remove entries.

The CSV file a lab vendor contains the following 15 columns:

Column	Description
Lab Vendor ID	Must be unique and can be an alpha numeric string up to 50 characters long.
Lab Vendor Name	Name of the lab vendor.
Address 1	First line for lab vendor’s address.
Address 2	Second line for lab vendor’s address.
City	Lab vendor’s city.
State/Province	Lab vendor’s state.
Postal Code	Lab vendor’s postal code.
Country	Lab vendor’s country.
Phone Number	Lab vendor’s phone number.
Fax Number	Lab vendor’s fax number.
Comments	Comments regarding the lab vendor.
Labdbid	Internal database identifier for the lab vendor. This is only required for updates or deletion of existing vendors. This is populated automatically in the CSV file when the CSV file is downloaded from the Lab List page.
TransactionType(I/U/D)	Only accepted values are: I – Used for “Insert” commands. U – Used for “update” commands. D – Used for “delete” commands. Any other value will raise an error for that row. If no value is provided, application defaults to “I” (insert).
ReasonForChange	Used during updates or deletion of existing vendors. If not provided, application defaults to “changed information”.
Associated Sites	Used if lab vendor is to be associated with sites. Lists the site mnemonics that lab vendor should be associated with.

• CSV file requirements for adding a new lab vendor
  
• CSV file requirements for updating an existing lab vendor
  
• CSV file requirements for deleting an existing lab vendor