2. PHPRunner General questions
  3. Excel Import is trashing data
This topic is locked

Excel Import is trashing data

 		12/22/2009 5:49:46 PM
PHPRunner General questions
H
 htwebdev author

Using PHPRunner version 5.1 (build 2503).
I have an Excel spreadsheet that is trashing 2 fields when importing into an MS SQL db (the fields are both varchar in the db). One column in the spreadsheet is a data column with a format of M/D/YY, the other column in the spreadsheet is formatted for time (1:30 PM). Both of the fields in the db are varchar right now. it's converting the dates to an integer and sometimes converting the times to a decimal number. Is there anyway to modify/change/remove the casting it's doing during the import?
J
 		Jane 12/23/2009

Hi,
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
H
 		htwebdev author 12/23/2009

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.



that's a lot of work for one small aspect of the script, plus this is app requires a login to get into. so I'll need to upload all that stuff as well right?
H
 		htwebdev author 12/23/2009

After digging around in the spreadsheet a bit, I discovered that it was Excel that was doing the conversion. It was strange, if I export to CSV, the values in the colunms were fine (but PHPR choked on the csv import). But if I would change the format in the spreadsheet itself, from date to text, it would convert the date to a number. Seems that Excel is actually saving the date as an integer rather than, a date I guess.