Hey first of let me say good work on the software guys it's really looking good. So my issue is that when I try to import an file either CS,EXL nothing happens i just get 0 records imported. Any idea on where I might start off to find the issue, IE "bad file format, connection, mysql side, phpside"
I am using phprunner 4.2 331
Apache 2.0
php 5.1.6
mysql 5.0.24a
SQL
SELECT `0000000001 SC1000 OUT DATETIME`,
`0000000001 SC1000 OUT PH`
FROM `0000000001 sc1000 out ph`
TABLE LAYOUT
-- Table "0000000001 sc1000 out ph" DDL
CREATE TABLE `0000000001 sc1000 out ph` (
`0000000001 SC1000 OUT DATETIME` datetime NOT NULL,
`0000000001 SC1000 OUT PH` decimal(5,2) default NULL,
PRIMARY KEY (`0000000001 SC1000 OUT DATETIME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
RAW DATA OUT OF EXCEL SHEET
12/1/2007 9:00 7.51
12/1/2007 9:15 7.52
12/1/2007 9:30 7.53
12/1/2007 9:45 7.54
12/1/2007 10:00 7.55
12/1/2007 10:15 7.56
12/1/2007 10:30 7.57
12/1/2007 10:45 7.58
12/1/2007 11:00 7.59
12/1/2007 11:15 7.6
12/1/2007 11:30 7.61
12/1/2007 11:45 7.62
12/1/2007 12:00 7.63
12/1/2007 13:00 7.64
RAW DATA OUT OF CSV SHEET
12/1/2007 9:00,7.51,,
12/1/2007 9:15,7.52,,
12/1/2007 9:30,7.53,,
12/1/2007 9:45,7.54,,
12/1/2007 10:00,7.55,,
12/1/2007 10:15,7.56,,
12/1/2007 10:30,7.57,,
12/1/2007 10:45,7.58,,
12/1/2007 11:00,7.59,,
12/1/2007 11:15,7.6,,
12/1/2007 11:30,7.61,,
12/1/2007 11:45,7.62,,
12/1/2007 12:00,7.63,,
12/1/2007 13:00,7.64,,
12/1/2007 13:15,7.65,,
12/1/2007 13:30,7.66,,
12/1/2007 13:45,7.67,,
Thank you for any help, or idea's
Travis Wilson
