ProdutFeature Import via impex

[Former Member]

Not able to find the way to provide the default substitution for classificationattribureassignmentvalue for product feature.

Impex like below:

 $P_classificationCataloVersion = catalogVersion(catalog(id[default = shopClassification]), version[default = '1.0'])
 $P_classificationSystemVersion = systemVersion(catalog(id[default = shopClassification]), version[default = '1.0'])
 $P_productCV = catalogversion(catalog(id[default = shopProductCatalog]), version[default = 'Staged'])[unique = true, default = shopProductCatalog:Staged]
 $classP = classificationClass(code, $P_classificationCataloVersion)
 INSERT_UPDATE ProductFeature;product(code,$P_productCV)[unique=true];classificationAttributeAssignment(classificationAttribute(code,$P_classificationSystemVersion),$P_classificationSystemVersion,$classP)[unique=true];featurePosition;language(isocode)[unique=true];qualifier;unit(code,$P_classificationSystemVersion);valueDetails;valuePosition[unique=true];valueType;value[translator=de.hybris.platform.catalog.jalo.classification.impex.ProductFeatureValueTranslator];description
 ;3755205;Input power, 6738,4593;16;en;qualifier;mm;;0;1;string,13$P_classificationCataloVersion = catalogVersion(catalog(id[default = shopClassification]), version[default = '1.0'])
 $P_classificationSystemVersion = systemVersion(catalog(id[default = shopClassification]), version[default = '1.0'])
 $P_productCV = catalogversion(catalog(id[default = shopProductCatalog]), version[default = 'Staged'])[unique = true, default = shopProductCatalog:Staged]
 $classP = classificationClass(code, $P_classificationCataloVersion)
 INSERT_UPDATE ProductFeature;product(code,$P_productCV)[unique=true];classificationAttributeAssignment(classificationAttribute(code,$P_classificationSystemVersion),$P_classificationSystemVersion,$classP)[unique=true];featurePosition;language(isocode)[unique=true];qualifier;unit(code,$P_classificationSystemVersion);valueDetails;valuePosition[unique=true];valueType;value[translator=de.hybris.platform.catalog.jalo.classification.impex.ProductFeatureValueTranslator];description
 ;3755205;Input power, 6738,4593;16;en;qualifier;mm;;0;1;string,13

However it works, if i provide all the value in the row itself like below.

 INSERT_UPDATE ProductFeature;classificationAttributeAssignment(classificationAttribute(code,systemVersion(catalog(id),version)),systemVersion(catalog(id),version),classificationClass(catalogversion(catalog(id),version),code))[unique=true];Product(catalogVersion(catalog(id),version),code)[unique=true];language;qualifier;value[translator=de.hybris.platform.catalog.jalo.classification.impex.ProductFeatureValueTranslator]
 ;attriuteCode:sampClassification:1.0:sampClassification:1.0:sampClassification:1.0:classificationcode;productCatalog:Staged:860185;en;prodlongname;String,feature value

Need a simplified value substitution for classificationattributeassignment of productfeatures with macros. Please help

[arvind-kumar_avinash]

You can write like:

 $P_classificationAttributeAssignment=classificationAttributeAssignment(classificationAttribute(code,systemVersion(catalog(id),version)),systemVersion(catalog(id),version),classificationClass(catalogversion(catalog(id),version),code))[unique=true, default=attriuteCode:sampClassification:1.0:sampClassification:1.0:sampClassification:1.0:classificationcode]
 
 INSERT_UPDATE ProductFeature;$P_classificationAttributeAssignment;Product(catalogVersion(catalog(id),version),code)[unique=true];language;qualifier;value[translator=de.hybris.platform.catalog.jalo.classification.impex.ProductFeatureValueTranslator]
  ;;productCatalog:Staged:860185;en;prodlongname;String,feature value

[arvind-kumar_avinash]

Hi - did it solve your problem?

[Former Member]

Thanks Aravind,

The solution is partially correct, it will not help in case of attribute and classification code dynamically like ;attributecode : catlogversionfrommacro :classificationclass: catalogversion from mcaro :Staged:. Again you have re declare the macro for subsequent rows.

Found the solution for that, its working like below,

$classP = classificationClass(code, $P_classificationCataloVersion)

INSERT_UPDATE ProductFeature;product(code,$P_productCV)[unique=true];classificationAttributeAssignment(classificationAttribute(code,$P_classificationSystemVersion),$P_classificationSystemVersion,$classP)[unique=true];featurePosition;language(isocode)[unique=true];qualifier(code,$P_classificationSystemVersion);unit(code,$P_classificationSystemVersion);valueDetails;valuePosition[unique=true];valueType;value[translator=de.hybris.platform.catalog.jalo.classification.impex.ProductFeatureValueTranslator];description ;productCode;attributecode:::::classificationcode;23;en;GENERAL.BATTERY_TYPE5.4670;;;0;1;string,dual