Fabrik User Manual 0

• Connection - select the Fabrik connection in which you want to create the
database table
• CSV file - press the browse button to locate the CSV file on your hard drive
(excel and open office spreadsheets can be exported as CSV file)
• Create new table - enter the name of the database table you wish to create
when importing the CSV file. Must be alphanumeric with no spaces.
• Label - enter a label for the Fabrik table.
• Create primary key - if yes selected then an additional prmary key element will
be added to the imported table.
• Press "import" to continue wit the creation of the Fabrik table from the uploaded
CSV file.
• Press "cancel" to abort this page and return to the table list.
If you had selected 'yes' for the 'create primary key' option then the next screen will look
like this. Here you can set the element type for each imported column and define the
element's label
If you had selected 'no' for the 'created primary key' option then you will see an
additional column as shown in the image below:
77

---

The Primary key radio list allow you to specify which element is the primary key.
• To continue with the import press the "save" button, this will create the table,
form, group and elements, create the database table and import the CSV data
into the table.
• To cancel the import press the "cancel" button
View details
You can view the table's details by clicking on the 'view details' link next to each table
entry in the table list.
Each hyperlink on this page goes to the edit form for the associated table part.
78

---

Edit table
79

---

80

---

Details
• Label - The text that appears at the top of the table
• Introduction - The introduction text that appears below the title and before the
table
Filters
Filters are fields or drop downs that enable your users to filter the table's data. Below is
an example of a couple of filters:
Note: The template file that is used to render the filter form is located in:
components/com_fabrik/views/form/{tmpl}/default_filter.php
• Filter trigger -
◦ On change - The table filters applied when they are changed
◦ Submit form - An "apply" button appears at the end of the filters. The
table data is only filtered when this button is pressed.
• Show Filters - Hides the filters from the form.
• Advanced search -Adds an advanced search link to the table filter table, as
shown in the image below:
◦
Clicking on this link will bring up the advanced filter window. From here
your users can select which elements should meet which criteria for
filtering the table. Pressing the "apply" button applies the filter to the
table, pressing "clear" removes all the current advanced filters.
81

---

• Search all - If yes selected then an additional search field will be added to the
table view. This field will allow you to search for text across the entire table.
• Require filtering - If yes selected then the table will show no data untill a filter
has been selected.
Navigation
• Rows per page - The default number of records to show in the table
• Show add - If set to 'No' then the 'add' button will not be shown in the table,
regardless of whether the user has ACL rights to add records.
• Show navigation - Shows or hides the table navigation controls. These controls
will only appear when your table has more records that the "Rows per page"
value you defined above
• Show All option - Includes an 'all' option in the navigation drop down that is
used to select the number of records to show per page. Turn this off if your table
contains a large data set as your users may see an out of memory error when
trying to view all the table data.
• Show total - show the total number of records in the table. If a filter is applied
then this shows the total number of filtered records.
• SEF Slug - When using SEF urls this element's data will be included in the SEF
url for each of the table's row's edit/view links.
Layout
• Template - The template to use to render the table. Templates are found in
components/com_fabrik/views/table/tmpl
• Admin template - The template used when rendering the Fabrik table in
administration pages.
• Detailed view link - Add a detailed view link to each of the table's rows.
Clicking on this link shows a uneditable detailed view of the record
• Empty data message - The message to display when the table is empty, this
will also be shown if filters return an empty table
• Detail url - If the "Detailed view link" option is activated you can override the
link's URL here.
• PDF Icon - Show a PDF button on the page which when clicked will generate a
PDF versions of the table
• PDF Template - You can specify an alternative template for the PDF file to use.
This is often advisable as the PDF generator has issues with re-creating wide
table layouts. If nothing selected here then the table's template setting is used.
82

---

Notes
• Note - Add an internal memo for yourself and other administrators describing
the purpose of the table. This note will appear as hover text when you roll over
the table's title in the table list page
Advanced
• Alter existing field types - If no selected then Fabrik will not attempt to alter
the existing structure of the database table's fields when you save elements. If
yes selected then Fabrik will update the fields types to best match the settings
you choose for each element. Its advisable to leave this as "yes" unless you are
confident with managing your database tables' structure from outside of Fabrik
Work in progress
This section is activated by going to components->fabrik->tables->parameters and
activating the "work in progress" option
• Joomfish data translation - if yes selected then when the table is saved a
Joomfish XML file will be created in
administrator/components/com_joomfish/contentelements/{tablename}.xml
This file will then allow you to translate your fabrik tables' content
• Title element - The element to use in Joomfish as the record title. If none
selected then the first element will be used.
83

---