Questions concerning csv-imports
Posted: 04 Feb 2018, 08:23
Dear Aimeos-team,
I am using: Aimeos-Typo3 (18.1.0 with T3 8.7.9), Ubuntu 16 (docker) with PHP 7.2.1
I am really enthusiastic about aimeos! We used Magento 1 before - and we are really not sure to switch to Magento 2 - we are therefore checking alternatives (and as we use Typo3 as CMS .. aimeos could be first choice!!)
I played around espacially with the imports and got the following questions:
1) All import for one processor automatically delete all existing values for the article / processor, right?
Thus it is not possible to import a file like <<I want to import several information for one article in different lines - not in different columns)
"product.code","product.type","attribute.type","attribute.code","attribute.label"
"1051WB17", "default","color","mehrfarbig","mehrfarbig"
"1051WB17", "default","collection","White Energy","White Energy"
"1051WB17", "default","warengruppe","Bordüre","Bordüre"
In this case only the last entry is taken. When I create a new file (i.e. with only color) - all other attributes for that article are deleted first. .. This means I do have to put all information to one article in one line ... ??
-----------------
2.) Is it possible to define "default" values in the TSConfig of Typo3? i.e:
in the example below "product.type" is always "default"; "text.type" is always "short"
mapping{
item{
0 = product.code
1 = product.label
2 = product.type
}
text{
3 = text.type
4 = text.content
}
}
Maybe something like:
mapping{
item{
0 = product.code
1 = product.label
"default" = product.type
}
text{
"short" = text.type
2 = text.content
}
}
In this case the csv-file needs only 3 columns (and easier to create)
------------------------
3.) It would be fantastic if will be possible to import categories as well.
That also bring aimeos nearer to our current export logic on which our content feed is based.
Thanks so much!
PAscal
I am using: Aimeos-Typo3 (18.1.0 with T3 8.7.9), Ubuntu 16 (docker) with PHP 7.2.1
I am really enthusiastic about aimeos! We used Magento 1 before - and we are really not sure to switch to Magento 2 - we are therefore checking alternatives (and as we use Typo3 as CMS .. aimeos could be first choice!!)
I played around espacially with the imports and got the following questions:
1) All import for one processor automatically delete all existing values for the article / processor, right?
Thus it is not possible to import a file like <<I want to import several information for one article in different lines - not in different columns)
"product.code","product.type","attribute.type","attribute.code","attribute.label"
"1051WB17", "default","color","mehrfarbig","mehrfarbig"
"1051WB17", "default","collection","White Energy","White Energy"
"1051WB17", "default","warengruppe","Bordüre","Bordüre"
In this case only the last entry is taken. When I create a new file (i.e. with only color) - all other attributes for that article are deleted first. .. This means I do have to put all information to one article in one line ... ??
-----------------
2.) Is it possible to define "default" values in the TSConfig of Typo3? i.e:
in the example below "product.type" is always "default"; "text.type" is always "short"
mapping{
item{
0 = product.code
1 = product.label
2 = product.type
}
text{
3 = text.type
4 = text.content
}
}
Maybe something like:
mapping{
item{
0 = product.code
1 = product.label
"default" = product.type
}
text{
"short" = text.type
2 = text.content
}
}
In this case the csv-file needs only 3 columns (and easier to create)
------------------------
3.) It would be fantastic if will be possible to import categories as well.
That also bring aimeos nearer to our current export logic on which our content feed is based.
Thanks so much!
PAscal