Help

Installation

  1. Install Component - Extensions » Install/Uninstall
  2. Download and Install searchplugin - Extensions » Install/Uninstall
  3. Enable Searchplugin - Extensions » Plug-ins

Usage

Two possible situations

  • The table(s) are already in your joomla database or you use tools like phpmyadmin or myodbc to import the data » continue to setup database.
  • You have a proper .sql,.xml,.xls or .csv-file » future versions will have a "import"-function.

Set up your first Database

  1. Open Joodb - Select Components»JooDatabase in the admin menu to open database configuration.
  2. Create new DB - Click on "new"-button at the toolbar to open Wizzard-Popup.
    1. Step 1 - Enter a name and choose your main database-table.
    2. Step 2 - Select some important fields like the "Title","Unique-ID" and "Main content text".
      Every Database must have these fields defined
    3. Step 3 - There is no step 3. Close the popup.
  3. Add Menuentry - Add a JooDB-Catalog-view to your menus.
  4. Thats it - You are ready! Test your database in frontend.

Customize Templates

Edit the predefined templates by clicking on the database title. Like template-engines (for example Smarty) JooDatabase uses wildcards to replace informations in templates. That makes the output highly customizable. JooDatabsae uses only some simple wildcards.

  • Data wildcards - {joodb FIELDNAME} is replaced by the field content. You can limit the output to a maximum char length by adding |XXX to the fieldname. (For example {joodb longtext|120})
  • Control wildcards - Control wildcards are replaced by page-control elements. Most of them are only valid in a certain context.
    • {joodb pagenav} - Pagination links in catalog-view
    • {joodb pagecount} - Pagination page informations in catalog-view
    • {joodb resultcount} - Total datasets in in catalog-view
    • {joodb nodata} - Error-message if no data was retrieved in catalog-view
    • {joodb limitbox} - Form for changing the amount of entries per page in catalog-view
    • {joodb readon} - A »Read more...« link to the single-view of the current entry
    • {joodb searchbox} - Search field for internal search at the database in catalog-view
    • {joodb ifis|FIELDNAME} -Show the following output till {joodb endif} only if the field is not empty
    • {joodb ifnot|FIELDNAME} -Show the following output till {joodb endif} only if the field is empty
    • {joodb alphabox} - [A-Z] Link-form for selecting the entries by letters in catalog-view
    • {joodb printbutton} - Print page button in single-entry view
  • Loop wildcards - The catalog-view expects two {joodb loop} declarations in the template. The part between these wildcards defines item-row.

Limitations

  • JooDatabase is only for simple Data-Collections and demands. Future versions will be able to handle multiple, linked tables.
  • JooDatabase is for advanced users with basic knowledges about Joomla, MYSQL and Template-engines.