Download the PHP package bfatoms/imex without Composer
On this page you can find all versions of the php package bfatoms/imex. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Package imex
Short Description a laravel package for importing and exporting data
License MIT
Informations about the package imex
DISCLAIMER: ALWAYS TEST IN A SEPARATE ENVIRONMENT FIRST
DATA IS PRICELESS
===============
Installation
Publish Config
Import Documentation
Update Or Create
currently the importer uses the updateOrCreate() model function of laravel, the syntax for finding a certain field is
the query string above will produce the query below:
Simplest Import
By default after installation you may import a file immediately by visiting this route
product_prices.csv
product_id | description | price |
---|---|---|
10000001 | Lollipop | $2000 |
10000002 | Ice Cream | $120 |
10000003 | Choco Robot | $100 |
Complex import:
Sometimes a client hands you a list of products with related products for upselling or cross selling, in database you create something like so.
Database Table:
related_products
product_id | related_product_id |
---|---|
10000001 | 10000002 |
and you receive a file that looks like below
related_products.csv
product_code | related_product_code |
---|---|
000-AAA-001 | 000-AAA-002 |
000-AAA-001 | 000-AAA-003 |
000-AAA-003 | 000-AAA-004 |
Problem: you wanted to find all product_code from a table and convert it to its product_id
Solution: Query Params
ex. for above related_products.csv
Explanation:
the product_code will be converted to product_id because of the query string column[product_code][field]=product_id
the related_product_code will be converted to related_product_id because of the query string column[related_product_code][field]=related_product_id
now you satisfy the field names of your table related_products
then in the database the other column data will create a query like so:
the word file_data
is constant meaning, it will get the data from the csv
How to use the Custom Import Service
The import service accepts array for parsing