csanquer/colibri-csv

Lightweight and performant CSV reader and writer library

CSanquer ColibriCSV

LOOKING FOR NEW MAINTAINER, _(*1)

, _(*2)

, _(*3)

A lightweight, simple and performant CSV Reader/Writer PHP 5.4+ Library, inspired from Python CSV Module. Fully Tested, very memory efficient and able to parse/write CSV files that weigh over 100 Mb., _(*4)

This is a fork of Spyrit LightCSV library, I have developed previously in this company., _(*5)

Installation

• get composer http://getcomposer.org/ and install dependencies

curl -s https://getcomposer.org/installer | php

• add "https://packagist.org/packages/csanquer/colibri-csv" package to your composer.json file require section

php composer.phar require csanquer/colibri-csv:1.0.*

• install dependencies

php composer.phar install

• include vendor/autoload.php

How To

Read

Instanciate a new CSVReader with the following CSV parameters:, _(*6)

• field delimiter (default for Excel = ; )
• field enclosure character (default for Excel = " )
• character encoding = (default for Excel = CP1252 )
• end of line character (default for Excel = "\r\n" )
• escape character (default for Excel = "\" )
• first_row_header : (default for excel = false) use the first CSV row as header
• UTF8 BOM (default false) force removing BOM
• transliteration (default for Excel = null ) available options : 'translit', 'ignore', null
• force encoding detection (default for Excel = false )
• skip empty lines (default for Excel = false ) lines which all values are empty
• trim (default = false for Excel) trim all values

use CSanquer\ColibriCsv\CsvReader;

// create the reader
$reader = new CsvReader(array(
    'delimiter' => ';', 
    'enclosure' => '"', 
    'encoding' => 'CP1252', 
    'eol' => "\r\n", 
    'escape' => "\\", 
    'first_row_header' => false,
    'bom' => false, 
    'translit' => 'translit',
    'force_encoding_detect' => false,
    'skip_empty' => false,
    'trim' => false,
));

//Open the csv file to read
$reader->open('test.csv');

// or open an existing stream resource
$stream = fopen('test.csv', 'rb');
$reader->open($stream);

// or read an existing CSV string by creating a temporary in-memory file stream (not recommended for large CSV)
$reader->createTempStream('lastname,firstname,age
Martin,Durand,"28"
Alain,Richard,"36"
');

//Read each row
foreach ($reader as $row) {
    // do what you want with the current row array : $row
}

// or get all rows in one call (not recommended for large CSV)
$csvRows = $reader->getRows();

//close the csv file stream
$reader->close();

Write

Instanciate a new CSVWriter with the following CSV parameters:, _(*7)

• field delimiter (default for Excel = ; )
• field enclosure character (default for Excel = " )
• character encoding = (default for Excel = CP1252 )
• end of line character (default for Excel = "\r\n" )
• escape character (default for Excel = "\" )
• first_row_header : (default for excel = false) use the PHP keys as CSV headers and write a first row with them
• enclosing_mode (default = 'minimal'), possible values :
  • all : always enclose string
  • minimal : enclose string only if the delimiter, enclosure or line ending character is present
  • nonumeric : enclose string only if the value is non numeric (other character than digits and dot)
• escape_double (default = true) if true double the enclosure to escape it, else escape it with escape character
• UTF8 BOM (default false) force writing BOM if encoding is UTF-8
• transliteration (default for Excel = null ) available options : 'translit', 'ignore', null
• trim (default = false for Excel) trim all values

use CSanquer\ColibriCsv\CsvWriter;

// create the writer
$writer = new CsvWriter(array(
    'delimiter' => ';', 
    'enclosure' => '"', 
    'encoding' => 'CP1252', 
    'enclosing_mode' => 'minimal',
    'escape_double' => true,
    'eol' => "\r\n", 
    'escape' => "\\", 
    'bom' => false, 
    'translit' => 'translit',
    'first_row_header' => false,
    'trim' => false,
));

//Open the csv file to write
$writer->open('test.csv');

// or open an existing stream resource
$stream = fopen('test.csv', 'wb');
$writer->open($stream);

// or create an empty temporary in-memory file stream to write in and get CSV text later 
// (not recommended for large CSV file)
$writer->createTempStream();

//Write a row
$writer->writeRow(array('a', 'b', 'c'));

//Write multiple rows at the same time
$writer->writeRows(array(
    array('d', 'e', 'f'),
    array('g', 'h', 'i'),
    array('j', 'k', 'l'),
));

// get the CSV Text as plain string
$writer->getFileContent();

//close the csv file
$writer->close();

Configuration : Dialect class

Instead of giving directly an array to the CsvReader or CsvWriter constructor, you can create a Dialect object, use setter methods to change parameters and pass it to the CsvReader (or CsvWriter) :, _(*8)

Be careful, the options 'force_encoding_detect', 'skip_empty' and 'trim' decrease significantly the performances, _(*9)

use CSanquer\ColibriCsv\Dialect;
use CSanquer\ColibriCsv\CsvReader;
use CSanquer\ColibriCsv\CsvWriter;

// create a dialect with some CSV parameters
$dialect = new Dialect(array(
    'delimiter' => ';', 
    'enclosure' => '"', 
    'enclosing_mode' => 'minimal',
    'encoding' => 'CP1252', 
    'eol' => "\r\n", 
    'escape' => "\\", 
    'escape_double' => true,
    'bom' => false, 
    'translit' => 'translit',
    'force_encoding_detect' => false,
    'skip_empty' => false,
    'trim' => false,
);

// change a parameter
$dialect->setLineEndings("\n");

// create the reader
$reader = new CsvReader($dialect);

//or a writer
$writer = new CsvWriter($dialect);

Requirements

• PHP >= 5.4
• extension mbstring

Suggested :, _(*10)

• extension iconv

Tests

run unit tests with phpunit :, _(*11)

phpunit

run benchmark test :, _(*12)

php tests/benchmark_test.php

Licensing

This library is a Fork of Spyrit LightCSV, _(*13)

License LGPL 3, _(*14)

• Copyright (C) 2012-2013 Spyrit Systeme (Spyrit LightCSV)
• Copyright (C) 2014 Charles Sanquer

This file is part of ColibriCSV., _(*15)

ColibriCSV is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version., _(*16)

ColibriCSV is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details., _(*17)

You should have received a copy of the GNU Lesser General Public License along with ColibriCSV. If not, see http://www.gnu.org/licenses/., _(*18)