DeeEmm

Pragmatism in code

The final part of our Geeklog to Joomla / Jomsocial migration deals with migrating the main site content.

With Geeklog, content is organised into 'Stories'. Similarly, with Joomla, content is organised into 'Articles'.

Migration is simple, and requires running one SQL command.

First, ensure that you copy the following tables to your new database

gl_stories

then simply run the following command

INSERT INTO `jos_content` (`title`,`introtext`,`fulltext`,`catid`,`created`,`hits`)
SELECT title,introtext,bodytext,tid,date,hits
FROM gl_stories

You will now be able to see all of your old Geeklog stories in the Article manager.