<HTML>
<HEAD>
<TITLE>Re: [consulting] Database migration script or copy/paste?</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>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. :) <BR>
<BR>
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.<BR>
<BR>
Holly<BR>
<BR>
<BR>
On 4/19/10 11:16 PM, "Ben West" <westbywest@gmail.com> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>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.<BR>
<BR>
There are solutions for importing legacy (HTML) content into nodes. Perhaps one of these may be useful:<BR>
<a href="http://drupal.org/project/import_html">http://drupal.org/project/import_html</a><BR>
<BR>
On Tue, Apr 20, 2010 at 4:11 AM, Holly Ferree <hferree@gmail.com> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>Hi All,<BR>
<BR>
What is the most efficient way of transferring a site's content of 10 pages<BR>
or more into drupal? (basically past the realm that you would want to copy<BR>
and paste all the content to where another option would be easier to add a<BR>
good amount of content would be the way to go)<BR>
<BR>
I have done the copy/paste of hundreds of lines of content from Word and<BR>
done the whole create content > page, paste and format content, save page,<BR>
repeat process till I thought I would die of boredom...<BR>
<BR>
Please tell me there is a better way! (these sites have been from scratch or<BR>
have not used a database previously. )<BR>
<BR>
Thanks,<BR>
<BR>
Holly Ferree, Graphic Designer, BFA<BR>
hferree@gmail.com<BR>
<a href="http://www.designbyholly.com/">http://www.designbyholly.com/</a><BR>
<BR>
<BR>
PS I would also prefer to do it myself and not hire someone who doesn't mind<BR>
repetitive work... :)<BR>
<BR>
<BR>
_______________________________________________<BR>
consulting mailing list<BR>
consulting@drupal.org<BR>
<a href="http://lists.drupal.org/mailman/listinfo/consulting">http://lists.drupal.org/mailman/listinfo/consulting</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'><BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'><BR>
<BR>
Holly Ferree, Graphic Designer, BFA<BR>
813.786.0852<BR>
hferree@gmail.com<BR>
<a href="http://www.designbyholly.com/">http://www.designbyholly.com/</a><BR>
</SPAN></FONT>
</BODY>
</HTML>