sudhaus7 / xlsimport
(Sudhaus7) XLS Importer
Installs: 25 952
Dependents: 0
Suggesters: 0
Security: 0
Stars: 5
Watchers: 4
Forks: 13
Open Issues: 8
Type:typo3-cms-extension
Requires
- php: ^8.2 || ^8.3 || ^8.4
- ext-json: *
- phpoffice/phpspreadsheet: ^1.29
- typo3/cms-core: ^13.4
Requires (Dev)
- armin/editorconfig-cli: ^1.8 || ^2.0
- codeception/codeception: *
- codeception/phpbuiltinserver: *
- friendsofphp/php-cs-fixer: ^3.46
- friendsoftypo3/tt-address: ^8 || ^9
- helhum/typo3-console: ^7.1 || ^8.1
- phpstan/phpstan: *
- phpstan/phpstan-phpunit: *
- phpunit/phpunit: ^9.6.7 || ^10.1
- saschaegerer/phpstan-typo3: *
- ssch/typo3-rector: *
- typo3/cms-backend: ^13.4
- typo3/cms-composer-installers: v4.0.0-RC1 || ^5.0
- typo3/cms-info: ^13.4
- typo3/cms-install: ^13.4
- typo3/cms-lowlevel: ^13.4
- typo3/cms-setup: ^13.4
- typo3/cms-tstemplate: ^13.4
- typo3/testing-framework: ^7.0 || ^8.0 || ^9.0
Suggests
- dev-master / 7.x-dev
- 6.0.0
- v5.0.5
- v5.0.4
- v5.0.3
- v5.0.2
- v5.0.1
- v5.0.0
- 4.0.3
- 4.0.2
- 4.0.1
- 4.0.0
- 3.0.0
- 2.0.8
- 2.0.7
- 2.0.6
- 2.0.5
- 2.0.4
- 2.0.3
- 2.0.2
- 2.0.1
- 2.0.0
- 1.1.0
- 1.0.7
- 1.0.6
- 1.0.5
- 1.0.4
- 1.0.3
- 1.0.2
- 1.0.1
- dev-task/typo3-xlsimport-38
- dev-task/issue-42
- dev-fix/ensure-type-in-upload
- dev-update-gitattributes
- dev-task/code-streamlining-v13
- dev-documentation-draft
- dev-typo3-xlsimport-58
- dev-typo3-13
- dev-typo3-12
- dev-typo3-xlsimport-47
- dev-typo12
- dev-legacy
This package is auto-updated.
Last update: 2025-09-01 07:25:55 UTC
README
TCA driven import Extension for Spreadsheets
What does it do?
This extension helps to import data from Spreadsheets into TYPO3.
How does it work?
This extension provides a new backend module in which you can use every TCA configured table for importing data from Excel.
When uploading the spreadsheet, you can select the table you want to import data to.
After the upload, you will get a table with the data of the first worksheet. In the header, you can select your field to import to, so you don't have to respect a specific order of columns in your spreadsheet.
Every line can be removed, so you import only the data you want to.
Configuration
The module can be configured by TSconfig. The following snippet has to be added to your Page TS Configuration.
This is the Default Setting:
module.tx_xlsimport {
settings {
allowedTables = tt_address
}
}
which you can either override, or extend in this fashion:
module.tx_xlsimport {
settings {
allowedTables := addItems(my_table_configured_in_TCA)
}
}
Important: you have to specify the TABLENAME of an extension you want to
import to, not the extension name. So for example, if you want to import data for
the news extension (tx_news) you have to add the tablename
tx_news_domain_model_news
. Respectfully, if you want to import tx_news's Tags,
you have to add the tablename tx_news_domain_model_tag
to the list.
The extension in itself does not maintain relations out of the box.
Limitations
When a non-admin user is using the tool, the folder the import is made to has to either be inside a site-setup with defined languages OR the sys_language_id (0,1,2,3) has to be part of the imported data. If these requisits are not met, the tool will report a successful import, while no data has been imported. We hope to address this in a future update.
TODO:
- add more Events/Signalslots for datamanipulation
- add support for multiple sheets
FUTURE: (hit me up if you are willing to help funding)
- support for related data as far as it is modelled in the TCA
- support for import-presets or templates for recurring import tasks
Local development
Local development environment with ddev
This extension repository includes a ddev
instance configuration matching the development
requirements and is setup to provide and easy and simple development experience for people,
which wants to contribute or play around.
That means, thatn on a simple ddev start
the environment is checked and the TYPO3 instance
configured (setup) against ddev with a generic admin user along with creating pages tree for
the backend using typo3/cms-styleguide
and the included generator.
Start
ddev start
Full reset (destroy)
ddev stop -ROU \ && git clean -xdf -e '.idea'
Recreate instance
ddev stop -ROU \ && git clean -xdf -e '.idea' \ && ddev start
To simplify the setup, a generic admin user is created:
type | username | password | |
---|---|---|---|
BE | john-doe | John-Doe-1701D. | john.doe@example.com |
with following urls:
url | command | description |
---|---|---|
https://typo3-xlsimport.ddev.site/typo3/ | ddev launch /typo3/ | Open the TYPO3 backend |
https://typo3-xlsimport.ddev.site/styleguide-demo-1/ | ddev launch /styleguide-demo-1/ | Open the styleguide frontend |
Changes in v5.0
- removed TypoScript support, as TypoScript is frontend related
- use Page TSconfig instead
- Configuration is the same as in TypoScript
- Or configure via Extension Configuration
- Rework for removing Extbase dependencies in Controller
- No changes needed