[consulting] Database migration script or copy/paste?

[Marty Landman]

I'd like to add to that based on some recent experience migrating 
about 10,000 nodes from a D5 site to the D6 dev site. I found that 
many of the D5 nodes had been coded with special character that made 
the node_import module choke. It was pretty simple once identifying 
this issue to pre-process the data byte by byte and convert all the 
problem characters to something compatble with node_import.

Marty

At 02:04 PM 4/23/2010, you wrote:
>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/
>
>_______________________________________________
>consulting mailing list
>consulting at drupal.org
>http://lists.drupal.org/mailman/listinfo/consulting