CSV file could not be parsed
Parsing CSV files is no easy task, there are many different formats and character encodings. We've done the best we can to address 80% of the use-cases. In situations where we can not parse the file there are usually a few things you can do to try and figure out what's going on. For starters here's what we've seen in the wild.
- Some systems format CSV files but surround the entire csv file with quotes. This gives our csv parser some trouble. We've been working on a solution to try and support this format but we aren't there yet. If you remove the starting and ending quotes of the csv file this may help.
- Our CSV parser supports the utf-8 encoding. Handling all encoding formats is a challenge to say the least so we've picked one that we think is the most popular. If your csv file has characters that are not utf-8 it's possible this has caused EZ Importer to throw an error.
- Look for strange characters in your file. We've seen things like the curley quotes cause the parser to break. You may want to look for them or other characters that are not supported.
- We support a subset of delimiters that seem to work for the majority of systems. We can't support everything under the sun but we do the best we can. We currently support commas, semi-colons, pipes and tabs. If this is a real issue for you let us know and we can see if we can support you.
If you are still struggling to get your CSV file to parse you can look at some possible validation tools that might be able to help you. Every case is different and you know your data better than anyone so the more you can test the better.
Obviously there are a myriad of problems that can arise when working with free from CSV files. We do our best to support everything we can. If we see problems arise with customers we work hard to support the issue. If you've run through everything you can and still can't seem to figure out how to get your CSV file to parse correctly please don't hesitate to contact us to see if we can help!
App: EZ Importer