[TYPO3-english] problem with External Data Import ext

Nicola Cerchiari nicola.cerchiari at gmail.com
Wed Mar 16 14:54:34 CET 2011


Hi Xavier,
I'm not sure I got ur suggestion.
Do u mean that my server is storing UTC value of my timestamp or am  I
completely out of  path?
The destination field is merely an int(11) field, what I don't really get is
why after the correct transformation date&time > timestamp the latter gets
altered again.

btw my $TYPO3_CONF_VARS['SYS']['serverTimeZone']  is set to 1, shall I
change it to something else? Which are the possibilities?

Thanks in advance,
N

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

> Hi,
>
>
>  In details: I could check that everything is fine till the TCEmain debug
>> step is complete but the final timestamp written in the db is an hour
>> backward.
>> For example:
>> I get this date ->  10-03-2011 13:47:37 transformed like this ->
>>  1299761257
>> but in the database I get this ->  1299757657
>>
>> Very strange to me, no?!
>>
>
> Sounds like a server timezone preset whereas your source timestamp was UTC:
>
> $TYPO3_CONF_VARS['SYS']['serverTimeZone'] = '1';
>
> But I may be wrong...
>
> --
> 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
>


More information about the TYPO3-english mailing list