Code Monkey home page Code Monkey logo

s9y-to-wp's Introduction

s9y-to-wp

This script will help you migrate from Serendipity to Wordpress. It is a plugin that you drop into Wordpress that will read your S9y database and migrate over your posts and comments.

License

There was none when I started, so there shall be none when I'm done. -JD

Public Domain or CC0

Instructions

IF YOU HAVE MORE THAN 9000 POSTS OR COMMENTS: Please change the "+9000" and "-9000" below (3 locations total) to be a number larger than what you have. It is arbitrary, but important to prevent ID collisions during update.

  1. Install Wordpress as normal
  2. In the Wordpress DB
  • TRUNCATE wp_posts;
  • TRUNCATE `wp_postmeta`;
  • TRUNCATE `wp_term_relationships`;
  • TRUNCATE `wp_term_taxonomy`;
  • TRUNCATE `wp_comments`;
  • TRUNCATE `wp_commentmeta`;
  • DELETE FROM wp_terms WHERE wp_terms.term_id!=1;
  1. Copy included serendipity.php to /wordpress/wp-admin/import/
  2. Login to Wordpress Admin Interface
  3. Goto Tools > Import
  4. Click "Serendipity"
  5. Fill out the information, follow the proccess
  6. Run the following SQL in the Wordpress DB
  • UPDATE `wp_comments` as a SET a.`comment_post_ID`= (SELECT b.`menu_order` FROM `wp_posts` as b WHERE a.`comment_post_ID`= b.`ID`);
  • UPDATE `wp_term_relationships` SET `object_id`=`object_id`+9000;
  • UPDATE `wp_term_relationships` as a SET a.`object_id`= (SELECT b.`menu_order` FROM `wp_posts` as b WHERE a.`object_id`-9000= b.`ID`);
  • UPDATE `wp_posts` SET `ID`=`ID`+9000;
  • UPDATE `wp_posts` SET `ID`=`menu_order`, `guid`=CONCAT("http://MYURL.COM/?p=",`menu_order`), `menu_order`=null; -- Replace MYURL.COM with your URL
  • SELECT `id`+1 FROM `wp_posts` ORDER BY `id` DESC LIMIT 0,1;
  • ALTER TABLE `wp_posts` AUTO_INCREMENT = XXX; -- Where XXX is the value returned from the select above
  1. Should be done.

Known issues

  • Comments become "flat" (IE "parents" aren't translated)
  • After the import, you'll need to edit one of the categories (just open and save it) to fix the hierarchy.

History & Change log

GitHub

GitHub Move (2013-07-13) - Jon Davis

Version 1.7

Version 1.7 ( 2012-03-15 ) - Abdussamad Abdurrazzaq

Version 1.6

Version 1.6 Released ( 2012-02-15 ) - Abdussamad Abdurrazzaq

  • Support for nested comments
  • Works as a plugin in WordPress

Version 1.5

Version 1.5 Release (2010-10-27) - Simone Tellini

Version 1.4

Version 1.4 Release (2010-06-10) - Jon Davis

Version 1.3

Version 1.3 Released (2008-11-08) - Dobschat

  • split articles with <!--more-->
  • import article-tags from s9y

Verison 1.2

Version 1.2 Released (2008-09-04)

  • Fixes Category Association
  • Breaks processing into smaller blogs for large imports
  • Performance improvements

Version 1.1

Version 1.1 Released (2006-02-01) - Dobschat

Version 1

Version 1 released - Dobschat

s9y-to-wp's People

Contributors

shakataganai avatar

Watchers

Julian avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.