Overview
You can import data from a tab-delimited text file directly into the Suppliers database for your account.
To use the Import Suppliers Wizard, follow these steps:
1. Log on to Certain as a System Administrator user.
2. Click the top left menu and select SUPPLIERS.
3. Click Import.
4. Upload an external data file to the server.
5. Map the columns of the data file to those of the suppliers database.
6. Preview the data upload.
7. We recommend performing a sample data import before completing a full import to ensure that data is imported as intended.
Preparing Your Data File for Import
Before you begin the import, prepare your data file.
The file must contain only tab-delimited text.
Most software applications offer a tab-delimited text option.
In Excel, select Save As → Tab-delimited text (*.txt).
Note: The data file must have the .txt extension to import into Certain.
Header Row: The first row must be column names.
The import file must include the required fields, Name and Unique Code.
If text is uppercase, it will appear uppercase in Certain.
For example, "HOTEL." will remain "HOTEL."
You may need to use Excel or another program to correct formatting before performing your import.
Note: State and Country must match values you could select if entering data manually, and are case sensitive in the import.
Example: "California" would import successfully, but "california" wouldn't.
Delete any information that you do not want to import.
Most data is organized in columns.
Delete any columns that are unnecessary for your import.
Make sure that data matches the format expected in Certain.
Certain uses a single Postal Code field, whereas some supplier data sets may contain a separate field for the four-digit zip code extension.
State and Country must match the values you could select if entering data manually, and are case sensitive in the import.
Delete any information that you do not want to import.
Delete any columns that are unnecessary for your import.
Make sure that data matches the format expected in Certain.
Certain uses a single Postal Code field, whereas some supplier data sets may contain a separate field for the four-digit zip code extension.
Uploading the Data File In order to start the import process and upload your data file: Go to Suppliers, and click Import. The Suppliers Import Wizard opens. Note: The Import option is only visible to Administrator users. Click Next. Click Browse to locate the file you'd like to import into Certain. Select the file and click Open. Select the action to take if the file being uploaded has the same name as an existing file: Don’t upload Overwrite existing file Upload and re-name the file Click Upload File to begin the import. This process may take a few minutes, depending on the size of the import file. Caution: Do not refresh or resubmit the page during the upload process.
Mapping Import Data Fields Map the data fields to import: 1. Select the file from the list of uploaded files. 2. Click Preview 1st Row to see a preview of the data in the first row of the selected file. 3. In the Fields to Import list, select any fields you do not have in your import file, and click to move them left into the Fields Available for Supplier list. 4. In the Fields Available for Supplier list, select any fields you do want to import, and have in your import file, and click to move them right into the Fields to Import list. 5. The Fields to Import list should now consist of all the fields that you want to import. 6. Reorder those fields (Top / Up and Bottom / Down buttons) until the Fields to Import matches the order of the columns in the Data File list. 7. Click Next.
Setting Data Import Options Supplier Type – Select the Supplier Type to assign to the imported records: Brand, Chain, Venue, or Other. First row containing data – The default of "2" assumes that the first row is a header row of column names. Enter 1 if the data has no headers. Maximum number of rows to import – The default is all rows in the file. Enter a lower number if you don’t want to import all of the data.
Confirming Import and Finishing Import Process 1. Click Next. 2. Review the information in the Confirm Upload Parameters dialog box. If any information is incorrect, click Back and rectify the errors. If the information appears correct, click Finish. 3. Click OK when you are ready to import the suppliers. 4. Certain uploads the file from your computer and maps the supplier data as specified. 5. The import process may take a few minutes, depending on the size of the import file. Caution: Do not refresh or resubmit the page during the upload process. 6. Click Finish to return to Certain. 7. Click OK in the confirmation dialog box.
Related articles Suppliers (List)