Help for integrating the Laravel package
Forum rules: Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#2012 by obayesshelton
31 Oct 2015, 16:31
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 allphp artisan aimeos:jobs product/import/csv


I get the following error -
Code: Select all Invalid product lines in 3/3


any ideas ?
#2013 by aimeos
31 Oct 2015, 17:03
obayesshelton wrote: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/Core/controller/jobs/product/import/csv/skip-lines