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.
Comment | File | Size | Author |
---|---|---|---|
#3 | export-order.txt | 25.02 KB | Cybertrail |
Comments
Comment #1
timtk CreditAttribution: timtk commentedPlease 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
Comment #2
vishusrinivasan CreditAttribution: vishusrinivasan commentedIs there an solution found to this, I am having similar issue
Comment #3
Cybertrail CreditAttribution: Cybertrail commentedI 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.
Comment #4
knalstaaf CreditAttribution: knalstaaf commentedConfirming #3, in my case the duplicate shows values with "0" whereas the original fields show the correct value.
Comment #5
loudpixels CreditAttribution: loudpixels as a volunteer commentedHi 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
Comment #6
loudpixels CreditAttribution: loudpixels as a volunteer commentedHi 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.
Comment #7
knalstaaf CreditAttribution: knalstaaf commentedThe 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.