Error while uploading Location Master Data?

[Former Member]

Hi,

In IBP 1708, I have added an attribute "Plant" in the Master data table Location.

When I am uploading the data through this table I am getting the following error:

List of columns provided for batch 1155 in L02LOCATION_TEMPLATE (2).csv is invalid/IBP/INTEGRATIONList of columns provided for batch 1155 in L02LOCATION_TEMPLATE (2).csv is invalid/IBP/INTEGRATIONNot sure why the columns are invalid. Please help.

[melinda_abel · Accepted solution]

Hi,
could you try that you download the master data template and check the difference? Can you upload this sample csv with 'dummy' data?
Best regards,
Melinda

[Former Member]

There can be three reasons:

1) NULL value is provided in the LOCATIONID field for at least one of the rows of the template OR

2) Some columns have been missed out in the output template, if this is the case Download template again and upload without removing any column for non-root attributes OR

3) Check the datatype for each of the column uploaded, it should be the same as the datatype mentioned in the attribute of the model configuration

[AyanBishnu]

Hi

Please provide details of the attribute that you have created (e.g if it is varchar / int, length) and what is the value that you are maintaining, while you are loading the data. If possible share screenshot of the attributes and also the csv file.