Workaround CSV export missing data when rows contain the same data

ghicar

Member
I think I would consider this a bug. I have a list with a repeating join that I have a display mode of "Each row separately". I use this list view to do CSV exports for some pivot analysis. The CSV export has selected columns to include in the export. The exported columns did not include the id column of either table.

I have found that if the data is the same for two or more repeated rows within a row of the main table, then only one instance is exported.

Probably best illustrated by example, diagram below shows the two joined tables with display mode "merge rows"
Screenshot merged view.png

And for the list view that I use for CSV export with display mode "each row separately":

SeparateRowView.png


So in the above case the CSV export has only 4 rows for the event on 13 April (should be 6).

I have fixed this by including the joined table ID element as one of the exported columns to make the rows distinct.

Joomla 5.0.3
php 8.1.27
Fabrik ver4.0
 
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top