Imports

How to Import Data into simPRO

Overview

Migrate your existing operational data into simPRO when implementing the system into your business.

A screenshot of the Imports page.

Go to Utilities > Import to import data formatted in CSV and text spreadsheets, including assets Enterprise Only, plant items, generic catalogues, supplier-specific catalogues, pre-builds, jobs, customers and customer notes, employees and contractors Enterprise Only, sites, suppliers and supplier invoices.

It is important to note that while importing is a valuable exercise, it requires careful attention and planning.

You need to have the applicable security group permissions enabled to import customer assets Enterprise Only, plant items, customers, employees and contractors Enterprise Only, jobs, pre-builds, sites, suppliers, and stock (generic and simPRO-formatted supplier catalogues).

US only: If you use simPRO in the United States, the term 'vendor' is used instead of 'supplier'.

US only: If you use simPRO in the United States, the terms 'inventory' and 'inventory count' are used instead of 'stock', 'stock take', and 'in stock'.

Import your operational data

simPRO uses an import process known as Extract, Transform, Load (ETL). Data is extracted from the source system, for example, your existing accounting package, your current software package, or your spreadsheet records, then transformed into a compatible format, and loaded into the target system (simPRO). Successful ETL requires a sound understanding of the source and target systems, as well as careful attention to data quality and integrity.

simPRO is glad to guide you in loading and updating your data once it is in the specified format. However, we are unable to extract the data from your current system and transform it for you, because we do not know your current systems the way you do and cannot guarantee the integrity of your data when extracting it.

If you choose to import the data yourself, we recommend you first review your data for integrity and completeness. You may wish to use a data quality or profiling tool to assist with this process, many of which are available online with varying degrees of ongoing support.

You can then follow the instructions for each import process to prepare your data in a CSV (.csv), text (txt) or ZIP (.zip) file according to simPRO's specific requirements.

If you need more help with migrating your data to simPRO, ask your simPRO Implementation Consultant about our Data Migration Partners.

It is recommended to test the import process by importing a test file with one or two items before importing all operational data.

Troubleshoot the import process

The following steps may assist in troubleshooting any issues with the import process:

  1. If applicable, download the error file CSV and check the error text.
  2. Refer to the file's preparation and import settings instructions.
  3. Ensure column headings and data are formatted identically to how they appear in simPRO and according to field requirements.
    • This includes spacing, case and number formatting. If the file is saved in Microsoft Excel, certain numerical fields may need to have Text formatting applied to prevent leading zeros from being truncated.
    • Fields containing names of employees, contractors Enterprise Only, customers etc, may need to be separated into First Name and Last Name columns depending on how they are set up in the card files.
  4. Ensure the format for any dates is the same as specified in System > Setup > Defaults > System > Date Format.
  5. Ensure cells that have been intentionally left blank to not contain spaces or clear text.
  6. Re-save the file in a CSV (.csv) or text (.txt) format.
  7. Import a smaller number of items in a test file before attempting the entire list.
    • This may also reduce the file size, as files larger than 75 MB cannot be processed.