1. "Fabrik 4" helpers needed!

    You are invited to join other community members active in coding, maintaining and improving Fabrik. Please visit https://fabrik.help for more information!
    Dismiss Notice

Export to CSV without using dialog

Apr 29, 2020
Export to CSV without using dialog

  • Contents


    Fabrik 3.0 +(top)


    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 (Text):
    &fields[tablename___elementname]=1&fields[tablename___elementname2]=1

    Fabrik 2.0 only:(top)


    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
() (11740 Views)
Last Modified: Apr 29, 2020 at 12:18 PM (Cached)
XenCarta PRO © Jason Axelrod from 8WAYRUN.COM