Resolved Issue when Translating VM3 categories

Hello Chris,

A good find. Attached is the patch file that fixes this issue.

Thanks Roland, tested with new patch but still the cats are not updated proprely.

See attached log file. I can see that it is only updating one category for some reason (id 1582), can you pls confirm?

Also i can see that the slug (Recreate Alias) is not being created properly.

Rgrds,
Chris

Hello Chris,

The log file did not attach, can you try it again?

Sorry Roland,

See attached again.

Rgrds,
Chris

Hello Chris,

The attached patch file should fix both issues. The issue was that the data wasn't reset for each category so it kept the existing category ID. As you noticed it was always the same ID.

In my test, I had a different ID and different slug for each category.

Thanks Roland,

One issue is fixed, the categories separation, which is good.

There is still some issue with the slug, see attached log. It seems the slug takes the metakey values instead of category names? It also strips the greek chars and sometimes it adds the date values.

Rgrds,
Chris

Hello Chris,

The slug is created based on the category name. The reason the Greek characters are stripped is because the transliteration was not taken into account the translation language. So it used English for transliteration. Attached is a patch file that takes into account the target language.

Date values are added to a slug to make sure it is unique. If you see a date, this means another slug with the name part already exists.

Let me know how it goes.

Thanks Roland, uploaded the patch but behaviour is the same, see attached new log.

A characteristic example:

2015-06-18 08:25:29 27 [QUERY] UPDATE `y9zak_virtuemart_categories_el_gr` SET `category_name`='Fuel Cut Defenders',`category_description`='',`metadesc`='Universal Προϊόντα,Turbo Αξεσουάρ,Fuel Cut Defenders',`metakey`='universal,προϊόντα,turbo,αξεσουάρ,fuel,cut,defenders',`customtitle`='',`slug`='universal-turbo-fuel-cut-defenders' WHERE `virtuemart_category_id`='1608'

You can see that the slug is actually the metakey (or metadesc?) without the Greek chars.

Rgrds,
Chris

Hi Roland,

Hope you can confim this issue, so we can do some imports during the weekend!

Rgrds,
Chris

Hello Chris,

I had been looking into this but couldn't put my finger on the sore spot. A goodnight sleep apparently worked as I now saw what was going on. The issue with you not seeing updated slugs is because the slugs were never processed again because they already existed, so the same ones stayed.

In the attached patchfile, there is a new option in the category template called Recreate alias. You can set this to Yes to force CSVI to recreate your aliases. This is an advanced option, so you will need to click the Advanced button before you see it.

Let me know how it goes.

Great Roland, the new option works nicely, thanks!

Rgrds,
Chris