Import of demand items with Excel

You can import demand items into Onventis using Excel. To import the demand items into Onventis, follow these steps:

1. Save the Onventis template for importing demand items on your computer. Here you can download the template:
   Import_DemandPosition_Template.xlsx

2. Fill in the columns according to the specifications.

3. Go to Onventis under Operational Purchasing → Purchase Order Processing → Requirement Items.

4. Select the Import function in the Action drop-down menu in the toolbar using the Import… button. button.

5. Via the Selection… button and then via the ... you can select the file.

6. Attach the file using the Attach button and close the current window using the Close button.

7. The Import button imports the requirements list into Onventis.

8. Once you have started the import, you will see the title, status and creation date in the table. The following statuses are possible:

   1. Saved:
      the file is being imported into Onventis.

   2. OK:
      the file was imported into Onventis without errors. The requirements items are available in the requirements item list.

   3. Error:
      the file is corrupted and could not be imported. Fix the errors in the Excel template and re-import the file. Click on the title to display the log file.
      The error and the corresponding error message are displayed in the Log area.