0

yii-importcsv-extension

ImportCSV 用于从 CSV 文件加载位置到数据库。这是 Yii 框架的扩展。（ImportCSV is used for load positions from CSV file to database. This is an extension for Yii Framework.）

Github repo
Main metrics
  • Owner: Ardem/yii-importcsv-extension
  • Platform: BSD, Linux, Mac, Windows
  • License::
  • Category::
  • Topic:
  • Like:
    0
      Compare:

Github stars Tracking Chart

关于

ImportCSV用于从CSV文件到数据库的加载位置。这是Yii Framework的扩展。

导入分三步进行：
  1. 上传文件;
  2. 选择分隔符和表格;
  3. 选择表格中的模式和列。
模块有3种模式：
  1. 全部插入 -- 添加所有行;
  2. 插入新内容 -- 添加新行。旧行保持不变;
  3. 插入 new 并替换旧 -- 添加新行。旧行替换。

以前导入的所有参数都将保存在 upload 文件夹中的特殊 .php 文件中。

要求

Yii 1.1

用法

  1. 复制 /protected/modules下的所有 'importcsv' 文件夹;
  2. 在 /protected/config/main.php中注册此模块 'modules'=>array( ......... 'importcsv'=>array( 'path'=>'upload/importCsv/', //保存csv文件的文件夹的路径和带导入参数的文件） ，......），
  3. 创建一个在“path”中使用的目录。不要忘记为目录'path'设置访问权限;
  4. 该模块可在此处获得：http://yourproject/importcsv。 或者在这里： http://yourproject/index.php?r=importcsv。 或者其他地方:-)这取决于项目中的路径设置;
  5. 注意！ csv文件的第一行必须是包含列名的行。

Main metrics

Overview
Name With OwnerArdem/yii-importcsv-extension
Primary LanguagePHP
Program languagePHP (Language Count: 2)
PlatformBSD, Linux, Mac, Windows
License:
所有者活动
Created At2012-10-27 18:22:00
Pushed At2012-10-29 13:10:23
Last Commit At2012-10-29 17:10:14
Release Count0
用户参与
Stargazers Count7
Watchers Count3
Fork Count15
Commits Count7
Has Issues Enabled
Issues Count5
Issue Open Count3
Pull Requests Count0
Pull Requests Open Count0
Pull Requests Close Count0
项目设置
Has Wiki Enabled
Is Archived
Is Fork
Is Locked
Is Mirror
Is Private

About

ImportCSV is used for load positions from CSV file to database. This is an extension for Yii Framework.

Import occurs in three steps:

  1. Upload file;
  2. Select delimiters and table;
  3. Select mode and columns in table.

Module has 3 modes:

  1. Insert all - Add all rows;
  2. Insert new - Add new rows. Old rows remain unchanged;
  3. Insert new and replace old - Add new rows. Old rows replace.

All parameters from the previous imports will be saved in a special .php file in upload folder.

Requirements

Yii 1.1

Usage

  1. Copy all the 'importcsv' folder under /protected/modules;

  2. Register this module in /protected/config/main.php

    'modules'=>array(
    .........
    'importcsv'=>array(
    'path'=>'upload/importCsv/', // path to folder for saving csv file and file with import params
    ),
    ......
    ),

  3. Create a directory which you use in 'path'. Do not forget to set access permissions for directory 'path';

  4. The module is available here:

http://yourproject/importcsv.

Or here:

http://yourproject/index.php?r=importcsv.

Or somewhere else:-) It depends from path settings in your project;

  1. ATTENTION! The first row of your csv-file must will be a row with column names.