CODEWITHSUNDEEP
sap-commerce-cloudimpex
Jyoshna mr
Jyoshna mr

Reputation: 45

error while importing data through impex

I am trying to insert into ProductFeature table in which product object is used. But unable to do it. How to insert values to the below impex header?

insert_update ProductFeature; product(code,catalogVersion(catalog(id[default=hpeCatalog]),version[default=Staged]))[unique=true];qualifier;value[translator=de.hybris.platform.catalog.jalo.classification.impex.ProductFeatureValueTranslator] 
;J007007;abcd;efgh

Upvotes: 1

Views: 6585

Answers (2)

Free-Minded
Free-Minded

Reputation: 5420

Adding to @dj_frunza answer, since value is Object type, you need to give object type followed by its value both separated by comma (,)

INSERT_UPDATE ProductFeature; product(code,catalogVersion(catalog(id[default=hpeCatalog]),version[default=Staged]))[unique=true];qualifier;value[translator=de.hybris.platform.catalog.jalo.classification.impex.ProductFeatureValueTranslator] ;
;J007007;abcd;String,efgh

Upvotes: 2

dj_frunza
dj_frunza

Reputation: 1593

The value attribute expects two strings instead of one (instead of "efgh" there should be "efgh,ijkl") Also upper case should be used for header(i.e insert_update should be INSERT_UPDATE). I modified the impex and bellow is the version that works for me:

INSERT_UPDATE ProductFeature; product(code,catalogVersion(catalog(id[default=hpeCatalog]),version[default=Staged]))[unique=true];qualifier;value[translator=de.hybris.platform.catalog.jalo.classification.impex.ProductFeatureValueTranslator] ;
;J007007;abcd;efgh,ijkl

Upvotes: 1

Related Questions