[consulting] Database migration script or copy/paste?

[Bob Schmitt]

Hi Holly-

Yes...but you need to play with the exact format of your csv delimiters. When I first started using it, it took me a while to get the delimiters sorted out (and getting the data cleaned up so that it didn't split up data based on field contents).

bob

On Apr 19, 2010, at 11:17 PM, Holly Ferree wrote:

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
> 
> 
> 
> _______________________________________________
> 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/