PHPackages ironshark/typo3-data-importer - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. ironshark/typo3-data-importer ActiveLibrary[Database & ORM](/categories/database) ironshark/typo3-data-importer ============================= Import data from XLS files into an Typo3 database v0.0.1(9y ago)018MITPHPPHP ~5.5|~7.0 Since Jul 26Pushed 9y ago3 watchersCompare [ Source](https://github.com/ironsharkde/typo3-data-importer)[ Packagist](https://packagist.org/packages/ironshark/typo3-data-importer)[ Docs](https://github.com/ironsharkde/typo3-data-importer)[ RSS](/packages/ironshark-typo3-data-importer/feed)WikiDiscussions master Synced today READMEChangelogDependencies (4)Versions (2)Used By (0) typo3-data-importer =================== [](#typo3-data-importer) [![Latest Version on Packagist](https://camo.githubusercontent.com/775270b47928e210825dd8a1c01d8e373740aa785a006aac27f4c236525e4f81/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f69726f6e736861726b2f7479706f332d646174612d696d706f727465722e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/ironshark/typo3-data-importer)[![Software License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](LICENSE.md)[![Total Downloads](https://camo.githubusercontent.com/b0819b029b814a3200d57fb33b5f02e9ce22ad83cfdf12a8e87a924626d27584/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f69726f6e736861726b2f7479706f332d646174612d696d706f727465722e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/ironshark/typo3-data-importer) Import data from XLS files into an Typo3 database. Features - Single file / directory import - Customizeable column name mapping - Dafault values for specified columns - Generate dynamic defalut values like dates / timestamps on the fly - Customizable value transformig - Updates for existing rows - Moving successful / failed files - Transaction rollbacks on errors Install ------- [](#install) Via Composer ``` $ composer require ironshark/typo3-data-importer ``` Usage ----- [](#usage) ``` php vendor/bin/typo3-data-importer import /path/to/file ``` #### Possible options [](#possible-options) OptionExampleDescriptionconfig-file--config-file="/var/www/typo3conf/localconf.php"Path to typo3 config file, used for loading database connection infocolumn**multiple values allowed** --column="last\_name:Name" --column="first\_name:Vorname"Import file column, to db field mapping. Column header name will be used as default database field name, if no mapping configured. Import values from `Name` column (import file) to `last_name` field (db)table--table="fe\_users"Database table name, where data should be importedmap**multiple values allowed** --map="gender:Herr:1" --map="gender:Frau:2" --map="gender:Firma:99"Field specific value mapping, makes possible to transform values before inserting into the database. For database field `gender` value `Herr` will be transformed to `1`unique-field**multiple values allowed** --unique-field="email"Unique field names, to find entities witch could be updateddefault**multiple values allowed** --default="pid:1709" --default="usergroup:4" --default="tstamp:{date:U}"Default values, to insert values not listed in the import file.success-directory--success-directory="/var/www/import/imported"Successful imported files will be moved to given directoryerror-directory--error-directory="/var/www/import/error"Unsuccessful imported files will be moved to given directory--no-trimDisables value trimming, all values will be trimmed by default#### Dynamic defaults [](#dynamic-defaults) NameExampleDescriptiondate--default="tstamp:{date:U}" // 1447057696 --default="tstamp:{date:Y-m-d H:i:s} // 2016-07-26 13:14:51"Generate dynamic default value during populating the databse. Format: --default="db\_field:{date:php date formar}"#### Arguments / Shortcuts / Defaults [](#arguments--shortcuts--defaults) ``` Usage: import [options] [--] Arguments: data-file Path to data file, or directory with files to be imported. Options: -c, --config-file[=CONFIG-FILE] Path typo3 configuration file, db configs fill be loaded from this file. [default: false] --column[=COLUMN] Import file column, to db field mapping in following format db_field:ImportFileColumn (multiple values allowed) -t, --table[=TABLE] Database table name [default: "fe_users"] -m, --map[=MAP] Data mapping, transform imported values before inserting in database: "column:source_value:target_value" e.g "gender:Herr:1" (multiple values allowed) -u, --unique-field[=UNIQUE-FIELD] Unique field names, to find entities witch could be updated (multiple values allowed) -d, --default[=DEFAULT] Default values, to insert some values not listed in the import file. (multiple values allowed) --success-directory[=SUCCESS-DIRECTORY] Successful imported files will be moved to given directory if option is set. --error-directory[=ERROR-DIRECTORY] Unsuccessful imported files will be moved to given directory if option is set. --no-trim Disables trimming of field values. -h, --help Display this help message -q, --quiet Do not output any message -V, --version Display this application version --ansi Force ANSI output --no-ansi Disable ANSI output -n, --no-interaction Do not ask any interactive question -v|vv|vvv, --verbose Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug ``` #### Example [](#example) ``` php vendor/bin/typo3-data-importer import --config-file="/var/www/src/typo3conf/localconf.php" --data-file="import" --column="last_name:Name" --column="first_name:Vorname" --column="gender:Anrede" --column="email:E-Mailadresse" --colu="language:Sprachcode" --column="username:E-Mailadresse" --map="gender:Herr:1" --unique-field="email" --default="pid:1709" --default="usergroup:4" --error-directory="error" --default="tstamp:{date:U}" --default="password:{date:U}" ``` Change log ---------- [](#change-log) Please see [CHANGELOG](CHANGELOG.md) for more information what has changed recently. Contributing ------------ [](#contributing) Please see [CONTRIBUTING](CONTRIBUTING.md) and [CONDUCT](CONDUCT.md) for details. Security -------- [](#security) If you discover any security related issues, please email instead of using the issue tracker. Credits ------- [](#credits) - [Anton Pauli](https://github.com/TUNER88) - [All Contributors](../../contributors) License ------- [](#license) The MIT License (MIT). Please see [License File](LICENSE.md) for more information. ### Health Score 22 — LowBetter than 21% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity6 Limited adoption so far Community8 Small or concentrated contributor base Maturity48 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Unknown Total 1 Last Release 3626d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/21e9b7ea17d986bae709d9ce167df6df4df854f742bc76097139af77e4e9a34b?d=identicon)[TUNER88](/maintainers/TUNER88) --- Top Contributors [![TUNER88](https://avatars.githubusercontent.com/u/1565397?v=4)](https://github.com/TUNER88 "TUNER88 (9 commits)") --- Tags xlsximportironsharktypo3-data-importer ### Embed Badge ![Health badge](/badges/ironshark-typo3-data-importer/health.svg) ``` [![Health](https://phpackages.com/badges/ironshark-typo3-data-importer/health.svg)](https://phpackages.com/packages/ironshark-typo3-data-importer) ``` ### Alternatives [doctrine/orm Object-Relational-Mapper for PHP 10.2k295.3M7.2k](/packages/doctrine-orm)[psalm/plugin-laravel Psalm plugin for Laravel 3345.1M337](/packages/psalm-plugin-laravel)[rector/rector-src Instant Upgrade and Automated Refactoring of any PHP code 136400.8k14](/packages/rector-rector-src)[contao/core-bundle Contao Open Source CMS 1231.6M2.7k](/packages/contao-core-bundle)[psx/sql Generate type-safe PHP classes from your database 1774.5k5](/packages/psx-sql)[code-rhapsodie/dataflow-bundle Data processing framework inspired by PortPHP 1854.1k4](/packages/code-rhapsodie-dataflow-bundle) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)