Export to CSV without using dialog

  • Views Views: 12,528
  • Last updated Last updated:

Navigation

  • Fabrik 3.0 +​


    You should use the CSV Fabrik menu item type.(Fabrik3.9: CSV menu item type doesn't do. You may create menu item type System/URL and use the export URL, see below).

    Starting from Fabrik 3.3.4 you can also use the URL:

    index.php?option=com_fabrik&view=list&listid=listid&format=csv&download=1

    You can append variables to the$url value to alter the output of the CSV file. These correspond with the settings located on the export CSV dialog box:
    • incraw=0 or 1
    • incfilters=0 or 1
    • inctabledata=0 or 1
    • inccalcs=0 or 1
    • excel=0 or 1
    By default this will export all of the table's Elements. If you want to specify which element's are exported append the following the url:

    Code:
    &fields[tablename___elementname]=1&fields[tablename___elementname2]=1


    Fabrik 2.0 only:​


    If you don't want to show the CSV export dialog then you can achieve a direct export to CSV by adding this into your table template. Templates are found in components/com_fabrik/views/table/tmpl
    PHP:
    <?php $url = "index.php?option=com_fabrik&c=table&view=table&format=csv&tableid={$this->table->id}&task=viewTable";?>
    <span class="csvExportButton custom">
    <a href="Javascript:oPackage.blocks.get('table_<?php echo $this->table->id;?>').triggerCSVImport(0, <?php echo $url'?>);">Export as CSV</a>
    </span>
    Note the span's 'custom' class is obligatory, as it stops the default export dialog from opening
Back
Top