Skip to main content
Skip table of contents

Import of several Excel files (Items list with LOTS)

With the use of LOT positions, you can also import several items lists using an Excel file. In the Items list editor on the interface, it must first be preselected via the "Items list Structure" button that LOTS are used.

  • To do this, click on  in the button bar to select the option.

  • Set the option “The reference numbering is taking place:” on “automatically”

  • check the box “Use lots”

  • Finaly, click on  “Renumber items list”

Settings for the Items list structure


The red folder in the Items list editor will then receive an "L" for LOT:


LOT position in the Items list

By right-clicking on the blue folder and selecting "New folder", further LOT positions can then be created.

Create more LOTS in the Items list


You can then import an items list for each red folder using the import function via Excel. To do this, select the desired red folder in advance and then execute the import via an Excel file.


Fig.: Import Items list by LOT position





If an unknown unit appears in your import file for the items list (GAEB or Excel), you will receive the following information:

You can then select the appropriate unit from the drop-down window. By clicking on "Next" the import continues and the unknown unit is replaced by the selected unit during import. If other units are unknown, the notification window appears again.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.