Where are the translations of categories stored?

[peterraeves]

We created categories for the HR catalog and translated them in 3 languages. When we move the categories to another instance with the update sets, the translations are left behind. Where are they stored, why are they not moved?

[Michael Ritchie]

I actually just worked on a project involving translations and figured out the key to this puzzle.   There are multiple tables involved for translations and understanding when to use Translated Name/Fields (sys_translated) and Translated Text (sys_translated_text) was confusing.   One way to figure out when to use one over another is to right click on the field label I needed to translate, configure dictionary and look at the field type.

Translated Text = Translated Text (sys_translated_text)

Translated Field = Translated Name/Fields (sys_translated)

In your case the category names are using sys_translated_text table.   You will need to "push" those to an update set.   This can be done by the Add to Update set utilities in Share.

[peterraeves]

The thing is, that they already show an update set under 'Version'. So they are supposed to be in the update set, but are not there.

Since it has to be done quick notice (within the next hour), I will ex-/import by XML for now and try your way later, but it's strange that the records in the Translated Text table are not automatically added to the update set, while the Translated Field records are...

[Michael Ritchie]

Peter, actually the sys_translated_text table out of the box doesn't "publish" to update sets out of the box.   So these records are considered data and don't automatically appear in update sets.

See the collection dictionary record doesn't have the "update_synch=true" attribute:

You can either "force" them to an update set via Share utilities or you can go to this list, filter for the records you need, and then export the list via XML and load into the target instance.   The second option will be the quickest.

[peterraeves]

It's more complex than that. Because translations for variables for example, are stored in the update set. They are part of the xml of the variable itself

Here you can see the XML for a variable. As you can see, it contains the updates for the Translated Text. But this is not the case in the category. So it probably has something to do with the variable or category table's config.