qplot/importer

为Laravel 4驱动的CSV导入器

dev-master / 0.1.x-dev 2014-07-23 23:19 UTC

This package is not auto-updated.

Last update: 2024-09-24 02:54:26 UTC


README

导入器可以导入CSV文件,并根据配置文件将列映射到数据库字段。

'customers'     => [
    'file'      => 'customers.csv',
    'model'     => 'user',
    'unique'    => 'fullname',
    'mapping'   => [
        'fullname'      => 'Full Name',
        'email'         => 'E-mail',
        'created_at'    => 'Signup Date',
    ],
    'rules'     => [
        'fullname' => 'required',
        'email' => 'required|email|unique:users',
        'username' => 'required',
    ]
],
'kids'          => [
    'file'      => 'appointments.csv',
    'model'     => 'kid',
    'unique'    => 'fullname',
    'mapping'   => [
        'fullname'      => 'Kid Name',
        'parent_id'     => [
            'column'    => 'Full Name',
            'type'      => 'reference',
            'model'     => 'user',
            'foreign_ref'   => 'id',
            'foreign_field' => 'fullname',
            'foreign_data'  => []
        ]
    ],
    'rules'     => []
],

想法是,您只需设置这些设置,然后调用 $importer->import() 即可导入所有内容。

安装

将包添加到 composer.json 文件

"require": {
    "qplot/importer": "dev-master"

然后运行 composer update,

composer update

app/config/app.php 文件中添加提供者

'providers' => array(
    'QPlot\Importer\ImporterServiceProvider'

要更改设置,您首先需要发布配置文件,

php artisan config:publish qplot/importer 

待办事项

  • 创建外观
  • 编写更多文档

变更日志

0.1.0

  • 添加服务提供者