fbk/csvmapper

CSV parser with callbacks on fields

CSVMapper

Official repo stats, _(*1)

, _(*2)

CSVMapper is a PHP library which parses CSV files., _(*3)

It allows to map the file to an array by defining some file configurations and each (wanted) columns properties., _(*4)

File Settings

CSVMapper needs to now where the file is located and which is the columns separator., _(*5)

It il also possible to specify how many columns are expected so that it aborts if the number of columns doesn't match., _(*6)

    $setting = new SettingManager();
    $config->set_setting('folder','./tests');
    $config->set_setting('filename','myfile.csv');
    $config->set_setting('separator',';');
    $config->set_setting('columns_allowed',3);

Mappings

CSVMapper extracts only the columns which are defined with mappings. With a mapping it is possible to specify the position of the column, which function to apply to the value and how to test the value., _(*7)

    $mapping = new MappingManager();
    // retrieve column number 1 (counting from 0) and label it as year
    $mapping->set_mapping("year", array('key'=>1,'fn'=>FALSE,'test'=>FALSE));
    // retrieve column number 2 (counting from 0) and label it as temperature, apply to each value the function 'return floatval($input);'
    $mapping->set_mapping("temperature", array('key'=>2, 'fn'=>create_function('$input','return floatval($input);'),'test'=>FALSE));