WordPress.org

1. Pete
   Member
   Posted 7 months ago #

   I want to import posts from a custom cms into a wordpress mu install. The mu install has over 280 subsites. The posts from the custom cms are all in the same table in a mysql db.

   I found a great article by Yoast that has worked for me to a degree but I'm stumped on one part. Here's the link to that article: MySQL to WP import

   Are there any suggestions as to how would i get this to import articles to a different subsite post table depending on data from a specified row in the exisiting cms db? Example: there is a column called facilities with a number 3 in it. How would i get that article to just import to the wp_3_post table and not the main wp_posts table?

   Thanks

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 7 months ago #

   You may want to try importing via HTML

   http://wordpress.org/extend/plugins/import-html-pages/

   Basically you'd make a site, call those pages, import and move to the next site.

3. Pete
   Member
   Posted 7 months ago #

   So, I'd do a network activate on this plugin and then use the plugin subsite by subsite?

   Sounds like lots of work :)

4. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 7 months ago #

   More or less than trying to rewrite Yoast's article to pull based on a row?

   You're in need of a very custom importer, and those only get written when they're needed. So...

5. Pete
   Member
   Posted 7 months ago #

   Yeah, i figured as much.

   I know that I could write it though if I had some direction as to how to redirect the articles to the correct table. I'll keep testing on my local dev environment

Reply

You must log in to post.