Comment on page
Import data templates
Use these to load any volume of data into your system.
You can import data into your system using .xlsx import templates.
These are located at:
Setup>Import Data
- Each worksheet has instructions on the first tab. Make sure you read them. I repeat make sure you read them.
- Each sheet in the worksheet has columns with notes, pay attention to the notes. I repeat, pay attention to the notes.
- The blue columns are Syntax sensitive, meaning that if the Syntax is wrong, then the import will not work.
- You have to put data in the columns with yellow headers.
- Worksheets update existing data if the data imported is different from the existing data.
Before you import lots of rows of data, import a couple of rows and check they look as you expect in the app.
If you don’t have Excel software installed, then get yourself a free Gmail account. Set up your Gmail account and then use Google Sheets to populate. When you are done, export the spreadsheet as a .xlsx file.
If you want to import data into fields that are not specified on the import templates, you can add additional columns:
Add an additional column at the end of the columns in the import template. Name the column the same as the label on the field in your system. Precede the column name with a $ sign. For example, $Label name.
An additional column at the end of the columns in the import template. Name the column the same as the label on the custom field in your system.
Template | Notes |
|---|---|
Workers | |
Accounts | |
Payment Terms | |
Classification Types | |
Leads | |
Prospects | |
Customers | |
Suppliers | |
Contacts | |
Items | |
Items Extra Info | See 'Items Extra Info' |
Preferred Suppliers | |
Customer Item Codes | See 'Customer Item Codes'. |
Base Price List | |
Item Site Data | See 'Item Site Data'. |
Upload Transactions | |
Upload Journals |
From The Explorer, click Setup- > Import Data this displays the Import Data page. From here you can download the appropriate Excel Template.
Click 'Download' to save a template on your local machine. You can rename the templates with versions if necessary, e.g, Import Customers May 2023. Make sure you keep the .xlsx extension.
Open the saved Excel spreadsheet and locate the relevant 'Sheet' for example 'Customers'.
Note that the columns are either yellow or grey. Yellow signifies a mandatory column that must be filled in. Grey columns are optional. To see information on the column values mouse over the red icon in the top right-hand corner of the associated column.
Do not delete or rearrange existing columns.
Color coded Columns and Notes on Columns.
Before you add your data to multiple rows in the template. Populate FIVE or fewer rows with data. Always test an upload FIRST to make sure your data is formatted correctly in your sheet and the data stores correctly in your system.
Go to: Setup>Import Data>import template name>Upload Data
Select the populated template and upload.
A large volume of data can take a few minutes to load.
In your Salesorder system randomly locate, bookmark, and check ALL populated fields.
If your upload fails, you will see an error message telling you which row has failed. Go check and correct the contents of the row in your upload template.
If you cannot rectify the problem, send an email to [email protected] with:
- 1.The .xlsx file attached
- 2.The SOA (account number of your system.
- 3.A description of the problem
If you cannot send the .xlsx sheet to us because it's too large. let us know and we'll arrange for a secure upload destination to be created, and send you directions.
Last modified 3mo ago