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

May 20, 2021
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)

    upload_2021-5-20_11-42-22.png
    • Import Row 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 Row PHP code - Code to run before each rows is imported. $formModel->updateFormData('yourtable___yourelement','new data') will modify the data (see example scripts for details). Returning false will skip the row. Will be run in addition to any selected file, so can call functions defined in the file(s)
    • (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.