Error during data import by CSV File in SAP IBP (

[former_member606794]

Hi,

I am trying to import data (TP, master data, KF) using CSV file into my planning area using Data Integration app. I am downloading the template and then making the upload of the duly filled data file. However, for every file upload I am getting an error such as:

- List of columns provided for batch 566 in <file name>.csv is invalid

- Required attribute <xxxxID> of master data type <MDT> is missing in file <file name>.csv.

Similar errors are also coming during upload of Product, Customer, Actual Quantity etc. All my data files have required attributes (CustID, PrdID, UoMTOID) specified. As an example, my UOMTO data file is as follows:

UOMTOID UOMTODESCR EA Each

but the upload fails and the problem report is as follows:

TIMESTAMP SEVERITY MESSAGE_TEXT MSGID MSGNO MSGV1 03/28/2019 07:13:16.8460000 List of columns provided for batch 566 in DS2UOMTO_V2.csv is invalid /IBP/INTEGRATION 400 DS2UOMTO_V2.csv 03/28/2019 07:13:16.8560000 Error Required attribute UOMTOID of master data type DS2UOMTO is missing in file DS2UOMTO_V2.csv. /IBP/INTEGRPT 24 DS2UOMTO_V2.csv 03/28/2019 07:13:16.8630000 Error List of columns provided for batch 566 in DS2UOMTO_V2.csv is invalid /IBP/INTEGRATION 400 DS2UOMTO_V2.csv

uomto-data-file.png

errorlog-uomto.png

Issue is only with CSV uploads, the master data creation through Excel Add-On works fine. I have tested by uploading both .csv and UTR-8 .csv files and the issue still persists.

Any pointers towards its resolution would be helpful.

Thanks,

[lingaiahvanam]

Hi,

Check any macros and VBA code enabled in excel template?

Based on the error log UOM issue.

Best Regards,

Lingaiah

[former_member606794]

Hi Lingaiah,

Re-tried by disabling all the com add-on from excel file and recreating the .csv file. But the issue still persists.

thanks,