[NSFW] translation data in sql database

  • Resolved sstrosar

    (@sstrosar)


    3 years, 4 months ago

    Hi, I am using wpglobus plugin for several languages at my site. Nature of the site requires that I do manual import of pages trough wp export import plugin which works just fine.

    I have exported one of the pages with 2 language translation and it seems fine on export since title is marked accordingly to wp globus fields
    {En}title{en} etc ( i know this is not right, I am just making a point here for you to see that I know what I am talking about)

    Let me just hop to the question

    This specific post also has yoast seo title and description translated but I cannot find that data in my export. I only get english ( default languahe) in that field.
    Is this data stored somewhere where the actuall wp export plugin cannot reach it or what is happening?
    Or should yoast data look like the title with {en} markers?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Alex Gor

    (@alexgff)

    You can find the multilingual Yoast SEO title, description (with language marks inside) in the postmeta table. This also applies to others meta, that can be found by _yoast_wpseo mask.

    Thread Starter sstrosar

    (@sstrosar)

    Thank you for your answer!

    So in theory if I did an impprt of all data marked like it should be marked this should work. So all of the data is stored in one line in database. What I want to say is that database is not using different lines for different languages?

    Plugin Contributor Alex Gor

    (@alexgff)

    WPGlobus stores all translations in one line.
    BTW you should export/import Yoast DB tables too.
    Table names is yoast_indexable, yoast_indexable_hierarchy and so on.

    Thread Starter sstrosar

    (@sstrosar)

    Yes, importer does it by selecting the respective fields that are relevant to post. I wasn’t sure if wpglobus had any fields that were outside of standard post. Now when I know that every translation is stored in respective field of data, it makes import so much easier.

    Ps. What I have noticed is:
    When export is done, there is a field called something like wpglobus language and in that field is stored language code (en) for the language of post translation that was active when save button was pressed. For example if I was editing german last, it would store “ge” in the field. What if I did an input of all the language codes in there like: en,ge,es etc?

    On top of that when last active language was set, data in yoast column in the list of posts is in that language. – reffering to admin backend posts list.

    Plugin Contributor Alex Gor

    (@alexgff)

    Sure. You can edit wpglobus_language meta. But it is unuseful in your case.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[NSFW] translation data in sql database’ is closed to new replies.