Importing CSV data into Drupal 6 CCK content types

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
mtbosworth's picture
Posted by mtbosworth on October 22, 2011 at 7:46pm

I have converted an MSSQL export to MySQL. Exported to CSV for import. Are their any field mapping tools for Drupal or am I doomed to write my own script?

Thanks in advance.

Categories: ,

Comments

There are field mapping modules.

Posted by jamesrutherford on October 22, 2011 at 9:37pm
jamesrutherford's picture

mtbosworth,

You can use the Node Import Module(http://drupal.org/project/node_import) to import that csv. Feeds(http://drupal.org/project/feeds) will also import from csv and can be used to update nodes after they have been imported.

Thanks,

James

Comparison of Content and User Import and Export Modules

Posted by Frank Ralf on October 24, 2011 at 6:54am
Frank Ralf's picture

You might find this comparison table useful:
Comparison of Content and User Import and Export Modules

Frank

My LinkedIn profile

Resources

Posted by mtbosworth on October 24, 2011 at 3:12pm
mtbosworth's picture

Thanks for all the help. With a little data manipulation, I think Node Import, and User Import will work. The trickiest piece is importing a one-to-many node reference from a lookup table in the source database.

Mike Bosworth
Balanced Scale Media, LLC
balancedscale.com

There is also the wonderful

Posted by kehan on October 25, 2011 at 10:25pm
kehan's picture

There is also the wonderful migrate module which supports relationships using skeleton entities then filling them out later - great documentation but a bit of a learning curve.

Importing multi row CSV data values into a single node

Posted by bitbaud on January 30, 2012 at 3:01am
bitbaud's picture

Hi,

I am working on a project that requires data from a .csv file with multiple rows of data to be imported into a single drupal node using drupal 6. For example a .csv file will contain 2 unique columns and Xnumber of unique rows. After the import is complete the Data needs to be displayed in table format with with each row of the .csv file corresponding to a single row in the drupal node.

I tried using the node_import module but instead of importing all rows of the .csv file into a single node it created a node for each row in the .csv file.

more detail:

.csv file contains these two rows which are essentially 2 unique records:

record1_valueA------record1_valueB
record2_valueA------record2_valueB

Import:

The data should be imported into a single drupal node containing the fields:
value_A
value_B

The Output (preferably using views)

  1. record1_valueA------record1_valueB
  2. record2_valueA------record2_valueB

Can anyone point me into the right direction?

Thanks,
Clif

my 2 cents here

Posted by dpovshed on January 31, 2012 at 7:56pm
dpovshed's picture

Hey Clif,

multiple rows of data to be imported into a single drupal node

If I understand you correctly you do not need in fact anything Drupal specific here. If I need to solve task like this I would make all conversion with other tool - bash script, php script - and then put data into a node manually or via simple drupal API call.

So, point of my message is - Ii believe you do not need to use Drupal-based tool to perform conversion.

Dennis