Hello,

I have the following issue when exporting my view to .csv or .txt:
I made a form in cck with fields 'street', 'number', 'city'. Using views I want to show these items together which is straightforward using a custom text field, 'address', and substitution patterns. The individual fields are 'excluded from display'. So far so good.
adress = [field_street] [field_number], [field_city]

I added the feed export to csv display using the same defaults as above. Al fields are exported nicely except for the 'address' field with its substitution patterns. Only "," is shown.
I played around and when I deactivate 'exclude from display' from any of the fields, this fields is also shown in the custom ´address' field in the .csv file.

For example when the full address is "pinestreet 4, london", it shows correctly in the default view, and shows "," in the feed. When deactivating 'exclude from display' for [field_number], it shows "4," in the feed. But off course it also show an extra 'number' column in the exported .csv file

The error is also shown in the using the views 'preview' function.

I tested the bug on 2 different sites with same results.

Iso

Comments

neclimdul’s picture

Status: Active » Reviewed & tested by the community

Hmm, I can't seem to reproduce. I did find that I had to put the fields that where excluded from display prior to the custom text but after I did that I had not problems in either the page or feed(csv,txt,xml,doc) displays. Can you try and see if maybe its fixed in -dev?

neclimdul’s picture

Status: Reviewed & tested by the community » Postponed (maintainer needs more info)
bokabu’s picture

I found this post while troubleshooting what's likely an identical problem. The Global: Custom text I use to concatenate earlier undisplayed fields via replacement patterns for output yields success with a page/table but nothing with a feed/csv.

I'm also at 6.x-1.0-beta4

bokabu’s picture

Status: Postponed (maintainer needs more info) » Active

I tried with 6.x-1.x-dev (2009-Dec-04), and the problem is still there.

neclimdul’s picture

Can you try narrowing down the problem? If you can export a view that causes this issue that uses some basic fields like title and body and attach that to the issue that'd be helpful. Or if you can narrow it down to when you have a CCK field of a specific type or something like that. I've tried quite a few combination of my own and don't seem to be finding the error.

neclimdul’s picture

Status: Active » Postponed (maintainer needs more info)

Still need something more to investigate this further.