importer mapper and example csv

[obayesshelton]

Hey,

I am using your exaple csv from - https://aimeos.org/docs/Developers/Cont ... s_from_CSV

I am also using the example mappings and this is how it looks in my config

Code: Select all

'common' => array(
            'product' =>  array(
                'import' =>  array(
                    'csv' =>  array(
                        'mapping' => array(
                            'item' => array(
                                0 => 'product.code', // e.g. unique EAN code
                                1 => 'product.label', // UTF-8 encoded text, also used as product name
                                2 => 'product.type', // type of the product, e.g. "default" or "selection"
                                3 => 'product.status', // enabled (1) or disabled (0)
                            ),
                            'text' => array(
                                4 => 'text.type', // e.g. "short" for short description
                                5 => 'text.content', // UTF-8 encoded text
                                6 => 'text.type', // e.g. "long" for long description
                                7 => 'text.content', // UTF-8 encoded text
                            ),
                            'media' => array(
                                8 => 'media.url', // relative URL of the product image on the server
                            ),
                            'price' => array(
                                9 => 'price.quantity', // the quantity the price is valid from (for block pricing)
                                10 => 'price.value', // price with decimals separated by a dot, no thousand separator
                                11 => 'price.taxrate', // tax rate with decimals separated by a dot
                            ),
                            'attribute' => array(
                                12 => 'attribute.type', // e.g. "size", "length", "width", "color", etc.
                                13 => 'attribute.code', // code of an existing attribute, new ones will be created automatically
                            ),
                            'product' => array(
                                14 => 'product.code', // e.g. EAN code of another product
                                15 => 'product.list.type', // e.g. "suggestion" for suggested product
                            ),
                            'property' => array(
                                16 => 'product.property.value', // arbitrary value for the corresponding type
                                17 => 'product.property.type', // e.g. "package-weight"
                            ),
                            'catalog' => array(
                                18 => 'catalog.code', // e.g. Unique category code
                                19 => 'catalog.list.type', // e.g. "promotion" for top seller products
                            ),
                        ),
                    ),
                ),
            ),
        ),

However when I run

Code: Select all

php artisan aimeos:jobs product/import/csv

I get the following error -

Code: Select all

 Invalid product lines in 3/3

any ideas ?

[aimeos]

I am using your exaple csv from - https://aimeos.org/docs/Developers/Cont ... s_from_CSV
I am also using the example mappings and this is how it looks in my config
I get the following error -

Code: Select all

 Invalid product lines in 3/3

The madmin_log table contains more information about the errors that have occurred. You can see all messages in the first tab of the admin interface.

In this case, the example file references a category (root) that doesn't exist. I've uploaded a new file that fixed the error. When importing you will now see 1 of 3 lines fails as long as you don't configure to skip the first line:
https://aimeos.org/docs/Configuration/C ... skip-lines