TableCsvImportExport by Adrian Jones

Admin and front-end importing and exporting of CSV formatted content for Profields Table fields.

Table CSV Import / Export

Processwire module for admin and front-end importing and exporting of CSV formatted content for Profields Table fields.

https://processwire.com/talk/topic/7905-profields-table-csv-importer-exporter/

Access to the admin import/export for non-superusers is controlled by two automatically created permissions: table-csv-import and table-csv-export

Another permission (table-csv-import-overwrite) allows you to control access to the overwrite option when importing.

The overwrite option is also controlled at the field level. Go to the table field's Input tab and check the new "Allow overwrite option" if you want this enabled at all for the specific field.

Front-end export of a table field to CSV can be achieved with the exportTableCsv() method:

<?php
// export as CSV if csv_export=1 is in url
if($input->get->csv_export==1){
	$modules->get('ProcessTableCsvExport'); // load module
	$options = array(
        'delimiter' => ',',
        'enclosure' => '"',
        'extension' => 'csv',
        'multipleValuesSeparator' => '|',
        'namesFirstRow' => true,
        'columns' => array('field1','field2'), // columns to export can be index starting at 1, or column names
        'selector' => 'field1%=foo, field2%=bar'
    );
	$p->exportTableCsv('field_name', $options);
}
// display content of template with link to same page with appended csv_export=1
else{
   include("./head.inc");

   echo $page->field_name->render(); //render table - not necessary for export
   echo "<a href='./?csv_export=1'>Export Table as CSV</a>"; //link to initiate export

   include("./foot.inc");
}

Front-end import can be achieved with the importTableCsv() method:

$modules->get('TableCsvImportExport'); // load module
$options = array(
    'delimiter' => ',',
    'enclosure' => '"',
    'convertDecimals' => false,
    'multipleValuesSeparator' => '|',
    'namesFirstRow' => false
);
$page->importTableCsv('field_name', $csvData, $options);
Support forum:

https://processwire.com/talk/topic/7905-profields-table-csv-importer-exporter/

License


This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

(See included LICENSE file for full license text.)

Install and use modules at your own risk. Always have a site and database backup before installing new modules.

Twitter updates

  • ProcessWire 3.0.192 (dev branch) contains 11 issue fixes and 5 pull requests, over 20 commits— More
    7 January 2022
  • ProcessWire 3.0.191 core updates: updates to the installer and the profile exporter module— More
    24 December 2021
  • This week ProcessWire went on a diet, trimming the core size from 15.5 MB down to 7.5 MB by moving optional site profiles into their own GitHub repos— More
    17 December 2021

Latest news

  • ProcessWire Weekly #402
    In the 402nd issue of ProcessWire Weekly we'll check out ProcessWire 3.0.193, highlight recent ProcessWire projects and resources, and more. Read on!
    Weekly.pw / 22 January 2022
  • ProcessWire 3.0.190 core updates
    ProcessWire 3.0.190 has 15 commits relative to 3.0.189 and contains a mixture of issue resolutions and feature additions. This post covers them all, in addition to updates for the PageAutosave and ProFields Table modules.
    Blog / 3 December 2021
  • Subscribe to weekly ProcessWire news

“We chose ProcessWire because of its excellent architecture, modular extensibility and the internal API. The CMS offers the necessary flexibility and performance for such a complex website like superbude.de. ProcessWire offers options that are only available for larger systems, such as Drupal, and allows a much slimmer development process.” —xport communication GmbH