Migrate translation from old site to the new one

  • Resolved sorinciupitu

    (@sorinciupitu)


    1 year, 2 months ago

    Hi everyone,

    I am facing the following problem:

    I have a current site on which I use the TranslatePress plugin to translate content.
    Since this site is quite old, I decided to make something more beautiful, more attractive, etc. from scratch.
    On the current site, I use WP Backery as a builder. On the new site I use Elementor.
    I am interested in migrating all the translations that I have already done in the current site to the new site.
    The steps I took:

    1. I installed the TranslatePress – Business and TranslatePress – Multilingual plugins on the new website
    2. I made the settings IDENTICAL to those on the current website
    3. I translated a few pages to make sure everything is ok
    4. I accessed the database of the current site and from there I exported the table
      wp_trp_dictionary_ro_ro_en_us
    5. on the new site in the database I imported this table (wp_trp_dictionary_ro_ro_en_us).
    6. on the new site, the table corresponding to the one on the current site is 74_trp_dictionary_ro_ro_en_us
    7. I ran the following script in phpmyadmin on the new site:

    UPDATE 74_trp_dictionary_ro_ro_en_us AS new

    JOIN wp_trp_dictionary_ro_ro_en_us AS old ON new.original = old.original

    SET new.translated = old.translated;

    1. in the table 74_trp_dictionary_ro_ro_en_us the same values are now found as in the one in the current site (I mean the two columns original and translated)

    From here everything gets weird

    On the new site, selecting the EN language in the frontend, everything appears untranslated.

    If I try to translate something, the TranslatePress interface loads, but when selecting a string, it appears with the translation already completed. Even if I click “Save” and exit the translation mode, all the text remains untranslated on the frontend.

    I later tried to fill in something on the translated column in the DB, but it still doesn’t update on the site.

    And here I come and ask for your help.

    Am I doing something wrong? Isn’t there a simpler procedure to export and import translations?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Anca

    (@ancavictoria)

    Hello Sorin,

    Thank you for reaching out to us!

    I’ve noticed that there is another ticket related to this issue open on our website.

    My colleague will continue the discussion in that open ticket.

    Kind Regards,

    Anca

    Hello, Can you post the solution here.

    As i am exactly on the same path.

    Old website needs to be changed, was using WP bakery, we are migrating to elementor, though the flow remains the same, we have 200+ pages, with image translation too.

    more than 300 blogs, 2000+ products and a lot of category pages.

    How will the image translation migration works? and I guess the string translation will continue to happen once the table is imported.

    Thread Starter sorinciupitu

    (@sorinciupitu)

    I translated everything manually. there is no migration solution yet. What they say in the documentation about DB import / export is not valid. not working.

    Good Lord, This is bad.

    Any suggestion?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Migrate translation from old site to the new one’ is closed to new replies.

Tags