add CSV and Excel importer for customers

[enesaktay]

[stevangoldduck]

I think we can add it by ourself following the Development documentation ??

[stevangoldduck]

Available importers show that in my app may upload with Excel, but always show Skip 1. and here is my Excel any clue of this??

[mattagohni]

@stevangoldduck Just guessing after having looked at the code, but maybe the empty values in Birthday could be a problem. The skipped value is only set in the ResourceImporter, if ha row is incomplete. My next guess would be that the FALSE in Subscribed_to_newsletter could be a problem.

Have you tried it with a csv-file yet, maybe it is a xlxs-related problem?

[stevangoldduck]

Okkay i'll try with the CSV

[stevangoldduck]

It still doesn't work in csv and excel,, any clue of this??

[stevangoldduck]

I just wanna close this.

1. Follow the Development guide for Importer
2. Just make sure your file as same as like this picture below for Excel Match the column with your HeaderKey in Generic ResourceProcessor
3. For CSV file format, you can check the examples in the tests/Behat/Resources/fixtures

[stevangoldduck]

@enesaktay

[enesaktay]

Did you try and remove the first row and move everything else up so the table starts at 1-A?

[stevangoldduck]

Yeah i've tried it and still skipped. With the example above, the data can be imported.

[stevangoldduck]

I don't know why it's happening, we can't exactly put the data from A-1 row.