List CSV list plugin

Jul 20, 2015
List CSV list plugin
  • This plug-in is run on each imported row when importing data from csv files.

    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.

    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...
daydah and vaughan like this.