What file format does EasyTable support?
EasyTable 1.0 imports data in a CSV file format. The CSV format (RFC4180) is defined here, a more readable summary is on Wikipedia.
The key part of the error message occurs at very begining:
Possibly your CSV file is malformed
EasyTable only supports CSV files and it does this using PHP's method fgetCSV method. If the fgetCSV throws up an error you will see that line "Possibly your CSV file is malformed"
The first thing to check is the CSV file meets the definition. The best way to do this is using a Unicode aware text editor that can search for & display invisible characters in your CSV file, ( and no Notepad isn't good enough ). I personally recommend BBEdit but I'm sure there's something on Windows/Linux environments that does a similar job.
Things to look out for
- control characters that need to be encoded first
- comma's in the body of a field that aren't properly encased
- the wrong delimiter used for fields eg. a semi-colon ; rather than a comma
To determine if your file is the source of the problem try downloading the sample CSV file in our downloads area and uploading it to your website. If that works then there's a reasonable chance that your CSV file is malformed as the error message indicates.
Get our Newsletter!
All the software updates and special offers in your mailbox.
Member Login
Latest Forum Posts
Latest Downloads
- EasyTable Component 1.0.3b (2010.04.15)
- EasyTable Component 1.0.2 (2010.03.30)
- US Presidents Portraits (2009.12.11)
- Sample CSV File of US Presidents (2009.12.11)
- USFlags.zip (2009.11.04)