Hot folder csv file is picking but values are not inserted into db

[former_member624336]

Hi All, csv file is picking successfully and file got archive but values are not inserted in to DB.

[arvind-kumar_avinash · Accepted solution]

A couple of points for your ImpexConverter bean:

a. You do not have to mention the productCatalog inside ImpexConverter bean. You have already done it using the following configuration:

 <bean id="EBikeHeaderSetupTask" class="de.hybris.platform.acceleratorservices.dataimport.batch.task.HeaderSetupTask">
     <property name="catalog" value="powertoolsProductCatalog" />
     <property name="net" value="false" />
     <property name="storeBaseDirectory" ref="baseDirectoryEBikes" />
 </bean>

b. It should be configured as

 <bean id="batchEbikeProductConverter" class="de.hybris.platform.acceleratorservices.dataimport.batch.converter.impl.DefaultImpexConverter">
     <property name="header">
         <value>#{defaultImpexProductHeader}
             INSERT_UPDATE EbikeProduct;code[unique=true];name[lang=$lang];description[lang=$lang];catalogversion(catalog(id),version)
         </value>
     </property>
     <property name="impexRow">
         <value>;{+0};{1};{2};{3};$catalog:Staged</value>
     </property>
     <property name="rowFilter">
         <bean class="de.hybris.platform.acceleratorservices.dataimport.batch.converter.impl.DefaultImpexRowFilter">
             <property name="expression" value="row[1]"/>
         </bean>
     </property>
     <property name="type" value="EbikeProduct"/>
 </bean>

Note: The property, rowFilter is optional and you can remove it if you do not need it. You can learn more about it at https://wiki.hybris.com/display/accdoc/Data+Importing#DataImporting-ConverterConfiguration and also find some good examples in hot-folder-store-apparel-spring.xml.

[former_member624336]