calien / xlsexport
Calien - XLS-Exporter
Installs: 3 112
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 3
Forks: 1
Open Issues: 0
Type:typo3-cms-extension
Requires
- php: >=7.4
- ext-pdo: *
- phpoffice/phpspreadsheet: ^1.27
- typo3/cms-core: ^11.5
Requires (Dev)
- armin/editorconfig-cli: ^1.5
- friendsofphp/php-cs-fixer: ^3.0
- friendsoftypo3/tt-address: ^7
- phpstan/phpstan: ^1.3
- phpunit/phpunit: ^9.5
- typo3/cms-backend: ^11.5 || ^12.2
- typo3/cms-fluid-styled-content: ^11.5 || ^12.2
- typo3/cms-install: ^11.5 || ^12.2
- typo3/cms-lowlevel: ^11.5 || ^12.2
- typo3/cms-tstemplate: ^11.5 || ^12.2
- dev-main
- 3.1.8
- 3.1.7
- 3.1.6
- v3.1.5
- v3.1.4
- v3.1.3
- 3.1.2
- 3.1.1
- 3.1.0
- 3.0.5
- 3.0.4
- 3.0.3
- 3.0.2
- 3.0.1
- 3.0.0
- 2.1.2
- 2.1.1
- 2.1.0
- 1.0.3
- 1.0.2
- 1.0.0
- dev-bugfix/export-trait-event-dispatch
- dev-task/prepare-new-release
- dev-task/manipulate-cell-data-event
- dev-task/language-file-update
- dev-export-event
- dev-override-actions
- dev-bugfix/autoloader
This package is auto-updated.
Last update: 2024-10-19 16:54:30 UTC
README
Export complex data to Excel sheets
What does it do?
This extension helps to export complex data from TYPO3 into spreadsheets.
How does it work?
This extension provides a new backend module for exporting complex data into spreadsheets.
In the default setup the table tt_address can be exported out of the box.
Configuration
The module can be configured by TSconfig. The following snippet has to be added to your PageTS configuration.
This is the Default Setting:
module.tx_xlsexport {
settings {
exports {
# name in settings, could be everything
tt_address {
# label shown in bakcned module
label = Addresses
# counter for selected records to export. String with SQL query
check = SELECT count(*) FROM tt_address where pid=%d and hidden=0 and deleted=0
# export query
export (
select uid,first_name,middle_name,last_name,address,building,room,city,zip,region,country,phone,fax,email,www,title,company from tt_address where pid=%d and deleted=0 and hidden=0
)
# list query, currently unused
list (
select uid,first_name,last_name from tt_address where pid=%d and deleted=0 and hidden=0
)
# SQL table name
table = tt_address
# field names from SQL query for export
exportfields {
10 = uid
20 = first_name
30 = middle_name
40 = last_name
50 = address
60 = building
70 = room
80 = city
90 = zip
100 = region
110 = country
120 = phone
130 = fax
140 = email
150 = www
160 = title
170 = company
}
# labels for export field columns, numbers must match with fields in exportfields
exportfieldnames {
10 = lfd. Nummer
20 = Vorname
30 = Mittelname
40 = Nachname
50 = Adresse
60 = Gebäude
70 = Raum
80 = Stadt
90 = PLZ
100 = Region
110 = Land
120 = Telefon
130 = Fax
140 = E-Mail
150 = Web
160 = Titel
170 = Firma
}
}
}
}
}
which you can either override, or extend in this fashion:
module.tx_xlsexport {
settings {
export {
myExport {
# [...]
}
}
}
}
Relations can be done by joins inside the select statements
TODO:
- add Events/Signalslots for datamanipulation
- add support for multiple sheets
- documentation
- localization
FUTURE: (hit me up if you are willing to help funding)
- support TCA for complex data structures
- update backend module to fit TYPO3 styles