Links package import for 6.x

I guess I can see that, although given that the database records are still there, even if Links isn't working, I guess I'll just do the SQL manually to update them.

Thanks!

Bruce

In case it helps anybody, here's the SQL I used.

I do NOT guarantee it's right. I especially have some doubts about the Taxonomy handling, but it got the links displayed and the basic world working again.

It does not handle "last checked" time or anything.

Update the weblinks:

INSERT INTO weblinks
(vid, nid, url)
SELECT node.vid, node.nid, links.url FROM node
INNER JOIN links_node on node.nid = links_node.nid
INNER JOIN links on links.lid = links_node.lid
WHERE node.type LIKE 'weblink'

Clean up node types:

UPDATE node
SET type = 'weblinks'
WHERE type = 'weblink';

Create a temporary table with a mapping of the first taxonomy name in the list to the "group" name for the weblink. I'm not sure this all works right, but...

create table tid_temp as
SELECT node.nid, min(term_data.tid) FROM weblinks
INNER JOIN node on node.nid = weblinks.nid
INNER JOIN term_node on node.nid = term_node.nid
INNER JOIN term_data on term_data.tid = term_node.tid
WHERE node.type LIKE 'weblinks'
GROUP BY url

Rename field (dumb way, but it was quick):

ALTER TABLE `tid_temp` CHANGE `min(term_data.tid)` `tid` INT( 10 ) UNSIGNED NULL DEFAULT NULL

Set taxonomy id's;

update weblinks, tid_temp
set weblinks.tid = tid_temp.tid
where weblinks.nid = tid_temp.nid

Clean up temp table:

DROP TABLE `tid_temp`;