<>
I don't see where to do this on 6.3.
I'd appreciate if you can point me in the right direction.
thanks

CommentFileSizeAuthor
#4 node-export[](0-nodes).1314095549.zip6.39 KBTribalMan

Comments

danielb’s picture

You have to enable the module node_export_csv, and then in the node export settings enable CSV as one of the available formats.

danielb’s picture

Status: Active » Fixed

One thing I should point out at every chance I get when people bring up CSV, is that it is not what a unix user might expect as a CSV file. The CSV implementation I have chosen is based on RFC4180 which is the closest thing to a description of what CSV 'should be'.
This implementation does not use the standard unix end-of-line character "\n" (LF) to delimit records. So if you just open it in a crappy editor it may appear as though records go over several lines... but that's because it's NOT line-by-line as some people think it should be. The delimiter is actually "\r\n" (CRLF) which does appear as a line break in windows, unix, mac, and old mac systems - but don't let that lead you to believe a line break represent a new record.
This works out really well for us because Node bodies and other field values often contain "\n" as a standard line break, and rather than replacing that with some BS ***BREAK*** or whatever, we keep the value as-is. So if you have a compliant editor, you can edit the content directly without any placeholders in the way.

If you don't like it you can copy the node_export_csv module and rename it to something else, and rename all the functions and stuff, and change it to work how you like :P

rocket777’s picture

Thanks. It works.
I had 6.2 installed and then saw that 6.3 had csv and since I used drush did not know there were more modules I needed to enable.

TribalMan’s picture

StatusFileSize
new6.39 KB

I am exporting Ubercart Product nodes. Many of the fields seem to be empty. This might be due to my use of the CSV format. I have tried this in Excel Mac2011, Numbers and Libre (Open Office) with the same results.

I use Text to Columns and always end up with the second half of the fields empty. I have attached a simple example. (please rename the extension to csv, this file is not compressed)

danielb’s picture

Ubercart nodes don't work right, and they don't care, e.g. #599806: uc_products.module Length, Width and Height validation adn DB insert fix

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

qylie-1’s picture

I can't find a module called 'node_export_csv' to enable.

Anandyrh’s picture

yup same here, can't find the module called 'node_export_csv'

ludo1960’s picture

Same here, can't find 'node_export_csv' any update on this?

Anandyrh’s picture

There is no module called 'node_export_csv'.

Within the 'Node export' module there is an option to enable

Installing the latest version '6.x-3.0-rc3'

Go to: admin/settings/node_export

Enabled 'CSV' check box under 'Format to use when exporting a node'

Changed the 'Filename pattern' to node-export-[nid-list]-[node-count]-[timestamp].csv

Under admin/content/node/overview I am able to find "Update options > 'Node export (CSV)'"

select the nodes that should be extracted and download the csv file

Anandyrh’s picture

opened a new issue here

ludo1960’s picture

Still playing about with this, when I upgrade to the dev version there is indeed a module named "Node export CSV" Trying to enable it tells me "Depends on: Node export (enabled), Uuid (missing)"

eh wtf is "Uuid" ???

danielb’s picture

atGota’s picture

Title: How to export to csv » Exporting only select fields of a node

I am using Node Export and it is a great module for exporting every single piece of content and fields from a node.
I am trying to export users to a csv file, but I only need specific pieces of information (fields).
Is thee a way to configure node export to select only what I need from nodes?

Thanks,

dilipvertical’s picture

Is there a way to configure node export to select only what I need from nodes?

dilipvertical’s picture

Status: Closed (fixed) » Active
danielb’s picture

Title: Exporting only select fields of a node » How to export to csv
Status: Active » Closed (fixed)

No.
Don't hijack issues.

batigolix’s picture

Issue summary: View changes

In the drupal 7 version of node export you must enable CSV export in the configuration: /admin/config/content/node_export
See #1681584: Bulk Export on Drupal 7