Download the PHP package popov/php-importer without Composer
On this page you can find all versions of the php package popov/php-importer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
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 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.
Informations about the package php-importer
PHP Importer
Universal importer for different table formats like excel or csv
Installation
Install it with composer
Supported drivers
- LibXl (commercial)
- Excel
- Soap
- Csv (not implemented yet)
Requirements
Importer use INSERT ... ON DUPLICATE KEY UPDATE Syntax in background for reduce number of queries to database.
You should have only one unique field in your table otherwise you can get undesirable result.
If you need to have several unique fields you should group them with UNIQUE Constraint
such as UNIQUE (field_1, field_2, ...)
Usage
Example import File
| Nominal | Serial |
|---|---|
| 3% | 3002345 |
| 3% | 3002346 |
| 3% | 3002346 |
| 5% | 5002344 |
| 5% | 5002345 |
Standalone
Advanced Usage
Most popular PHP frameworks implement IoC pattern and they also implement standard interface Interop\Container\ContainerInterface.
This library support this functionality. You can pass your own IoC to Factory and be happy with creating objects.
Configuration
Options marked with * are required.
driver *
Driver is handler for data from source.
You can use one of the registered drivers or create your own.
driver_options
You can pass any custom options to driver, there is no limit for it.
Excel options
path
Path to file which should be handled.
sheet: name
Name of the sheet which should be handled. By default first sheet is taken.
sheet: skip
Skip first N rows in file. By default first row is taken.
fields
Mapping fields from one resource to new (MySQL, CSV, Excel)
The simples mapping can be written as:
Fields filtration and preparation can be grouped in chain
__filter - reserved name for filtration
__prepare - reserved name for preparation
All reserved options begin with "__" (double underscore).
__table
Required. A table where to save imported data.
__codename
Required. Shortcut unique name for config related to table.
__identifier
Unique field name for avoid duplicated items. Identifier can be as one field such as multiple fields.
__ignore
Fields which should be ignored in save operation. These fields can be used in data filtration.
__exclude
Bool. Exclude table from save operation. All fields can be used in data filtration.
__exclude
This option is actual if set up minimum two group of fields in config. For example, if you have customer and review info, you put customer info in first group of fields and review info in second group of fields. When first group will be saved the ID will be marked in memory and second group can use this value.
Options
mode
save - save new and excited data
update - only update excited data
Integration with ZF2
There's a module for that!
