almaudoh / csvtools

Tools for importing, parsing and structuring CSV files and data

CSV Tools

Simple PHP based classes for importing, parsing and structuring CSV files and data.

It is made up of just two files, which contain a parser and then a mapper. The parser class parses the CSV files, which the mapper class allows mapping of the CSV file headers to another set of keys. The mapper class provides allows iteration over the CSV data and array access to each of the columns. The mapper implements \Iterator, \ArrayAccess and \Countable.

Example usages:

filename.csv

NAME,MOBILE,MOBILE2,EMAIL,CITY,COUNTRY,BIRTH_DAY,WORK,NOTES,ACTIVE_ROLES,WANTED_ROLES
Jolly,2348030783839,,[email protected],NoCity,NoCountry,38758,My work,My Notes,,
Nolly,2348038983839,2348030783839,[email protected],NoCity,NoCountry,38758,My work,My Notes,,
,,,,,,,,,,
Polly,2348030783839,2348030783839,[email protected],NoCity,NoCountry,38758,My work,My Notes,,
Solly,2348030783457,2348030783839,[email protected],NoCity,NoCountry,38758,My work,My Notes,,
,,,,,,,,,,
,,,,,,,,,,
Lolly,2347090783839,,[email protected],NoCity,NoCountry,38758,My work,My Notes,,
Wolly,2347090783234,,[email protected],NoCity,NoCountry,38758,My work,My Notes,,
,,,,,,,,,,

$mapping = [
    'name' => 'NAME',
    'phone' => 'MOBILE',
    'phone2' => 'MOBILE2',
    'email' => 'EMAIL',
    'city' => 'CITY',
    'country' => 'COUNTRY',
    'dob' => 'BIRTH_DAY',
    'address' => 'WORK',
    'notes' => 'NOTES',
    'roles' => 'ACTIVE_ROLES',
    'additional_roles' => 'WANTED_ROLES',
];
$csv = (new CsvDataListMapper())
            ->setSourceFile('filename.csv')
            ->setDataMap($mapping);
foreach ($csv as $record) {
    write_to_database($record);
    print($record['name']);
}

prints

Jolly
Nolly

Polly
Solly


Lolly
Wolly

csvtools's Issues

Empty rows should not be parsed

Right now, the CsvParser will include rows that have absolutely no content. There should be an option to skip empty records and not include them in the parsed result.