Export to CSV attached to Exposed filter View page not working correctly

Yep it's possible and I do it all the time. I'm not sure I did anything special to get it to work-- i created a page display at 'page_display_path' with exposed filters, then set the feed/csv path to be '/page_display_path/csv', and set the 'Attach to' setting to be the page display with the exposed filters.

I also had to export a view after filtering the nodes by dates.

The attached feed/csv export will not pick up the filters from the attached view.

What I did was add some PHP code in the header that parses the URL string to create a link to send the correct arguments to the export view.

You must turn off AJAX so the query string appears in the url after filtering. Also remember to enable the PHP input filter and set the header to PHP.

In this code, I am picking up 2 filters, one for the posted date and one for the most recent revision date.

<?php

//you can copy your url here for debugging
//$url = "http://twn.local/workflow/adhoc_reporting?date_filter_1[min][year]=2010&date_filter_1[min][month]=10&date_filter_1[min][day]=1&date_filter_1[max][year]=2010&date_filter_1[max][month]=10&date_filter_1[max][day]=29&date_filter[min][year]=2010&date_filter[min][month]=11&date_filter[min][day]=1&date_filter[max][year]=2010&date_filter[max][month]=11&date_filter[max][day]=4";

$url = $_SERVER['QUERY_STRING'];
$iso = "";


if (strpos($url,'date_filter')){
$end = strpos($url,'/workflow/adhoc_reporting-');
$len = strlen('/workflow/adhoc_reporting-');
$url  = substr($url,$end+$len+1);
//created year from
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso = "/" . substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);
//created month from
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);
//created day from
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "--";
$url = substr($url,$end+1);

//created year to
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);
//created month to
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);
//created day to
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "/";
$url = substr($url,$end+1);

//revised year from
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);
//revised month from
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);
//revised day from
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "--";
$url = substr($url,$end+1);

//revised year to
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);
//revised month to
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);
//revised day to
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= substr($url,$pos+1);
}



//echo "pos: " . $pos . "<br /><br />" . " end: " . $end . "<br /><br />"; 

//echo "iso: " . $iso. "<br /><br />";

//. "<br /><br />" . " url: " . $url; 

//2010-10-02--2010-11-09/2010-11-04--2010-11-09

echo "<script>";
echo "function csv(){location = 'http://twn.local/workflow/export_csv" . $iso . "'}";
echo "</script>";

?>

<div id="adhoc_csv_link"><a href="javascript:void(0)" onclick = "csv()">Export CSV</a></div>
<div id="adhoc_reset"><a href="javascript:void(0)" onclick = "location='/workflow/adhoc_reporting'">Reset Dates</a></div>

I tried the path setup suggested by WorldFallz but the csv button still exports the entire unfiltered view

I switched from select filters to popups which create a different URL syntax, here is some code for popup filters:

<?php

//$url = "http://twn.local/dashboards/adhoc_reporting?date_filter_1[min][date]=2010-10-01&date_filter_1[max][date]=2010-10-29&date_filter[min][date]=2010-11-01&date_filter[max][date]=2010-11-02";

$url = $_SERVER['QUERY_STRING'];
$iso = "";


if (strpos($url,'date_filter')){
$end = strpos($url,'/dashboards/adhoc_reporting-');
$len = strlen('/dashboards/adhoc_reporting-');
$url  = substr($url,$end+$len+1);

//created from
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso = "/" . substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);

//created to
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= "-" . substr($url,$pos+1,$end-$pos-1);
$url = substr($url,$end+1);

//revised from
$pos = strpos($url,'=');
$end = strpos($url,'&');
$iso .= "/" .  substr($url,$pos+1,$end-$pos-1) . "-";
$url = substr($url,$end+1);

//revised to
$pos = strpos($url,'=');
$iso .= "-" . substr($url,$pos+1);
}

echo "<script>";
echo "function csv(){location = 'http://twn.local/dashboards/adhoc_reporting/csv/" . $iso . "'}";
echo "</script>";

?>

<div id="adhoc_csv_link"><a href="javascript:void(0)" onclick = "csv()">Export CSV</a></div>
<div id="adhoc_reset"><a href="javascript:void(0)" onclick = "location='/dashboards/adhoc_reporting'">Reset Dates</a></div>

I had to make the BOTH the fields and the filters of the Page view match the Feeds view exactly. Fortunately, I was able to go into the fields that I wanted to hide in the Page view but not in the Feeds view by simply selecting "Exclude ffrom display" for each field.

---- Correction: Having the fields be the same is not necessary. The reason mine was not working was because I changed the CSV feed icon on my page, thereby preventing the arguments from passing to that feed page when clicked. Now I am back to the default icon and the feed button is working great with exposed filters from my page view.