webworksnbg/csv-bundle

webworksCSVBundle

webworksCSVBundle

The webworksCSVBundle helps you to handle csv data and files in your Symfony application. It provides a simple YAML based mapping for doctrine., _(*1)

Requirements

• PHP 7.x
• Symfony 3.x
• See also the composer.json file

Installation

Step 1: Download webworksCSVBundle using composer

Require the bundle with composer:, _(*2)

composer require webworksnbg/csv-bundle "~0.1"

Step 2: Enable the bundle

Enable the bundle in the kernel:, _(*3)

``` php // app/AppKernel.php, <sub>(*4)</sub>

public function registerBundles() { $bundles = array( // ... new webworks\CSVBundle\webworksCSVBundle(), // ... ); }, <sub>(*5)</sub>

### Step 3: Create the mapping YAML file

Create a YAML file with the following content (for example):

``` yaml
# app/config/csv/mapping.yml

import:
# not supported in the current version

export:
    clients: # mapping name 
        class: acme\AppBundle\Entity\Kunde
        mapping:
            name:         firstname, lastname
            street:       street
            city:         zip, city
            email:        email
            company:      company_name

Note: Currently, only one export of the data is possible. The import function will follow shortly, <sub>(*6)</sub>

Step 4: Use the mapping service to write data from your database to csv

You can call the service from container:, <sub>(*7)</sub>

``` php // where ever you have an container, <sub>(*8)</sub>

$csvPath = $this->getContainer()->get('webworks.csv.mapping') ->setMappingName('clients') // mapping name ->setMode('export') ->process() ->getPath(); // Temporary file path!, <sub>(*9)</sub>

### Step 5: Enjoy :)

Now, you can easily write data from your database via doctrine to csv.

## Credits

This bundle has been created by [webworks nürnberg](http://webworks-nuernberg.de) and the community.

## Examples

### Parse CSV file
``` php
use webworks\CSVBundle\Lib\ParseCSV;

$parser = new ParseCSV('example.csv', ';', '"');
$data = $parser->parse();