Importing CSV data into Drupal 6 CCK content types

mtbosworth's picture

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.

Comments

There are field mapping modules.

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

Frank Ralf's picture

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

Resources

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

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

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

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

Content migration, import, and export

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: