• From: Boston, USA
  • Registered: 2004-09-20
  • Posts: 27

Topic: migrating from Tiki

Hi all,

I asked about 6 months ago about a possible migration tool or script from Tiki (tikiwiki.org) forums, but nothing existed. I am trying to work it out manually and am having some issues. In particular, I am having problems with the differing database schemas and the way tiki handles topics.  Tiki defines a top-level (non-reply) post as a "parent" using the post id [Tiki field threadId]. 

IOW:
The parentId of a top-level post = 0, while its threadId may be (say) 3245. Any child posts of the parent reference the parentId (3245), not a separate topic id as used in Pun.

I don't know how to handle this difference.  Also I am not sure what fields I can leave out in Pun, or set to default.  More information on Tiki as related to my problem:

http://melhuish.org/tikiTransfer.html

The target forum is    http://fullrangedriver.com/forum/
The source forum is   http://fullrangedriver.com/tiki-view_fo … ?forumId=1

Thanks for any help...

James

James Melhuish

JMelhuish's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: migrating from Tiki

Regarding the topics and posts. Here's what I would do:

1. Fetch the first post in a topic. Let's say this is threadId 50 with parentId set to 0.
2. Insert a new topic into the PunBB database. This will get the id 1 (use $db->insert_id($blaha) to get the new ID).
3. Fetch all posts from the tikiWiki database that have parentId set to 50.
4. Insert these posts into PunBB's posts table with topic_id set to 1 (from step 2).
5. Loop smile

If you decide to do this, it would be great if it could be integrated with the current migration tool. Perhaps you could speak to Chacmool about that.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • From: Boston, USA
  • Registered: 2004-09-20
  • Posts: 27

Re: migrating from Tiki

Thanks, this sounds like the right thing to do, I (or a friend) needs to write a little script to loop through and output a table in the correct format.  I assume that I simply supply the default field values for fields that don't have equivalents in Tiki (like Pun's hide_smilies).

Thanks for the quick reply!  If I get a little script programmed, I would be happy to pass code along to Chacmool, what language is the converter written in, PHP?

Thanks.

James

James Melhuish

JMelhuish's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: migrating from Tiki

Yes, it's written in PHP. You can find it on the download page.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website