Generating/Parsing csv files with craur

In the previous blog post we looked at parsing/generating xml with craur.

Today we'll check, how you can parse csv (even xlsx) files with craur. Craur is a json/xml/csv/xlsx to json/xml/csv/xlsx conversion library.

Usually you might use fgetcsv or some custom code to parse csv, but with craur we have a a simple api for any of those formats, with a consistent api when it comes to throwing exception.

A sample csv-file, looks like this:

Book Name;Book Year;Author Name;Author Age;Book Category
My Book;2012;Hans;32;Fantasy
My second Book;2010;Erwin;10;Comedy

Generating this csv, works with craur like this:


$craur = new \Craur(array(
    'book' => array(
            'name' => 'My Book',
            'year' => 2012,
            'author' => 'Paul',
            'age' => '32',
            'genre' => 'Fantasy'
            'name' => 'My second Book',
            'year' => '2010',
            'author' => 'Erwin',
            'age' => '10',
            'category' => 'Comedy'

$craur->saveToCsvFile('books.csv', array(

If you want to parse this csv file, you can do this easily with craur in the following way:


$craur = Craur::createFromCsvFile('books.csv', array(

# 2

foreach ($craur->get('book[]') as $book)
# My Book
# My second Book

The brackets [] in book[] indicate, that you are expecting an array here. Craur will handle the case, when your csv file is empty and if no element is found, or if there is only one element. In all cases craur will return an array, if the key is suffixed with []. If the key is not suffixed with [], craur will only return the first value.

That's it!

Bonus: With craur it's even possible, to load multi dimension fields in csv/xlsx files. An example may be found in the craur tests and is called csvinputwithmultiplecolumnsandsamemappingtest.php.

In craur, csv, open source, php by
@ 09 Dec 2013, Comments at Reddit & Hackernews

Give something back

Were my blog posts useful to you? If you want to give back, support one of these charities, too!

Report hate in social media Campact e.V. With our technology and your help, we protect the oceans from plastic waste. Gesellschaft fur Freiheitsrechte e. V. The civil eye in the mediterranean

Recent Dev-Articles

Read recently

Recent Files