Categories
View Replies (4)

Resolved Adding missing translation strings (VM categories)

  1. IOJens
    IOJens
  2. RO CSVI
  3. Wednesday, 01 July 2015
  4.  Subscribe via email
Hi,

I have the following issue: with a migration tool I imported and older VM shop (J 1.5) to VM3 (J 3.0). The old shop used Joomfish for translation purposes and the migration tool imported the translation strings from Joomfish into the corresponding VM3 tables. So far so good.
However only a part of the categories needed an translation and as a result many categories have no translation. What I want is to add the 'category name' of the default language to the corresponding translation tables, if there isn't a translation of the category.

I was hoping that I could simply export the 'virtuemart_category_id' and 'category_name' using the default language of the shop (that part works). And after that import the file again changing the language (and checking a box not to overwrite existing entries). But that plan didn't work out - when trying to process the file I get:

Oops something went wrong.

Let me try to show the warning below here. If nothing shows up then I didn't get any data, sometimes this is caused by faulty plugins.

Cancel the import and check if all settings are correct and try the import again. Status error: 200 Status message: OK
jos-Error: View nicht gefunden [Name, Typ, Präfix]: login, json, loginView


Using the 'product_sku' + 'product_name' worked fine for products - but it seems categories don't work the same way here.

Is there another way to solve the problem? Any hints greatly appreciated - thank you.
0
Responses (4)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The error you see has been documented at Logged out on import.

I was hoping that I could simply export the 'virtuemart_category_id' and 'category_name' using the default language of the shop
That will work if you use the custom table import/export. The regular category import will require the category_path field. With the custom table import/export you can export the specific language table with the fields you mentioned.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
IOJens
IOJens
Accepted Answer Pending Moderation
Thank you very much for the help - but it seems I'm missing something.

I created an export file from the main language (de_de) for the categories as well as from the (en_gb) table. This seemed to work fine (I attached part of the csv file):

http://s24.postimg.org/pa131jrqd/exportsettings.jpg

http://s27.postimg.org/8x3np9zkj/exportsettings2.jpg

http://s27.postimg.org/o784a7kgj/exportsettings3.jpg
This includes all fields from the corresponding sql table

When I import the file I get a 'success' in the log - however the table seems to be unchanged (here the import settings):

http://s9.postimg.org/ho6i81k9r/importsettings2.jpg
http://s13.postimg.org/u9y80wt53/importsettings.jpg

What am I doing wrong ?

(On a sidenote - I solved the problem with SQL since it's fairly simple in this case. But a solution would intrest me nonetheless.

For anyone stuck with the same problem this snipped should do the trick - change the language table accordingly and the table prefix of your joomla installation:

 

INSERT INTO xxx_virtuemart_categories_en_gb

SELECT * 

FROM xxx_virtuemart_categories_de_de

WHERE NOT EXISTS(SELECT * 

                 FROM xxx_virtuemart_categories_en_gb

                 WHERE (xxx_virtuemart_categories_de_de.virtuemart_category_id=xxx_virtuemart_categories_en_gb.virtuemart_category_id)

                 )
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

When I import the file I get a 'success' in the log - however the table seems to be unchanged
Nothing is attached but looking at your images, you are using the virtuemart_category_id field. This field must already exist in the table because using this field will force CSVI to do an update. An update is successful even if the ID doesn't exist. I understood from your original message that the IDs already existed, so didn't think twice about it. If the IDs are not missing, they should be added first.

Thanks for posting your solution.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
IOJens
IOJens
Accepted Answer Pending Moderation
Thank you for the clarification - no the IDs didn't exist. The sql table with the translation only had IDs/entries for a few categories where a translation existed in the old shop.
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!