1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

List CSV list plugin

Feb 29, 2020
List CSV list plugin
  • This plug-in is run on each imported row when importing data from csv files.

    Since ?? it is also run on CSV export.

    It can be useful for massaging data into required formats or performing additional tasks. For example creating a Joomla user for each imported row.

    A useful thread if you are looking to import to import users by CSV: http://fabrikar.com/forums/index.php?threads/usertype-in-list-csv-list-plugin.39585/#post-199394


    Settings (top)

    listcsv-option.png

    • Import PHP File- A file containing the PHP to run , located in
      • Fabrik 2.x: components/com_fabrik/plugins/tablecsv/scripts/
      • Fabrik 3.x plugins/fabrik_list/listcsv/scripts
    • Import PHP code - Alternatively enter the PHP code you want to run in this text area.
    • (to do): for the additional import and export settings see the tooltips

    Example for Fabrik 3.1 or later(top)

    PHP:

    //ensure the file will only be called from within Joomla
    defined('_JEXEC') or die();
     
    // get a reference to the form model - as we are importing line by line, the form model contains the current
    // data that we are going to submit to the table.
    $listModel = $this->getModel();
    $formModel = $listModel->getFormModel();
     
    // the record's data is stored in the array 'formData' - to alter the element 'us_streets___street_desc' to the value 'testing' we use the following line:
    $formModel->formData['us_streets___street_desc'] = "testing";
     

    Example for older versions of Fabrik(top)

    PHP:

    //ensure the file will only be called from within Joomla
    defined('_JEXEC') or die();
     
    // get a reference to the form model - as we are importing line by line, the form model contains the current
    // data that we are going to submit to the table.
    $formModel = $tableModel->getForm();
     
    // the record's data is stored in the array 'formData' - to alter the element 'us_streets___street_desc' to the value 'testing' we use the following line:
    $formModel->formData['us_streets___street_desc'] = "testing";
     
  • Loading...
samani, daydah and vaughan like this.