[TYPO3-english] problem with External Data Import ext

[Nicola Cerchiari]

Hi guys and specially François,
i'm doing some filed thest with the extention external_import and i'm
encountring a little glitch.
As I understood these kind of errors in email report are per record errors:

*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.

I tried to track back the code but I could really succeed in this, I thought
easy stuff to do though :(.

Any help?


Thanks,

N

2011/3/16 Xavier Perseguers <xavier.perseguers at typo3.org>

> Hi,
>
>
>  btw my $TYPO3_CONF_VARS['SYS']['serverTimeZone']  is set to 1, shall I
>> change it to something else? Which are the possibilities?
>>
>
> With serverTimeZone = 1 you set your timezone to GMT+1. A Unix timestamp
> has no timezone support (that's was an issue with the Fluid date viewhelper
> at the beginning btw). With GMT+1, the timestamp you put in the DB should
> take this into account and be modified accordingly. Just add/subtract the
> serverTimeZone number of hours before storing and TYPO3 should be happy and
> show you the "correct" date/hour.
>
> For instance here is how to get a valid DateTime object out of a timestamp
> (coming from TYPO3 DB). It takes the php.ini timezone setting but you may of
> course take serverTimeZone into account instead.
>
> $dateTime = new DateTime('@' . $this->lastModificationDate);
> $dateTime->setTimezone(new DateTimeZone(date_default_timezone_get()));
> return $dateTime;
>
> HTH
>
> --
> Xavier Perseguers
> Release Manager TYPO3 4.6
>
> TYPO3 .... inspiring people to share!
> Get involved: http://typo3.org
>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>