Fatal error 'Duplicate fields found in header : '

[aminebk]

HI,

When I load CSV file, I got fatal error

( ! ) Fatal error: Uncaught exception 'Csv\Error' with message 'Duplicate fields found in header : ' in C:\wamp\www\site\vendor\mmerian\csv\lib\Csv\Reader.php on line 242
( ! ) Csv\Error: Duplicate fields found in header : in C:\wamp\www\site\vendor\mmerian\csv\lib\Csv\Reader.php on line 242

I can know how to fix that?

Thanks

[mmerian]

Hi !

Could you provide the csv file you are using (after removing any sensitive data), and the code you use to read it ?

[aminebk]

here is csv demo : https://www.dropbox.com/s/yong25nozjvj8s4/copy.csv?dl=0
I changed delemiter to "\t"

also some number in csv are like that : 4,41E+13

the library doesn't convert them to number? for ex it should be 44143100000000

thanks

[mmerian]

Thanks for the data. Could you send me the code you use to read the file ?

The library by default doesn't convert anything, but you can use registerFormatter() to add automatic field formatting

[aminebk]

why it doesn't convert this file? I have used library to send, it was working good:
https://github.com/parsecsv/parsecsv-for-php

regarding code, I used :

 $reader = new Reader($this->path, array(
                        'hasHeader' => true,
                        'inputEncoding' => 'UTF-8',
                        'outputEncoding' => 'UTF-8',
                        'delimiter' => "\t"
                    ));

[mmerian]

OK,

I know what happened. The header of you CSV file has twice the field "Type de Parc" (both are in the 3 last fields). The library can't handle two fields with the same header, because it would not be able to identify them.

I'll investigate why the error message was truncated, because it should have given you the name of the duplicate field.

[aminebk]

ok, there is any option that the library can read this type of file? actually I can't, with other library that I mentioned before, I did :

                    $csv->encoding('UTF-16', 'UTF-8');
                    $csv->delimiter = "\t";

and it worked good

[mmerian]

For your encoding, you can use UTF-16 as input encoding :
$reader = new Reader($this->path, array( 'hasHeader' => true, 'inputEncoding' => 'UTF-16', 'outputEncoding' => 'UTF-8', 'delimiter' => "\t" ));

For your duplicate header fields, a good option would be to rename one of your duplicate fields in the file.

Cheers

[aminebk]

ok, I got it work by renaming column, but maybe you should add a verification, if 2 columns found, you consider only first one.

some fields number have this data in csv : 4,41431E+13

how to convert them in real numbers? in previous librairies excel and csv I used, they convert automatically, but not with your library