In this article:

Who can use the product data export/import?

This is available for Company administrator users only.

How to use product data export and import?

Step 1: Download existing data

1. Being logged in, use this direct link **https://app.evocon.com/#/settings/products/dataImport?reportName=ProductExport**

2. Click on the “Download” button in the first section to get the current products’ data in an Excel file.

   

   <aside> ⚠️

   Please note that we strongly suggest using MS Excel to edit the file, as other editing programs could create issues with the import.

   </aside>

   <aside> ☝🏼

   NB! ”Include deleted data” means include previously deleted items in the spreadsheet. All data that is deleted in Evocon is in a state called “soft deleted” (product stays in database, but is not visible in the user interface). If ”Include deleted data” is checked, then deleted items will be shown in the exported file.

   </aside>

Step 2: Edit the Excel file to add/edit data

1. Open the downloaded Excel file and move through each tab from left to right.

   <aside> ⚠️

   Please note that adding or editing station data is not possible. Therefore, please do not make any changes in the “Stations” tab.

   </aside>

2. Product groups

   • Adding new groups:

     • Go to the “Product groups” tab.
     • Leave the “Product group ID” field empty when adding new groups (this is automatically generated later).
     • Use Excel’s “UNIQUE” function if you have a list of groups, to get unique product group names. Here is link to guide how to use this function. If the group names are not unique, the import will fail.
     • Copy or enter the new group names into the “Product group name” column and mark them as active by entering 1 in the “Active or deleted item**”** column.

   • Editing existing group names:

     • Please do not modify the Group ID. Also, if it is removed, the system will treat the entry as new and attempt to create another group with the same name, which is not allowed.
     • Edit the group names as needed and save the file.
       • After making changes to group names and uploading the file, you will see errors for routes (because the products had the old group name attached). This does not require any action and the group names will be updated in the next file you download.

   • Deleting product groups is not possible via import, and must be done in the UI of Evocon.

     More info here.

3. Products

   • Adding new products:

     • Go to the “Products” tab.

     • Leave the “Product ID” field empty (this will be generated automatically by the system later).

     • Select the product group from the dropdown in the “Product group” column.

     • Enter the product code into the “Product code” field or in case you don’t use product codes, just copy the product name.

     • Enter the product name in the “Product name” column.

     • Enter the primary/main unit for this product in the “Unit” column (max 5 characters).

       For example: pcs, kg, l, t, m.

     • In case you use an alternative unit for this product as well, add it to the “Alternative unit” column. This is an optional field.

       For example: box, set, t.

     • Set the product as active by selecting 1 from the dropdown in the “Active or deleted item” column.

     • To add new products to existing stations, proceed to point 4 for routes.

   • Editing existing products:
     • Please do not modify the Product ID. Also, if it is removed, the system will treat the entry as new and attempt to create another group with the same name, which is not allowed.
     • Make the necessary changes (to product name, unit etc) and save the file.
     • To add existing products to a new station, proceed to point 4 for routes.
   • Deleting products:
     • Mark the “Active or deleted item” from 1 to 0 and save the file.

4. Routes

   • Adding new routes:

     • Each product that will be produced on a station, needs to have a separate row detailing the route settings.
     • Leave “Route ID” empty (these are automatically generated later).
     • Select the product code from the dropdown in the “Product code” column.
     • Product name is automatically filled after selecting the product code.
     • Select the station from the dropdown in the “Station” column.
     • Select the unit from the dropdown in “Cycle time unit” column. The “unit” will be replaced with your selected unit in the system.
     • Enter the ideal production speed for this product on this station in the “Ideal production speed” (Target speed) column.
       • This must be bigger than 0. Use comma or point for decimals and do not use thousands separators.
     • Enter the time in seconds for the stop start time (when the delay between signals becomes a stop) in the “Production stop” column.
       • This must be bigger than 0.
       • We recommend to use 180 seconds (3 minutes) if you have no exact knowledge of the real value yet.
     • Enter how many units are registered by obe sensor signal in the “Quantity per sensor signal” column.
       • This must be bigger than 0 and the most used value is 1.
     • Select the conversion direction from the dropdown in the “Alternative unit conversion” column (if you use the alternative unit for this product).
       • 0 = Primary unit to alternative unit (1 primary = x alt).
       • 1 = Alternative unit to primary unit (1 alt = x primary).
     • Set the alternative unit value in the “Alternative unit value” column.
       • Enter the conversion value between units (e.g. if you entered "1" as the conversion direction, and enter "6" as the value, then 6 primary units (such as cans) = 1 alternative unit (such as a box).

   • Editing existing routes:

     • Please do not modify the Route ID. Also, if it is removed, the system will treat the entry as new.
     • Make the necessary changes and save the file.

     <aside> 💡

     NB! We recommend to delete every route row in the excel that isn’t new or changed before uploading.

     </aside>

Step 3: Upload the edited file

• After completing the additions or changes, save the updated Excel file.
• Return to the Data Import page and upload the file to complete the import.

<aside> ☝🏼

For larger updates we recommend doing the changes by tabs - first adding and editing the groups, then uploading the file, next adding and editing the products, then uploading the file again and lastly, adding and editing routes and uploading the file.

This makes it easier to track any errors, reduces the chances of making mistakes and also reduces the amount of errors that don’t require any action from the uploader.

</aside>