Invalid CSV error while importing from Sharepoint

Hi,

I have a workflow that imports multiple files from a Sharepoint site and then combines them together to output to a SQL database. I have never had any issues with the whole process but today I started getting an error saying the CSV files I am importing are not valid CSVs.

I then went through the data and by hit and trial identified that if I remove all the comma from my data the CSV file is imported correctly from the Sharepoint.

Strange thing is this has never happened before and all the files are the same as before and all the data is also exactly the same. Nothing has changed apart from this error all of a sudden.

Also, if I import the same CSV files using standard input tool, everything works fine. It seems like something has changed in the Sharepoint input tool so I tried going back a version but still got the same error. Attaching a two row CSV file I have been testing on.

Please help!!!

Test.csv

Workflow

Datasets

Developer

Input

Macros

Sharepoint

Accepted answers

danilang

Hi @sau953

If nothing has changed in your workflow, or Alteryx version, then maybe something has changed in your data.

Your sample data has a quoted field on line 2, "Cost, other" with a contained comma.

Of course, you can only see this if you open the file in a text editor. Excel automatically removes the quotes and shows just Cost, other

When you initially set up the SharePoint Input tool, the Quote Character option is set to none. Change this to Double Quote.

Dan

All comments

danilang

Hi @sau953

If nothing has changed in your workflow, or Alteryx version, then maybe something has changed in your data.

Your sample data has a quoted field on line 2, "Cost, other" with a contained comma.

Of course, you can only see this if you open the file in a text editor. Excel automatically removes the quotes and shows just Cost, other

When you initially set up the SharePoint Input tool, the Quote Character option is set to none. Change this to Double Quote.

Dan

sau953

Thank you so much Dan, this did the trick.

The surprising bit is that I had a ton of such quoted fields in my data and had never tweaked the Quote Character option earlier but it worked.

sau953

Solution:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/CSV-not-importing-all-the-data-from-Sharepoint/m-p/1140027#M281741

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703