Error on Importing ZIP files via Cloud Hot Folder.

[Sagar_Bh]

Hello,

I am trying to upload the zip of products & media (Screenshot attached) from CSV files using Cloud Hot folder import.

I'm facing 2 issues currently :

1. How to trigger Email if the Impex import gets failed. I've already configured it for normal import & it's working fine, but I am unable to do it for ZIP import.

2. While importing media I'm getting the below error:

INFO   | jvm 1    | main    | 2021/09/01 12:09:00.145 | WARN  [impex result worker [cj:00000K28]] [ImpExImportReader] line 3 at main script: dumped unresolved line ValueLine[unresolvable:Can not find file: /Users/sagarbhambhani/Desktop/Hybris/CXCOMM201100P_7-70005693/hybris/data/acceleratorservices/import/master/unzipped/8ca9be0c-47d0-dc29-86fa-ed81d3467457/EC_PRODUCT_CONTENTS_202109/images/logo.jpg,line 3 at main script,Media,HeaderDescriptor[line 2 at main script, insert_update, Media, {}, [mediaFormat, code, mime, catalogversion, folder, realfilename, @media] ],{1=ValueEntry('1200Wx1200H'=8796093251635,unresolved=false,ignore=false), 2=ValueEntry('/1200Wx1200H/logo.jpg'=/1200Wx1200H/logo.jpg,unresolved=false,ignore=false), 3=ValueEntry(''=image/jpg,unresolved=false,ignore=false), 4=ValueEntry(''=Default/Staged(8796093088345),unresolved=false,ignore=false), 5=ValueEntry(''=images(8796093382710),unresolved=false,ignore=false), 6=ValueEntry('logo.jpg'=logo.jpg,unresolved=false,ignore=false), 7=ValueEntry('file:/Users/sagarbhambhani/Desktop/Hybris/CXCOMM201100P_7-70005693/hybris/data/acceleratorservices/import/master/unzipped/8ca9be0c-47d0-dc29-86fa-ed81d3467457/EC_PRODUCT_CONTENTS_202109/images/logo.jpg'=null,unresolved=null,ignore=false)}]

Here is the media converter:

<bean id="customBatchMediaConverter" class="de.hybris.platform.acceleratorservices.dataimport.batch.converter.impl.DefaultImpexConverter">
    <property name="header">
        <value>#{defaultImpexProductHeader}
            # Import media from filesystem
            $importFolder=file:$BASE_SOURCE_DIR$/images
            INSERT_UPDATE Media;mediaFormat(qualifier);code[unique=true];mime[default='image/jpg'];$catalogVersion;folder(qualifier)[default=images];realfilename;@media[translator=de.hybris.platform.impex.jalo.media.MediaDataTranslator]
        </value>
    </property>
    <property name="impexRow">
        <value>;1200Wx1200H;/1200Wx1200H/{+2};;;;{+2};$importFolder/{+2}</value>
    </property>
</bean>

[former_member780778]

Hi @sagar_bh, I'm getting the same error while importing media data, did you solve this issue? Thanks in advance.

[Sagar_Bh]

Hi @msagaseta,
this is how I used configuration:

<int:service-activator input-channel="convertUnzippedCsvFilesHeader"
                       output-channel="executeUnzippedFilesHeader"
                       ref="zipHeaderTransformerTask"
                       method="executeZip"/>

<bean id="zipHeaderTransformerTask"
      class="de.hybris.platform.cloud.hotfolder.dataimport.batch.zip.task.ZipHeaderTransformerTask"
      parent="XTransformerTask"/>

<bean id="cloudHotFolderZipMediaConverterMapping"
      class="de.hybris.platform.acceleratorservices.dataimport.batch.converter.mapping.impl.DefaultConverterMapping"
      p:mapping="EC_PRODUCT_CONTENTS"
      p:converter-ref="XBatchMediaConverter"/>

<bean id="cloudHotFolderZipMediaContainerConverterMapping"
      class="de.hybris.platform.acceleratorservices.dataimport.batch.converter.mapping.impl.DefaultConverterMapping"
      p:mapping="EC_PRODUCT_CONTENTS"
      p:converter-ref="XBatchMediaContainerConverter"/>

<bean id="XBatchMediaConverter" class="de.hybris.platform.acceleratorservices.dataimport.batch.converter.impl.DefaultImpexConverter">
<property name="header">
<value>#{defaultImpexProductHeader}
# Import media from filesystem
$importFolder=file:$BASE_SOURCE_DIR$
INSERT_UPDATE Media;mediaFormat(qualifier);code[unique=true];mime[default='image/jpg'];$catalogVersion;folder(qualifier)[default=images];realfilename;@media[translator=de.hybris.platform.impex.jalo.media.MediaDataTranslator]
</value>
</property>
<property name="impexRow">
<value>;;{+0};;;;{+35};$importFolder/{+35}</value>
</property>
</bean>

<bean id="XBatchMediaContainerConverter" class="de.hybris.platform.acceleratorservices.dataimport.batch.converter.impl.DefaultImpexConverter">
<property name="header">
<value>#{defaultImpexProductHeader}
# Import media container
INSERT_UPDATE MediaContainer;qualifier[unique=true];medias(code, $catalogVersion);$catalogVersion
</value>
</property>
<property name="impexRow">
<value>;{0};{0}</value>
</property>
</bean>


<bean id="XConverter" class="de.hybris.platform.acceleratorservices.dataimport.batch.converter.impl.DefaultImpexConverter">
<property name="header">
<value>
#{productImpexHeader}
INSERT_UPDATE Product;$approved;$catalogVersion;code[unique=true];...;.;.;.;. </value>
</property>
<property name="impexRow">
<value>
;;;{+0};{1};{2};{3};{4};{5};{6};{7};{8};{9};{10};{11};{12};{15};{16};{17};{18};{19};{20};{21};{22};{23};{24};{25};{28};{29};{30};{31};{32};{33};{0};{36};{37};{38};{39};{40};{41};{42};{43};{44};{45};{46};{47}
</value>
</property>
<property name="type" value="Product"/>
</bean>