This topic is locked

PHP Runner 4.2 Import error

3/5/2008 10:13:10 PM
PHPRunner General questions
J
jackel66 author

I have tried this a ton of different ways and still no good. I have 3 date fields in an excell sheet i want to import. When i import them useing a customer script there is no issue they are on the excel sheet as 2007/11/28. But when there imported with the Importer built into phprunner they come out as 1969/12/31. Has anyone encoutered anything like this? or is there a way i need to setup my excel template to avoid this.... Im importing into MySql the column is as a Date column.
i have realized the 1969 date is becuase the importer cannot read the date listed where can i or even can i edit the formats of the dates. i have added the following to the Excel reader.php file with no success.

0xa => "yyyy/mm/dd",

0xb => "dd/mm/yyyy",

0xc => "mm/dd/yyyy",

0xd => "y/m/d",
any help would be appreciated.
thanks

W
wrjost 3/6/2008

Hi, Jackel55,

there are a lot of problems with the import, with both csv and Excel files.
Hope they will be addressed (and solved) before the 4.2 final.
Greetings,

Wilfried
P.S.: It is always a good idea to search before posting... ;-))) Just type "excel import" into the "Enter Keywords" box and then press "Search Forum" - you will find a list of problems others have encountered. Mine also centers around the import of date fields.