I imported CSV data into my MYSQL database into a table. When I uses phpMyAdmin to import the data
it works correctly. When I use the phprunner mechanism two fields did not work correctly. The two
fields were the "datetime" field and the "text" field.
When I followed the directions on the phprunner import page
"The first line in the file should contain the field names" nothing imported.
When I imported the CSV data with out the "field names" all but the "datetime" & "text"
fields imported correctly. On the notes field the first line of the text field imported into the record.
Below is my record structure.
CREATE TABLE terr (
lang varchar(10) default NULL,
ter# int(11) NOT NULL,
dt_out datetime default NULL,
dt_in datetime default NULL,
who varchar(25) default NULL,
note text,
PRIMARY KEY (ter#)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
