outlet.ee Posted February 7, 2010 Share Posted February 7, 2010 Well, I am very pleased now as I solved the problem importing product data in different languages via CSV. First you have to import the products in one language with the import tool though. I opened the SQL database at my web host phpmyadmin, then exported table 'ps_product_lang' in CSV, edited the data and imported it back to the database, and voila!, it works! Link to comment Share on other sites More sharing options...
VladoZem Posted February 7, 2010 Share Posted February 7, 2010 How you do that?have u got any manual?and which module are u using for export?Thanks Link to comment Share on other sites More sharing options...
outlet.ee Posted February 7, 2010 Author Share Posted February 7, 2010 It's external from prestashop, you have to log in to your web hosting service and find phpmyadmin or sql database and export-import from there. Link to comment Share on other sites More sharing options...
Timothy Jarman Posted April 15, 2010 Share Posted April 15, 2010 hey Elvis, your a legend for telling us this, it has been so frustrating editing one by one. Now i can do this. thank you once again. Link to comment Share on other sites More sharing options...
uddhava Posted April 15, 2010 Share Posted April 15, 2010 RC1 import tool has the ability now to import in the default language and any other installed language.No more messing around with myadmin...ys Link to comment Share on other sites More sharing options...
Timothy Jarman Posted April 16, 2010 Share Posted April 16, 2010 really? nice one i will check it out. Does rc though mean its still not stable for live use? Link to comment Share on other sites More sharing options...
howard Posted October 25, 2010 Share Posted October 25, 2010 Well, I am very pleased now as I solved the problem importing product data in different languages via CSV. First you have to import the products in one language with the import tool though. I opened the SQL database at my web host phpmyadmin, then exported table 'ps_product_lang' in CSV, edited the data and imported it back to the database, and voila!, it works! Hi I am searching the forum for help on importing csv files I can export them edit them but they will just not import I have tried heitSQL compressing + not compressed changed the fields but I keep getting the same message Invalid field count in CSV input on line 1. can anyone give some more help Link to comment Share on other sites More sharing options...
yast Posted October 26, 2010 Share Posted October 26, 2010 RC1 import tool has the ability now to import in the default language and any other installed language.No more messing around with myadmin...ys Just wanted to report,i am on Version 1.3.2.3 en the import tool for multiples languages doesnt work at all,it overwrites the default language.I will just write the 2nd language into the db directly with a php script Link to comment Share on other sites More sharing options...
mecollectibles Posted June 5, 2011 Share Posted June 5, 2011 Import does not work for version 1.3.2.3 Link to comment Share on other sites More sharing options...
pemeclama Posted June 5, 2011 Share Posted June 5, 2011 Thank you very much!!!! It works!!!. I had a very big problem with translations in 1.3.2.3 with 7549 products. Thanks for your help!! Link to comment Share on other sites More sharing options...
mecollectibles Posted June 5, 2011 Share Posted June 5, 2011 Thank you very much!!!! It works!!!. I had a very big problem with translations in 1.3.2.3 with 7549 products. Thanks for your help!! How was it solved for you?? Link to comment Share on other sites More sharing options...
pemeclama Posted June 5, 2011 Share Posted June 5, 2011 Like outlet.ee says in first post:Well, I am very pleased now as I solved the problem importing product data in different languages via CSV.First you have to import the products in one language with the import tool though. I opened the SQL database at my web host phpmyadmin, then exported table ‘ps_product_lang’ in CSV, edited the data and imported it back to the database, and voila!, it works!You have to go inside your phpadmin (you have to know the address and yours username and password for go inside). Be careful!!! Make backups!!!.Then export the table ps_product_lang in CSV format. Open it with excel and in the second row, you will find de id_lang (Code of the language). Change the product name in the lines with your id_lang. Save it in CSV format. Then go again into your phpadmin and delete the products (you can do it with "truncate ps_product_lang") and import your CSV file with LOAD DATA. That's all. I remake the index and it works fine!!!!I hope you will done it!! Link to comment Share on other sites More sharing options...
mecollectibles Posted June 5, 2011 Share Posted June 5, 2011 Open it with excel and in the second row, you will find de id_lang (Code of the language). Change the product name in the lines with your id_lang. Save it in CSV format. Then go again into your phpadmin and delete the products (you can do it with "truncate ps_product_lang") and import your CSV file with LOAD DATA. That's all. I remake the index and it works fine!!!!I hope you will done it!! I exported it but do not know what must be changed say for the German language in my account & where to upload. Link to comment Share on other sites More sharing options...
pemeclama Posted June 6, 2011 Share Posted June 6, 2011 As you can see in the picture, you have to open the CSV file with excel. At the second row, you will find the id_lang. Filter the desire id_lang and change the description (of what you want). Then save as CSV and import in your phpadmin. Link to comment Share on other sites More sharing options...
pemeclama Posted June 6, 2011 Share Posted June 6, 2011 I forget the picture... sorry Link to comment Share on other sites More sharing options...
mecollectibles Posted June 6, 2011 Share Posted June 6, 2011 As you can see in the picture, you have to open the CSV file with excel. At the second row, you will find the id_lang. Filter the desire id_lang and change the description (of what you want). Then save as CSV and import in your phpadmin. My CSV file is not sorted as yours as you see in the picture & thus there is no place as you state.What should I do? Link to comment Share on other sites More sharing options...
pemeclama Posted June 6, 2011 Share Posted June 6, 2011 When you export the table, you have to click on CVS for Excel and another click on make a downloaded file. I hope your phpadmin can do that. Link to comment Share on other sites More sharing options...
pemeclama Posted June 6, 2011 Share Posted June 6, 2011 Sorry again... You have to click at CVS data down the other CVS for excel, and you will find the rows in your excel. 1 Link to comment Share on other sites More sharing options...
mecollectibles Posted June 6, 2011 Share Posted June 6, 2011 When you export the table, you have to click on CVS for Excel and another click on make a downloaded file. I hope your phpadmin can do that. Same as before even after following your instructions.Please have a look at the attached picture. Link to comment Share on other sites More sharing options...
mecollectibles Posted June 6, 2011 Share Posted June 6, 2011 Thought this might also help to see what I downloaded. Link to comment Share on other sites More sharing options...
pemeclama Posted June 6, 2011 Share Posted June 6, 2011 I'd sent you another message, because you have to click in CSV (not in CSV for excel) I'm sorry. Link to comment Share on other sites More sharing options...
mecollectibles Posted June 6, 2011 Share Posted June 6, 2011 Would you please see my file above & make which one you mean? Link to comment Share on other sites More sharing options...
pemeclama Posted June 6, 2011 Share Posted June 6, 2011 I think it has to be this one... If not, try whit the ones that say excel.Good luck! Link to comment Share on other sites More sharing options...
mecollectibles Posted June 6, 2011 Share Posted June 6, 2011 the Excel file does not download!The CVS you advised was not also the proper file. Link to comment Share on other sites More sharing options...
mecollectibles Posted June 6, 2011 Share Posted June 6, 2011 I think it has to be this one... If not, try whit the ones that say excel.Good luck! The excel file downloaded at last & it is the file we were searching!Thanks a lot.Now, what should be done? Link to comment Share on other sites More sharing options...
pemeclama Posted June 6, 2011 Share Posted June 6, 2011 You have to make a filter of the second row (id_lang). Select the language you want and change the descriptions or what you want. Then save like CSV and import in your phpadmin. Link to comment Share on other sites More sharing options...
mecollectibles Posted June 6, 2011 Share Posted June 6, 2011 I do not know how to do.In fact if you have a look at my website, you notice it is in 4 languages but the titles of the items in the English version are complete starting with the country name & to end while the titles of other languages are just 3-5 words & not complete.I just want the title of products in the English language replaces the title of the products in the other 3 languages & make them complete starting with the country name.The language section in the 2nd row are numbers 1, 2, 3, 4, 5 & I wonder which represent what language & why 5 numbers while the languages are 4 in my website.Would you please help? Link to comment Share on other sites More sharing options...
mecollectibles Posted June 6, 2011 Share Posted June 6, 2011 Found many with 6 too ! Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts