bykrmom Posted September 9, 2008 Share Posted September 9, 2008 No, I haven't updated (yet) because I'm afraid to mess up all my weeks of work making the site look/feel the way I need it to. I hope that isn't why this doesn't work.Problem: .csv won't import with "," as the seperator. It tells me I have "Invalid CSV file or delimiter." However, it WILL import the file with a ";", but the rows are all messed up. They look NOTHING like the Wiki instructions illustrate.What I have done to try to fix it: I re-arranged the columns to be in the exact order shown in the Wiki, just in case that might make a difference. I stripped the column headers too, as they showed up in the messed up import as an uption to import.Here is an image of what I get when I import using ; as the delineator. As you can see, not the desired result. WHat might I be doing wrong? What might be in the file itself causing the issues?The bosses just gave me a CD with 10,000 new products on it to go on the site. If I can't import the 150 or so we already had to list using this file, what chance do I have? I could retire (12 years away) without finishing the products if I have to bring them in one at a time.Solution:Not so much a solution, as it is a lot more understanding on my part. The import function is VERY picky on what is in each field. So far, a comma anywhere in the description or price will keep the import from working. The only commas you can have are the data seperators. Also, after re-reading the Wiki, you need to remove $ (or other currency marker) from the price. You cannot do this using the standard .csv file opened in Microsoft Excel. I used notepad, and manually edited the files using the find and replace functions. I also had to go in and remove commas from anything over 1000 dollars line-by-line.Among other things that CANNOT be in the text, are "#" and "*" and "/", even if they are inside of quotes. Also, anywhere the description included inches using the " symbol, I had to change them all to "inches".I did manage to successfully import 671 products that I now have to go in and edit one at a time. But it should save me about a month by already existing in the database. I like time saving!I still haven't gotten the original website data to import from the boss's old site. It's frustrating. But I'll get there. I've come too far to quit now! :coolsmile: Link to comment Share on other sites More sharing options...
getmerich63 Posted September 10, 2008 Share Posted September 10, 2008 Thanks for the info about CSV import. I'll know now what to make sure is not in the CSV file when I bulk upload next. Link to comment Share on other sites More sharing options...
Tito Posted September 10, 2008 Share Posted September 10, 2008 I use # as seperator, making it easier to ereg_replace , or ; in descriptionsto bad my favorite seperator | doesn't work Link to comment Share on other sites More sharing options...
bykrmom Posted September 10, 2008 Author Share Posted September 10, 2008 I tried # as a seperator too, but it wouldn't go. I did manage to get everything imported now using commas, however.All in all, it's been a GREAT day here where my work with this new site is concerned. :coolsmile: Next for me is creating tables in MySql for forms submission, and generating emails to notify us of it, and notify the customers that we recieved it.I may cheat and just use .php wiout the .tpl.. I'm still confuzed using .tpl and smarty code. :gulp: Link to comment Share on other sites More sharing options...
getmerich63 Posted September 10, 2008 Share Posted September 10, 2008 I'm still having problems with the CSV import even though I did everything that you suggested. Hope somebody can help me get this figured out soon.Other than the XSV import problems this is a good store script. I like it very much. Link to comment Share on other sites More sharing options...
bykrmom Posted September 11, 2008 Author Share Posted September 11, 2008 How many items are you trying to import?Did you read over the Wiki about what fields you can currently import to Prestashop? Link to comment Share on other sites More sharing options...
getmerich63 Posted September 11, 2008 Share Posted September 11, 2008 Yes I did read the Wiki about the CSV import and tried everything that it suggested. I still game up with the same invalid CSV file or delimiter. I had 1 item in for the test import. I was doing just fine a few days ago when I added an import of a little over 100 products in. Link to comment Share on other sites More sharing options...
Tito Posted September 11, 2008 Share Posted September 11, 2008 Probably a 'bad' word in the description.I have been reformatting my csv file on trial and error. without any logic what could be wrong.Tried different seperators, htmlentities encode, decode, even tried removing all non letter characters from descriptions.Then I started importing (through import csv function) product by product. Veeerrrryyy time consuming.When I was at product 478, I discovered the word 'Ciney' (a Belgian beer) is not allowed !!The BO didn't show what the error was, just a 'bad csv or seperator' error.Removing this 1 product from a +1000 csv file solved it...So, What would be very useful is a list with all 'bad' words. Or a module to edit the bad word filter list!! Link to comment Share on other sites More sharing options...
getmerich63 Posted September 11, 2008 Share Posted September 11, 2008 Would you like me to send you a copy of the CSV file so you can check it out? If I can I'll attach it in here.products.csv Link to comment Share on other sites More sharing options...
bykrmom Posted September 12, 2008 Author Share Posted September 12, 2008 You have your file formatted incorrectly. You cannot have empty fields, or special characters. You have – between "beadspread" and "full" on 2 lines. Your description is in the reference number field. Unless your file was corrupted on upload or download to my PC, it's all messed up.You have much too much info in the fields, and a lot of quotes where you don't need them. You can import only the few values in the Wiki: ID Reference Name EAN13 (what is this value anyway?)Price Weight Quantity Description Short Description Category I'm having problems with this forum at the moment, having to refresh the pages 3 or 4 times constantly to get them to load, but I'll try to attach a revised file. Obviously you'll need to edit it once it's in the store to make it the way you want it. Link to comment Share on other sites More sharing options...
bykrmom Posted September 12, 2008 Author Share Posted September 12, 2008 I'll try the file upload one more time...won't work, sorry.Just make sure you remove the special characters, and don't have any empty fields. Even a "0" in a field is enough and you can edit it once you import it.That's all I can suggest. Oh - and USD is not a number. Just use "95.00" (without the quotes) and add USD to the text after import. Link to comment Share on other sites More sharing options...
Tito Posted September 12, 2008 Share Posted September 12, 2008 EAN13 = (european) barcode numberean13 @ wikipedia Link to comment Share on other sites More sharing options...
getmerich63 Posted September 12, 2008 Share Posted September 12, 2008 Everytime I try, bulk uploading a few products in, I still get the invalid CSV file or delimeter.I tried 2 items this last time. I'm wondering if there's a bug with the CSV Import toolI'm including the CSV file again. When I tried to bulk upload, I tried using a comma in between each field.When that wouldn't work, I tried using a ; for the field delimiter. It still won't work. If I can't get anywhere, we'll probably have to add our products in by hand which takes a long time also.Hopefully the 1.1 RC1 will work without the bug if there's one in the script now.. tmntest.csv Link to comment Share on other sites More sharing options...
jtyana Posted September 12, 2008 Share Posted September 12, 2008 Your csv is incorrect. The csv has to be one field per column and one record per rowYou are using only one column for all fields and many rows for one recordIf you are using Excel, choose File > Save As > comma separated csvThen upload with a comma delimiter. Link to comment Share on other sites More sharing options...
jeremy Posted October 10, 2008 Share Posted October 10, 2008 Could someone send me a copy of a working, correct csv so that i can do some test uploads. I couldn't find one in the wiki. Thank you. Really appreciate it. Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 29, 2008 Share Posted October 29, 2008 I have a similar problem with importing CSV files.I get the following message whenever I try to import the file:-Invalid CSV file or delimiter.This is really getting to me now, I've tried a few options as I've worked with CSV files before on other projects.Can anyone please help me get the stock list I have from my supplier (available in Excel or CSV format) to work as I need to import around 3700 items this way. Link to comment Share on other sites More sharing options...
bykrmom Posted October 30, 2008 Author Share Posted October 30, 2008 The first thing I can suggest is to make sure that there are no extra commas in your import file. I checked this by counting entries between commas in notepad. Then check to be sure you're not trying to import a field with more than 400 characters (including spaces). Next, take out any "$" signs, "#" characters, and "/" characters. Once I did this, I got mine to import using the comma as a seperator.If none of that works, I might be willing to take a look at your CSV file for you, in case I missed something. As I have gotten more than my fair share of help here in this forum, I think it'll be OK if I give back a little.Let me know how it goes. If you need me to look at the file directly, we can exchange emails in a private message later.Angie (bykrmom) Link to comment Share on other sites More sharing options...
Darkmarauder Posted October 30, 2008 Share Posted October 30, 2008 Hello There,I made this post yesterday because I was having little to no luck with the topic I had already subscribed to. Therefore could you have a look at:-http://www.prestashop.com/forums/viewthread/5780/P15/general_discussion/example_of_correct_csv_import_fileHere you can find the csv file I'm wrestling with and make any comments on this topic if you are able to help.Thank YouRegards Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now