Error in loading a CSV file

[Gopi22]

Hi Team,

We are facing an issue while loading a CSV file in to a data source. When loading all records, we are getting the below error: 

Expecting ; in position 122. Line=282;2024-06-17T10:02:33Z;2024-06-21T10:35:15Z;Phone;Hardware;Phone;Extensive/Widespread;Low;High;"Aughültige SIM-Karte" erscheint auf dem iPhone seit 14.06. andauernd;Closed;Team 07 - Service Desk;Muehlweg 2516 99091 ErfurtDE

Could anyone please guide how we can move ahead ? 

Thanks,

Gopi

[Sumanth16]

Hi @Gopi22 ,

To prevent this error the line in CSV should be like the one below.

8,m03145,"15"" OPEN",56454453

If you observe the error, there is no matching double quote, so it is throwing an error ("8","m03145","15" OPEN","56454453"). The one in the green color should have the matching " to prevent the error. Try with the line I posted above.

Please mark my answer helpful and accept as a solution if it helped

Thanks & Regards,

Sumanth Meda

[Gopi22]

Hi Sumanth,

Thank you for your update.

So this is a problem with the CSV file, right ? Editing the file from our end will not be allowed as it has to be the owners. 

Just wanted to make sure, that there is nothing that can be done from ServiceNow on this issue. Only solution is the owners should provide the CSV file in correct format, right ? 

Thanks,

Gopi