Export Drupal nodes to CSV

Want to extract all your content from Drupal? I bet you do… seems like the world has gotten a distaste for all things Drupal and is jumping on the WordPress or even Jekyll bandwagon. Anyway, this query will probably get you what you need:

SELECT DISTINCT no.nid, n.title, u.name, n.timestamp, n.body, group_concat(DISTINCT td.name) as terms FROM users u, node no, term_data td, node_revisions n LEFT JOIN (term_node) ON (n.nid = term_node.nid) WHERE n.uid = u.uid AND no.vid=n.vid AND term_node.tid = td.tid GROUP BY no.nid

This was inspired by a more complicated method here; but why use node.js and a long JavaScript script to do something that can be done in one SQL statement?

Disclaimer: I’m still waiting for confirmation from my collaborator that this is actually what he needs, so there might be some edits coming.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>