If you’re a plugin developer whose been using custom tables for storing information in WordPress the transition to custom post types may be daunting.<\/p>\n
However, as WordCamp UK showed there’s no need to as it’s a really simple process, thanks to a demonstration by Kieran O’Shea<\/a>.<\/p>\n It’s really simple, and here are the two steps;<\/p>\n Create, install and activate the following plugin:<\/p>\n Note the last few lines, especially flush_rewrite_rules() which make sure your new post type can be viewed on your site.<\/p>\n Now all you need to do is loop through your database entries and add them as new posts for your new custom post type!<\/p>\n Now, you need to run that from the command line. So, grab yourself a tool like PuTTY for Windows<\/a> or use the Mac Terminal and connect to your server to run the script.<\/p>\n Job done! You’ll see a new menu item in your dashboard with all your new custom posts.<\/p>\n Thankfully, Kieran has provided a mini site for WordCamp UK<\/a> where you can see his full presentation and download the code above too.<\/p>\n I spoke to Kieran afterwards who provided a useful summary of his session:1. Create your custom post type<\/h3>\n
\r\n\/*\r\nPlugin Name: Example Custom Post\r\nPlugin URI: http:\/\/www.kieranoshea.com\r\nDescription: Allows the demonstration of custom posts\r\nAuthor: Kieran O'Shea\r\nAuthor URI: http:\/\/www.kieranoshea.com\r\nVersion: 1.0\r\n*\/\r\n\r\nfunction create_post_type() {\r\nregister_post_type( 'calendar_event',\r\narray(\r\n'labels' => array(\r\n'name' => __( 'Events' ),\r\n'singular_name' => __( 'Event' ),\r\n'add_new' => __('Add New'),\r\n'add_new_item' => __('Add New Event'),\r\n'edit_item' => __('Edit Event')\r\n),\r\n'public' => true,\r\n'has_archive' => true,\r\n'rewrite' => array('slug' => 'events')\r\n)\r\n);\r\n}\r\nadd_action( 'init', 'create_post_type' );\r\n\r\nfunction my_rewrite_flush() {\r\ncreate_post_type();\r\nflush_rewrite_rules();\r\n}\r\nregister_activation_hook(__FILE__, 'my_rewrite_flush');\r\n<\/pre>\n2. Move your existing content to your new custom post type<\/h3>\n
\r\n\/*\r\nA quick command line script to migrate a table of data to custom posts\r\n*\/\r\n\r\n\/\/ Turn off errors as we're sort of outside wordpress\r\n\/\/ and the browser and that can cause warnings\r\ndefine('WP_DEBUG', false);\r\n\r\n\/\/ Require the standard WordPress header\r\nrequire(dirname(__FILE__).'\/wp-blog-header.php');\r\n\r\n\/\/ Tell the user what we're about to do\r\necho 'Migrating table WP_CALENDAR to custom post type CALENDAR_EVENT\r\n';\r\n\r\n\/\/ We need some of the WordPress globals to proceed\r\nglobal $wpdb;\r\n\r\n\/\/ Get all our events\r\n$events = $wpdb->get_results("SELECT * FROM wp_calendar");\r\n\r\n\/\/ How many are there?\r\necho sizeof($events).' events will be imported...\r\n\r\n';\r\n\r\n\/\/ Loop through 'em and load 'em to WordPress\r\nif (!empty($events))\r\n{\r\nforeach ($events as $event)\r\n{\r\n$ent['post_type'] = 'calendar_event';\r\n$ent['post_content'] = $event->event_desc;\r\n$ent['post_parent'] = 0;\r\n$ent['post_author'] = 1;\r\n$ent['post_status'] = 'publish';\r\n$ent['post_title'] = $event->event_title;\r\n$entid = wp_insert_post ($ent);\r\nif ($entid == 0) {\r\necho 'Failed to migrate event "'.$event->event_title.'"\r\n';\r\n} else {\r\necho 'Migrated event "'.$event->event_title.'"\r\n'; }\r\n}\r\n}\r\n\r\n\/\/ Tell the user we're all done\r\necho '\r\nDone!\r\n';\r\n<\/pre>\n
\n