1. Fabrik 3.7 is now available. This version contains critical security updates, please update as soon as possible. Please remember to backup your site before updating, we also recommend testing your updates on development sites if possible.

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