Set CsvEncoder delimiter in Symfony

Question

I want to decode csv files, but some of them have ";" as delimiters which result in faulty objects. With the following code comma separated csv files are decoded properly:

https://symfony.com/blog/new-in-symfony-3-2-csv-and-yaml-encoders-for-serializer

// instantiation, when using it as a component
use Symfony\Component\Serializer\Serializer;
use Symfony\Component\Serializer\Encoder\CsvEncoder;
use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;

$serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder()]);

// instantiation, when using it inside the Symfony framework
$serializer = $container->get('serializer');

// encoding contents in CSV format
$serializer->encode($data, 'csv');

// decoding CSV contents
$data = $serializer->decode(file_get_contents('data.csv'), 'csv');

I tried setting the context as parameter in the decode function:

$context = array(";", '"', "\\", ",");

$data = $serializer->decode(file_get_contents($file), 'csv', $context);

and as a parameter in the constructor:

$serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder($context)]);

Both tries without any different result.

I got it working this way:

$context = [
    CsvEncoder::DELIMITER_KEY => ';',
    CsvEncoder::ENCLOSURE_KEY => '"',
    CsvEncoder::ESCAPE_CHAR_KEY => '\\',
    CsvEncoder::KEY_SEPARATOR_KEY => ',',
];

$serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder()]);
$serializer = $this->get('serializer');
$data = $serializer->decode(file_get_contents($file), 'csv', $context);

HypeR · Accepted Answer · 2021-06-04 08:39:49Z

9

For Symfony 4, the good syntax is :

$serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder()]);
$datas = $serializer->decode(file_get_contents($csvPath), 'csv', [CsvEncoder::DELIMITER_KEY => ';']);

edited Jun 4, 2021 at 8:39

answered Jul 4, 2019 at 10:50

HypeR

2,21618 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mary2501 · Accepted Answer · 2019-02-07 16:49:16Z

1

Try this:

$context = ['csv_delimiter' => [",", '"', "\\", "."] ];

answered Feb 7, 2019 at 16:49

mary2501

362 bronze badges

1 Comment

v.nivuahc Feb 7 at 9:49

The new version of the encoder now requires multiple context keys, as shown in other answers.

Collectives™ on Stack Overflow

Set CsvEncoder delimiter in Symfony

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related