java - Hybris:如何使用 impex 导入?
问题描述
我正在尝试使用 impex 导入产品,但脚本不起作用,我不明白为什么。这是我的脚本:
insert TaxRow ; &Item ; catalogVersion(catalog(id),version) ; creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss] ; currency(isocode) ; endTime[dateformat=dd.MM.yyyy hh:mm:ss] ; modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss] ; owner(&Item)[allownull=true] ; pg(code,itemtype(code)) ; product(catalogVersion(catalog(id),version),code) ; productId[forceWrite=true] ; productMatchQualifier ; startTime[dateformat=dd.MM.yyyy hh:mm:ss] ; tax(code)[allownull=true,forceWrite=true] ; ug(code,itemtype(code)) ; user(uid) ; userMatchQualifier ; value
; Item0 ; hybrisProductCatalog:Staged ; 18.02.2019 04:00:18 ; ; ; 18.02.2019 04:00:18 ; ; standard:ProductTaxGroup ; ; ; 8 796 129 198 171 ; ; standard ; ; ; 0 ;
; Item1 ; hybrisProductCatalog:Staged ; 30.05.2017 03:25:52 ; ; ; 30.05.2017 03:25:52 ; ; eu-vat-full:ProductTaxGroup ; ; ; 8 796 129 362 011 ; ; uk-vat-full ; uk-taxes:UserTaxGroup ; ; 8 796 129 034 331 ;
; Item2 ; hybrisProductCatalog:Staged ; 30.05.2017 03:25:52 ; ; ; 30.05.2017 03:25:52 ; ; eu-vat-half:ProductTaxGroup ; ; ; 8 796 129 427 547 ; ; de-vat-half ; de-taxes:UserTaxGroup ; ; 8 796 129 132 635 ;
; Item3 ; hybrisProductCatalog:Staged ; 30.05.2017 03:25:52 ; ; ; 30.05.2017 03:25:52 ; ; eu-vat-full:ProductTaxGroup ; ; ; 8 796 129 362 011 ; ; de-vat-full ; de-taxes:UserTaxGroup ; ; 8 796 129 132 635 ;
; Item4 ; hybrisProductCatalog:Staged ; 30.05.2017 03:25:52 ; ; ; 30.05.2017 03:25:52 ; ; eu-vat-half:ProductTaxGroup ; ; ; 8 796 129 427 547 ; ; uk-vat-half ; uk-taxes:UserTaxGroup ; ; 8 796 129 034 331 ;
; Item5 ; hybrisProductCatalog:Staged ; 29.05.2017 03:34:46 ; ; ; 29.05.2017 03:34:46 ; ; specific:ProductTaxGroup ; ; ; 8 796 129 263 707 ; ; specific ; ; ; 0 ;
; Item6 ; hybrisProductCatalog:Staged ; 29.05.2017 03:34:46 ; ; ; 29.05.2017 03:34:46 ; ; zero:ProductTaxGroup ; ; ; 8 796 129 230 939 ; ; zero ; ; ; 0 ;
; Item7 ; hybrisProductCatalog:Staged ; 29.05.2017 03:34:46 ; ; ; 29.05.2017 03:34:46 ; ; jp-vat-full:ProductTaxGroup ; ; ; 8 796 129 394 779 ; ; jp-vat-full ; jp-taxes:UserTaxGroup ; ; 8 796 129 099 867 ;
insert_update Product ; &Item ; Europe1PriceFactory_PDG(code,itemtype(code)) ; Europe1PriceFactory_PPG(code,itemtype(code)) ; Europe1PriceFactory_PTG(code,itemtype(code)) ; activeProductReview ; approvalStatus(code,itemtype(code))[allownull=true] ; articleStatus[lang=en] ; articleStatus[lang=fr] ; baseNotes[lang=en] ; baseNotes[lang=fr] ; bestRated ; bestSeller[allownull=true] ; bestViewed[allownull=true] ; buyerIDS(key(code,itemtype(code))) ; catalog(id)[allownull=true] ; catalogVersion(catalog(id),version)[unique=true,allownull=true] ; code[unique=true,allownull=true] ; contentUnit(code) ; contentUnitSize ; creationtime[forceWrite=false,dateformat=dd.MM.yyyy hh:mm:ss] ; customPageTitle ; data_sheet(catalogVersion(catalog(id),version),code) ; defaultSku(catalogVersion(catalog(id),version),code) ; deliveryTime ; description[lang=en] ; description[lang=fr] ; detail(catalogVersion(catalog(id),version),code) ; discountable[allownull=true] ; doNotOverrideApprovalStatus ; doNotOverwriteBestSeller ; doNotOverwriteNewProduct ; ean ; endLineNumber ; erpGroupBuyer ; erpGroupSupplier ; erpName[lang=en] ; erpName[lang=fr] ; erpShortDescription[lang=en] ; erpShortDescription[lang=fr] ; erpStatus(code,itemtype(code)) ; europe1Discounts(&Item) ; europe1Prices(&Item) ; europe1Taxes(&Item) ; exclusiveBrand(code,itemtype(code)) ; exportToMakeUp ; extraZoomDisabled ; feedType(code,itemtype(code)) ; formulation[lang=en] ; formulation[lang=fr] ; galleryImages(catalogVersion(catalog(id),version),qualifier) ; gender(code,itemtype(code)) ; generalPromotionText[lang=en] ; generalPromotionText[lang=fr] ; generalPromotion[allownull=true] ; giveAway ; heartNotes[lang=en] ; heartNotes[lang=fr] ; informativePrice1 ; informativePrice2 ; informativePrice3 ; informativePrice4 ; informativeText1[lang=en] ; informativeText1[lang=fr] ; informativeText2[lang=en] ; informativeText2[lang=fr] ; informativeText3[lang=en] ; informativeText3[lang=fr] ; ingredients[lang=en] ; ingredients[lang=fr] ; isAvaliableInMultipleShades ; logo(catalogVersion(catalog(id),version),code) ; manufacturerAID ; manufacturerName ; manufacturerTypeDescription[lang=en] ; manufacturerTypeDescription[lang=fr] ; markDownMemPrice(&Item) ; markDownPrice(&Item) ; marketingClass(code,itemtype(code)) ; masterBrandRef(catalogVersion(catalog(id),version),code) ; maxOrderQuantity ; minOrderQuantity ; modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss] ; mrnDepartmentCode ; mrnFeatures[lang=en] ; mrnFeatures[lang=fr] ; mrnFinal ; mrnPrdVatCode ; mrnTipsAdviceHtml[lang=en] ; mrnTipsAdviceHtml[lang=fr] ; name[lang=en] ; name[lang=fr] ; newProduct[allownull=true] ; normal(catalogVersion(catalog(id),version),code) ; numberContentUnits ; offlineDate[dateformat=dd.MM.yyyy hh:mm:ss] ; olfactives[lang=en] ; olfactives[lang=fr] ; onlineDate[dateformat=dd.MM.yyyy hh:mm:ss] ; order ; orderQuantityInterval ; others(catalogVersion(catalog(id),version),code) ; owner(&Item)[allownull=true] ; packType[lang=en] ; packType[lang=fr] ; pharmacyInfo[lang=en] ; pharmacyInfo[lang=fr] ; picture(catalogVersion(catalog(id),version),code) ; prdVatCode ; priceQuantity ; productOrderLimit(&Item) ; prohibitMemberPoints ; rangeName ; ranking ; recyclingInfo[lang=en] ; recyclingInfo[lang=fr] ; remarks[lang=en] ; remarks[lang=fr] ; segment[lang=en] ; segment[lang=fr] ; seoDescription[lang=en] ; seoDescription[lang=fr] ; sequenceId ; shippingInfo[lang=en] ; shippingInfo[lang=fr] ; shortDescription[lang=en] ; shortDescription[lang=fr] ; showPdpContentHubArticles ; showReserveAndCollectButton ; showVPProms ; specialTreatmentClasses() ; startLineNumber ; storageCondition[lang=en] ; storageCondition[lang=fr] ; storage[lang=en] ; storage[lang=fr] ; summary[lang=en] ; summary[lang=fr] ; supplier(code) ; supplierAlternativeAID ; thumbnail(catalogVersion(catalog(id),version),code) ; thumbnails(catalogVersion(catalog(id),version),code) ; topNotes[lang=en] ; topNotes[lang=fr] ; unit(code) ; uses[lang=en] ; uses[lang=fr] ; vOpeningBusinessRule(&Item) ; vSortingBusinessRule(&Item) ; variantType(code) ; variants(catalogVersion(catalog(id),version),code) ; volume ; warnings[lang=en] ; warnings[lang=fr] ; webExclusive ; weight ; xmlcontent ; zoomDisabled
; Item2 ; ; ; standard:ProductTaxGroup ; true ; load:ArticleApprovalStatus ; ; ; ; ; 0 ; false ; false ; ; hybrisProductCatalog ; hybrisProductCatalog:Staged ; BP_101628163 ; ; ; 13.02.2019 09:08:53 ; ; ; ; ; ; ; ; false ; false ; false ; false ; ; ; ; ; ; DEMO MELLE COUTUR.EDP90ML VP ; ; DEMO MELLE COUTUR.ED ; Available:IgcErpStatusCode ; ; ; Item0,Item1 ; N:IgcBrandTypeName ; false ; false ; IS21MD:ProductfeedType ; ; ; ; FEMME:ProductGender ; ; ; false ; false ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; false ; ; ; ; ; ; ; ; A:MarketingClass ; ; ; ; 13.02.2019 09:08:56 ; ; ; ; false ; ; ; ; ; ; false ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 1 ; ; false ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; false ; true ; false ; ; ; ; ; ; ; ; ; 1364900101 ; ; ; ; ; ; EACH ; ; ; ; ; MrnGenericVariantProduct ; ; ; ; ; ; 328 ; ; false
这是在hac提到的:
insert_update Product;&Item;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));activeProductReview;approvalStatus(code,itemtype(code))[allownull=true];articleStatus[lang=en];articleStatus[lang=fr];baseNotes[lang=en];baseNotes[lang=fr];bestRated;bestSeller[allownull=true];bestViewed[allownull=true];buyerIDS(key(code,itemtype(code)));catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];contentUnit(code);contentUnitSize;creationtime[forceWrite=false,dateformat=dd.MM.yyyy hh:mm:ss];customPageTitle;data_sheet(catalogVersion(catalog(id),version),code);defaultSku(catalogVersion(catalog(id),version),code);deliveryTime;description[lang=en];description[lang=fr];detail(catalogVersion(catalog(id),version),code);discountable[allownull=true];doNotOverrideApprovalStatus;doNotOverwriteBestSeller;doNotOverwriteNewProduct;ean;endLineNumber;erpGroupBuyer;erpGroupSupplier;erpName[lang=en];erpName[lang=fr];erpShortDescription[lang=en];erpShortDescription[lang=fr];erpStatus(code,itemtype(code));europe1Discounts(&Item);europe1Prices(&Item);europe1Taxes(&Item);exclusiveBrand(code,itemtype(code));exportToMakeUp;extraZoomDisabled;feedType(code,itemtype(code));formulation[lang=en];formulation[lang=fr];galleryImages(catalogVersion(catalog(id),version),qualifier);gender(code,itemtype(code));generalPromotionText[lang=en];generalPromotionText[lang=fr];generalPromotion[allownull=true];giveAway;heartNotes[lang=en];heartNotes[lang=fr];informativePrice1;informativePrice2;informativePrice3;informativePrice4;informativeText1[lang=en];informativeText1[lang=fr];informativeText2[lang=en];informativeText2[lang=fr];informativeText3[lang=en];informativeText3[lang=fr];ingredients[lang=en];ingredients[lang=fr];isAvaliableInMultipleShades;logo(catalogVersion(catalog(id),version),code);manufacturerAID;manufacturerName;manufacturerTypeDescription[lang=en];manufacturerTypeDescription[lang=fr];markDownMemPrice(&Item);markDownPrice(&Item);marketingClass(code,itemtype(code));masterBrandRef(catalogVersion(catalog(id),version),code);maxOrderQuantity;minOrderQuantity;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];mrnDepartmentCode;mrnFeatures[lang=en];mrnFeatures[lang=fr];mrnFinal;mrnPrdVatCode;mrnTipsAdviceHtml[lang=en];mrnTipsAdviceHtml[lang=fr];name[lang=en];name[lang=fr];newProduct[allownull=true];normal(catalogVersion(catalog(id),version),code);numberContentUnits;offlineDate[dateformat=dd.MM.yyyy hh:mm:ss];olfactives[lang=en];olfactives[lang=fr];onlineDate[dateformat=dd.MM.yyyy hh:mm:ss];order;orderQuantityInterval;others(catalogVersion(catalog(id),version),code);owner(&Item)[allownull=true];packType[lang=en];packType[lang=fr];pharmacyInfo[lang=en];pharmacyInfo[lang=fr];picture(catalogVersion(catalog(id),version),code);prdVatCode;priceQuantity;productOrderLimit(&Item);prohibitMemberPoints;rangeName;ranking;recyclingInfo[lang=en];recyclingInfo[lang=fr];remarks[lang=en];remarks[lang=fr];segment[lang=en];segment[lang=fr];seoDescription[lang=en];seoDescription[lang=fr];sequenceId;shippingInfo[lang=en];shippingInfo[lang=fr];shortDescription[lang=en];shortDescription[lang=fr];showPdpContentHubArticles;showReserveAndCollectButton;showVPProms;specialTreatmentClasses();startLineNumber;storageCondition[lang=en];storageCondition[lang=fr];storage[lang=en];storage[lang=fr];summary[lang=en];summary[lang=fr];supplier(code);supplierAlternativeAID;thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code);topNotes[lang=en];topNotes[lang=fr];unit(code);uses[lang=en];uses[lang=fr];vOpeningBusinessRule(&Item);vSortingBusinessRule(&Item);variantType(code);variants(catalogVersion(catalog(id),version),code);volume;warnings[lang=en];warnings[lang=fr];webExclusive;weight;xmlcontent;zoomDisabled
,,,;Item2;<ignore>;<ignore>;<ignore>standard:ProductTaxGroup;<ignore>true;<ignore>load:ArticleApprovalStatus;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>0;<ignore>false;<ignore>false;<ignore>;<ignore>hybrisProductCatalog;<ignore>hybrisProductCatalog:Staged;<ignore>BP_101628163;<ignore>;<ignore>;<ignore>13.02.2019 09:08:53;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>false;<ignore>false;<ignore>false;<ignore>false;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>DEMO MELLE COUTUR.EDP90ML VP;<ignore>;<ignore>DEMO MELLE COUTUR.ED;<ignore>Available:IgcErpStatusCode;<ignore>;<ignore>;<ignore>Item0,Item1;<ignore>N:IgcBrandTypeName;<ignore>false;<ignore>false;<ignore>IS21MD:ProductfeedType;<ignore>;<ignore>;<ignore>;<ignore>FEMME:ProductGender;<ignore>;<ignore>;<ignore>false;<ignore>false;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>false;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>A:MarketingClass;<ignore>;<ignore>;<ignore>;<ignore>13.02.2019 09:08:56;<ignore>;<ignore>;<ignore>;<ignore>false;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>false;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>1;<ignore>;<ignore>false;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>false;<ignore>true;<ignore>false;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>1364900101;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>EACH;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>MrnGenericVariantProduct;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>;<ignore>328;<ignore>;<ignore>false
21.02.2019 14:33:27: ERROR: Can not resolve any more lines ... Aborting further passes (at pass 2). Finally could not import 1 lines!
以及控制台上的内容:
WARN [impex result worker [cj:000002BR]] (000002BC) [ImpExImportReader] line 3 at main script: dumped unresolved line ValueLine[,line 3 at main script,null,HeaderDescriptor[line 2 at main script, insert_update, Product, {}, [&Item, Europe1PriceFactory_PDG, Europe1PriceFactory_PPG, Europe1PriceFactory_PTG, activeProductReview, approvalStatus, articleStatus, articleStatus, baseNotes, baseNotes, bestRated, bestSeller, bestViewed, buyerIDS, catalog, catalogVersion, code, contentUnit, contentUnitSize, creationtime, customPageTitle, data_sheet, defaultSku, deliveryTime, description, description, detail, discountable, doNotOverrideApprovalStatus, doNotOverwriteBestSeller, doNotOverwriteNewProduct, ean, endLineNumber, erpGroupBuyer, erpGroupSupplier, erpName, erpName, erpShortDescription, erpShor
tDescription, erpStatus, europe1Discounts, europe1Prices, europe1Taxes, exclusiveBrand, exportToMakeUp, extraZoomDisabled, feedType, formulation, formulation, galleryImages, gender, generalPromotionText, generalPromotionText, generalPromotion, giveAway, heartNotes, heartNotes, informativePrice1, informativePrice2, informativePrice3, informativePrice4, informativeText1, informativeText1, informativeText2, informativeText2, informativeText3, informativeText3, ingredients, ingredients, isAvaliableInMultipleShades, logo, manufacturerAID, manufacturerName, manufacturerTypeDescription, manufacturerTypeDescription, markDownMemPrice, markDownPrice, marketingClass, masterBrandRef, maxOrderQuantity, minOrderQuantity, modifiedtime, mrnDepartmentCode, mrnFeatures, mrnFeatures, mrnFinal, mrnPrdVatCode,
mrnTipsAdviceHtml, mrnTipsAdviceHtml, name, name, newProduct, normal, numberContentUnits, offlineDate, olfactives, olfactives, onlineDate, order, orderQuantityInterval, others, owner, packType, packType, pharmacyInfo, pharmacyInfo, picture, prdVatCode, priceQuantity, productOrderLimit, prohibitMemberPoints, rangeName, ranking, recyclingInfo, recyclingInfo, remarks, remarks, segment, segment, seoDescription, seoDescription, sequenceId, shippingInfo, shippingInfo, shortDescription, shortDescription, showPdpContentHubArticles, showReserveAndCollectButton, showVPProms, specialTreatmentClasses, startLineNumber, storageCondition, storageCondition, storage, storage, summary, summary, supplier, supplierAlternativeAID, thumbnail, thumbnails, topNotes, topNotes, unit, uses, uses, vOpeningBusinessRu
le, vSortingBusinessRule, variantType, variants, volume, warnings, warnings, webExclusive, weight, xmlcontent, zoomDisabled] ],{1=ValueEntry('Item2'=null,unresolved=null,ignore=false), 2=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 3=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 4=ValueEntry('<ignore>standard:ProductTaxGroup'=null,unresolved=null,ignore=true), 5=ValueEntry('<ignore>true'=null,unresolved=null,ignore=true), 6=ValueEntry('<ignore>load:ArticleApprovalStatus'=null,unresolved=null,ignore=true), 7=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 8=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 9=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 10=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 11=ValueEntry('<ignore>0'=nul
l,unresolved=null,ignore=true), 12=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 13=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 14=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 15=ValueEntry('<ignore>hybrisProductCatalog'=null,unresolved=null,ignore=true), 16=ValueEntry('<ignore>hybrisProductCatalog:Staged'=null,unresolved=null,ignore=true), 17=ValueEntry('<ignore>BP_101628163'=null,unresolved=null,ignore=true), 18=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 19=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 20=ValueEntry('13.02.2019 09:08:53'=Wed Feb 13 09:08:53 CET 2019,unresolved=false,ignore=false), 21=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 22=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 23
=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 24=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 25=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 26=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 27=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 28=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 29=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 30=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 31=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 32=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 33=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 34=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 35=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 36
=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 37=ValueEntry('<ignore>DEMO MELLE COUTUR.EDP90ML VP'=null,unresolved=null,ignore=true), 38=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 39=ValueEntry('<ignore>DEMO MELLE COUTUR.ED'=null,unresolved=null,ignore=true), 40=ValueEntry('<ignore>Available:IgcErpStatusCode'=null,unresolved=null,ignore=true), 41=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 42=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 43=ValueEntry('<ignore>Item0,Item1'=null,unresolved=null,ignore=true), 44=ValueEntry('<ignore>N:IgcBrandTypeName'=null,unresolved=null,ignore=true), 45=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 46=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 47=ValueEntry('<ignore>IS21MD
:ProductfeedType'=null,unresolved=null,ignore=true), 48=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 49=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 50=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 51=ValueEntry('<ignore>FEMME:ProductGender'=null,unresolved=null,ignore=true), 52=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 53=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 54=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 55=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 56=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 57=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 58=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 59=ValueEntry('<ignore>'=null,unresolved=null,ignore=true)
, 60=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 61=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 62=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 63=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 64=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 65=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 66=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 67=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 68=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 69=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 70=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 71=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 72=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 73=ValueEntry
('<ignore>'=null,unresolved=null,ignore=true), 74=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 75=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 76=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 77=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 78=ValueEntry('<ignore>A:MarketingClass'=null,unresolved=null,ignore=true), 79=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 80=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 81=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 82=ValueEntry('<ignore>13.02.2019 09:08:56'=null,unresolved=null,ignore=true), 83=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 84=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 85=ValueEntry('<ignore>'=null,unresolved=null,ignore=true)
, 86=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true), 87=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 88=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 89=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 90=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 91=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 149=ValueEntry('<ignore>MrnGenericVariantProduct'=null,unresolved=null,ignore=true), 150=ValueEntry('<ignore>'=null,unresolved=null
,ignore=true),
------------------------------------
151=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 152=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 153=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 154=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 155=ValueEntry('<ignore>328'=null,unresolved=null,ignore=true), 156=ValueEntry('<ignore>'=null,unresolved=null,ignore=true), 157=ValueEntry('<ignore>false'=null,unresolved=null,ignore=true)}]
INFO [impex result worker [cj:000002BR]] (000002BC) [ImpExWorker] Returning worker impex result worker [cj:000002BR] to the pool
INFO [impex reader worker [cj:000002BR]] (000002BC) [ImpExWorker] Returning worker impex reader worker [cj:000002BR] to the pool
INFO [hybrisHTTP20] (000002BR) [Importer] Finished 2 pass in 0d 00h:00m:00s:025ms - processed: 1, dumped: 1 (last pass: 1)
WARN [hybrisHTTP20] (000002BR) [Importer] Import aborted after 0d 00h:00m:00s:334ms
ERROR [hybrisHTTP20] (000002BR) [ImpExImportJob] Can not resolve any more lines ... Aborting further passes (at pass 2). Finally could not import 1 lines!
ERROR [hybrisHTTP20] [DefaultImportService] Import has caused an error, see logs of cronjob with code=000002BR for further details
有人可以解释一下是什么问题。谢谢
解决方案
Impex 脚本由两部分组成:
- 标题
- 数据
这两个可以在 impex 文件中多次出现。
标题
操作:如何处理以下数据:有以下选项:
- 插入:创建新项目
- INSERT_UPDATE:创建新项目或更新现有项目
- 更新:更新现有项目
- 删除:删除现有项目
Itemtype:您要编辑的项目类型(产品、类别、用户...)
属性您要编辑的所有属性以分号分隔。
标头的格式如下所示:
OPERATION ITEMTYPE;ATTRIUTE1;ATTRIBUTE2;
有了这个例子,那就是:
INSERT Address ; firstname ; lastname ;
这意味着您尝试使用属性 firstname 和 lastname 创建一个地址类型的新项目。
数据
在标题之后是数据。对于标题中的每个属性,您都可以添加数据。将第一个条目留空(以分号开头)。然后根据标题中属性的顺序添加每个属性的值。
格式:
;value for attribute1;value for attribute2;
上述标头的示例:
;John;Doe;
完整的 Impex 脚本如下所示:
INSERT Address ; firstname ; lastname ;
; John ; Doe ;
复杂数据类型
当属性类型不是原始类型(字符串、整数...)而是复杂类型时,您需要定义属性来标识要设置给属性的值。一个例子:如果你想创建一个价格,你需要一个价格的货币。Currency是自己的itemtype,所以需要通过itemtype currency的属性来识别货币。货币有一个独特的属性,称为“isocode”。因此,您使用货币的 isocode 来确定应该使用哪种货币。
例子
INSERT PriceRow;...; currency(isocode);
; ; USD ;
使用括号,您可以将属性或逗号分隔的属性列表添加到标题中的属性。如果您需要多个属性来标识目标值,则这些属性的值用冒号分隔。您还可以像在示例中那样嵌套这些表达式:
insert TaxRow ; ... ; catalogVersion(catalog(id),version) ;
; ; hybrisProductCatalog:Staged ;
TaxRow 类型的属性 catalogVersion 的值由目标类型 CatalogVersion 的属性目录和版本标识。两者用逗号隔开。然而,目录(再次)是一种复杂类型,并由其 id 属性标识。标识您的 CatalogVersion 类型项目的两个值是“hybrisProductCatalog”和“Staged”。因此,该脚本会搜索 CatalogVersion 项目,该项目具有分配有 id hybrisProductCatalog 的 Catalog 和 Staged 版本。
这些值需要准确识别一个项目。否则你的脚本会失败。
独特的价值观
使用 INSERT_UPDATE、UPDATE 或 REMOVE 时,您需要确定要更改的项目。您可以通过将属性添加到唯一标识您要更改的项目的标题来做到这一点。您可以通过将 [unique=true] 添加到属性中来做到这一点。如您的示例所示:
INSERT_UPDATE Product ; code[unique=true] ; catalogVersion(catalog(id),version)[unique=true] ;
; BP_101628163 ; hybrisProductCatalog:Staged ;
在这种情况下,您可以插入具有代码 BP_101628163 和 catalogVersion hybrisProductCatalog:Staged 的新产品,或者更改具有这些值的现有产品。
推荐阅读
- python - Django中的ModelForm没有显示
- java - 面向对象的 java 代码和 firebase 的问题
- python - 每个 X 点绘制多个 Y 点
- c - Libelf 会创建损坏的输出文件,即使没有进行任何更改
- r - glmmTMB 'giveCsparse' 的每个模型中的警告
- reactjs - React Ant Design Card 组件没有它的用户界面
- bash - macOS sed - 复杂的替换命令
- c# - Excel 和 C#、非常大的数据集和内存泄漏
- javascript - 如何在 Safari 上平滑滚动到(或等效)?
- r - 您如何计算 R 中组的时间差均值?