Data load
From the Data load tab, you can upload your data to Fairmarkit. To upload data, it must be formatted into a Fairmarkit template. Once uploaded, Fairmarkit will process the file, creating and updating valid data. Once complete, you can review the upload process. If there were errors during the process, you can rollback changes or download the error file, correct the errors, and then upload your corrected file.
Access: To access these settings, you will need to be assigned to the Admin role for your organization.
What data can be uploaded?
You can upload the following types of data:
Addresses
Business units
Suppliers
Purchase orders
How do I format my data?
To upload data, you will need to add it to a Fairmarkit template. The template ensures that the necessary data columns are included. In addition, your data must be in CSV format; use a comma (,) delimiter and double-quotes (") to wrap data inside a column.
Download a data template
Click Add File. The Add file window displays.
At the bottom of the window, click to download the template for your data type.
Upload data
Click Add File. The Add file window displays.
Enter the following.
Source type: Select the type of data you want to upload. This must match the CSV template you used. Available options are Suppliers or Purchase Orders.
ERP system: Select your ERP system. Your available ERP systems are defined during onboarding.
File: Click Upload File to add your CSV file you want to upload.
Click Add. Your file will be validated, processed, and added to the Data load list. During the process, valid records are created and any errors, such as an invalid header or a duplicated email, are highlighted and listed in the error file.
Review upload
After your file is uploaded, it will be processed and added to the Data load list below. From this list, you can review a list of processed files, check the processing status, rollback changes, or download an error file.
Data load - column descriptions
File
Displays the name of the uploaded file. Click the file name to download the file.
ERP system
Displays the name of your ERP system. This was selected when the file was uploaded.
Source type
Displays the type of data uploaded. This was selected when the file was uploaded.
Status
Displays two columns of status information about the upload.
upload status: Displays the upload status. Available statues include:
Finished (green): Displays when the file at least partially processed.
Failed (red): Displayed when the file fails to process. Hover over the label to see an error message (e.g., Invalid Header).
Rolled back (yellow): Displayed when you or another user have undone any changes created when the file was uploaded.
processed/failed lines: Displays the number of successfully processed records (in green) and the number of failed records (in red).
actions 
A list of available actions for the location.
Rollback
If you have uploaded a file and want the undo the changes made, complete the following:
For a line, click actions and select Rollback. Any new records are removed, and any edits to existing records are reverted to the previous version.
Download error file
If there were errors during the process, you can download the error file, correct the errors, and then upload the corrected error file.
For a line, click actions
and select Download error file.
The error file downloads. The file contains a list of all lines with an error and an additional Errors column that provides a description of the error (e.g., {'email': ['Supplier with email [email protected] and title PhotoEquip already exists.']}).
Last updated
Was this helpful?