[TYPO3-english] problem with External Data Import ext

[François Suter]

Hi Nicola,

> *These fields are not properly updated in database:
> (first_name,last_name,name) Probably value mismatch with fieldtype.*
>
> The matter is that with>  20.000 record is kinda impossible to get which
> record contains the offending data, is there a way to add or see the record
> id in the reports or in the devlog.

Unfortunately TCEmain logging is not very helpful when you manipulate a 
lot of records at a time, which happens often with External Import.

What you can do, though, is to looks directly at table sys_log using a 
MySQL client and look for records with that message. Normally the 
columns "tablename" and "recpid" should be filled, so you should be able 
to find the erroneous records.

I can add that the error that you see is due to the fact that the data 
has not been stored properly in the database. The most common source of 
error for simple text fields is bad encoding or data that is longer than 
the field's size.

HTH

-- 

Francois Suter
Cobweb Development Sarl - http://www.cobweb.ch