Typo3 CSV Import: Attribute Text and column double usage

Mathlin Comos · Post by **Mathlin Comos** » 20 Jul 2018, 13:33

Hello,
using: Typo3 8.7.17 and Aimeos 18.7.0
is there a possibility to import attributes including their texts via the Scheduler?
My bet would've been the product import task but it doesn't add the attribute texts.

Something like:

Code: Select all

0=attribute.text.languageid
1=attribute.text.type
2=attribute.text.content

or an external attribute importer would be perfect!

And is there a possibility to use columns of a CSV twice? e.g. I wan't to add two texts to a product: one short description in english and one long description in english.
Is there a possibility to use the column for the same language twice as id like:

Code: Select all

0=text.languageid   #for english
1=text.type  #short description
2=text.content
##Add another Text
0=text.languageid   #use english once again
3=text.type    #this time for a long description
4=text.content

This would make the CSV file much smaller, cleaner and easier to adapt !

Thank you for your help.
Best regards

Post by **aimeos** » 21 Jul 2018, 08:16

Mathlin Comos wrote: is there a possibility to import attributes including their texts via the Scheduler?
or an external attribute importer would be perfect!

There's no import for attribute texts/images/properties yet and yes, an attribute importer would by nice

Mathlin Comos wrote: And is there a possibility to use columns of a CSV twice? e.g. I wan't to add two texts to a product: one short description in english and one long description in english.

Yes, that might work as you expect.

Mathlin Comos · Post by **Mathlin Comos** » 22 Jul 2018, 09:37

Hey,
thank you for your answer once again !

aimeos wrote: Yes, that might work as you expect.

Sadly, this does not work for me...

As soon as I try to map a column twice it imports nothing for this category (here languageid). Neither for the first text or for the second one
e.g.
CSV FILE:

Code: Select all

"ProductCode","ProductLabel","ProductType","ProductStatus","TextType_1","Language","TextContent_1","TextType_2","TextContent_2"
"TestCSVImport","CSVImported","default",1,"short","en","This is short.","long","But this is a long description in english!"

Typoscript mapping

Code: Select all

item {
0 = product.code
1= product.label
2 = product.type
3 = product.status
}
text {
#First text: short description
4= text.type
5= text.languageid
6 = text.content

#long description with the same language as before
7 = text.type
5=text.languageid #use english once again as a language
8 = text.content
}

With this config both texts won't have a language defined.

Mapping the languageid only one time (ligning out the mapping for the long description) will define the language for the first text; but not for the second one.

A solution to this would be including another column with the languageid for the second text, but as I already mentioned, the other way around would be much better and cleaner with a smaller CSV !

Best regards

Post by **aimeos** » 23 Jul 2018, 22:06

Yes, you are right. The column content is removed after being used the first time so it won't be available any more later on.

Help for Aimeos