@Aguay-val opened this Issue on December 19th 2022

Expected Behavior

When i have a custom reports that has been created, and i want to export data as a csv file, I should have all data in several "levels".

Current Behavior

Actually when i click and "export" button and choose "CSV" only the first level of data has been exported.

Possible Solution

Using XML or JSON solved the problem but CSV is more convenient for some people.

Steps to Reproduce (for Bugs)

  1. Go to : https://demo.matomo.cloud/index.php?module=CoreHome&action=index&idSite=1&period=day&date=yesterday#?period=day&date=yesterday&idSite=1&category=CustomReports_CustomReports&subcategory=2
  2. Click on export and choose CSV
  3. Open CSV and there is no mention of "Client habitué"


We wanted to get csv data and process them.

Your Environment

  • Matomo Version: 4.13.0
  • PHP Version: 8.0.20
  • Server Operating System: Debian (docker container)
  • Additionally installed plugins: All premium Bundle
  • Browser: Chrome or Firefox same issue
  • Operating System: Linux
@heurteph-ei commented on December 20th 2022

I think this is possible this way:
(I choose TSV instead of CSV because my Excel is French and understand TSV instead of CSV...)

@Aguay-val commented on December 20th 2022

Already tried this way and it doesn't change anything.

Same issue with TSV format.

@heurteph-ei commented on December 20th 2022

The options to use were mainly:

  • Limit: All
  • Flatten report: Yes
@sgiehl commented on December 20th 2022 Member

@Aguay-val How would you expect a multilevel table to be structured in CSV format?
While that is easy in JSON and XML, I can't think of a structure in CSV that is able to handle that in a useful way.

Powered by GitHub Issue Mirror