You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
I have 1300 products to add to the database and its all in an excel spreadsheet but when I save the spreadsheet in CSV it sees the commas in teh descriptions as delimiters , what can I do short of removing all commas from the descriptions ?
Offline
I think this will work:
If a comma or leading and/or trailing blanks appear in any field value the field must be enclosed by quotes (") to indicate the information is data and not a field divider.
Offline
Thanks I'll give it a try !
Offline
Okay , got past all that , turned out there was hidden "end of line" keys in my short descriptions , messes everything up ! Now I have a new problem . I brought the product.csv file into MSAccess and wrote an append query to add all my 1300 products in and it worked fine , I dumped it back to a new product.csv file and all the records look good , CCP51 accepted the new products.csv fine and let me change it to MySql , BUT a few of the fields are not being read by CCP51 , first , the product_status , even though there is an "R" in the field if you browse the database ( using PHPMyAdmin ) when I pull up the data file for the record in CCP51 ( in admin mode ) , it shows blank , when I pull up the product like a customer would , it shows everything including the price but no option to actually buy it .
Then there is the product_delmethod , this one shows the "R" for realtime if I browse the database but it shows up as blank in the CCP51 admin .
So obviously there is some hidden character there or something , I just am not sure where to start to get a grip on this , anybody got any ideas ?
Offline
Okay I got it , it was the fact that Access added some leading spaces during the append query . I used a cute little program called CSVed to remove all the leading and trailing spaces with simple click . Now all is good !
Offline