Hello! Sorry for my English.
In the online shop running Virtuemart 2.0.22d and Joomla 2.5.14 has more than 1200 products. Each of them has filled custom field - Tags. It uses components vm2tags ver 1.2.8.
I need to transfer these values to the "Meta keywords".
Thought to solve this problem with SQL query that will be able (considering virtuemart_product_id) to copy information from one place to another.
From the table virtuemart_product_customfields (field custom_param, considering custom_value: vm2tags) to the table virtuemart_products_ru_ru (field metakey).
But the problem is that the tags in virtuemart_product_customfields are in that format:
{"product_tags":"magnum,lorem,\u0442\u0443\u0444\u043b\u0438"}
How in SQL query remove thre first part {"product_tags":" and }
and to recode in Cyrillic: \u0442\u0443\...
Or there is some other way to solve this problem?
You could do such with csvi component http://www.csvimproved.com/en/. Just export data from tags table, modify it in the open office with regular expressions or just with find&replace function than import it to the meta keywords table.