Page History

...

In case, if there are any errors while Import data from excel file (using Excel Import templates), please check the settings according to this list:

...

        All fields in excel file should be filled with format as it was set in corresponding excel template.

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.

   Image Added

   Hints in the file:

   Image Added

       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.

          Image Modified

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

...

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.  A convenient tool for checking the correctness of filling in the fields in a file is uploading a file template when calling the import command.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.

Image Removed

Hints in the file:Image Removed

Thank you for being FirstBIT customer!