How to import from SQL-file into WP with WPML-translations working?

  • Resolved devstorm

    (@devstorm)


    13 years, 2 months ago

    Hi,

    we are currently stuck in the process of migrating the data from an old custom/closed-code CMS to WordPress (single site).

    For the multi-language support, we are using WPML. For a website offering currently 7 languages and there are 22 planned,
    the import must be done automatically for several thousand posts.
    All Data is in a SQL-export (UTF8), so no text-conversion for WP is required AFAIC.
    How can this be done? I only need WP-Types Post and Page (and some Custom Type, like FAQ I could do manually, not that much) import to work.
    I think this is a fairtly common task, but many use more common open-source CMS where there are converters existing.

    When using the wp-admin backend, normal page-hooks (in the backend when creating and saving/publishing a post) are run?
    What are the implications if I do the import not via these. Any inconsistencies?

    Has anybody managed to import WPML-pages also?
    https://wpml.org/documentation/support/wpml-tables/
    https://wpml.org/documentation/support/editing-wpmls-languages-table/

    How to create a customized permalink for each post automated (old site’URL was just numbers)?

    Should this be done directly from src-SQL to WP-DBs? Or is the RSS-Import or WP-XML- the way to go?
    I’d like to import directly into the DB, IF it is possible and safe.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Both RSS and SQL approaches will work, but SQL is faster. I mean if you import RSS data all your posts and pages will be assigned to only one language(as true for importer version 0.5) , means you cannot map pages and posts to different languages(would be nice feature of import plugin). Also apart from page or post knowing their own language(“Language of this page” field) you will loose pages translations interconnections(“This is a translation of” field).

    With SQL approach you keep all data safe. Once you exported all your data into SQL file you need to replace all hardcoded domain names to the domain names you are going to move your data in. As soon as all plugins and wordpress versions equal on both domains you should not experience any inconsistency or data loss while migrating.

    But all this should work only for “from wordpress to wordpress” migration. If you are doing something like custom CMS to wordpress migration. You should stick to SQL approach and create sql import script that will represent you custom CMS data in WPML schema way. Yes you need to research WPML DB schema in detail to do that. My googling abilities didn’t give any result on any software to generate that SQL script for you.

    Thread Starter devstorm

    (@devstorm)

    Hi Zacorich,

    I am migrating from non-WP to WP, so this is somewhat tougher. Thank you for this detailled explanation. Now I managed to import the first batch, cross-checked right conversion of Posts. We had 7 different character-sets before, now it’s only UTF-8 ??

    Best Wishes
    Devstorm

    Hi Devstorm,
    Congrats on job you’ve done already! As I see you have that complicated case, I thought the last of ?? Wish you luck with that!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to import from SQL-file into WP with WPML-translations working?’ is closed to new replies.