File Import Tool

How to update data such as Users' Information, Pickup & Delivery Contacts or Addresses on the Cargobase platform in bulk?

Admin Settings

As an admin user, you have the ability to utilize the File Import Tool feature to efficiently create or edit your company settings in bulk. This includes managing stored users' information, contacts, and addresses.

1. Make sure you have access to 'File Import Tool' under the Admin Settings

Screenshot 2024-04-29 at 10.16.34 PM

2. Under the Download Template section, you will find 'Select Data' which you can select a file template such as User, Address or Contact

Screenshot 2024-04-29 at 10.21.20 PM

3. Once a template is selected, choose the type of action required under 'Select Action'. You can select Bulk Create or Bulk Edit action.

Screenshot 2024-04-29 at 10.25.33 PM

4. Click 'Download Template' to retrieve the excel file for completion. The file should look similar to the image below but the column titles may differ based on the templates selected. Complete the information required.

Screenshot 2024-04-29 at 10.38.58 PM

5. After completing the template, go back to the 'File Import Tool'. Look for File Import section on the right. Select 'Create New Import'.

Screenshot 2024-04-29 at 10.46.55 PM

6. Select a data type and the action  to be performed via 'Select Data' and 'Select Action'.

Screenshot 2024-04-29 at 10.57.53 PM

Screenshot 2024-04-29 at 10.58.12 PM

7. Enter a file description and upload the file by clicking on 'Select File'.

Screenshot 2024-04-29 at 11.05.03 PM

8. Click 'Create' to upload the file. 

Screenshot 2024-04-29 at 11.05.34 PM-1

9. An Import Details window will appear for your reference. It will show that the upload is processing. You can also check the status via the File Import History section.

Screenshot 2024-04-29 at 11.09.42 PMScreenshot 2024-04-29 at 11.11.05 PM-1

You may find a few status of the file import action performed. 

  • Processing -> Upload in Progress
  • Imported -> The uploaded data is imported successfully and is available on the platform.
  • Upload Failed -> The data failed to upload and require a re-upload. 
  • Has Errors -> The data failed to upload due to errors found in the file. 
  • Incomplete -> Data that has the status 'Upload Failed' or 'Has Errors'. 

Screenshot 2024-04-29 at 11.21.31 PM

If the status shows 'Upload Failed', you may re-upload the file again via the 'Reupload' button. 

Screenshot 2024-04-29 at 11.46.02 PM

If the status shows 'Has Errors', download the error log file to check what went wrong. 

Screenshot 2024-04-29 at 11.50.52 PM

Check the 'Error Column' and 'Error Message' to determine the error in the file and make the necessary changes. 

Screenshot 2024-04-29 at 11.53.01 PM

Once the changes are made, upload the file again via 'Upload Revised File' button. 

Screenshot 2024-04-29 at 11.55.41 PM