All I can think of is that there is a special character being used. If so, have you tried using its hex format representation?
1 of 1 people found this helpful
Thanks for reply, the file has created based on the guidelines given on the tableau CSV Import File Guidelines and interestingly the examples shown on the page returns the same error while i added them on CSV and try import that data.
I am running on Tableau Server 10.1 on AWS cloud.
Oh, good test!
Hmm, I'm not familiar with Tableau Online Unless someone has an idea you may want to create a support ticket (and let us know the answer if you figure it out ).
Hi Sivasankar, It looks like Tableau Server is ignoring the commas. I wonder if this could be a locale problem. If you want to try a workaround, then either switch locale temporarily, or else try using the same delimiter that you'd use importing a csv file into Tableau Desktop. Regardless, I agree with Toby that you should report this to support.
Hi Jeff and Toby
Thanks very much for all your valuable input, I have verified the server system locale for the Decimal separator and List separator. Decimal separator has set to . and list separator set to , . I also wanted to share the interesting bit of information that when I I created the file without comma separator and each field on a separate column then it works. Below the copy of the CSV file i used.
autotest pa$$word Fred Suzuki_autotest Viewer None no firstname.lastname@example.org
There seems to be a difference in the way the files handled in the server and my local machine. When i created the CSV file on the server with comma separator and when I open them on my local machine, the file looks as above. If i creates the file with comma separator and if I use them on the server then it gives an error. Creating the file without comma separator and each field on a separate column then it works in the local machine and moving them to the server on the AWS cloud works.
I have reported this with Tableau and waiting for the response from Tableau technical support.
I wonder if there is something different with the Online setup, like a localization change. Odd.
I had a response from Tableau support and they are very prompt in handling my issue. The response from tableau -
It appears, in fact, that Excel modifies automatically the content of the CSV file. When the list freds,pa$$word,Fred Suzuki,Viewer,None,no,email@example.com is entered in one single cell of the Excel spreadsheet. The actual .csv file created contains this information:
Please note that quotes are added to the begin and end of the list. This is then imported into Tableau Server which reads it as only one field due to the quotes added automatically by excel. The first filed for us is the username, so for Tableau Server "freds,pa$$word,Fred Suzuki,Viewer,None,no,firstname.lastname@example.org" is the actual Username and the password is then missing. For this reason the error is returned.
To avoid the issue in future, please ensure that the content of the file is saved without extra contents added to it. This operation can be performed by entering each filed in its own cell if using Excel, otherwise entering the full list line using a simple text editor as Notepad.
Thanks again for tableau support to make this working with the clear response.