Get EasyTable Pro !

Get a Subscription for EasyTable Pro!
(
The current version is emailed to you when your subscription is payed.
Existing Subscribers can download here

Saturday May 19 , 2012
Font Size
   

500 - Error: Data insert failed for table: X in updateETTDTableFrom()

500 - Error: Data insert failed for table: X in updateETTDTableFrom():
Possibly your CSV file is malformed

This error occurs when uploading a new file to the component. This is the result of errors in the CSV file being uploaded - the CSV file format (RFC4180) is defined here, a more readable summary is on Wikipedia.

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 ismalformed"

The first thing to check is the CSV file meets the definition. The best way to do this isusing 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 CSVfile 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.

Failing all of that, if you have a current Support Subscription you can send the file in question to our subscriber support forum and we'll take a look at it for you.

RSForm! Pro by RSJoomla!


RSForm!Pro is a powerful Joomla! form creator, helping you to create custom forms in minutes. The new product makes form management much easier and gives you the time to handle your clients better.

For only €19.00 how can you go wrong?
 ( We've used it for years... Shouldn't you? )

Member Login