flexiconvert question--all fields placed in body

All the fields are in the body because that's how Flexinode used to store and display its fields. It would create <div> tags with data and insert them into node body at the database level.

I "fixed" this by removing body and teaser text from the database after doing flexiconvert. But it's a little tricky. The safe way is to write a script to loop through the node table, find nid/vid of all nodes of type X, and then run an UPDATE against node_revisions to make body and teaser into blank strings ''.

If you remove the body and teaser elements from the database, CCK will create new ones on-the-fly from the data it has stored.

You could do this in SQL, but I think it requires a subquery. This might work:

UPDATE {node_revisions} nr INNER JOIN {node} n ON n.vid = nr.vid SET nr.body = '', nr.teaser = '' WHERE n.type = '$string';

Where $string is the CCK node type you created. And {tablename} indicates possible table prefixing if you use that.

DO NOT RUN THE ABOVE CODE ON A LIVE SERVER. it may horribly fail.

Here's a safe query you can run to test the logic above.

SELECT nr.nid FROM {node_revisions} nr INNER JOIN {node} n ON n.vid = nr.vid WHERE n.type = '$string'

On my test server, this works as expected:

SELECT nr.nid FROM node_revisions nr INNER JOIN node n ON n.vid = nr.vid WHERE n.type = 'blog';

--
http://ken.blufftontoday.com/
http://new.savannahnow.com/user/2
Search first, ask good questions later.