on 2023 Feb 22 6:25 PM
Hi Gurus, I'm wondering if you could help me out, I've worked on an IMPEX file that works but I'm trying to automate things a little bit more
This IMPEX works
$productCatalog=usProductCatalog
$catalogVersion=catalogversion(catalog(id[default=$productCatalog]),version[default='Staged'])[unique=true,default=$productCatalog:Staged]
$thumbnail=thumbnail(code, $catalogVersion)
$picture=picture(code, $catalogVersion)
$thumbnails=thumbnails(code, $catalogVersion)
$detail=detail(code, $catalogVersion)
$normal=normal(code, $catalogVersion)
$others=others(code, $catalogVersion)
$data_sheet=data_sheet(code, $catalogVersion)
$medias=medias(code, $catalogVersion)
$galleryImages=galleryImages(qualifier, $catalogVersion)
$siteResource=jar:de.hybris.platform.multicountry.setup.SampleDataSystemSetup&/impex/$productCatalog
$media=@media[translator=de.hybris.platform.impex.jalo.media.MediaDataTranslator]
INSERT_UPDATE Media;mime[default='image/jpg'];folder(qualifier)[default='images'];$catalogVersion;mediaFormat(qualifier);code[unique=true];$media
"#% impex.includeExternalDataMedia( ""Media.csv"" , ""UTF-8"", ',', 1 , -3);"
INSERT_UPDATE MediaContainer;qualifier[unique=true];$medias;$catalogVersion
;51300119.jpg;/1200Wx1200H/51300119.jpg
But when I try to create the Media container by using a CSV file instead of creating them by referencing them in the code individually, I get this error message.
WARN line 3 at main script: dumped unresolved line ValueLine[unresolvable:Exception : line 2: cannot create MediaContainer with values ItemAttributeMap[ registry: null, type: <null>, data: {catalogversion=usProductCatalog/Staged(8796093219417), qualifier=null, medias=[]} ] due to [de.hybris.platform.servicelayer.interceptor.impl.MandatoryAttributesValidator@1f5bf5af]:missing values for [qualifier] in model MediaContainerModel (<unsaved>) to create a new MediaContainer, Exception : line 3: cannot create MediaContainer with values ItemAttributeMap[ registry: null, type: <null>, data: {catalogversion=usProductCatalog/Staged(8796093219417), qualifier=null, medias=[]} ] due to [de.hybris.platform.servicelayer.interceptor.impl.MandatoryAttributesValidator@1f5bf5af]:missing values for [qualifier] in model MediaContainerModel (<unsaved>) to create a new MediaContainer,line 3 at main script,null,HeaderDescriptor[line 2 at main script, insert_update, MediaContainer, {}, [qualifier, medias, catalogversion] ],{1=ValueEntry(''=null,unresolved=false,ignore=false), 2=ValueEntry(''=[],unresolved=false,ignore=false), 3=ValueEntry('usProductCatalog:Staged'=usProductCatalog/Staged(8796093219417),unresolved=false,ignore=false), 4=ValueEntry('51300119.jpg'=null,unresolved=null,ignore=false), 5=ValueEntry('/30Wx30H/51300119.jpg,/65Wx65H/51300119.jpg,/96Wx96H/51300119.jpg,/300Wx300H/51300119.jpg,/515Wx515H/51300119.jpg,/1200Wx1200H/51300119.jpg'=null,unresolved=null,ignore=false)}]
This is the code that is not working.
$productCatalog=usProductCatalog
$catalogVersion=catalogversion(catalog(id[default=$productCatalog]),version[default='Staged'])[unique=true,default=$productCatalog:Staged]
$thumbnail=thumbnail(code, $catalogVersion)
$picture=picture(code, $catalogVersion)
$thumbnails=thumbnails(code, $catalogVersion)
$detail=detail(code, $catalogVersion)
$normal=normal(code, $catalogVersion)
$others=others(code, $catalogVersion)
$data_sheet=data_sheet(code, $catalogVersion)
$medias=medias(code, $catalogVersion)
$galleryImages=galleryImages(qualifier, $catalogVersion)
$siteResource=jar:de.hybris.platform.multicountry.setup.SampleDataSystemSetup&/impex/$productCatalog
$media=@media[translator=de.hybris.platform.impex.jalo.media.MediaDataTranslator]
INSERT_UPDATE Media;mime[default='image/jpg'];folder(qualifier)[default='images'];$catalogVersion;mediaFormat(qualifier);code[unique=true];$media
"#% impex.includeExternalDataMedia( ""Media.csv"" , ""UTF-8"", ',', 1 , -3);"
INSERT_UPDATE MediaContainer;qualifier[unique=true];$medias;$catalogVersion
"#% impex.includeExternalDataMedia( ""MediaContainer.csv"" , ""UTF-8"", ',', 1 , -3);"
Thanks!
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.