Contao Exporter Bundle
A module for exporting any contao entity to file., (*1)
, (*2)
Export config preview, (*3)
Features
- export entities and list of entities
- easily add backend modules to your application/extension or use the frontendmodule
- expandable exporter architecture
- included exporter:
- csv
- Excel (xlsx)
- pdf
- Media files (export media files assoziated with an entity as archive(zip))
Csv and Excel export are archived by Spout library.
PDF export is archived by mPDF library. This library comes not as dependency and therefore must be added to your bundle/project dependencies to archvie pdf export functionality., (*4)
Technical instruction
Install
Install with composer:, (*5)
composer require heimrichhannot/contao-exporter-bundle
If you want to use the pdf exporter, add "mpdf/mpdf":"^7.0" to your composer dependencies., (*6)
Backend export
Step 1
Define your global operation in your entity's dca as follows:, (*7)
'global_operations' => [
'export_csv' => \Contao\System::getContainer()->get('huh.exporter.action.backendexport')
->getGlobalOperation('export_csv',$GLOBALS['TL_LANG']['MSC']['export_csv'])
],
Step 2
Add your backend module in your entity's config.php as follows:, (*8)
$GLOBALS['BE_MOD']['mygroup']['name'] = [
'export_csv' => ['huh.exporter.action.backendexport', 'export'],
'tables' => ['tl_name'],
];
Step 3
Create a configuration for your export by using the exporter's backend module (group devtools)., (*9)
Frontend
You can use the included frontend module to add an easy export functionality., (*10)
You can also use frontendedit or formhybrid_list in order to easily create a module for manipulating your entities in the frontend. It already contains a function to export entities after submission!, (*11)
You can also create an custom implementation for your extension:, (*12)
1) Create a configuration for your export by using the exporter's backend module (group devtools).
2) Call export() of huh.exporter.action.frontendexport service in your module:, (*13)
/** @var Symfony\Component\DependencyInjection\ContainerInterface $container */
$container->get('huh.exporter.action.export')->export($config: ExporterModel, $entity: int|string, $fields = []: array);
Developers
Upgrade from exporter module
Please see Upgrade Instructions., (*14)
Events
You can hook into the export with given event. Please check Symfony Event Documentation if you don't know how., (*15)
| Eventname |
Event-ID |
Description |
| Before Export |
huh.exporter.event.before_export |
Fired before start of export. Customize file name and file path. |
| Before Build Query |
huh.exporter.event.before_build_query |
Fired before building and executing the query for collecting list content. |
| Modify Table Header field |
huh.exporter.event.modifyheaderfields |
Modify header field values in tables. |
| Modify Table field value |
huh.exporter.event.modifyfieldvalue |
Fired before writing a table value to the table object (e.g. spreadsheet). |
| Modify Media File Name |
huh.exporter.event.modifymediafilename |
Modify media file before adding to archive (filename and file object). |
Add custom exporter
You can add custom exporter to add additional file types or functionality., (*16)
Your exporter class must implement ExporterInterface and must be registered in the container with the huh_exporter.exporter service tag. We recommend to extend AbstractExporter, because it already has most of the mechanics implemented., (*17)
services:
_defaults:
autowire: true
_instanceof:
HeimrichHannot\ContaoExporterBundle\Exporter\ExporterInterface:
tags: ['huh_exporter.exporter']
lazy: true
Your\Exporter\Class: ~
Custom field selection
You can pass an array of fields to export() of an exporter. Those fields will be used, when exporting an item., (*18)
There are two options:
1) A list of field names. Example: ['firstname','lastname','age']
2) A field list with labels and values. Should be structured as shown:, (*19)
<?php
$fields = [
'field1' => [
'raw' => '', // raw field value
'inputType' => '', // field input type
'value' => '', // formatted field value
'formatted' => '', // formatted field value
'label' => '', // formatted field value
],
// ...
];
Pdf
To use Pdf export, you first need to install mPDF., (*20)
Templates
You can overwrite the pdf output template. Templates are written in Twig and name should start with exporter_pdf_. See exporter_pdf_item_default.html.twig for a working example., (*21)
Fonts
To add custom Pdf font, please see the corresponding chapters in [Utils Bundle docs][3] and the [mPDF Docs][4]. Afterwards you can add the folders in the exporter config., (*22)
Wallogit.com
