export product desc for translate

[marvays]

Hi.
I have eshop with slovak language. Now I need make copy for Hungarian.
I created a copy of the e shop, re-set it in Hungarian and prepare export products for the translator.

All export via CSVI is good (category, menus, short-desc). But I have problems with a long description. accented issues.

On the website i have:

Code Select Expand

Pracovný nerezový stôl so drezom od spoločnosti TECHNOLOGIES je nenahraditeľný v pekárňach

In database i have save:

Code Select Expand


<span style="font-size: 10pt;">Pracovn&yacute; nerezov&yacute; st&ocirc;l kvalitne spracovan&yacute;, veľk&aacute;  ....


CSVI exports what it sees in the database. But this is unreadable for the translator. What can I do about it?

[jjk]

I don't have CSVI inststalled, so I can't answer your above question. However, maybe you can add Hungarian as the second language to the shop, assign the translator for example to an 'Editor' role and limit that user to editing categories and products using the permissions settings. So the translator can work directly on the live site or on a copy of that one in a subfolder.

[marvays]

translator need export file. she work with https://www.memsource.com

problem isn in CSVI but in database 

[jjk]

Perhaps try other collations in the database: https://csvimproved.com/support/questions-and-answers/3536-deal-with-different-collations-in-mysql
The collation can also be changed using the 'Operations' tab in phpmyadmin. Joomla meanwhile uses utf8mb4_unicode_ci while VirtueMart default still is utf8-general_ci.

[marvays]

Yes, Joomla meanwhile uses utf8mb4_unicode_ci while VirtueMart default still is utf8-general_ci. All tables I must chneg to . . . ?

[marvays]

problem is "HTML entities" . . . i need decode.
1. long way is setupn JCE and open and save all product in VM.
2. or use any tools for HTML entities decode. But cant find any tool for decode all csv

[jjk]

If you have an exported csv file, you can simply open it with an editor (I usually use Notepad++ for such things) and use the Search/Replace tool to change all at once.
You can also just export a single table column, replace the entities with an editor and then import the table column again.