Fabrik User Manual 0

The Publishing tab
84

---

• Published - Is the table published or not, has to be published for users to see
the table
• Author - The user who created the table
• Author Alias - An alias to the author
• Created date - The date at which the table was created
• Start Publishing - A start date and time at which to start publishing the table
• Finish Publishing - An end date and time at which to stop publishing the table
RSS
Note Fabrik uses its own feed document type, which is an enhancement of the standard
Joomla feed document.
It is located in libraries/joomla/document/fabrikfeed/
With this Fabrik can create special name spaces, such as the
GEORSS
name space for
including geographical locations within the feed. We also allow for correct enclosures
meaning that you can create pod-casts from your fabrik tables, that are automatically
accessible in iTunes.
• Create RSS feed - If yes selected then Fabrik will create a RSS feed out of the
table's data - See the element's RSS feed options section for further information
on how to structure the content of the feed items.
• Feed title - The element whose data will be used for the feed item's title
• Feed date - The element whose data will be used for the feed item's date
• RSS Limit - Default number of records returned by the feed. This can be
overwritten in the feed url by adding "limit=10"
• RSS Maximum Limit - The maximum number of items that the feed can
output. The RSS limit setting must be lower than the value entered here.
CSV
• CSV import - This selects which user groups can access the CSV import option.
• CSV export - This defines which user groups can access the CSV export option
• Heading format - When you export and import CSV files they should always
have the same heading format. For maximum compatibility within Fabrik choose
"Element full name".
For increased legibility select "Element label"
Search
These options refer to how the data in the Fabrik table is referenced by Joomla's main
search. You must also install the Fabrik search plug-in for the table's data to appear in
Joomla's search results.
• Include in search results - Select 'no' to hide the table's data from the search
results.
• Field - The element whose data will be used as the search results title
• Description - The element whose data will be used as the search results
descriptive text
85

---

Access
The access tab specifies what each user group can or can't do with the data presented in
the table.
• View table - The user level at which users can view the table
• View records - The user level at which users can view the uneditable details
view
• Edit records - The use level at which users can edit the records
• Or use field -Use this setting if the user doesn't have edit rights based on their
group, but you still want them to be able to edit records that 'belong' to
themselves. Select the element whose data will contain the user's id. The user
will then be able to edit any records where the element's data match the user's
id.
• Add records - The access level at which users can add records
• Delete records - The access level at which users can delete records
• Or use field - the same principal as the Edit record's or use field option, except
this applies to deleting records.
• Empty records - The access level at which users can empty the table. This
removes ALL records from the database and resets the primary key to 0 - Enable
this with extreme caution!
Data Tab
When editing an existing table the start of the data tab will look like this:
86

---

Note you can now select the additional options:
• Primary key - the element that should be used as the primary key - this
element's data should be unique for each record.
• Auto increment - set the primary key element to be an auto-incrementing value.
This is the recommended setting
When creating a new table the data tab will appear as below:
87

---

The data tab defines the data that the Fabrik table will use.
• Connection - the Fabrik connection to store the table in
• Create new table - If you want to create a new database table enter its name
here. Its best to user lowercase letters and "_" in the name.
Note: Fabrik does not automatically replace "#_" with Joomla's database prefix
and will strip the "#" from the database name . Trying to create a table called
"#_test" will create one called "_test"
• Link to table - Alternatively you can link to an existing database table. If this
option is selected Fabrik will automatically create the form, group and element's
that correspond with the database table's structure. In addition you can also
88

---

select a MySQL view to use as your Fabrik table's data source, in this case
however, you will not be able to add or edit records.
• Order by - The element to use to order the data by (note you can set ordering
up for individual elements in their table options tab)
• Oder direction - The default order direction
Group by
Splits the table data up into sub tables. Each sub table is "grouped" by the fact that they
contain the same data for the "group by" element.
• Group by - Select the element to group by
• Order by - Select the element to order the group by.
• Template - HTML template that appears before the start of each grouped by
table. Use element placeholders (e,g, {tablename___elementname}) To insert
data form the first grouped by table's row into the template.
• Order direction - Select the group order direction.
Prefilter
Prefilters will filter the table's data before it is displayed. Unlike normal filters these are
not editable by the end user. The can be used to great effect to filter the table's data
base on the logged in user's user group. So registered users see a small subsection of
the records and administrators see all records.
Prefilters can only be applied once the table has been saved.
To start working with pre-filters you need to be editing an existing table. If you are
creating a new table, fill in the other form fields up to this point and press 'apply' to save
and continue editing the form.
To add your first pre-filter press the "add" button.
• Prefilter query - this can contain an SQL query that is run to get a record from
the database. Its data is stored in an object that can be accessible in the pre-
filters value field with the variable name $q
• Field - The element to filter on
• Condition - what matching should be done to the element's value
• Value - the value to match on.
Note: If the prefilter type is set to "eval" then any commnets starting with '//'
will be stripped from the code
• Type - How Fabrik should interpret the data in the value field:
◦ Text - fabrk will do a textual comparison between teh fields data and the
value
89

---