1 of 1 people found this helpful
Often the above error message occurs when the file that is being imported is opened. Close the file and try re-importing it. I have also attached the ini file and csv file here. Make sure that they are saved in a folder all by themselves. Hope this helps!
Thank you for your answer.
The file is closed and the ini file is in the same folder.
I have tried a thousand different situations and nothing. I had read all the posts in the forum and tried everything.
I will keep trying!
Thanks once again
I just tried to open your original CSV file in Excel and I got a weird message about Sylk file format not being supported.
This turns out to be because the first two characters in the file are "ID", as described here.
Not sure if this is what's confusing the custom geocoding import - I didn't look any further - but I thought I'd point this out. I notice Tracy has swapped the order of the columns in the file she attached, which would have been enough to get around the Sylk issue anyway.
Thanks. I have saw this to. It's just changing "ID" to "Id". But these are not the problem.
I have found a solution with support team that I want to share:
- Replace all the comma column delimiters in the file with vertical bar
- In the schema.ini file put this option: Format=Delimited(|) (Attched my schema.ini file and a csv sample)
- Put the csv file and the ini in the same directory
- Import in Tableau
With this solution I was able to import.
Normal Problems that I Found:
Decimal Separator: , or ; or . (This depends your regional settings that can be changed in Control Panel) I have imported mine with ,
I hope that helps