I'm using the beta1 version with the ubercart views module

I have an xls file view and I am combining two fields into one column (first name and last name of the customer), when I 'exclude from display' the first name and 'rewrite the output of this field' for last name to [billing_first_name] [billing_last_name]

the resulting xls file displays everyone's first name as what ever the first row's first name was, so if the first customer was Jim Jones, the export file looks like this:

Jim Jones
Jim Smith
Jim Washington
Jim Barton
etc.

Is combining fields not allowed? If I keep the first name in it's own column it works fine.

CommentFileSizeAuthor
#4 705368-rewrite-field-tokens.patch492 bytesdafeder
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

creaoy’s picture

Assigned: Unassigned » creaoy

I need some time to look at this. I'm very busy now.

dafeder’s picture

I am struggling with this as well. It looks like views bonus pack has a similar bug and there has been some progress on that front:

#715770: The fields when assigned within global custom text returns only the last row

However, none of the fixes there that seemed to work for other people have worked for me so far, either in views bonus pack or trying to adapt them for XLS Export, which is a similar module (both export tabular data from views).

dafeder’s picture

Category: support » bug

Oh and I think this can safely be labeled as a bug.

dafeder’s picture

Turns out I just needed to upgrade views and the fix from #715770 worked fine. Here is a patch for views_export_xls that works for me.

creaoy’s picture

Status: Active » Closed (fixed)

Thanks, added to latest dev.

ChoNguyenVan’s picture

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

I also see this bug on 7.x-1.0 version.
So after apply the patch of dafeder, the module worked.
Thank!