Settings in the [ERPTABLE-IDENTIFY-COLUMNS] block
Here the columns are entered which are needed for the line identification in the LinkDB. If no adequate line is found and createEmptyERPdataSetIfUnknown = 1, then a new line is created.
The default setting applies if the unique number can be found in the ERP_PDM_NUMBER column on the ENTERPRISE 3Dfindit side and the corresponding information is in the first column of the CSV file in the third-party system.
[ERPTABLE-IDENTIFY-COLUMNS] ERP_PDM_NUMBER=row.cells.item(0).value
In this example, the unique number is in the "SAP_MAT_NR" column on the ENTERPRISE 3Dfindit side. In the third-party system, the corresponding information is in the second column of the CSV file.
SAP_MAT_NR=row.cells.item(1).value
Several CSV columns are required in order to identify the correct line in the LinkDB.
At the value in the first CSV column the leading zeros shall be removed, then an underscore be added and finally the value from column 2 be attached.
ERP_PDM_NUMBER=""&row.cells.item(0).value & "_" & row.cells.item(1).value
Excerpt from the CSV file from column 1 and 2:
0000014245 001
Result: The LinkDB search for the adequate line is performed with:
14245_001
For the identification of the correct LinkDB line several CSV columns, respectively LinkDB columns are needed.
ERP_PDM_NUMBER=row.cells.item(0).value ERP_VERSION=row.cells.item(1).value
If a value shall be set in a certain column use the following expression:
[ERPTABLE-UPDATE-COLUMNS] MAT_NAME=replace(row.cells.item(0).value,”Stahl”,”8.8”)