Questions around the TYPO3 integration and plugins as well as Flow and NeosCMS
Forum rules: Always add your TYPO3/Flow, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#2574 by mueironshark
02 Mar 2016, 10:10
I have an csv file from an magento system. Now are there items that belongs to multiple/several catalog categories. How can i set this in the TSconfig for the csv import job?
#2575 by aimeos
02 Mar 2016, 10:56
All categories have to be in one field and at best separated by a newline (that's configurable).
How does the data in the file looks like? Can you give us an example?
#2577 by aimeos
02 Mar 2016, 13:00
mueironshark wrote:The Catalog categories are comma separated


That's OK, you only have to set a comma as separator:
https://aimeos.org/docs/Configuration/Core/controller/common/product/import/csv/separator

Before you import the products, create the categories and use the Magento category IDs as code.
#2582 by mueironshark
04 Mar 2016, 13:18
If i start the import with the valid example csv, get successful message but there are no products imported. Here is the TsConfig:
plugin.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
}
price {
8 = price.value
}
}
}
}
}
What is wrong?
#2583 by aimeos
04 Mar 2016, 13:23
Did you enter the configuration in the TSconfig field of the scheduler task?
Try an absolute URL instead because relative URLs depend on the directory the task is executed from.
#2584 by mueironshark
04 Mar 2016, 14:13
Yes in the field of the scheduler task. And also with absolute path was nothing imported. Then i tried to import from the product tab import. The same result. Success message with see it in the overview and no products imported.
#2585 by aimeos
04 Mar 2016, 14:28
Are there any messages in the logs ("Overview" tab or madmin_log table) regarding product import? There should be at least messages for the start and end of the import, and messages is lines couldn't be imported.

The import button in the "Product" tab is only for importing translated product texts, not the products itself.
#2597 by mueironshark
08 Mar 2016, 12:21
The import works partly now. But what keys and values are needed in the csv file for products being active in the catalog categories / shown in frontend? When look into the categories after the import, they products are correct imported but not shown in fronted. By clicking each product and save it and save the category, these are shown.
#2600 by aimeos
08 Mar 2016, 12:40
You must rebuild the index (via the scheduler task) after product imports to update the frontend (maybe clear the frontend cache as well)