1. Important notice about Cloudbleed - if your site uses the Cloudflare CDN, and you intend to follow the Joomla security team's advice to change your site "secret", you MUST READ THIS NOTICE.
  2. Fabrik 3.6 Released Remember to backup and test your backup before proceeding with this update. Please report any problems you might experience with this new version here on the forum. You are safe to upgrade to Joomla! 3.7 and PHP 7.x with this version of Fabrik. View the blog for more details on this release.

CSV Export: No records available for CSV export

Discussion in 'Community' started by joomlamate, Jan 11, 2017.

  1. joomlamate

    joomlamate Member

    Level: Professional
    Hi - happy and healthy new year to all.

    I am getting 'No records available for CSV export' on a list that has a pre-filter by getting the value of the filter from the URL parameter "myvar"

    /index.php?option=com_fabrik&view=list&listid=1&myvar=68094

    In the prefilter of the list I have:

    WHERE `fieldname` EQUALS to value '{myvar}' type 'text'

    In this case I can't export to csv.
     
  2. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Supporter
    See the tooltip for "Custom QS" in the CSV options.

    That's exactly the scenario I added that setting for. So you'd add ...

    myvar={myvar}

    ... to that setting, which will add whatever 'myvar' is set to on the query string that loads that list page, to the posted data the CSV is fired off with.

    -- hugh
     
    joomlamate likes this.
  3. joomlamate

    joomlamate Member

    Level: Professional
    Awesome - I have never ever noticed that field.

    I am just having another csv export relevant issue. On another list where I use advanced search, the csv export doesn't take into consideration the filtered data from the advanced search.
    I think I found some older posts describing this so initially I would like to know if this is a known issue.

    Taking it a step forward - as I am creating custom_csv_list_export.php files for my lists, I am looking for the method that could return the terms that have been used in the advanced search field - from the FabrikFEModel - but so far I had no luck -nor able to spot something that would do the work.
     
  4. joomlamate

    joomlamate Member

    Level: Professional
    Write it all wrong - it's not the advanced search I am talking about above - it's the search all feature.

    And I am trying to:
    1. export csv with the filtered data from the search all feature
    2. find a way to get the values (keywords entered) of the search all field
     
    Last edited: Jan 12, 2017

Share This Page