How can I solve ImpexException: pk has wrong format

[Former Member]

Hello, I am getting an error after trying to update a products attributes through the HAC:

2019-03-25 09:50:16,944 ERROR [hybrisHTTP5] (00000JAH) [ImpExImportJob] line 8 at main script: pk has wrong format: 'approved':For input string: "approved" de.hybris.platform.impex.jalo.ImpExException: line 8 at main script: pk has wrong format: 'approved':For input string: "approved"[HY--1] at de.hybris.platform.impex.jalo.Importer.importNextInternal(Importer.java:763) at de.hybris.platform.impex.jalo.Importer.importNext(Importer.java:738) at de.hybris.platform.impex.jalo.cronjob.ImpExImportJob.doImport(ImpExImportJob.java:287) at de.hybris.platform.impex.jalo.cronjob.ImpExImportJob.performJob(ImpExImportJob.java:244) at de.hybris.platform.impex.jalo.cronjob.ImpExImportJob.performCronJob(ImpExImportJob.java:111) at de.hybris.platform.cronjob.jalo.Job.execute(Job.java:1297) at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:815) at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:738) at de.hybris.platform.cronjob.jalo.Job.perform(Job.java:639)

Here is the ImpEx script I am trying to import:

"# ImpEx for Importing enhanced product desciption # Macros / Replacement Parameter definitions $productCatalog=ProductCatalog $catalogVersion=catalogversion(catalog(id[default=$productCatalog]),version[default='Staged'])[unique=true,default='$productCatalog:Staged'] $approvalStatus=approvalStatus[default='Approved']

UPDATE ASMProduct;code[unique=true];name;description;$catalogVersion[unique=true];$approvalStatus; ;ABCD10249;"Test Item to modify approvalStatus";"Active";""

I'm relatively new to Hybris and putting together an ImpEx file, so any help would be appreciated! Thanks!

[Former Member · Accepted solution]

I think your issue is in the macro below:

$approvalStatus=approvalStatus[default='Approved']

You should try with:

$approvalStatus=approvalStatus(code)[default='approved']

which will look-up the approvalstatus by code

[Former Member · Accepted solution]

That worked, thank you!