Migrating some content to a new Drupal site from an old Drupal site

Events happening in the community are now at Drupal community events on www.drupal.org.
rgracia's picture

Hi Group members, I need some guidance...

We have a Drupal site in the beginning stages of a redesign. As part of the agreed new design, only three content types (and their corresponding existing nodes in the database) will need to be migrated to the new site and new database. Is there a module that allows me to selectively choose nodes from particular content types and export in a format that can be imported as content in the new site? Both sites being Drupal sites...

I have never migrated content in this way before. I have always done an upgrade from one version of Drupal to another (5 to 6) and working with legacy content from that point on, but this is the first time I need to export only some content and import it into the new site.

I know some people have done that before but I am confused as to how to do this properly with the available modules out there. Any suggestions are appreciated.

Comments

There are a few attempts to approach this

johnstorey's picture

One is the Node Import module (http://drupal.org/project/node_import). That might help you. It's downside is that it imports from CSVs. If you have non-trivial content nodes, they can be spread across multiple tables -- so dumping a database table or two, and running some editor macros isn't convenient.

CTools and Exportables seem to offer the correct path for Drupal to offer this functionality, but it's not universally adopted. To be honest, I usually just write a pair of export / import scripts for this sort of thing. You could wrap that sort of thing in a module, and even put a nice GUI over it to selectively choose which nodes are migrated and which are not. That's nice when your content types are fairly stable, and relatively quick to do. Somewhere on my 'projects to take on' list is writing a nice GUI interface tool that lets you selectively migrate content nodes between Drupal installs with a pretty GUI, updating content types along the way as needed. It's pretty far down the list though.

John S.

Can I use the Table Wizard

rgracia's picture

Can I use the Table Wizard and Migrate modules to do this? The nodes I need to bring in are now three separate content types but simple ones. The key is to import them with intact create date (for archive purposes). I tested the node export module yesterday and although it bring the items in fine, they all get the current date as the create date in the new db. Is keeping the create date intact possible in an import with solutions you have tried in the past?

I just realized the import settings were set to override those fields, it is working now using Node Export.

Data Export Import

bailey86's picture

I've created a module which is at:

http://drupal.org/sandbox/bailey86/1278830

Which may be of use.

The module can be installed on both the exporting and the importing sites. The data is exported to dataset files. This may not be suitable as currently it only deals with Pages content types - but I'm adding the ability to handle all content types - so you might want to keep an eye on it.

Regards,

Kevin

Content migration, import, and export

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: