Holiday Schedule
Your code gophers will be away for the next couple of weeks so support will be sporadic. We should be fully back online by the end of September.
A new version of Full Calendar is now available.
See the details here

Export to CSV without using dialog

Views Views: 13,217
Last updated Last updated: Apr 29, 2020

Page

Contents
Fabrik 3.0 +
Fabrik 2.0 only:
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

Top