CSV not importing all the data from Sharepoint

[sau953]

Hi,

I am trying to import a CSV file from a Sharepoint site with some data on Dates (file attached).

Sharepoint input tool configuration looks like this:

However, I get the following output which does not make sense. I get only 1 column and that too incorrect. 

I am facing similar weird issue with other CSVs I have. And this issue has started happening only in the past few days. Prior to that I have been working with the same files and the same Alteryx tools for the past 2 months and never had any issues with any CSV file. 

Please help!

[FrederikE]

Hey @sau953,

Which SharePoint Tool Version are you using? I also had these probs a while back with 2.2.

2.1 worked well - don't know about the newer ones, but downgrading should help. 

[sau953]

I have been using 2.4 (the latest one) since its launch in March and it has been working fine for the past 2 months but suddenly now does not work. 

I will try to use 2.1, thanks!

[sau953]

Unfortunately 2.1 also didn't work. 

[FrederikE]

nvm - stupid comment :D 

[sau953 · Accepted solution]

Found the solution !!

As it turns out, even if one installs the latest Sharepoint tool (2.4.0) the older versions of the same tool can still override it. 

I uninstalled Alteryx, deleted all the folders related to it including the tools folder which had 4 different versions of the Sharepoint tool and then did a fresh install.

This finally solved all the issues. All files now getting imported perfectly like before.