How to do database migration in drupal



Hi All,

What is the most efficient way of transferring a site's content of 10 pages or more into drupal? (basically past the realm that you would want to copy and paste all the content to where another option would be easier to add a
good amount of content would be the way to go)

I have done the copy/paste of hundreds of lines of content from Word and done the whole create content > page, paste and format content, save page, repeat process till I thought I would die of boredom...

Please tell me there is a better way! (these sites have been from scratch or have not used a database previously. )

Thanks,
Pooni

Created by pooni 2 years 1 week ago Drupal   Tags:


There is a node import/export module, but it doesn't do well with complex CCK fields. That said, importing rows directly via SQL can also be tricky for nodes with complex fields, since you would be importing more than just entries in node and node_revision.

There are solutions for importing legacy (HTML) content into nodes. Perhaps one of these may be useful:
http://drupal.org/project/import_html

Thanks
Ben

Thanks. Anything would help. I love my development and design work, but find the adding pages of content (esp. To large sites) a little monotonous. :)

And I have no problem doing the migration early in development (hopefully the client will give the majority of content) before I add the CCK fields or
complex functionality to the site.

Pooni

If Import HTML doesn't work out for you, you'll probably have to copy and paste, since the content isn't in a
database. If you find yourself doing that, you might at least ease the burden a little (reduce necessary clicks) with Add anothermodule.

Best wishes!
Ken

Hey thanks. Glad I asked.

No matter what it sounds like things won?t be as bad as before :)

I had just been clicking on the add page link 10 times, pasting in the appropriate content, save, close window, etc...but even that gets old if you decide you need to add another CCK field, then you have to refresh all those
windows.... :)

Thanks everyone... I have hope! These modules are great!

Cheers,
Pooni

Sometimes, even on site with 50-100 pages, copy/paste the way to go. The
reasons are the links inside the content need to be cleaned up, or need to
attach images and such.

Otherwise, import_html is worth exploring for static legacy content.

Cheers,
Priyanka
www.ebizontek.com