2. PHPRunner General questions
  3. [SOLVED]  Problem with import from excel
This topic is locked
[SOLVED]

 Problem with import from excel

 		7/3/2010 6:44:58 AM
PHPRunner General questions
S
 sadisticmagician author

Hi, i have a Problem with import from excel.

example of excel file:
date 1

05/06/2010
date2

05/07/2010
date 3

empty
in phprunner i received this list:
date 1

05/06/2010
date2

05/07/2010
date 3

01/01/1970 (here i want a field empty)
thanks for help me
Sergey Kornilov admin 7/3/2010

You can try to leave this field empty in Excel if you don't want to import any date.
S
 		sadisticmagician author 7/5/2010



You can try to leave this field empty in Excel if you don't want to import any date.


Yes, i leave this field empty in excel but phprunner automatically put

date in 01/01/1970.
A
 		ann 7/5/2010

Hi,
use Before Insert Record event on the Events tab.

Here is just a sample:

if (!$rawvalues["date3"]) {

unset($values["date3"]);

}



where date3 is your actual field name.