It appears that creating a xls feed view that contains a multi-value field results in an export that separates each value in the multi-value field into it's own field in the xls export (see attached example). Is there a way to export the xls so that all the values of a multi-value field appear in 1 field in the xls?

CommentFileSizeAuthor
#7 views_export_xls-multivalues_fields_export-799146-6.patch8.31 KBsirko_el
views_multivalue_issue.jpg134.41 KBsweimer

Comments

sweimer’s picture

sweimer commented

bump

creaoy’s picture

creaoy commented

Sorry, too much work right now.
I will look when will have a chance.

sweimer’s picture

sweimer commented

understood...thanks. i'll keep checking back

hiyikiyikas’s picture

hiyikiyikas commented

Would like to know if there is any progress... I need the function in this moment!

Elementica’s picture

Elementica commented
Title: Multi-value fields export as seperate fields in xls » Multi-value fields export as separate or multiple fields in xls
Version: 6.x-1.x-dev » 6.x-1.1-beta1

I have the opposite problem: I don't experience what stated in first post, my rows are like <Cell><Data ss:Type="String">3030</Data></Cell> where "3030" should actually be "30" and "30" (two values).
Option "Group multiple values" is checked and table-style view online is good (I'm using version 6.x-1.1-beta1).

bartezz’s picture

bartezz commented
Version: 6.x-1.1-beta1 » 7.x-1.0

In 7.x-1.0, when exporting users, roles are comma separated into a single cell. Would like to know how to split these over multiple cells as mentioned in #1.

Cheers

sirko_el’s picture

sirko_el commented
Component: Miscellaneous » Code
Assigned: Unassigned » sirko_el
Status: Active » Needs review
StatusFileSize
new views_export_xls-multivalues_fields_export-799146-6.patch8.31 KB

Looks like works now. Had some problems with Office 2003 xml format, but now it works fine for me.

creaoy’s picture

creaoy commented

Looks good, will test for some time.

creaoy’s picture

creaoy commented
Status: Needs review » Fixed

Committed to latest dev

Status: Fixed » Closed (fixed)

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