Hi Jason,
Thanks for the spreadsheets. I thought I'd give it a try and see how it worked. The first think I noticed was that you are using a semicolon instead of a comma. Sure makes the sheets harder to work with. Nonetheless I soldiered on. I tried an import in both products and categories. I got the same results with both. Obviously I'm doing something wrong with the import. I've tried several different ways and get the same results. I've pretty much got the import down with csv but not ssv. (semicolon separated value) Any indea on what I'm doing wrong in the import?
Thanks
LOAD DATA LOCAL INFILE 'C:\\xampp\\tmp\\phpA1.tmp' INTO TABLE `ps3_categories` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'(
`CategoryID;"CategoryName";"CategoryParent"`
)
MySQL said: Documentation
#1054 - Unknown column 'CategoryID;"CategoryName";"CategoryParent"' in 'field list'