Skip to main content

Mass Data Imports

Is there a way to mass-import new data into Weighsoft?

A
Written by Andrei M

Weighsoft does support importing data for certain elements of the system.
The options can be found by following the steps below:

  1. Hover on Administration

  2. Click on Lookups

  3. Click on Imports

The screen will show a list of items that can be imported with the use of a downloadable template. The process for using them is as follows:

  1. Locate the data type you want to import

  2. Click on the Download Template option - this will download an Excel sheet template for that data type

  3. Enter the required data into the template, making sure to fill in all required fields

  4. Save the completed spreadsheet somewhere easy to find, for example, your desktop

  5. Go back to the Imports screen in Weighsoft and click on Choose File at the top of the screen

  6. Select the spreadsheet on your desktop

  7. Locate the data type you downloaded and click on the Process link on the right.

If there is any required data missing from the import file, then you will get an error message at the top of the screen.
​
The system will process the data on the spreadsheet and import it into the required section of Weighsoft.

Note: Most Lookup Imports do not overwrite or update existing data; they only create new data, i.e if a lookup already exists, it will not be changed by the import, and the import line will be skipped.

Ticket numbers on transaction imports: Weighsoft will not auto-generate the next available ticket number if the field is left blank during import — the row will be rejected for missing required data instead. Enter an explicit, unused ticket number for each row (for example, your highest existing ticket number plus 10) to avoid clashes.

Editing an imported transaction can delete its unit price: if you edit and save a transaction that was created via import, Weighsoft recalculates the unit price based on the haul sell/product price — this can remove a unit price that was set correctly in the import file. Check the unit price after editing any imported transaction.

Did this answer your question?