How to import, export, or transfer my data | ParagonERP

Importing, exporting, or transferring my data

Introduction

The universal translator is a powerful tool that can be used to import or export large amounts of data to and from Paragon. You can mass update your reference modules and you can also export and import transaction data. As an example, this document will show how to export, add records and then re-import the product file.

Access the import and export functions

To access the import and export functions, click the settings button from anywhere in Paragon and you will see Import and Export will under the Reports & Data card.


Export your configuration

Click on export under the reports & data card.


From the first drop-down scroll, select the module you'd like to export. 



If you have selected a reference module, such as products, customers or vendors, you will have the option to include inactive references using the toggle button on the right.  In this example, we have selected product. When you're ready, hit export.



Paragon will start exporting your data into a spreadsheet format. The text box below your selections on the screen will provide you with the detail of the actions taken and their outcome.



























Note that your browser may block the file as a security measure. Be sure to allow popups for this URL. The export will go into your downloads folder. 

Viewing your exported data

After opening your newly downloaded file, of the attributes that are configured on the product screen will appear as columns in your excel sheet. 



To understand the structure of the export, it may help to visit the module or screen set up for the module in order to view all of the attributes related to your export. 

The first column is always the unique identifier of the record. This corresponds to code in the screen setup. There are additional columns in the spreadsheet as well, including:

  1. Status - This can be set to active and inactive. Depending on the status of the reference, you can perform specific actions in Paragon.
  2. isMaterial, isProduct, isTool, isLabor - Use these columns to identify the type of record that you are importing. If the record that you are importing is a product, set the isProduct field to 1. Follow the same rules for material, labor or tool.
Do not modify the names of columns. As explained, the columns are mapped to attributes that are set up on the module you're exporting

Add or manipulate your export

Below are requirements for the data that you will try to import. If these are not respected, the import log will inform you that some of the data could not be loaded and will provide an explanation as well as the corresponding row number(s) on the spreadsheet.

  • Attributes set up as drop down lists must be entered exactly as is on the spreadsheet. Suggested values will not appear. If you have not added attribute values to the attribute you set up, they will not be automatically loaded.
  • You must set the status, i.e. temp (only for transactions) active or inactive (only for references)
  • Check-mark attributes need a value of 0 or 1 (0 = unchecked and 1 = checked)
  • For references : You must enter a unique record ID in the column "xxxxID" 
  • For transactions: You must enter a unique record ID in the column "xxxxID" and for each line in the column "detailsxxxxDetailID"

                        

If you want to add new transactions manually, please make sure to put an asterisk (*) before the transaction ID. 
If you would like to use your own ID number for your new transaction(s) instead of Paragon generating them for you, prefix your ID number with a '~'
If you do not use either prefix, the transaction will be rejected on import as invalid.

In this example, we have imported the credit data and we have added new data manually :
  1. imported data ID : 000001, 000002

  2. new data ID : *00045





After importing, ParagonERP  will automatically set an ID based on the existing transactions ID. 
Here, we set *00045 as the credit ID and ParagonERP renamed it into 000003. This is to avoid any inconsistency of data and to prevent errors.


Import your data

Click on import under the reports & data card. 

Please note that the current maximum size limit of a file to be imported should not exceed 1MB.




Select the type of data that you wish to import or update - e.g. products, customers, vendors.


Then hit select a file.


Once you've chosen the correctly formatted file you'd like to import, hit upload.


Paragon will start importing your data from the spreadsheet selected.


The import modal screen will provide you with the detail of the actions taken and their outcome. If any rows in the spreadsheet were unsuccessful in the import, a reason will be given. If you do not see this information on the modal screen, you can scroll down to see additional information.

Any columns in the excel file that failed to import will be mentioned under Import file feedback. In this example, the attribute code nonSufficient failed to import because it was removed from the screen set up for product at the time of import. You will see a similar error message if you try to import a column for which the attribute was never created and applied to screen setup in Paragon.



If there are failures, you can correct your file and return back to the previous step by hitting the back button.

Please note that any column which fills data in a drop down attribute will fail to import if the data has not already been configured for that attribute.  For example, if you are trying to import colors in your product file and your file contains color black but the color attribute in Paragon only contains options for colors red, blue and green; the import for that record will fail and return a message like the one sampled above.

If you're satisfied with the import, hit done.

 

 Export/import custom BOM

In My Company you can set some transactions to have a custom BOM (invoice, order, quote, purchase order, and work order). These are the transactions that will show up in the list to be exported and imported.





Once you have exported your file, you should be able to edit: total quantity, UOM, cost, and attributes. For this example we will change the UOM and quantity. 




Please note that if you want to add a new Custom BOM line to the import file, you must leave the LineNumber field blank.

Once you have made your changes, save and Import to Paragon using invoice custom BOM. When the process is complete, navigate to the invoice screen to view your changes in the custom BOM.

Adding a new item

If you decide to add a new item into the custom BOM, leave the line number blank and a new line will be created when your file is imported.





Import/export log

In the import/export log you can see the history of the imported files as well as the details of the actions taken and their outcome.
Go to Settings -> Reports & Data and open the import/export log:

You will see the history of all the imports that have been made:


If you hover over the information button it will show you the details about the import: 


If you want to see the details in full - hit the information button and a log modal will appear. 



From the Import/Export Log you can also download the Imported files by clicking on the file name. 



If you are looking for details on a specific Import you can also use the search bar to filter the log entries.

What's next




    • Related Articles

    • Importing and exporting associations

      ParagonERP allows you to import and export associations that are used to link different pieces of information throughout the system. This can be useful when you want to add an association for multiple items at once. If you are unfamiliar with ...
    • Importing warehouse locations

      If you have multiple warehouse locations that you want to add to Paragon's warehouse setup, you can import the information using the Universal Translator tool through the Location module. If you are unfamiliar with importing and transferring data ...
    • How to export purchase orders from Paragon to QuickBooks Online

      Introduction Paragon offers a few ways to export data to QuickBooks Online (to make sure that the integration is working smoothly. To export your purchase orders, there are a few extra requirements you will need to set up in Paragon and QuickBooks ...
    • How to import attribute associations from Excel

      Introduction In Paragon, attribute values can have additional information from other attributes associated with them. This can be useful for setting up restrictions on the values available during a process. When you export your data, you can edit ...
    • How to import products, vendors, and customers from QuickBooks to Paragon

      So you've purchased Paragon for all your ERP needs (good for you!) and you've activated your QuickBooks integration.  Fantastic.  Time to get down to business.  First things first - you need to have all the relevant data from QuickBooks Online to be ...