[consulting] Database migration script or copy/paste?

[Holly Ferree]

Hi Bob,

Thanks for the input. I'm not web to scripts... I just didn't know what else
to call them... I just want to know if there is a better way to insert a lot
of content without so much clicking and copying/pasting. :)

I am so thrilled to know about all these modules that I can try!

I was curious if Excel could be used (it's all tables anyways)... Would you
export it was a .csv?

Thanks,
Holly


On 4/20/10 12:12 AM, "Bob Schmitt" <bobschmitt at xinsys.net> wrote:

> I've had pretty good luck with the Import/Export module
> (http://drupal.org/project/import_export_tool) and the Node Export module
> (http://drupal.org/project/node_export). I can't remember which one is the
> best, but I have used them to dump/import more than 30K nodes organized in in
> 7 cck node types. It worked pretty well except for importing multiple taxonomy
> terms per node.
> 
> I've also used these modules to migrate content from other sites into Drupal
> sites using Excel and FilemakerPro as intermediary platforms to massage the
> data into the correct formats prior to the migration.
> 
> Strictly speaking, neither of these are database migration scripts, but the
> get the job done.
> 
> bob
> 
> On Apr 19, 2010, at 9:11 PM, Holly Ferree wrote:
> 
> 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,
> 
> Holly Ferree, Graphic Designer, BFA
> hferree at gmail.com
> http://www.designbyholly.com/
> 
> 
> PS I would also prefer to do it myself and not hire someone who doesn't mind
> repetitive work... :)
> 
> 
> _______________________________________________
> consulting mailing list
> consulting at drupal.org
> http://lists.drupal.org/mailman/listinfo/consulting
> 
> Bob Schmitt
> 432 Harrison Ave.
> Helena, MT 59601
> Voice: +1.406.459.6537
> Skype: captbobalou
> 
> 
> 
> _______________________________________________
> consulting mailing list
> consulting at drupal.org
> http://lists.drupal.org/mailman/listinfo/consulting

Holly Ferree, Graphic Designer, BFA
hferree at gmail.com
http://www.designbyholly.com/