DC products with Node Reference

I created a new D7 and DC site of books as the products. The site will also contain a content type called authors. The Book product will be referencing an Author from the author type, and vice versa. Each book can potentially have multiple authors, as well as the author to multiple books. This was pretty simple to do with five books and ten authors. Now... question... Was this the best way to do this? If so...

I have a couple of hundred books and even more authors. What is the best way to add those?
Should I export? this data so that I can fill it in with an excel file? If I have data on an excel file with a sheet of authors and a sheet of books, how do I reference them to each other?

I would rather not, but I am even willing to try phpmyadmin if I have to.

I appreciate any help.

Posted: Dec 1, 2011


zeta1600 on December 1, 2011

Matt... thanks for the suggestion. I will take a look at that. I had actually ran into that earlier. But, at first glance, I didn't know if it would help me teach how to "export" since the title was about "importing." If you have any additional comments, be glad to hear them. By the way, do you think the way I am setting up my product/reference is the best way?