By helvetius on

Hi, I'm trying to import data from a legacy CMS system into drupal 6.x forums. Using MySQL (far too much data to use the front end).

So far my process is:

1. insert header record into node table ('forum') type - get new nid (primary key)
2. insert main body into node_revisions - new vid (pk)
3. update node record to set vid column to link to new node_revisions record
4. insert record into forum table (nid, vid, & tid for relevant forum - from term_data table)
5. insert record into term_node table (nid, vid & tid again)

so if I go to the new node in question via node/x it looks fine and has all the navigation around it that you would expect for a topic in the target forum.

However, when browsing the Forum tree, it doesn't show up as a topic. Also doesn't appear in the New Forum Topics or Active Forum topics menus.

I've tried running cron and dumping the cache. No dice. Buggered if I can see another table in the database that could be relevant.

Any ideas?

⋅ Categories: Drupal 6.x

Comments

helvetius’s picture

helvetius commented

Aha. node_comments_statistics is the culprit. So the full sequence:

insert  into `node` (`created`, `type`, `uid`, `title`, `status`, `comment`) values
(unix_timestamp('2005-10-27 11:18:00'), 'forum', 7, 'My Org branch minutes Oct 26', 1, 2);

insert into `node_revisions` (`nid`, `uid`, `title`, `teaser`, `body`, `timestamp`, `format`) values
(last_insert_id(), 7, 'My Org branch minutes Oct 26', 'Noted that ... [teaser text]', '[Full body of post]', unix_timestamp('2005-10-27 11:18:00'), 1)

update `node` set
    `vid` = [vid]
where `nid` = [nid];

insert into `forums` (`nid`,`vid`,`tid`) values
([nid], [vid], [tid]);

insert into `term_node`  (`nid`,`vid`,`tid`) values
([nid], [vid], [tid]);

insert into `node_comment_statistics` (`nid`, `last_comment_timestamp`, `last_comment_uid`, `comment_count`) values
([nid], unix_timestamp('2005-10-27 11:18:00'), 7, 0);

is roughly the process. Of course you need to have added the users before hand and process your previous CMS dump to transform your users into their new drupal uid, plus you need to know the tid of the forum you're importing to. The bits in [] above need to be sorted into local variables or summat.

mojoinst’s picture

mojoinst commented

Thanks soo much mate... was pulling my hair out!!!