Download the PHP package ironshark/typo3-data-importer without Composer
On this page you can find all versions of the php package ironshark/typo3-data-importer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download ironshark/typo3-data-importer
More information about ironshark/typo3-data-importer
Files in ironshark/typo3-data-importer
Download ironshark/typo3-data-importer
More information about ironshark/typo3-data-importer
Files in ironshark/typo3-data-importer
Vendor ironshark
Package typo3-data-importer
Short Description Import data from XLS files into an Typo3 database
License MIT
Homepage https://github.com/ironsharkde/typo3-data-importer
Package typo3-data-importer
Short Description Import data from XLS files into an Typo3 database
License MIT
Homepage https://github.com/ironsharkde/typo3-data-importer
FAQ
After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.
Example:
Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories.
In this case some credentials are needed to access such packages.
Please use the auth.json textarea to insert credentials, if a package is coming from a private repository.
You can look here for more information.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?
Informations about the package typo3-data-importer
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
Via Composer
Usage
Possible options
| Option | Example | Description |
|---|---|---|
| config-file | --config-file="/var/www/typo3conf/localconf.php" | Path to typo3 config file, used for loading database connection info |
| column | 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 imported |
| map | 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 updated |
| default | 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 directory |
| error-directory | --error-directory="/var/www/import/error" | Unsuccessful imported files will be moved to given directory |
| --no-trim | Disables value trimming, all values will be trimmed by default |
Dynamic defaults
| Name | Example | Description |
|---|---|---|
| date | --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
Example
Change log
Please see CHANGELOG for more information what has changed recently.
Contributing
Please see CONDUCT for details.
Security
If you discover any security related issues, please email [email protected] instead of using the issue tracker.
Credits
- Anton Pauli
- All Contributors
License
The MIT License (MIT). Please see License File for more information.
All versions of typo3-data-importer with dependencies
PHP Build Version
Package Version
Requires
php Version
~5.5|~7.0
symfony/console Version ^3.1
doctrine/dbal Version ^2.5
nikic/php-parser Version ^2.1
box/spout Version ^2.5
symfony/console Version ^3.1
doctrine/dbal Version ^2.5
nikic/php-parser Version ^2.1
box/spout Version ^2.5
The package ironshark/typo3-data-importer contains the following files
Loading the files please wait ....