Issue Summary

I have a entityform that has several fields that have unlimited number of entries attached to them. The fields are displayed as a group using field groups (Multiple Fields Table). In order to be able to export them as a csv I have installed and enable views data export.
However, when I export the csv I get multiple entries of the same field.
So instead of
Company|Project|Price0|
Company1|Project1|Price1
i.e two companies have listed a project they have each completed
I get
Company|Project|Price0|
Company|Project|Price1|
Company|Project1|Price0|
Company|Project1|Price1|
Company1|Project|Price0|
Company1|Peoject|Price1|
Company1|Project|Price0|
Company1|Peoject1|Price1|

These items show fine in the table view that is provided by Entityforms, however, when I export it as a csv this happens. It keeps repeating itself for the number of additional entries.

CommentFileSizeAuthor
#3 export-order.txt25.02 KBCybertrail
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

timtk’s picture

Please could I get some assistance with this. I cannot seem to find a similar issue and have been struggling for weeks now to find a solution

vishusrinivasan’s picture

Issue summary: View changes

Is there an solution found to this, I am having similar issue

Cybertrail’s picture

FileSize
25.02 KB

I am also having this problem using 7.x.3.0-beta8 and exporting an xml file. Also tried the dev version with the same problem. I am using it to create Commerce orders. It works fine when I choose commerce order fields. It also works fine when adding a relationship to shipping or billing information. The duplication problem occurs when adding a relationship to the commerce order: line items. Each order is duplicated with each order appearing twice. All the fields are identical in both copies except for the line item fields. The line item field content only appears in one of the copies.
I have included an export of the view if that helps.

knalstaaf’s picture

Confirming #3, in my case the duplicate shows values with "0" whereas the original fields show the correct value.

loudpixels’s picture

Hi there ... I have a similar problem ... my data export generates an excel spreadsheet with a list of users ... all users are listed twice.

Did anyone found a solution yet? Thanks

loudpixels’s picture

Hi there, I was able to resolve my issue by turning on "aggregation" and setting a filter criteria with an aggregation filter set to: COUNT. Posting here in case someone is looking for a temporary solution.

knalstaaf’s picture

The trick in #6 didn't work for me. I after enabling the Views Distinct module (combined with aggregation turned on in the View) it's kind of fixed by applying the following Views Distinct settings on the product field (which displays the name of the item in the cart): Aggregate repeats.

I added the rest of the fields one by one, saving everytime to check if all worked out (it tended to show nothing at all at some point, just the column headers).

I'm afraid this could be a bug of which workarounds depend on the actual structure of the view, so that there's no real one fits all. Best option is the bug being fixed altogether.