search

matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.3k stars 2.59k forks source link

Bug when exporting report #4035

Closed anonymous-matomo-user closed 10 years ago

anonymous-matomo-user commented 11 years ago

Hi! We have discovered two bugs when we like to export reports. Case no 1 I can not export any reports when I use a date range and the parameter &flat=1. Here's what I do:

  1. I go to the Entry Page report.
  2. I select a date range, for example July 1st 2012 to July 1st 2013.
  3. In the url I add the parameter &flat=1. I do this because I want the report to include all subpages.
  4. I get an error message and no statistics are displayed: "There is no data for this report" My intention is to export this report to TSV Excel but it is no use clicking on the export icon as no statistics are presented. Here's an example of the url: http://piwik.vgregion.se/index.php?module=CoreHome&action=index&date=2012-07-01,2013-07-01&period=range&idSite=32#module=Actions&action=indexEntryPageUrls&date=2012-07-01,2013-07-01&period=range&idSite=32&flat=1

Case no 2 I can not export the report after using the cog wheel tool.

  1. I go to the Entry Page report.
  2. I select a date range, for example July 1st 2012 to July 1st 2013.
  3. I click on the cog wheel icon and select "Make it flat"
  4. I get an error message "There is no data for this report". My intention is to export this report to TSV Excel but it is no use clicking on the export icon as no statistics are presented.

I would like to be able to export all subpages when I select a date range.

Do you have any solution for this? Grateful for any help as reports are often used in our organisation. Thanks in advance! Best regards, E

Keywords: export reports, cog wheel, flat reports

anonymous-matomo-user commented 10 years ago

I was trying to get a similar export but typing the url directly: http://demo.piwik.org/index.php?module=API&method=Actions.getDownloads&format=TSV&idSite=7&period=range&date=2013-07-09,2013-07-22&flat=1&translateColumnNames=1&language=en&filter_limit=100

and I get this:

Error: The date '2013-07-09' is not a correct date range. It should have the following format: 'lastN', 'previousN', 'YYYY-MM-DD,YYYY-MM-DD'.```

If  I set the flat parameter to 0 I get the right results:
http://demo.piwik.org/index.php?module=API&method=Actions.getDownloads&format=TSV&idSite=7&period=range&date=2013-07-09,2013-07-22&flat=1&translateColumnNames=1&language=en&filter_limit=100

Hope this helps to find the cause.
Regards,
Cristina
mattab commented 10 years ago

Thanks for the report.

anonymous-matomo-user commented 10 years ago

Hi again! Another great feature would be that the exported report shows more than 100 rows.

It would be great if it was possible to choose how many rows the report should include, for example 'All rows, 3000, 1000, 500, 400, 300, 200, 100'.

Hope it is not too troublesome to fix! You can be sure this would be appreciated greatly by our users who often export reports. Best regards, E

diosmosis commented 10 years ago

The "There is no data for this report." and the 'incorrect date range' bugs are both fixed in git. It's also possible to export more than 100 rows. All of this will be in Piwik 2.0 and the bug fixes will be in 1.12.1.

anonymous-matomo-user commented 10 years ago

Fanstastic! Well done and big THANKS!