1. NOTICE: If you are using Fabrik and update to Joomla 3.10, you will need to update to Fabrik 3.10. And, if you are using Fabrik, do not upgrade to Joomla 4, we do not have a supported version ready for release. More information on a release date coming soon. Also, please note that Fabrik 3.10 will not install on any Joomla sites less than 3.8.
    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.