- Home /home on the range…
EasyTable Pro! product info & how-to's
- Get EasyTable Pro!
- Getting Started
- Manager Features
- Search Options
- Field Types & Tokens
- Displaying your Table
- Detail View
- Advanced Display Options
- Advanced Settings
- Automatic Imports using CRON
- EasyGitHub Include
- EasyTable Pro! product info & how-to's
Downloads get your files here...
- EasyTable Pro! Login to see your downloads
- EasyNAB for AkSubs Login to see your downloads
- EasyNAB for JDonation Login to see your downloads
- EasyTable for J! free... as in beer.
- EasyGitHub Include ...the geeks content plugin...
- EasyStaging ...your website staging helper...
- EasyDownloads ...your secure download manager...
- CommWeb/MIGS for VM2 Login to see your downloads
- Register for Forums
- Category: EasyTable
- Published on Friday, 13 November 2009 15:47
- Written by Craig Phillips
- Hits: 19963
EasyTable for J 1.0+ and EasyTable Pro! imports data in a CSV file format. (EasyTable Pro! also supports the TSV variant for TAB seperated files.) 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:
EasyTable only supports CSV (and TSV for EasyTable Pro! ) 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 files 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.
Non-Latin CSV/TSV files
If you are using a non-latin languages you can export UTF-8 encoded CSV/TSV files which will preserve the non-latin charaters. (To see an example of a non-Latin UTF8 encoded CSV file you can download one from our Sample Files area.)