malcek Posted August 28, 2009 Share Posted August 28, 2009 Hi,I'm having problem importing product and categories in my language. (Slovenian) In my language we have ČŠŽ, which is in cvs file seen like some strange signs and import wont do what is he need to do and report to me "Hack attempt". I have in Excell selecting language code UTF-8. Does anybody know what is the problem and solution for that.best regards,martin Link to comment Share on other sites More sharing options...
CYTechnologies Posted August 28, 2009 Share Posted August 28, 2009 What are the signs in the csv? Link to comment Share on other sites More sharing options...
radders Posted August 28, 2009 Share Posted August 28, 2009 Csv files are a really difficult way of loading data. I've been playing around for ages to get some products loaded without much success and I don't think you can load such characters using the standard routine.I don't know if it would make any difference if you replace the letters with the character codes (probably not).Failing that there should be a way of using phpmyadmin to create the appropriate tables if you already have the data in mysql. Link to comment Share on other sites More sharing options...
malcek Posted August 28, 2009 Author Share Posted August 28, 2009 Here is the strange symbolsJERZEES 001M DOLGE DELOVNE HLA�ESee attached picture! Link to comment Share on other sites More sharing options...
VIXUS Posted August 28, 2009 Share Posted August 28, 2009 after saving excel file to csv open it in notepad and than save with UTF-8 code... that works for me. Link to comment Share on other sites More sharing options...
malcek Posted August 29, 2009 Author Share Posted August 29, 2009 Hvala, brate. Sada radi bez problema. Puno ti hvala. :cheese: Martin Link to comment Share on other sites More sharing options...
VIXUS Posted August 29, 2009 Share Posted August 29, 2009 ma nema na cemu! ;-) ...ceka te jos problem nasih slova u PDF-u Link to comment Share on other sites More sharing options...
Jaason Posted August 31, 2009 Share Posted August 31, 2009 Hi, Can You tell me how Yours csv look like? I have problem with uploading products, and don't know how this file should look like...I need to use " separators for text? I need to use every column in the csv file, even if there is no information for it??could You share with some example? Link to comment Share on other sites More sharing options...
malcek Posted August 31, 2009 Author Share Posted August 31, 2009 You just use MS Excell and named coloums with field name you need. After you make complete selection of your product Save as and select insted .xls - . cvs. and your cvs is prepare for importing to prestashop. kategorije_cvs.csv Link to comment Share on other sites More sharing options...
Jaason Posted August 31, 2009 Share Posted August 31, 2009 heh, probably that was the reason.. I'm using Open Office, ok I'll try MS excelBig thx ! Link to comment Share on other sites More sharing options...
malcek Posted August 31, 2009 Author Share Posted August 31, 2009 But be aware when you export excell file it don't know to export in UTF-8 format, that you need to with Notepad. Just open cvs file and at bottom of window you will see encoding (by defult ANSI, change it to UTF-8) and we are in bussines ;-) Link to comment Share on other sites More sharing options...
howard Posted June 30, 2011 Share Posted June 30, 2011 after saving excel file to csv open it in notepad and than save with UTF-8 code... that works for me. Solved How do you get notepad to save as UTF-8? sorry got it bott0m line encoding may help others? Link to comment Share on other sites More sharing options...
malcek Posted June 30, 2011 Author Share Posted June 30, 2011 adding picture. Change to UTF-8 on button marked with red 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