CSVDataSource

Introduction #

In many case, data is stored in CSV for example log file. The CSVDataSource will help us to read data from those file and pipe their data into our processing chain.

Settings #

Nametypedefaultdescription
classstringMust set to '\koolreport\datasources\CSVDataSource'
filePathstringThe full file path to the .csv file.
fieldSeparatorstring","Set the field separator in your csv, some file use "\t" tab as field separator
charsetstring"utf8"Charset of your CSV file
firstRowDatabooleanfalseWhether the first row is data. Normally the first row contain the field name so default value of this property is false.

Example #

<?php
class MyReport extends \koolreport\KoolReport
{
    public function settings()
    {
        return array(
            "dataSources"=>array(
                "csv_example_datasource"=>array(
                    "class"=>'\koolreport\datasources\CSVDataSource',
                    "filePath"=>"/var/storage/sales.csv",
                    "fieldSeparator"=>"\t",
                ),
            )
        );
    }
    public function setup()
    {
        $this->src('csv_example_datasource')
        ->pipe(..)
        ->pipe(...)
        ...
        ->pipe($this->dataStore('salescsv'));
    }
}

Get started with KoolReport

KoolReport will help you to construct good php data report by gathering your data from multiple sources, transforming them into valuable insights, and finally visualizing them in stunning charts and graphs.