Page History

...

1. A convenient tool for checking the correctness of filling in the fields in a file is uploading a file template when user try to import data from excel file.When hovering over the upper right corner of each column of the template, the user is prompted about the format for filling out this column.

    

   Hints in the file:

   

       2. Under user with Administrator role it is possible to go to Administration - Master data - Excel Import Templates.       

Image Modified

Information about format of excel cells is on Fields tab of Template, "Format" column. In users excel file all fields should be filled with selected format.

      23.  In excel file it is needed to be checked -

...

• all fields with numeric values must not contain space symbol. For example: using 1000 separator it might be added spaces in between digits of the numbers - "2 230" - for automatically import from excel into ERP system - it is an error. Numerics should be filled without it - "2230".

      34. To check the correct operation of the data loading mechanism itself, you must enter the data manually into the system when calling the loading commanduser push Import from excel Image Added button:

Image Modified

With manually filling of data in external import template in the system you can check uploading of data of find some errors in filling. 

4.  Hints in the file:

Thank you for being FirstBIT customer!

...