Migrating from J 2.x / Fabrik 3.0

Upgrade instructions(top)

• disable the Fabrik System Plugin (in Extensions/Plugins)
• update Joomla to 3.5.1 (May 2016)
• not necessary but recommended: rename the existing Fabrik list and form template folders (components/com_fabrik/view/xxx/tmpl to e.g. components/com_fabrik/view/xxx_old/tmpl)

Breaking change:(top)

• Element JavaScript - we now encode the JavaScript events when we save the element. So you will need to edit and save any elements which use JavaScript actions. Tip: to quickly identify which elements have Javascript events, issue the following sql on your database (I use MijoSql from JED)
  SELECT DISTINCT element_id FROM #__fabrik_jsactions ORDER BY element_id ASC
• Form/List JavaScript - Please ensure you use the Fabrik JavaScript template outlined here
• Dates - we have moved to use PHP's date()format options to keep in line with a change in Joomla's date handling. You should edit your date elements and update their formatting options. Alternatively you can try this (use at own risk): (Remark: this will only remove % from date format, but there have to be some more changes, e.g.%H:%M -->H:i etc)
  
  Code (Text):

  <?php
  $db = JFactory::getDBO();
  // Get the site configuration and make a db connection
  $Config = new JConfig();
  $connection = mysql_connect($Config->host,$Config->user, $Config->password);
  mysql_select_db($Config->db,$connection);
  
  /* List all the date type elements */
  $query = $db->getQuery(true);
  $query
      ->select('*')
      ->from('#__fabrik_elements')
      ->where('plugin="date"');
  $db->setQuery($query);
  $elements = $db->loadObjectList();  
  if ( empty($elements) ) {
      echo "There are no date elements";
  } else {
  }
  $properties = array("date_table_format",
          "date_form_format",
          "date_time_format",
          );
  /* Run through each element and update the formats by stripping the % */
  foreach($elements as $element) {
      $data = json_decode($element->params);
      if (!isset($data) || empty($data))
          continue;
      foreach ($properties as $property) {
          if (property_exists($data, $property))
              $data->$property = str_replace("%", "", $data->$property);
      }
      /* renecode the data and write to the db */
      $element->params = json_encode($data);
      $query = $db->getQuery(true);
      $query
          ->update('#__fabrik_elements')
          ->set('params="' . mysql_real_escape_string($element->params,$connection) .'"' )
          ->where('id=' . $element->id);
      $db->setQuery($query);
      $db->execute();
  }
  ?>
• Templates:
  • If you are updating to Joomla3 rename components/com_fabrik/views/list/tmpl to e.g. components/com_fabrik/views/tmpl_old (same with form) so that you won't get tmpl-folders including old F3.0 and new F3.2 templates
  • Fabrik is providing new templates using bootstrap (list: bootstrap, div; form/details: bootstrap, bootstrap_tabs)
  • Details view template are now in their own folder: components/com_fabrik/views/details/tmpl (or tmpl25 see below...)
  • So if you have selected specific templates in either
    • menu items
    • the list/form admin page
    • the module admin page
    • a content plug-in declaration
      Then you should edit and alter the templates
  • If you are still using Joomla 2.5 (with Fabrik3.2 only): the old core Fabrik3.0.x templates can be found in components/com_fabrik/views/xxx/tmpl25

New Requirements(top)

• In Joomla 3.x You MUST use a bootstrap enabled Joomla template (e.g. Protostar coming with Joomla). Fabrik us using Joomla's BS2 (Nov. 2015).
  f you are using a BS3 template see https://github.com/Fabrik/bootstrap3-jlayouts
  If you have a non-bootstrap Joomla template you may try an extentions loading the bootstrap, e.g. http://digitaldisseny.com/en/joomla-extensions/twitter-bootstrap-plugin-joomla(not tested)

Know issues/manually to change (Dec. 2014), please add any others(top)

• Element settings in general: Edit/Add access
• Textarea element: truncation
• Custom PHP code (in scripts or php code fields):
  • _formData --> formData

Example script to update date and element settings via manual scheduled task(top)

Example DB queries(top)