Problem exporting agiven date data to csv

I am trying to export the result of the following url to csv file. I can see the url result. It doesn’t generate csv file when I select export to csv. Instead i get an error. Appreciate quick response help. Trying to exporte to XML, json and php generates the export file. I am running Piwik 2.6.5 version.

Here is the URL:
http://hostname/index.php?module=CoreHome&action=index&idSite=10&period=day&date=today#?module=Live&action=indexVisitorLog&idSite=10&period=day&date=2016-10-01

Error that I am getting:

Firefox can’t find the file at http://hostname/index.php?module=API&method=Live.getLastVisitsDetails&format=CSV&idSite=10&period=day&date=2016-10-01&expanded=1&translateColumnNames=1&language=en&token_auth=8d09da4f7f800902afbeb6ea72029d8e&filter_limit=-1&token_auth=8d09da4f7f800902afbeb6ea72029d8e&filter_limit=-1&token_auth=8d09da4f7f800902afbeb6ea72029d8e&filter_limit=-1.

What does the server log say?

It appears to be a simple 404 error. Easiest way to check is to look at the server configuration file for the document root. In that directory, is there a file named index.php? Or is the URL missing directories?

Yes, I do have index.php in Piwik document root directory. I can generate xml, json and php but not csv and tsv.

Here is what is in the log: IPN is removed before –

    • [25/Oct/2016:11:27:46 -0400] “GET /index.php?module=CoreHome&action=index&idSite=10&period=day&date=today HTTP/1.1” 200 16406
    • [25/Oct/2016:11:27:46 -0400] “GET /index.php?module=Proxy&action=getNonCoreJs&cb=aa1ee9a73d35e1a30af4e3f0a599a123 HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:46 -0400] “GET /index.php?module=Proxy&action=getCss&cb=d7a3c0f71a60051c069a9de1770cd319 HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:46 -0400] “GET /index.php?module=Proxy&action=getCoreJs&cb=aa1ee9a73d35e1a30af4e3f0a599a123 HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:46 -0400] “GET /plugins/Morpheus/stylesheets/base/bootstrap.css HTTP/1.1” 200 3355
    • [25/Oct/2016:11:27:46 -0400] “GET /plugins/Morpheus/stylesheets/base/icons.css HTTP/1.1” 200 1058
    • [25/Oct/2016:11:27:46 -0400] “GET /plugins/Morpheus/images/logo.svg HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:46 -0400] “GET /plugins/Morpheus/images/loading-blue.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:47 -0400] “GET /plugins/CoreHome/angularjs/quick-access/quick-access.directive.html?cb=aa1ee9a73d35e1a30af4e3f0a599a123 HTTP/1.1” 200 709
    • [25/Oct/2016:11:27:47 -0400] “GET /plugins/CoreHome/angularjs/siteselector/siteselector.directive.html?cb=aa1ee9a73d35e1a30af4e3f0a599a123 HTTP/1.1” 200 1111
    • [25/Oct/2016:11:27:47 -0400] “GET /plugins/CoreHome/images/reset_search.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:47 -0400] “POST /index.php?date=2016-10-25&format=JSON2&idSite=10&method=SitesManager.getNumWebsitesToDisplayPerPage&module=API&period=day HTTP/1.1” 200 12
    • [25/Oct/2016:11:27:47 -0400] “POST /index.php?date=2016-10-25&format=JSON2&idSite=10&limit=15&method=SitesManager.getPatternMatchSites&module=API&pattern=%25&period=day HTTP/1.1” 200 59
      85
    • [25/Oct/2016:11:27:47 -0400] “POST /index.php?date=2016-10-25&module=Dashboard&action=getAvailableWidgets&idSite=10&period=day HTTP/1.1” 200 10300
    • [25/Oct/2016:11:27:47 -0400] “POST /index.php?date=2016-10-01&module=Live&action=indexVisitorLog&idSite=10&period=day HTTP/1.1” 200 748201
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/Live/images/visitorProfileLaunch.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/Live/images/returningVisitor.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/us.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/IE.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicePlugins/images/plugins/java.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/os/WIN.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/screens/normal.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicePlugins/images/plugins/flash.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicePlugins/images/plugins/silverlight.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/MF.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/os/IOS.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/screens/smartphone.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/CH.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicePlugins/images/plugins/pdf.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/Morpheus/images/search_ico.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/Morpheus/images/link.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/os/MAC.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/FF.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicePlugins/images/plugins/quicktime.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/SF.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicePlugins/images/plugins/director.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/CM.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/ca.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/screens/tablet.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/os/AND.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/IM.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/os/WPH.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicePlugins/images/plugins/windowsmedia.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/UNK.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/xx.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/os/WRT.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/OP.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicePlugins/images/plugins/realplayer.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/os/UBT.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/vn.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/tw.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/gb.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/screens/unknown.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/sa.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/os/COS.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/AN.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/gr.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/es.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/cn.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/kr.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/DevicesDetection/images/browsers/CR.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:58 -0400] “GET /plugins/UserCountry/images/flags/it.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/UserCountry/images/flags/de.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/DevicesDetection/images/browsers/MX.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/Morpheus/images/download.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/UserCountry/images/flags/ae.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/DevicesDetection/images/os/LIN.gif HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/UserCountry/images/flags/in.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/Morpheus/images/data_table_footer_active_item.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/Morpheus/images/table.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/Morpheus/images/export.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/Morpheus/images/sortasc_dark.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:27:59 -0400] “GET /plugins/Morpheus/images/sortdesc_dark.png HTTP/1.1” 304 -
    • [25/Oct/2016:11:28:35 -0400] “GET /index.php?module=API&method=Live.getLastVisitsDetails&format=CSV&idSite=10&period=day&date=2016-10-01&expanded=1&translateColumnNames=1&language=en&to
      ken_auth=8d09da4f7f800902afbeb6ea72029d8e&filter_limit=-1 HTTP/1.1” 500 -

All of those log entries appear to return a success code (200 and 304) except the very last one which appears to be truncated but looks like a 500 internal server error. These are almost always syntax errors of some kind.