How to configure and adapt Aimeos based shops as developer
Forum rules: Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#4747 by Innonic
09 Oct 2017, 11:19
aimeos wrote:We've updated the product CSV file and the required mapping in the Wiki:
https://aimeos.org/docs/Developers/Controller/Import_products_from_CSV#Default_mapping


Thank you for this information. I updated my mapping and the CSV but I keep getting this error:

Code: Select allNot imported: Array(   
[0] => job_csv_test
[1] => job csv test product
[2] => default
[3] => 1
)

Not imported: Array(
[0] => job_csv_test2
[1] => job csv test 2. product
[2] => select
[3] => 1
)


What is that message supposed to tell me except there's no import?
#4757 by aimeos
10 Oct 2017, 10:16
Your mapping is still not correct for the example file. You need exactly the same mapping as described in the documentation: https://aimeos.org/docs/Developers/Controller/Import_products_from_CSV#Default_mapping

Also, make sure that you've configured https://aimeos.org/docs/Configuration/Core/controller/jobs/product/import/csv/skip-lines with value "1" to skip the first line as stated in the docs because in the example file this is the header line.
#4758 by Innonic
10 Oct 2017, 12:09
I wrote, that I adapted the mapping:

Code: Select allplugin.tx_aimeos {
settings {
controller.jobs.product.import.csv {
location = [...]/fileadmin/import
mapping {
item {
0 = product.code
1 = product.label
2 = product.type
3 = product.status
}
text {
4 = text.type
5 = text.content
6 = text.type
7 = text.content
}
media {
8 = media.url
}
price {
9 = price.currencyid
10 = price.quantity
11 = price.value
12 = price.taxrate
}
attribute {
13 = attribute.code
14 = attribute.type
}
product {
15 = product.code
16 = product.lists.type
}
property {
17 = product.property.value
18 = product.property.type
}
catalog {
19 = catalog.code
20 = catalog.lists.type
}
}
}
}
}


And from the beginning on, I deleted the first line in the CSV, which means I don't have to skip it. This is my complete CSV:

Code: Select all"job_csv_test","job csv test product","default",1,"short","short description","long","long description","[...]/fileadmin/import_img/spice-2546147.jpg","EUR",1,"10.00","20.00","import-test","size",,,"1.50","package-weight","home","promotion"
"job_csv_test2","job csv test 2. product","select",1,"short","short selection description","long","long selection description","[...]/fileadmin/import_img/spice-2546147.jpg","EUR",1,"10.00","20.00",,,"job_csv_test","default","1.50","package-weight",,


So these two reasons are not responsible or did I do something wrong here?
#4760 by aimeos
10 Oct 2017, 20:11
Hm, both look OK and I ran a successful CSV file import with the same mapping and file (dev-master in my case).
Are the "Not imported: Array( ... )" messages the only error in the madmin_log table?
#4763 by Innonic
10 Oct 2017, 21:03
Yes, these are the only error messages after running the import task.

Maybe, as additional info:
I'm using Typo3 6.2.15 and Aimeos 16.10.5.
Could I have a problem with these versions?

I see, there's an update. Do I have to run it? Can I do that without any risk?
#4769 by aimeos
11 Oct 2017, 22:38
TYPO3 6.2.15 is extremely old and there's no support any more for this version. You should upgrade nevertheless to avoid security breaches. For updating Aimeos it depends how much you customized the shop. Version 2017.x has some incompatible changes to 2016.10.5 so your required time may vary.

We've tried to import the two CSV lines using your mapping. It worked, even if the logs contain the two "Not imported" messages ...