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 https:\/\/www.wpml.org did a great job creating a new plugin that works like a charm.
\nI 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.
\nIMPORTANT: 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)<\/p>\n
SELECT post.`ID`, post.`post_title`, wpml.`language_code` as wpml_language, gengoLang.`code` as gengo_language\nFROM `wp_posts` post\nLEFT JOIN `wp_icl_translations` wpml on wpml.`element_id` = post.`ID`\nLEFT JOIN `wp_post2lang` gengo on gengo.`post_id` = post.ID\nLEFT JOIN `wp_languages` gengoLang on gengoLang.`language_id` = gengo.`language_id`\nWHERE wpml.`element_type` ='post'\nORDER BY post.`ID` DESC;<\/pre>\nThen you can update the post language with the following statement:<\/p>\n
UPDATE `wp_icl_translations` wpml\nLEFT JOIN `wp_posts` post on wpml.`element_id` = post.`ID`\nLEFT JOIN `wp_post2lang` gengo on gengo.`post_id` = post.ID\nLEFT JOIN `wp_languages` gengoLang on gengoLang.`language_id` = gengo.`language_id`\nset wpml.`language_code` = gengoLang.`code`\nWHERE wpml.`element_type` ='post'<\/pre>\nThis 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.
\ncheers Marco<\/p>\n","protected":false},"excerpt":{"rendered":"
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 https:\/\/www.wpml.org did a great job creating a new plugin that works like a charm.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[28],"tags":[125],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-web-development","tag-qgis-org"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":68,"url":"https:\/\/www.opengis.ch\/de\/2009\/08\/07\/wordpress-wpml-iphone-app\/","url_meta":{"origin":94,"position":0},"title":"wordpress iphone app with wpml","author":"Marco Bernasocchi","date":"7. August 2009","format":false,"excerpt":"Solution to use the iphone application for multilingual blogging with wpml","rel":"","context":"In "Web Development"","block_context":{"text":"Web Development","link":"https:\/\/www.opengis.ch\/de\/category\/web-development\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15627,"url":"https:\/\/www.opengis.ch\/de\/2025\/06\/02\/xlsform-converter-unlock-a-world-of-surveys-with-our-brand-new-qgis-plugin\/","url_meta":{"origin":94,"position":1},"title":"XLSForm Converter: unlock a world of surveys with our brand new QGIS plugin","author":"Mathieu","date":"2. Juni 2025","format":false,"excerpt":"Easily bring your XLSForm surveys into the QGIS and QField ecosystem. The plugin converts spreadsheets into fully prepared QGIS projects\u2014with media support, automatic form configuration, and one-click upload to QFieldCloud. Migrating to QField was never easier!","rel":"","context":"In "Processing"","block_context":{"text":"Processing","link":"https:\/\/www.opengis.ch\/de\/category\/gis\/qgis\/processing\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/05\/xlsformconverter-qgis-qfield.webp?fit=1098%2C859&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/05\/xlsformconverter-qgis-qfield.webp?fit=1098%2C859&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/05\/xlsformconverter-qgis-qfield.webp?fit=1098%2C859&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/05\/xlsformconverter-qgis-qfield.webp?fit=1098%2C859&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/05\/xlsformconverter-qgis-qfield.webp?fit=1098%2C859&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2074,"url":"https:\/\/www.opengis.ch\/de\/2016\/05\/04\/qgis-qt5-and-python3-migration-current-state\/","url_meta":{"origin":94,"position":2},"title":"QGIS: Qt5 and Python3 migration, current state","author":"Matthias Kuhn","date":"4. Mai 2016","format":false,"excerpt":"Behind the scenes a lot has happened to get ready for Qt5 and Python3. On the same codebase that is becoming the next release QGIS 2.16. This is really a great thing since we can focus work on a single master branch and I'm very happy that we got so\u2026","rel":"","context":"In "C++"","block_context":{"text":"C++","link":"https:\/\/www.opengis.ch\/de\/category\/programming\/cpp\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3691,"url":"https:\/\/www.opengis.ch\/de\/2018\/04\/13\/porting-qgis-plugins-to-api-v3-strategy-and-tools\/","url_meta":{"origin":94,"position":3},"title":"Porting QGIS plugins to API v3 – Strategy and tools","author":"Marco Bernasocchi","date":"13. April 2018","format":false,"excerpt":"The Release of QGIS 3.0 was a great success and with the first LTR (3.4) scheduled for release this fall, it is now the perfect time to port your plugins to the new API. QGIS 3.0 is the first major release since September 2013 when QGIS 2.0 was released. During\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/www.opengis.ch\/de\/category\/featured\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4180,"url":"https:\/\/www.opengis.ch\/de\/2018\/09\/11\/qgis-speaks-a-lot-of-languages\/","url_meta":{"origin":94,"position":4},"title":"QGIS speaks a lot of languages","author":"Dave Signer","date":"11. September 2018","format":false,"excerpt":"QGIS is a real cosmopolitan. Born in Alaska sixteen years ago, it has spread all over the world since. Thanks to its open source mentality, it finds not only in economically strong countries big usergroups. No question, that beside all the developers, there is a bunch of brave translators giving\u2026","rel":"","context":"In "C++"","block_context":{"text":"C++","link":"https:\/\/www.opengis.ch\/de\/category\/programming\/cpp\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2018\/09\/trans_linguist_translation-2.png?fit=975%2C358&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2018\/09\/trans_linguist_translation-2.png?fit=975%2C358&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2018\/09\/trans_linguist_translation-2.png?fit=975%2C358&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2018\/09\/trans_linguist_translation-2.png?fit=975%2C358&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":2059,"url":"https:\/\/www.opengis.ch\/de\/2016\/03\/23\/prepare-your-plugins-for-qgis-3\/","url_meta":{"origin":94,"position":5},"title":"Prepare your plugins for QGIS 3","author":"Matthias Kuhn","date":"23. M\u00e4rz 2016","format":false,"excerpt":"QGIS 3 is not yet there and there is still plenty of time to prepare and migrate. But I thought I would give some advice about things that you can keep in mind while working on your plugins to make your life easier when you will have to actually do\u2026","rel":"","context":"In "Uncategorised"","block_context":{"text":"Uncategorised","link":"https:\/\/www.opengis.ch\/de\/category\/uncategorised\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_shortlink":"https:\/\/wp.me\/pbdBtI-1w","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":1,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":11239,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/posts\/94\/revisions\/11239"}],"wp:attachment":[{"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}