Re: [TYPO3-english] problem with External Data Import ext

2011-04-26 Thread François Suter
Hi, 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

Re: [TYPO3-english] problem with External Data Import ext

2011-03-24 Thread 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 repo

Re: [TYPO3-english] problem with External Data Import ext

2011-03-23 Thread 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 va

Re: [TYPO3-english] Problem with External Data Import ext

2011-03-17 Thread François Suter
Hi, I'm planning to come up with a fixed version very soon. Fixed in version 1.2.1 which should be visible in TER soon. Cheers -- Francois Suter Cobweb Development Sarl - http://www.cobweb.ch ___ TYPO3-english mailing list TYPO3-english@lists.typo

Re: [TYPO3-english] Problem with External Data Import ext

2011-03-17 Thread François Suter
Hi Tonyo, That's it. After all this configuration, I launched the import process and had a successful message "3 new records were imported" Unfortunately, I have nothing in the database. In "developer log", In the "New IDs" line, I have nothing, so I presume it's normal to have nothing imported

[TYPO3-english] Problem with External Data Import ext

2011-03-17 Thread Tonyo
Hi, I have a problem with this wonderful extension ;) I hope somebody could help me. I use externalimport and the feed connector to load and parse a XML in one of my databases. My XML structure is the following : 2 fruitiere test fileadmin/ footer 1 0 ...bla bla 4 fruitiere test3 credit

Re: [TYPO3-english] problem with External Data Import ext

2011-03-16 Thread Xavier Perseguers
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 beg

Re: [TYPO3-english] problem with External Data Import ext

2011-03-16 Thread Nicola Cerchiari
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 altere

Re: [TYPO3-english] problem with External Data Import ext

2011-03-16 Thread Xavier Perseguers
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 Ve

Re: [TYPO3-english] problem with External Data Import ext

2011-03-16 Thread Nicola Cerchiari
Yeah, glad too but i found a (in my case) minor problem in the storing of a field and I don't really know if it even depends on the extension itself. I'm importing a formatted date & time that I convert back to a timestamp before storing it into the destination table. With much surprise when it's

Re: [TYPO3-english] problem with External Data Import ext

2011-03-16 Thread François Suter
Hi Nicola, I finally understood why it wasn't working with trnasformations. I stupidly thought that the $record array passed to the transformation function would contain source fields, instead it's already named against destination fields. Yes, this is a common mistake. I guess I should add

Re: [TYPO3-english] problem with External Data Import ext

2011-03-16 Thread Nicola Cerchiari
I found it!!! I finally understood why it wasn't working with trnasformations. I stupidly thought that the $record array passed to the transformation function would contain source fields, instead it's already named against destination fields. Now everything works like a charm, i got tricked b

Re: [TYPO3-english] problem with External Data Import ext

2011-03-15 Thread François Suter
Hi, But in the step "Data received for storage" the field nmc_external_approval it's always empty. I have other fields with transformation and they just work like a charm. Any further suggestion? Hmm, not really. I would suggest to put some debug statements inside your transformation functio

Re: [TYPO3-english] problem with External Data Import ext

2011-03-15 Thread Nicola Cerchiari
Sorry to confuse you François, i'll try to explain myself better. I think i got ur point and I believe i did everything correctly but anyways here is the external config of my field in the ext_tables.php: 'nmc_external_approval' => array( 'exclude' => 0, 'label' => 'LLL:EXT:nmc-adrxl-liga/lang/loca

Re: [TYPO3-english] problem with External Data Import ext

2011-03-15 Thread François Suter
Hi Nicola, Everything seems to work fine but one little field. What happens is that this field reaches correctly the debug step "Data received (sample)" but then when it should get imported to the corresponding destination field it magically disappear and i really don't understand why. It's just

Re: [TYPO3-english] problem with External Data Import ext

2011-03-15 Thread Nicola Cerchiari
Hi to all, got a new little tricky problem in my exploration of external_import ext. Everything seems to work fine but one little field. What happens is that this field reaches correctly the debug step "Data received (sample)" but then when it should get imported to the corresponding destination fi

Re: [TYPO3-english] problem with External Data Import ext

2011-03-09 Thread François Suter
Hi, I feel really stupid I just forgot to uncheck "substituteOldMailAPI". And I had forgotten about that setting ;-) Cheers -- Francois Suter Cobweb Development Sarl - http://www.cobweb.ch ___ TYPO3-english mailing list TYPO3-english@lists.typo3.o

Re: [TYPO3-english] problem with External Data Import ext

2011-03-09 Thread Nicola Cerchiari
I feel really stupid I just forgot to uncheck "substituteOldMailAPI". As punishment I'll stay silent for 1 day. Thank you again Nik 2011/3/9 François Suter > Hi, > > > The matter is that if i set to any value defaultMailFromAddress >> and/or defaultMailFromName mails are not sent. >> > > Well

Re: [TYPO3-english] problem with External Data Import ext

2011-03-09 Thread François Suter
Hi, The matter is that if i set to any value defaultMailFromAddress and/or defaultMailFromName mails are not sent. Well, I haven't adapted external_import to the new features of TYPO3 4.5, sorry. In particular the sending of the mail doesn't use the new SwitftMailer API and so does not use d

Re: [TYPO3-english] problem with External Data Import ext

2011-03-09 Thread Nicola Cerchiari
Hi again, going on in the exploring of external_import extension and I found a strange behaviour (in my opinion of course). Everything works just fine even report but, of course, the sender is the default one. I didn't find anywhere to set it specifically for this extension but on from installation

Re: [TYPO3-english] problem with External Data Import ext

2011-03-08 Thread François Suter
Hi, The first run complain that the cli user had not enough rights to update tt_address (table that i need to update). Then I updated cli_scheduler user rights to everything i found that could make sense with tt_address table and in fact second run went smooth and it inserted every record, but

Re: [TYPO3-english] problem with External Data Import ext

2011-03-08 Thread Nicola Cerchiari
Hi again, i went on with my develop and made some trials with the scheduled tasks, but i'm stuck again (sorry). The first run complain that the cli user had not enough rights to update tt_address (table that i need to update). Then I updated cli_scheduler user rights to everything i found that cou

Re: [TYPO3-english] problem with External Data Import ext

2011-03-08 Thread François Suter
Hi Nicola, Moreover I also found out that it's just (or mainly) a matter of execution time in fact rising it from 30 to 90 seconds makes the execution not to fail. This matter, as i suppose, happens only in the manual sync coz it uses ajax? I think, yes. AFAIK there's no timeout when executed

Re: [TYPO3-english] problem with External Data Import ext

2011-03-08 Thread Nicola Cerchiari
Hi Françcois, thank you very much for ur advices, they have been very beautiful. In fact i could find out that the "problem" is into the method: $tce->process_datamap(); Moreover I also found out that it's just (or mainly) a matter of execution time in fact rising it from 30 to 90 seconds makes the

Re: [TYPO3-english] problem with External Data Import ext

2011-03-07 Thread François Suter
Hi Nicola, UPDATE: I found it (stupid me), i didn't really understand that "additional_fields" do not have to be declared if u also want to import them ;). Correct :-) So now the import goes smooth but still it gives me "syncronization failed!" even if the data are all correctly imported. I

Re: [TYPO3-english] problem with External Data Import ext

2011-03-07 Thread Nicola Cerchiari
UPDATE: I found it (stupid me), i didn't really understand that "additional_fields" do not have to be declared if u also want to import them ;). So now the import goes smooth but still it gives me "syncronization failed!" even if the data are all correctly imported. It always stops at the debug me

[TYPO3-english] problem with External Data Import ext

2011-03-07 Thread Nicola Cerchiari
Hi guys, I'm trying to accomplish a sync task for which i thought about using ext external_import, but i'm stuck on something that i cannot get through. 1) I made a new connector service as I need to retrieve data from db -> works fine; 2) I prepared my own version of ext "external_import_tut" ac