Importing CSV table to nodes in Drupal 7

Posted by Anthony Pero on November 14, 2012 at 10:05pm

Hi folks,

I have a CSV file of schools, addresses, contact info, etc... I need to import these so that each school is its own node, with the columns in the csv file mapped to corresponding fields in the node. In D6, I would have used the node_import module. How is this done in D7?

Comments

Try using the feeds module.

Posted by kscheirer on November 14, 2012 at 11:33pm

Try using the feeds module.

Thank you

Posted by Anthony Pero on November 14, 2012 at 11:48pm

I guess the name of that threw me off, but yes, I see it does do CSV import. Here's a question:

Some of the fields in my csv file will reference other nodes... is there a way in Feeds, or some other way, to have the csv value map to a node reference field? If i had to, I could get the NIDs and replace these fields with the NID in the spreadsheet before I import it, but if theres a way to automate this somehow... any ideas?

Anthony Pero
Project Lead
Convergent Creative Web Design
http://www.convergentcreative.com/

Yes...

Posted by yelvington on November 15, 2012 at 12:42am

... if there is a distinct title, for instance. Example: Import venues, then events that reference the venues. Done that, works great.

Thanks. I'll try that. The

Posted by Anthony Pero on November 15, 2012 at 4:19pm

Thanks. I'll try that. The node reference fields will definitely refer to nodes with distinct titles. I suppose I could install a module that makes sure all nodes have distinct titles, to be safe. Anyone know the name of that module by any chance?

Anthony Pero
Project Lead
Convergent Creative Web Design
http://www.convergentcreative.com/

http://drupal.org/project/uni

Posted by Anthony Pero on November 15, 2012 at 4:28pm

http://drupal.org/project/unique_field

Supports unique titles.

Anthony Pero
Project Lead
Convergent Creative Web Design
http://www.convergentcreative.com/