A client of mine used to have a multilingual blog using the Gengo plugin, which I consider by now unfortunatly dead. Fortunately, the guys at http://www.wpml.org did a great job creating a new plugin that works like a charm.
I did the migration from one to the other and I had no troubles (beside figuring out how to map gengo’s model to wpml). Further down are two SQL statements to check and update the posts language in wpml.
IMPORTANT: first disable gengo, then install wpml, then choose the default language and create the languages you had in geng. All your post will now be in the default language. you can check this with this SQL statement (for example using phpMyAdmin)

SELECT post.`ID`, post.`post_title`, wpml.`language_code` as wpml_language, gengoLang.`code` as gengo_language
FROM `wp_posts` post
LEFT JOIN `wp_icl_translations` wpml on wpml.`element_id` = post.`ID`
LEFT JOIN `wp_post2lang` gengo on gengo.`post_id` = post.ID
LEFT JOIN `wp_languages` gengoLang on gengoLang.`language_id` = gengo.`language_id`
WHERE wpml.`element_type` ='post'
ORDER BY post.`ID`  DESC;

Then you can update the post language with the following statement:

UPDATE `wp_icl_translations` wpml
LEFT JOIN `wp_posts` post on wpml.`element_id` = post.`ID`
LEFT JOIN `wp_post2lang` gengo on gengo.`post_id` = post.ID
LEFT JOIN `wp_languages` gengoLang on gengoLang.`language_id` = gengo.`language_id`
set wpml.`language_code` = gengoLang.`code`
WHERE wpml.`element_type` ='post'

This will update your POSTS only, no category or tags yet. I might look at those as well and I’ll get in touch with wpml to see if they can use my snippets to get out a sort of import tool.
cheers Marco

Categories: Web Development

4 Comments

Yegor Korzh · 2009-12-22 at 09:15

Marco,
You are my savior!!! I’m so tired of gengo and was thinking of the way to get rid of it, but couldn’t figure out how to do it …
Many thanks again!!!

piet van oostrum.com - » Converting Wordpress from Gengo to WPML · 2009-08-22 at 12:27

[…] in the WPML site and I found a few threads in the forum. One topic mentions a partial solution by Marco Bernasocchi. I started with that. In […]

WPML » WPML tables description (and a poll) · 2009-09-27 at 16:23

[…] Many folks have asked us how WPML’s language information is stored. Some have even spent valuable time reverse engineering it in order to solve immediate problems (like migrating from Gengo to WPML). […]

The definitive recipe for Wordpress Gengo to WPML conversion · 2010-07-31 at 17:47

[…] Migrating WordPress from Gengo to WPML […]

Leave a Reply

%d bloggers like this: