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.

This topic contains 3 replies, has 2 voices.

Last updated by Maciej 4 years, 7 months ago.

Assigned support staff: Maciej.

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

Régis

Hi,
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!

Regards

March 11, 2015 at 3:23 pm #575987

Maciej

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?
https://wordpress.org/plugins/duplicator/
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

Régis

Hi,
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

Maciej

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:
http://wpml.org/documentation/support/wpml-tables/
http://wpml.org/documentation/support/editing-wpmls-languages-table/

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.