Docs  /  NVXIJI Excel Import Job Invoices  /  Setup

App Setup

2022/03/01 • 1 min. to read
In the Page Mappings a new Mapping needs to be created:

Within the mapping the connection between the table fields and excel columns is being defined. Up to 3 excel columns can be linked to one table field (the necessary columns/fields in Business Central need to be added to the view) and can be separated by a custom separator in the adequate field

No.	Field/Action	Description
1	Table-ID	Choose the table in which you want to import the data to
2	Load Mapping-Fields	Upload an Excel sample file to link make the columns available in the mapping lines
3	Feld No.	Chose the field you want to link
4	Column No.	Chose the excel column you want to import
5	Separator	Define the separator which should be used to separate the values from the two columns
6	Column No. 2	WChose the excel column you want to import