Last Updated on Monday, 03 October 2011
- Change database name my_joomla_db to your joomla database and my_wordpress_db to your Wordpress database
- Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site.
- If post_type is to be post then append with ?p= otherwise use ?page_id=.
- ------ MIGRATING JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.# ------
- -----------------------------------------------------------------
- INSERT INTO my_wordpress_db.wp_posts
- SELECT
- id 'ID',
- 1 'post_author',
- created 'post_date',
- created 'post_date_gmt',
- CONCAT(introtext, ' ', `fulltext`) 'post_content',
- title 'post_title',
- '' post_excerpt,
- CASE state WHEN '1' THEN 'publish' ELSE 'draft' END 'post_status',
- 'open' comment_status,
- 'open' ping_status,
- '' post_password,
- alias 'post_name',
- '' to_ping,
- '' pinged,
- modified 'post_modified',
- modified 'post_modified_gmt',
- '' post_content_filtered,
- '0' post_parent,
- CONCAT('http://demo.joellipman.com/wordpress/', '?p=', id) AS guid,
- '0' menu_order,
- 'post' AS 'post_type',
- '' post_mime_type,
- 0 comment_count
- FROM
- my_joomla_db.jos_content
- ORDER BY
- id
Importing the joomla categories to Wordpress: (still to do: sections as parent categories?)
- SET @CountCategoriesAlreadyEntered:=(SELECT MAX(term_id) FROM my_wordpress_db.wp_terms);
- INSERT INTO my_wordpress_db.wp_terms
- SELECT
- (a.id + @CountCategoriesAlreadyEntered) 'term_id',
- a.title 'name',
- a.alias 'slug',
- 0 'term_group'
- FROM
- my_joomla_db.jos_categories a
- ORDER BY
- a.id;
- INSERT INTO my_wordpress_db.wp_term_taxonomy
- SELECT
- (a.id + @CountCategoriesAlreadyEntered) 'term_taxonomy_id',
- (a.id + @CountCategoriesAlreadyEntered) 'term_id',
- 'category' AS 'taxonomy',
- a.description 'description',
- 0 'parent',
- (SELECT COUNT(c.id) FROM my_joomla_db.jos_content c WHERE c.catid=a.id) 'count'
- FROM
- my_joomla_db.jos_categories a
- ORDER BY
- a.id;
- INSERT INTO my_wordpress_db.wp_term_relationships
- SELECT
- b.id 'object_id',
- (b.catid + @CountCategoriesAlreadyEntered) 'term_taxonomy_id',
- 0 'term_order'
- FROM
- my_joomla_db.jos_content b
- ORDER BY
- b.id;
- ...still to come...
Latest Posts
-
Joes Revolver Map (JRM)
-
Fri 17-May-13
Hmmm... Sounds like a problem with the identifier. Was it working before and has there been a change ...
-
Fri 17-May-13
Hello Joel: Yes, I do have it published on all pages of the site. I just went back to Revolver maps to ...
-
Fri 17-May-13
Hi Bill, From the developers of RevolverMaps, "the module would need to be published on every page ...
-
Fri 17-May-13
Hi Bill, I'll investigate further as you're not the first to say this happens. In the meantime, simply ...
-
Fri 17-May-13
Its a great extension. But when I set it up I only show my presence on the 3D map and no other visitors ...
-
Fri 17-May-13
Comments
Will this work for a 2.5?
If so, how do I use it?
Cheers,
Mike
Sorry, this only works for Joomla 1.5.x to Wordpress v3.2+. I did it for someone a while back (a year ago) but it would only need a few tweaks. It's a bunch of database commands and you would need a MySQL administration tool or something like PhpMyAdmin installed on the same server as your website. As it has been a year, I'm a little unfamiliar with it but there can't be too many changes...
Joe
RSS feed for comments to this post