By andrewl-1 on

Hi,

I have successfully exported content type definitions from one Drupal site and imported to another, but...

Is there a way to export the data and import?

⋅ Categories: Drupal 6.x

Comments

goedsole’s picture

goedsole commented

I'd like to use drupal as the development framework for a reasonable complex ( ~ 6 programmer-month effort ) application. I'm surprised I haven't been able to find (hour of doc search, hour of forum search) a simple means of exporting just the data from all content-types as a CSV (or whatever) file for later use in external systems like SPSS (i.e. Statistical Package for the Social Sciences).

Abstractly, I want to export *only the data* for *all* the nodes of a particular content type to a file format that is loadable by a variety of external applications. This seems so basic to me. I fear I'm missing a way of building a view, or something similarly core to drupal functionality.

I have used node export and it's nearly what I need with the following two exceptions. 1) If there was a SQL insert analog to Drupal Var Export that would be great. 2) It "must" be able to do *all* the nodes at once (there could be 10s of thousands).

Thanks in advance for any suggestions.

- Billy

jaypan’s picture

jaypan
Location Victoria, BC
commented

Take a look at the migrate module.

You can also look at Feeds.

Contact me to contract me for D7 -> D10/11 migrations.

goedsole’s picture

goedsole commented

The answer to my problem is the module Views Data Export.

I'm using drupal as a framework on which to build a data collection application. The data then needs to be exported for import to a variety of external applications (primarily statistical apps). So, I needed to be able to create, as a system test, a CSV file that contained a line for each node of a particular content type, which corresponds to a particular, filled in, data collection instrument in my system.

Problem solved.