Convert all products from English to Macedonian language

[skullmonkey]

Hi,
I need to install second language on my website but I have problem. I installed the language correctly but the items in VMart are entered in English and they don't show when I change language. Is there a way that I can see the items in both language?

Thanks,
S@

[jjk]

Which language switch do you mean - the Joomla language switcher or the VirtueMart language switcher on the 'Product edit view' in VM backend?
I assume, you didn't translate your product descriptions from English to Macedonian yet. Do you initially want to see the english descriptions where normally the macedonian descriptions would be visible, i.e. for easier translation?

[skullmonkey]

Yes, I have complete translation of Joomla but when I switch the default language to Macedonian, no VM product is shown.

Thanks,
S@

[jjk]

If you have both languages in the Virtuemart configuration > Language Settings > Multilingual Shop and your products don't display in Macedonian, check if you have all your categories translated already. Also, you need menu items to your shop and i.e. all product categories and the cart. If the frontend interface language still shows english instead to macedonian buttons after you change to Macedonian in Joomla, turn on 'Debug Language' in Joomla configuration and check if all required macedonian language virtuemart files are being loaded. Sometimes a simple typing error like a missing quote can prevent a language file from being loaded.

[skullmonkey]

I need to translate all Categories and Items in order to get them in Macedonian language? Can't I just get the original as they are, on English?

Also, do I need to have Translation in mk-MK folder for Vmart in order this to work?

Thanks,
S@

[jjk]

I just had a look at the Macedonian language at Transifex, which is our translation tool for translating Virtuemart language files. If you look at it at:
https://www.transifex.com/projects/p/virtuemart/language/mk_MK/
you will see that the only language file which is almost completed in Macedonian is the main frontend language file com_virtuemart.ini.
Perhaps you can help a little bit to translate all the other files. At present i.e. the cart would only display in English, because there is no Macedonian translation for this.

In order to get you started, I've created a Macedonian language pack, which you can install with the Joomla extension manager. However, keep in mind that although all language files are labeled 'mk-MK...', the only file which is actually translated into Macedonian is the 'mk-MK.com_virtuemart.ini' for the frontend.

The language setup on your system depends on what you want to do. Which of the two languages do you want to be the default language and which one will be the translation?





[attachment cleanup by admin]

[skullmonkey]

Hi,
I actualy need one language, the Macedonian. It will be one language shop.
I still dont understand why the products dont show.

P.s. Ill translathe the whole vmart, with no probs, if that solves the problem.

Thanjs,
S@

[jjk]

If your test shop still is the same you posted here: http://forum.virtuemart.net/index.php?topic=111956.msg376409#msg376409
then I can't see what you did wrong. On most pages I see "ERROR: Flexible VM2 Template Plugin hasn't been installed or it is unpublished."
And it looks like you currently have all your products in the english language xxxx_virtuemart_products_en_gb table. You can check this with PhpMyAdmin. If you have the macedonian VM language file for the frontend installed, you should also have a xxxx_virtuemart_products_mk_mk table. Are your macedonian tables still empty?

[skullmonkey]

Thats the old test page. The current is http://www.gorast.com/gtest3

I have installed the Macedonian language and I can see it in the backend but that table thingy, dont quite understand it 

Thanks,
S@

[jjk]

I have installed the Macedonian language and I can see it in the backend but that table thingy, dont quite understand it 

You can only see the Macedonian Joomla language files in the backend, because the Virtuemart backend files have not been translated into Macedonian yet.
If you open phpMyadmin, select the table "yourprefix_virtuemart_products_mk_mk" in your database and click on "Browse", what do you see, Macedonian or English product names and descriptions?
Same question for "yourprefix_virtuemart_products_en_en". Do you see English language product descriptions or Macedonian language?

Also check the content of "yourprefix_virtuemart_categories_en_en" and "yourprefix_virtuemart_categories_mk_mk tables.

[skullmonkey]

Hi,
when I set default language to Macedonian and I go t Virtuemart / Categories I get this warning on the top:

vmError: exeSortSearchListQuery Table 'gtest3.nknv_virtuemart_categories_mk_mk' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `nknv_virtuemart_categories_mk_mk` l JOIN `nknv_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `nknv_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name DESC

In Products this:

        vmError: exeSortSearchListQuery Table 'gtest3.nknv_virtuemart_products_mk_mk' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `nknv_virtuemart_products_mk_mk` as l JOIN `nknv_virtuemart_products` AS p using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY product_name DESC LIMIT 0, 3
        vmError: exeSortSearchListQuery Table 'gtest3.nknv_virtuemart_categories_mk_mk' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `nknv_virtuemart_categories_mk_mk` l JOIN `nknv_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `nknv_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC

Where might be the problem?

Thanks,
S@

EDIT: I fixed this. Needed to install the Multilingual in VM / Configuration. No errors now but when default language is set to Macedonian I still dont see any products nor categories Backend nor frontent.

[skullmonkey]

I have installed the Macedonian language and I can see it in the backend but that table thingy, dont quite understand it 

You can only see the Macedonian Joomla language files in the backend, because the Virtuemart backend files have not been translated into Macedonian yet.
If you open phpMyadmin, select the table "yourprefix_virtuemart_products_mk_mk" in your database and click on "Browse", what do you see, Macedonian or English product names and descriptions?
Same question for "yourprefix_virtuemart_products_en_en". Do you see English language product descriptions or Macedonian language?

Also check the content of "yourprefix_virtuemart_categories_en_en" and "yourprefix_virtuemart_categories_mk_mk tables.

I cant browse the Macedonian. The BROWSE option is not click-able. The en-GB is full with English titles.

[attachment cleanup by admin]

[jjk]

I cant browse the Macedonian. The BROWSE option is not click-able. The en-GB is full with English titles.

That means, that your mk_mk tables are empty. You can easily copy the content from your en_gb tables into the mk_mk tables with phpMyAdmin by following this procedure:
http://forum.virtuemart.net/index.php?topic=108685.msg363927#msg363927

[skullmonkey]

I dont know what to say... exactly what was the problem! THANKS!
For everyone else, just follow the guide and have nothing to worry!

Thanks again,
G