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.<div>
<br></div><div>There are solutions for importing legacy (HTML) content into nodes. Perhaps one of these may be useful:</div><div><a href="http://drupal.org/project/import_html">http://drupal.org/project/import_html</a></div>
<div><br><div class="gmail_quote">On Tue, Apr 20, 2010 at 4:11 AM, Holly Ferree <span dir="ltr"><<a href="mailto:hferree@gmail.com">hferree@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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>
<a href="mailto:hferree@gmail.com">hferree@gmail.com</a><br>
<a href="http://www.designbyholly.com/" target="_blank">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>
<a href="mailto:consulting@drupal.org">consulting@drupal.org</a><br>
<a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Ben West<br><a href="mailto:westbywest@gmail.com">westbywest@gmail.com</a><br>
</div>