<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'>Hey thanks. Glad I asked. <BR>
<BR>
No matter what it sounds like things won’t be as bad as before :) <BR>
<BR>
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.... :)<BR>
<BR>
Thanks everyone... I have hope! These modules are great!<BR>
<BR>
Holly<BR>
<BR>
<BR>
On 4/19/10 11:25 PM, "Travis Carden" <travis.carden@gmail.com> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>If Import HTML <a href="http://drupal.org/project/import_html"><http://drupal.org/project/import_html></a> 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 another <a href="http://drupal.org/project/addanother"><http://drupal.org/project/addanother></a> module. Best wishes!<BR>
<BR>
<BR>
On Mon, Apr 19, 2010 at 10:22 PM, Holly Ferree <hferree@gmail.com> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><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>
<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>
<BR>
hferree@gmail.com<BR>
<a href="http://www.designbyholly.com/">http://www.designbyholly.com/</a><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>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'><BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:10.0px'>_______________________________________________<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></FONT></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:10.0px'><BR>
<BR>
</SPAN></FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12.0px'>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>