ImpExException pk has wrong format error while trying to import Product data using HAC/import

[former_member693689]

#-----------------------------------------------------------
INSERT_UPDATE Product;pk[unique=true];code[unique=true];variantType(code);catalogversion(catalog(id[default=avsEurope1ProductCatalog]),version[default='Online'])[unique=true,default=avsEurope1ProductCatalog:Online];approvalStatus(code);name[lang=tr];description[lang=tr];unit(code)[default=pieces];ean;europe1prices[translator=de.hybris.platform.europe1.jalo.impex.Europe1PricesTranslator];europe1Discounts[translator=de.hybris.platform.europe1.jalo.impex.Europe1ProductDiscountTranslator];priceQuantity;Europe1PriceFactory_PTG(code);picture(code);thumbnail(code);galleryImages(qualifier);availableForClasses(code);brand(code);europe1Taxes(pg(code), value);internetName;installmentType(code);productStockControl;classificationClasses(code);supercategories(code, name[lang=tr], name[lang=en])


"#% impex.includeExternalDataMedia( ""Product.csv"" , ""UTF-8"", ';',  1 , -1 );"
#-----------------------------------------------------------

I was playing around with a sample Product data to be able to import just one item into our Hybris system. Eventually, my aim is to import a few thousands of Product data so that our project's initial data is ready.

Above is the importscript.impex file & below is the error I am shown on HAC

INSERT_UPDATE Product;pk[unique=true];code[unique=true];variantType(code);catalogversion(catalog(id[default=avsEurope1ProductCatalog]),version[default='Online'])[unique=true,default=avsEurope1ProductCatalog:Online];approvalStatus(code);name[lang=tr];description[lang=tr];unit(code)[default=pieces];ean;europe1prices[translator=de.hybris.platform.europe1.jalo.impex.Europe1PricesTranslator];europe1Discounts[translator=de.hybris.platform.europe1.jalo.impex.Europe1ProductDiscountTranslator];priceQuantity;Europe1PriceFactory_PTG(code);picture(code);thumbnail(code);galleryImages(qualifier);availableForClasses(code);brand(code);europe1Taxes(pg(code), value);internetName;installmentType(code);productStockControl;classificationClasses(code);supercategories(code, name[lang=tr], name[lang=en])
",,,,pk has wrong format: '8803367550977,0_base,GenericVariantProduct,avsEurope1ProductCatalog:Online,approved,,,,,,,1,,,,,,,,,NOT_INSTALLABLE,true,,EMPTY_::NONE':For input string: ""8803367550977,0_base,GenericVariantProduct,avsEurope1ProductCatalog:Online,approved,,,,,,,1,,,,,,,,,NOT_INSTALLABLE,true,,EMPTY_::NONE""";8803367550977,0_base,GenericVariantProduct,avsEurope1ProductCatalog:Online,approved,,,,,,,1,,,,,,,,,NOT_INSTALLABLE,true,,EMPTY_::NONE;


28.07.2020 10:59:50: ERROR: line 3 at main script: de.hybris.platform.impex.jalo.ImpExException: Can not resolve any more lines ... Aborting further passes (at pass 2). Finally could not import 1 lines![HY-123]
28.07.2020 10:59:50: ERROR: line 3 at main script: Exception ocurred, will ignore: de.hybris.platform.impex.jalo.ImpExException: pk has wrong format: '8803367550977,0_base,GenericVariantProduct,avsEurope1ProductCatalog:Online,approved,,,,,,,1,,,,,,,,,NOT_INSTALLABLE,true,,EMPTY_::NONE':For input string: "8803367550977,0_base,GenericVariantProduct,avsEurope1ProductCatalog:Online,approved,,,,,,,1,,,,,,,,,NOT_INSTALLABLE,true,,EMPTY_::NONE"[HY--1]
28.07.2020 10:59:49: ERROR: line 5 at main script->line 2 at 0000L1Q3-Product.csv: Exception ocurred, will ignore: de.hybris.platform.impex.jalo.ImpExException: pk has wrong format: '8803367550977,0_base,GenericVariantProduct,avsEurope1ProductCatalog:Online,approved,,,,,,,1,,,,,,,,,NOT_INSTALLABLE,true,,EMPTY_::NONE':For input string: "8803367550977,0_base,GenericVariantProduct,avsEurope1ProductCatalog:Online,approved,,,,,,,1,,,,,,,,,NOT_INSTALLABLE,true,,EMPTY_::NONE"[HY--1]

Any help will be greatly appreciated! Thanks!

Best regards,

[geffchang]

Can you share your impex header, and 1 line of impex data?

[former_member693689]

The problem was that I was trying to import pk data as well. I excluded pk field from both my csv and impex file and now problem is solved.