API tools faq
paste
Advertisement
ralievepam

Sample of Migration Script for Hybris 4 and 5

ralievepam
Nov 10th, 2022 (edited)
246
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 37.04 KB | None | 0 0
raw download clone embed print report
  1. # -------------------------------------------------------
  2. # # used 'header validation mode' during script generation was: import_strict
  3. "#% impex.setLocale( new Locale( ""en"" , """" ) );"
  4. # -------------------------------------------------------
  5.  
  6. $contentCatalog='electronicsContentCatalog'
  7. $msm-prod-catalog-id='electronicsProductCatalog'
  8. $contentCatalogVersion='Staged'
  9.  
  10. $catalog-id=electronicsContentCatalog
  11. $catalog-Staged=Staged
  12. $catalog-Online=Online
  13. $msm-contentCV=catalogVersion(catalog(id[default=$catalog-id]),version[default=$catalog-Staged])[default=$catalog-id:$catalog-Staged]
  14. $msm-ProductCV=catalogVersion(catalog(id[default=$msm-prod-catalog-id]),version[default=$catalog-Online])[default=$msm-prod-catalog-id:$catalog-Online]
  15.  
  16. "#% impex.setTargetFile( ""MediaMSM_staged.csv"" );"
  17. INSERT_UPDATE Media;$msm-contentCV[unique=true];code[unique=true];mime;realfilename;@media[translator=de.hybris.platform.impex.jalo.media.MediaDataTranslator];
  18. "#% impex.exportItems( ""SELECT {temp1:pk} FROM {Media as temp1}, {CatalogVersion as CV1}, {Catalog as C1} WHERE {temp1:catalogversion}={CV1:PK} AND {CV1:catalog}={C1:PK} AND {C1:id}='$catalog-id' AND {CV1:version}='$catalog-Staged' "" ,Collections.EMPTY_MAP, Collections.singletonList( Item.class ), true, true, -1, -1 );"
  19.  
  20. # ---- Extension: cms2 ---- Type: CMSLinksForNavNodes ----
  21. "#% impex.setTargetFile( ""CMSLinksForNavNodes.csv"" );"
  22. insert_update CMSLinksForNavNodes;language(isocode)[unique=true];qualifier;sequenceNumber;source(catalogVersion(catalog(id),version),uid)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),uid)[unique=true,allownull=true]
  23. "#% impex.exportItems( ""CMSLinksForNavNodes"" , false );"
  24.  
  25. # ---- Extension: cms2 ---- Type: ElementsForSlot ----
  26. "#% impex.setTargetFile( ""ElementsForSlot.csv"" );"
  27. insert_update ElementsForSlot;language(isocode)[unique=true];qualifier;sequenceNumber;source(catalogVersion(catalog(id),version),uid)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),uid)[unique=true,allownull=true]
  28. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ElementsForSlot as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogVersion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  29.  
  30. # ---- Extension: cms2 ---- Type: CMSLinkComponent ----
  31. "#% impex.setTargetFile( ""CMSLinkComponent.csv"" );"
  32. insert_update CMSLinkComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];category(catalogVersion(catalog(id),version),code);categoryPOS;contentPage(catalogVersion(catalog(id),version),uid);contentPagePOS;external[allownull=true];linkName[lang=de];linkName[lang=en];linkName[lang=fr];linkName[lang=it];linkName[lang=ja];linkName[lang=pt];linkName[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];product(code,$msm-ProductCV);productPOS;target(code,itemtype(code))[allownull=true];uid[unique=true,allownull=true];url;visible[allownull=true]
  33. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSLinkComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  34.  
  35. # ---- Extension: cms2 ---- Type: ABTestCMSComponentContainer ----
  36. "#% impex.setTargetFile( ""ABTestCMSComponentContainer.csv"" );"
  37. insert_update ABTestCMSComponentContainer;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];scope(code,itemtype(code));uid[unique=true,allownull=true];visible[allownull=true]
  38. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ABTestCMSComponentContainer as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  39.  
  40. # ---- Extension: cms2lib ---- Type: BannerComponent ----
  41. "#% impex.setTargetFile( ""BannerComponent.csv"" );"
  42. insert_update BannerComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];content[lang=de];content[lang=en];content[lang=fr];content[lang=it];content[lang=ja];content[lang=pt];content[lang=zh];external[allownull=true];headline[lang=de];headline[lang=en];headline[lang=fr];headline[lang=it];headline[lang=ja];headline[lang=pt];headline[lang=zh];media(catalogVersion(catalog(id),version),code)[lang=de];media(catalogVersion(catalog(id),version),code)[lang=en];media(catalogVersion(catalog(id),version),code)[lang=fr];media(catalogVersion(catalog(id),version),code)[lang=it];media(catalogVersion(catalog(id),version),code)[lang=ja];media(catalogVersion(catalog(id),version),code)[lang=pt];media(catalogVersion(catalog(id),version),code)[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];page(catalogVersion(catalog(id),version),uid);uid[unique=true,allownull=true];urlLink;visible[allownull=true]
  43. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {BannerComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  44.  
  45. # ---- Extension: acceleratorcms ---- Type: SimpleBannerComponent ----
  46. "#% impex.setTargetFile( ""SimpleBannerComponent.csv"" );"
  47. insert_update SimpleBannerComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];external[allownull=true];media(catalogVersion(catalog(id),version),code)[lang=de];media(catalogVersion(catalog(id),version),code)[lang=en];media(catalogVersion(catalog(id),version),code)[lang=fr];media(catalogVersion(catalog(id),version),code)[lang=it];media(catalogVersion(catalog(id),version),code)[lang=ja];media(catalogVersion(catalog(id),version),code)[lang=pt];media(catalogVersion(catalog(id),version),code)[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];urlLink;visible[allownull=true]
  48. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {SimpleBannerComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  49.  
  50. # ---- Extension: cms2lib ---- Type: FlashComponent ----
  51. "#% impex.setTargetFile( ""FlashComponent.csv"" );"
  52. insert_update FlashComponent;bgcolor;catalogVersion(catalog(id),version)[unique=true,allownull=true];external[allownull=true];height;loop;media(catalogVersion(catalog(id),version),code)[lang=de];media(catalogVersion(catalog(id),version),code)[lang=en];media(catalogVersion(catalog(id),version),code)[lang=fr];media(catalogVersion(catalog(id),version),code)[lang=it];media(catalogVersion(catalog(id),version),code)[lang=ja];media(catalogVersion(catalog(id),version),code)[lang=pt];media(catalogVersion(catalog(id),version),code)[lang=zh];menu;name;onlyOneRestrictionMustApply[allownull=true];page(catalogVersion(catalog(id),version),uid);play;quality(code,itemtype(code));sAlign(code,itemtype(code));scale(code,itemtype(code));uid[unique=true,allownull=true];urlLink;visible[allownull=true];width;wmode(code,itemtype(code))
  53. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {FlashComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  54.  
  55. # ---- Extension: acceleratorcms ---- Type: ImageMapComponent ----
  56. "#% impex.setTargetFile( ""ImageMapComponent.csv"" );"
  57. insert_update ImageMapComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];external[allownull=true];imageMapHTML[lang=de];imageMapHTML[lang=en];imageMapHTML[lang=fr];imageMapHTML[lang=it];imageMapHTML[lang=ja];imageMapHTML[lang=pt];imageMapHTML[lang=zh];media(catalogVersion(catalog(id),version),code)[lang=de];media(catalogVersion(catalog(id),version),code)[lang=en];media(catalogVersion(catalog(id),version),code)[lang=fr];media(catalogVersion(catalog(id),version),code)[lang=it];media(catalogVersion(catalog(id),version),code)[lang=ja];media(catalogVersion(catalog(id),version),code)[lang=pt];media(catalogVersion(catalog(id),version),code)[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];urlLink;visible[allownull=true]
  58. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ImageMapComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  59.  
  60. # ---- Extension: b2bstore ---- Type: AdministrationNavComponent ----
  61. "#% impex.setTargetFile( ""AdministrationNavComponent.csv"" );"
  62. insert_update AdministrationNavComponent;b2bItemTypes()[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  63. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {AdministrationNavComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  64.  
  65. # ---- Extension: b2bstore ---- Type: B2BReportComponent ----
  66. "#% impex.setTargetFile( ""B2BReportComponent.csv"" );"
  67. insert_update B2BReportComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];report(catalogVersion(catalog(id),version),code);uid[unique=true,allownull=true];visible[allownull=true]
  68. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {B2BReportComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  69.  
  70. # ---- Extension: storetemplate ---- Type: CartAndWishlistComponent ----
  71. "#% impex.setTargetFile( ""CartAndWishlistComponent.csv"" );"
  72. insert_update CartAndWishlistComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];mode(code,itemtype(code))[allownull=true];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  73. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CartAndWishlistComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  74.  
  75. # ---- Extension: storetemplate ---- Type: CartSummaryComponent ----
  76. "#% impex.setTargetFile( ""CartSummaryComponent.csv"" );"
  77. insert_update CartSummaryComponent;cartImage(catalogVersion(catalog(id),version),code);cartTitle[lang=de];cartTitle[lang=en];cartTitle[lang=fr];cartTitle[lang=it];cartTitle[lang=ja];cartTitle[lang=pt];cartTitle[lang=zh];catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];suplementaryText[lang=de];suplementaryText[lang=en];suplementaryText[lang=fr];suplementaryText[lang=it];suplementaryText[lang=ja];suplementaryText[lang=pt];suplementaryText[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  78. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CartSummaryComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  79.  
  80. # ---- Extension: mobiletemplate ---- Type: MobileCatalogListComponent ----
  81. "#% impex.setTargetFile( ""MobileCatalogListComponent.csv"" );"
  82. insert_update MobileCatalogListComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];useCatalogsOfStore[allownull=true];visible[allownull=true]
  83. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {MobileCatalogListComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  84.  
  85. # ---- Extension: acceleratorcms ---- Type: CategoryFeatureComponent ----
  86. "#% impex.setTargetFile( ""CategoryFeatureComponent.csv"" );"
  87. insert_update CategoryFeatureComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];category(catalogVersion(catalog(id),version),code);description[lang=de];description[lang=en];description[lang=fr];description[lang=it];description[lang=ja];description[lang=pt];description[lang=zh];media(catalogVersion(catalog(id),version),code)[lang=de];media(catalogVersion(catalog(id),version),code)[lang=en];media(catalogVersion(catalog(id),version),code)[lang=fr];media(catalogVersion(catalog(id),version),code)[lang=it];media(catalogVersion(catalog(id),version),code)[lang=ja];media(catalogVersion(catalog(id),version),code)[lang=pt];media(catalogVersion(catalog(id),version),code)[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  88. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CategoryFeatureComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  89.  
  90. # ---- Extension: storetemplate ---- Type: CategoryTreeComponent ----
  91. "#% impex.setTargetFile( ""CategoryTreeComponent.csv"" );"
  92. insert_update CategoryTreeComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];useFacets[allownull=true];visible[allownull=true]
  93. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CategoryTreeComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  94.  
  95. # ---- Extension: cms2 ---- Type: CMSImageComponent ----
  96. "#% impex.setTargetFile( ""CMSImageComponent.csv"" );"
  97. insert_update CMSImageComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];media(catalogVersion(catalog(id),version),code)[lang=de];media(catalogVersion(catalog(id),version),code)[lang=en];media(catalogVersion(catalog(id),version),code)[lang=fr];media(catalogVersion(catalog(id),version),code)[lang=it];media(catalogVersion(catalog(id),version),code)[lang=ja];media(catalogVersion(catalog(id),version),code)[lang=pt];media(catalogVersion(catalog(id),version),code)[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  98. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSImageComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  99.  
  100. # ---- Extension: cms2 ---- Type: CMSParagraphComponent ----
  101. "#% impex.setTargetFile( ""CMSParagraphComponent.csv"" );"
  102. insert_update CMSParagraphComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];content[lang=de];content[lang=en];content[lang=fr];content[lang=it];content[lang=ja];content[lang=pt];content[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  103. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSParagraphComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  104.  
  105. # ---- Extension: acceleratorcms ---- Type: CMSTabParagraphComponent ----
  106. "#% impex.setTargetFile( ""CMSTabParagraphComponent.csv"" );"
  107. insert_update CMSTabParagraphComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];content[lang=de];content[lang=en];content[lang=fr];content[lang=it];content[lang=ja];content[lang=pt];content[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  108. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSTabParagraphComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  109.  
  110. # ---- Extension: acceleratorcms ---- Type: FooterComponent ----
  111. "#% impex.setTargetFile( ""FooterComponent.csv"" );"
  112. insert_update FooterComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;navigationNodes(catalogVersion(catalog(id),version),uid);notice[lang=de];notice[lang=en];notice[lang=fr];notice[lang=it];notice[lang=ja];notice[lang=pt];notice[lang=zh];onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];visible[allownull=true];wrapAfter
  113. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {FooterComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  114.  
  115. # ---- Extension: storetemplate ---- Type: LinkListComponent ----
  116. "#% impex.setTargetFile( ""LinkListComponent.csv"" );"
  117. insert_update LinkListComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];columns[allownull=true];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  118. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {LinkListComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  119.  
  120. # ---- Extension: acceleratorcms ---- Type: MiniCartComponent ----
  121. "#% impex.setTargetFile( ""MiniCartComponent.csv"" );"
  122. insert_update MiniCartComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];lightboxBannerComponent(catalogVersion(catalog(id),version),uid);name;onlyOneRestrictionMustApply[allownull=true];shownProductCount[allownull=true];title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];totalDisplay(code,itemtype(code))[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  123. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {MiniCartComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  124.  
  125. # ---- Extension: mobiletemplate ---- Type: MobilePromotionComponent ----
  126. "#% impex.setTargetFile( ""MobilePromotionComponent.csv"" );"
  127. insert_update MobilePromotionComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];showPromotionItems[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  128. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {MobilePromotionComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  129.  
  130. # ---- Extension: acceleratorcms ---- Type: NavigationBarComponent ----
  131. "#% impex.setTargetFile( ""NavigationBarComponent.csv"" );"
  132. insert_update NavigationBarComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];dropDownLayout(code,itemtype(code));link(catalogVersion(catalog(id),version),uid)[allownull=true];name;navigationNode(catalogVersion(catalog(id),version),uid);onlyOneRestrictionMustApply[allownull=true];styleClass;uid[unique=true,allownull=true];visible[allownull=true];wrapAfter
  133. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {NavigationBarComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  134.  
  135. # ---- Extension: b2bstore ---- Type: OrderListComponent ----
  136. "#% impex.setTargetFile( ""OrderListComponent.csv"" );"
  137. insert_update OrderListComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];orderType(code,itemtype(code))[allownull=true];status(code,itemtype(code))[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  138. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {OrderListComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  139.  
  140. # ---- Extension: cms2lib ---- Type: ProductCarouselComponent ----
  141. "#% impex.setTargetFile( ""ProductCarouselComponent.csv"" );"
  142. insert_update ProductCarouselComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];scroll(code,itemtype(code))[allownull=true];title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  143. "#% impex.exportItems( ""ProductCarouselComponent"" , false );"
  144.  
  145. # ---- Extension: cms2lib ---- Type: ProductDetailComponent ----
  146. "#% impex.setTargetFile( ""ProductDetailComponent.csv"" );"
  147. insert_update ProductDetailComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];product(catalogVersion(catalog(id),version),code);uid[unique=true,allownull=true];visible[allownull=true]
  148. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ProductDetailComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  149.  
  150. # ---- Extension: acceleratorcms ---- Type: ProductFeatureComponent ----
  151. "#% impex.setTargetFile( ""ProductFeatureComponent.csv"" );"
  152. insert_update ProductFeatureComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];description[lang=de];description[lang=en];description[lang=fr];description[lang=it];description[lang=ja];description[lang=pt];description[lang=zh];media(catalogVersion(catalog(id),version),code)[lang=de];media(catalogVersion(catalog(id),version),code)[lang=en];media(catalogVersion(catalog(id),version),code)[lang=fr];media(catalogVersion(catalog(id),version),code)[lang=it];media(catalogVersion(catalog(id),version),code)[lang=ja];media(catalogVersion(catalog(id),version),code)[lang=pt];media(catalogVersion(catalog(id),version),code)[lang=zh];name;onlyOneRestrictionMustApply[allownull=true];product(catalogVersion(catalog(id),version),code);title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  153. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ProductFeatureComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  154.  
  155. # ---- Extension: cms2lib ---- Type: ProductListComponent ----
  156. "#% impex.setTargetFile( ""ProductListComponent.csv"" );"
  157. insert_update ProductListComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];category(catalogVersion(catalog(id),version),code);headline[lang=de];headline[lang=en];headline[lang=fr];headline[lang=it];headline[lang=ja];headline[lang=pt];headline[lang=zh];layout(code,itemtype(code))[allownull=true];name;onlyOneRestrictionMustApply[allownull=true];pagination[allownull=true];productsFromContext[allownull=true];searchQuery[lang=de];searchQuery[lang=en];searchQuery[lang=fr];searchQuery[lang=it];searchQuery[lang=ja];searchQuery[lang=pt];searchQuery[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  158. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ProductListComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  159.  
  160. # ---- Extension: acceleratorcms ---- Type: ProductReferencesComponent ----
  161. "#% impex.setTargetFile( ""ProductReferencesComponent.csv"" );"
  162. insert_update ProductReferencesComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];displayProductPrices[allownull=true];displayProductTitles[allownull=true];maximumNumberProducts[allownull=true];name;onlyOneRestrictionMustApply[allownull=true];productReferenceType(code,itemtype(code));title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  163. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ProductReferencesComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  164.  
  165. # ---- Extension: acceleratorcms ---- Type: PurchasedProductReferencesComponent ----
  166. "#% impex.setTargetFile( ""PurchasedProductReferencesComponent.csv"" );"
  167. insert_update PurchasedProductReferencesComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];category(catalogVersion(catalog(id),version),code)[allownull=true];displayProductPrices[allownull=true];displayProductTitles[allownull=true];filterPurchased[allownull=true];maximumNumberProducts[allownull=true];name;onlyOneRestrictionMustApply[allownull=true];productReferenceType(code,itemtype(code));title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  168. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {PurchasedProductReferencesComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  169.  
  170. # ---- Extension: storetemplate ---- Type: PromotionComponent ----
  171. "#% impex.setTargetFile( ""PromotionComponent.csv"" );"
  172. insert_update PromotionComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;onlyOneRestrictionMustApply[allownull=true];uid[unique=true,allownull=true];visible[allownull=true]
  173. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {PromotionComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  174.  
  175. # ---- Extension: cms2lib ---- Type: RotatingImagesComponent ----
  176. "#% impex.setTargetFile( ""RotatingImagesComponent.csv"" );"
  177. insert_update RotatingImagesComponent;catalogVersion(catalog(id),version)[unique=true,allownull=true];effect(code,itemtype(code));name;onlyOneRestrictionMustApply[allownull=true];timeout;uid[unique=true,allownull=true];visible[allownull=true]
  178. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {RotatingImagesComponent as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  179.  
  180. # ---- Extension: cms2 ---- Type: ContentPage ----
  181. "#% impex.setTargetFile( ""ContentPage.csv"" );"
  182. insert_update ContentPage;approvalStatus(code,itemtype(code))[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];defaultPage[allownull=true];homepage[allownull=true];label;lockedBy(uid);masterTemplate(catalogVersion(catalog(id),version),uid)[allownull=true];name;onlyOneRestrictionMustApply[allownull=true];previewImage(catalogVersion(catalog(id),version),code);title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];uid[unique=true,allownull=true]
  183. "#% impex.exportItems( ""ContentPage"" , false );"
  184.  
  185. # ---- Extension: btg ---- Type: BtgSegmentRestriction ----
  186. "#% impex.setTargetFile( ""BtgSegmentRestriction.csv"" );"
  187. insert_update BtgSegmentRestriction;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;outputActionDefinition(catalogVersion(catalog(id),version),code,uid)[allownull=true];uid[unique=true,allownull=true]
  188. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {BtgSegmentRestriction as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  189.  
  190. # ---- Extension: cms2 ---- Type: CMSCatalogRestriction ----
  191. "#% impex.setTargetFile( ""CMSCatalogRestriction.csv"" );"
  192. insert_update CMSCatalogRestriction;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;uid[unique=true,allownull=true]
  193. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSCatalogRestriction as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  194.  
  195. # ---- Extension: cms2 ---- Type: CMSCategoryRestriction ----
  196. "#% impex.setTargetFile( ""CMSCategoryRestriction.csv"" );"
  197. insert_update CMSCategoryRestriction;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;recursive[allownull=true];uid[unique=true,allownull=true]
  198. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSCategoryRestriction as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  199.  
  200. # ---- Extension: cms2 ---- Type: CMSInverseRestriction ----
  201. "#% impex.setTargetFile( ""CMSInverseRestriction.csv"" );"
  202. insert_update CMSInverseRestriction;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;originalRestriction(catalogVersion(catalog(id),version),uid)[allownull=true];uid[unique=true,allownull=true]
  203. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSInverseRestriction as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  204.  
  205. # ---- Extension: cms2 ---- Type: CMSProductRestriction ----
  206. "#% impex.setTargetFile( ""CMSProductRestriction.csv"" );"
  207. insert_update CMSProductRestriction;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;uid[unique=true,allownull=true]
  208. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSProductRestriction as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  209.  
  210. # ---- Extension: cms2 ---- Type: CMSTimeRestriction ----
  211. "#% impex.setTargetFile( ""CMSTimeRestriction.csv"" );"
  212. insert_update CMSTimeRestriction;activeFrom[dateformat=dd.MM.yyyy hh:mm:ss];activeUntil[dateformat=dd.MM.yyyy hh:mm:ss];catalogVersion(catalog(id),version)[unique=true,allownull=true];name;uid[unique=true,allownull=true]
  213. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSTimeRestriction as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  214.  
  215. # ---- Extension: cms2 ---- Type: CMSUserGroupRestriction ----
  216. "#% impex.setTargetFile( ""CMSUserGroupRestriction.csv"" );"
  217. insert_update CMSUserGroupRestriction;catalogVersion(catalog(id),version)[unique=true,allownull=true];includeSubgroups[allownull=true];name;uid[unique=true,allownull=true]
  218. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSUserGroupRestriction as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  219.  
  220. # ---- Extension: cms2 ---- Type: CMSUserRestriction ----
  221. "#% impex.setTargetFile( ""CMSUserRestriction.csv"" );"
  222. insert_update CMSUserRestriction;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;uid[unique=true,allownull=true]
  223. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSUserRestriction as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  224.  
  225. # ---- Extension: cms2 ---- Type: CMSNavigationEntry ----
  226. "#% impex.setTargetFile( ""CMSNavigationEntry.csv"" );"
  227. insert CMSNavigationEntry;navigationNode(catalogVersion(catalog(id),version),uid);navigationNodePOS
  228. "#% impex.exportItems( ""CMSNavigationEntry"" , false );"
  229.  
  230. # ---- Extension: cms2 ---- Type: CMSNavigationNode ----
  231. "#% impex.setTargetFile( ""CMSNavigationNode.csv"" );"
  232. insert_update CMSNavigationNode;catalogVersion(catalog(id),version)[unique=true,allownull=true];name;parent(catalogVersion(catalog(id),version),uid);parentPOS;title[lang=de];title[lang=en];title[lang=fr];title[lang=it];title[lang=ja];title[lang=pt];title[lang=zh];uid[unique=true,allownull=true];visible[allownull=true]
  233. "#% impex.exportItems( ""CMSNavigationNode"" , false );"
  234.  
  235. # ---- Extension: cms2 ---- Type: ContentSlot ----
  236. "#% impex.setTargetFile( ""ContentSlot.csv"" );"
  237. insert_update ContentSlot;activeFrom[dateformat=dd.MM.yyyy hh:mm:ss];activeUntil[dateformat=dd.MM.yyyy hh:mm:ss];active[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];currentPosition;name;uid[unique=true,allownull=true]
  238. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ContentSlot as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  239.  
  240. # ---- Extension: cms2 ---- Type: PageTemplate ----
  241. "#% impex.setTargetFile( ""PageTemplate.csv"" );"
  242. insert_update PageTemplate;active[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];frontendTemplateName;name;uid[unique=true,allownull=true];velocityTemplate
  243. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {PageTemplate as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  244.  
  245. # ---- Extension: acceleratorservices ---- Type: EmailPageTemplate ----
  246. "#% impex.setTargetFile( ""EmailPageTemplate.csv"" );"
  247. insert_update EmailPageTemplate;active[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];frontendTemplateName;htmlTemplate(code);name;subject(code);uid[unique=true,allownull=true];velocityTemplate
  248. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {EmailPageTemplate as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  249.  
  250. # ---- Extension: cms2 ---- Type: CMSRelation ----
  251. "#% impex.setTargetFile( ""CMSRelation.csv"" );"
  252. insert_update CMSRelation;catalogVersion(catalog(id),version)[unique=true,allownull=true];uid[unique=true,allownull=true]
  253. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {CMSRelation as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  254.  
  255. # ---- Extension: cms2 ---- Type: ContentSlotForPage ----
  256. "#% impex.setTargetFile( ""ContentSlotForPage.csv"" );"
  257. insert_update ContentSlotForPage;catalogVersion(catalog(id),version)[unique=true,allownull=true];contentSlot(catalogVersion(catalog(id),version),uid)[allownull=true];page(catalogVersion(catalog(id),version),uid)[allownull=true];position[allownull=true];uid[unique=true,allownull=true]
  258. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ContentSlotForPage as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  259.  
  260. # ---- Extension: cms2 ---- Type: ContentSlotForTemplate ----
  261. "#% impex.setTargetFile( ""ContentSlotForTemplate.csv"" );"
  262. insert_update ContentSlotForTemplate;allowOverwrite[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];contentSlot(catalogVersion(catalog(id),version),uid)[allownull=true];pageTemplate(catalogVersion(catalog(id),version),uid)[allownull=true];position[allownull=true];uid[unique=true,allownull=true]
  263. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ContentSlotForTemplate as type}, {CatalogVersion as CV}, {Catalog as C} WHERE {type:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  264.  
  265. # ---- Extension: cms2 ---- Type: ContentSlotName ----
  266. "#% impex.setTargetFile( ""ContentSlotName.csv"" );"
  267. insert ContentSlotName;name[allownull=true];template(catalogVersion(catalog(id),version),uid)[forceWrite=true,allownull=true];templatePOS
  268. "#% impex.exportItemsFlexibleSearch(""SELECT {type:pk} FROM {ContentSlotName as type}, {CatalogVersion as CV}, {Catalog as C}, {PageTemplate AS PT} WHERE {type:template} = {PT:PK} AND {PT:catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND {C:id}=$contentCatalog AND {CV:version}=$contentCatalogVersion"");"
  269.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!