This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Our next available supporter will start replying to tickets in about 3.08 hours from now. Thank you for your understanding.

This topic contains 3 replies, has 2 voices.

Last updated by Maciej 5 years, 2 months ago.

Assigned support staff: Maciej.

Author Posts
March 11, 2015 at 9:32 am #575445


sorry, i've pasted debug informations but there was an error...
My topic isn't related with WPML versions.

In a project, I need to export some multilingual content from a website to import it in a new one. Important thing is I need to export only posts from one language, and it's not the main language.

Since there is no tool to do such a thing, I think the easiest way for me, if I don't want to create a complex script, is to import with a SQL Query only the posts (wp_posts) in the new database. Then, in a second time, assign these posts to the right language (because here it won't be the main language).

Is there a way to do this assignment in WordPress admin?
It's quite the same thing I've already asked myself when by mistake, I've created a post while in wrong language. Can I change a post language after its creation.

If you know a better way to do this, or a tool, don't hesitate to tell me!


March 11, 2015 at 3:23 pm #575987


Thank you for submitting your question.

Can you please tell me wich version of our plugin are you using?
Have you heard about the Duplicator plugin?
Maybe it will be more easy to duplicate the site and delete the unwanted data from the duplicate?

Please let me know.

March 12, 2015 at 11:53 am #576801


I'm using latest version of WPML.

That's not possible to duplicate since websites are already existing sites.
To explain a bit more, I use WPML to manage stores (A custom post type) either in french for France, or in dutch for Netherlands. Stores a never in both languages.

Website 1 :
french stores (lang FR) <-- Already existing
Dutch stores (lang NL) <-- Already existing

Website 2 :
belgium stores (lang FR) <-- Already existing
Dutch stores (lang NL <-- Here I need to put Website 1 dutch stores

Any kind of help would be much appreciated!

March 12, 2015 at 3:29 pm #577024


Thank you for your reply.

I consulted your problem with our Developers, there is a high risk that your working site can be broken or the import can cause many issues.

In the links below you can find information about our database structure:

Please let me know if this solves your problem and I can help you with anything else.

The topic ‘[Closed] Import content via SQL then assign a language’ is closed to new replies.