This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 1 reply, has 2 voices.

Last updated by Yvette 12 months ago.

Assigned support staff: Yvette.

Author Posts
October 18, 2018 at 11:34 am #2827808

Luca

I am trying to export the main language categories in order to match them to the translated ones and put everything in a CSV files so I can import them.

I used 'Wp All Export' to export the main language's categories. I expected to see a kind of primary key to be linked to the translated ones, instead I got just a list of all categories (main and translated ones) with no reference useful to match them.

How I can link a translated category to the category in the main language?

October 19, 2018 at 5:47 pm #2832790

Yvette
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Hello

The link between worpdress objects (taxonomies, posts, pages, attachments...) is made in the following table: icl_translations

The common key that connects the different langauge versions is the field "trid".

The icl_translations table will also tell you the assigned langauge for each worpdress object.
Some related documentation for you:
https://wpml.org/documentation/support/wpml-tables/

Does this help you?