CSV Import product ctime / create date

[aimeos]

If you have dev-master installed, you can use "product.ctime" for mapping.

[yacms]

i have installed "18.7.3-pre1"


Typoscript for scheduler

Code: Select all

plugin.tx_aimeos {
    settings {
        controller.jobs.product.import.csv.container.type = Directory
        controller.common.product.import.csv.separator = ,
        controller.jobs.product.import.csv.skip-lines = 1
        controller.jobs.product.import.csv {
            location = /var/www/vhosts/***.com/staging.***.com/typo3temp/aimeos/
            mapping {
            item {
               0 = product.code
               1 = product.label
               2 = product.type
               3 = product.status
               32 = product.ctime
            }
            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.list.type
            }
            property {
               17 = product.property.value
               18 = product.property.type

               #Seitenzahlen
               19 = product.property.value
               20 = product.property.type

               #booksize
               23 = product.property.value
               24 = product.property.type

               #binding
               25 = product.property.value
               26 = product.property.type

               #no_of_pictures
               27 = product.property.value
               28 = product.property.type

               # reviews
               29 = product.property.value
               30 = product.property.type
            }
            catalog {
               21 = catalog.code
               22 = catalog.list.type
            }
            }
        }
   }
}

Sample rows of my freaking huge CSV

Code: Select all

"item code","item label","item type","item status","text type","text content","text type","text content","media url","price currencyid","price quantity","price value","price tax rate","attribute code","attribute type","subproduct code","product list type","property value","property type","property value","property type","catalog code","catalog list type","property value","property type","property value","property type","property value","property type","property value","property type","crdate","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""

"5","BOOKTITLE","default","1","short","CONTENT","IMAGE.jpg","EUR","1","14.95","19","","size","","default","3-000000-74-0","isbn","257","number_of_pages","2,6","","21 x 13,5","booksize","Paperback","binding","","no_of_pictures","12,13,14,15,16,17,98,256,257,258,413,414,415,457,848,876,1089","reviews","2006-02-16 09:26:21","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""

[aimeos]

It doesn't work with that version yet.