First of all, we are happy to annouce that we are keeping WPML (we are on our trial period, but we have tested the functionalities that we need, and everything is working fine, very happy).
Our last step is to migrate our existing content to the site with WPML. Because this is more of a technical/development question, I do not expect WPML to assist, but if you could shed some light or give us your suggestion, that would be more than sufficient.
Our current content is in english, spanish and portuguese. What we would like to do is:
1. Import our current posts in the default language, which is english (for this we just need a wordpress importer).
2. For every post, import the portuguese and spanish translated post (This is were a suggestion from WPML could come in handy). Our idea is to make one or more SQL queries, to add the translations, but of course, there is probably more than one WPML table involved in this process.
If you could just tell us the tables involved, we could work it out. For this SQL import/s, we would like the translated posts to be saved as if they were translated using the "WordPress Editor" (off course). Then, with more time we would manually translate each post using the "WPML Translation Editor" which is our preference.
What we want to avoid, is having corrupted data, which could happen if we import the translations with custom SQL queries. If you think doing SQL queries may put in risk the integrity of our content, we would like to know it, in which case we might end up doing the translations manually (no SQL queries involved).
In summary: Would you import translated posts with custom SQL queries, or do you suggest avoding that, and doing this process one by one? in the first case, we would like to know just what tables are involved.
Thank you very much, we are happy that we have decided to being using WPML ♥
Is there any documentation that you are following?
No, if you have any for this case it would be great!
Is there a similar example that we can see?
Nope
What is the link to your site?
It is under devlopment (local site)
Hi Long, I am reopening this issue, because I have one more question related about this.
I understand that doing SQL queries might be risky. But I have just checked, and our current translation plugin, saves the translations on its own tables, which is why it is quite unprobable that any export plugin will be able to export the translated posts. In this scenario, I think my only option is to:
1. Import my posts in the default language
2. Install WPML and set the translation languages
3. Then do custom SQL queries to insert the translations the way WPML would do as If I translated the posts manually.
What are your thoughts about this approach?
As I said, our current translations are stored on the plugin tables, so I don't think any export/import plugin would be able to recognize them.
There are some plugins that support exporting data from the custom table and are compatible with WPML so I think you can re-import it to your site in the second language. For example WP Sheet Editor, WP All Export ...
You can follow these links hidden link hidden link (needs a custom code)
If you want to use the SQL queries, I suggest you follow two steps:
- Import posts normally.
- Set the language of the post and relation (original and second language of a post) in the table icl_translations. Refer documentation https://wpml.org/documentation/support/wpml-tables/
If you are not able to accomplish this, I would recommend you contact one of our certified partners who will be more than happy to help you with this. In this link, you will find a list of our certified partners: https://wpml.org/contractors/
Thanks.
The topic ‘[Closed] Migrate translations from other plugin’ is closed to new replies.
