Skip to Content

Is it possible to export whole content catalog data using any scrip to setup data in another environment without DB dump?

I wanted to setup UAT Content catalog data into my Local or lower (QA) environments. So looking for a solution to export full stage content catalog data.

What are the ways we can achieve it .

FYI : I don't have impex scripts to create the data during system update or initialization. I don't want to do a DB dump export/import.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 26, 2019 at 11:14 PM

    Hi

    Yes, you can do it using export scripts from backoffice . you can generate scripts from backoffice/hmc and then using those scripts for your component data and all relation tables , you can export the content.

    Scripts varies from project to project as all projects have different attributes in tables. hence you will first need to generate scripts from backoffice for your project and then using those script, export the data and then import those exported data into backoffice.

    you can export data for 1 particular version of catalog and then synch(like export data for staged version and synch to online.)

    example like given below is product data export.: You can export all dependant components

    -----------------------------------------------------------

    insert_update Product;&Item;code[unique=true,allownull=true];approvalStatus(code,itemtype(code))[allownull=true];catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];category;dcsClassId;dcsSubClassId;harmonizedTariffCode;hazardousClass;hazardousMaterialCode;hazardousMaterialCodeClass;hzmByAir;hzmByGround;hzmByOcean;hzmExeCode;hzmFlag;hzmLimitedQuantity;hzmPackageGroup;hzmUnitOfWeight;inStrFlag;itemLevelGtin;itemMinQtyPerApplication;legacySKU;length;lineCode;partNumber;partStatus;pbyCode;pbySkuCode;priceCode;priceQuantity;productFamily;publishedToBlc;qtyPerApplicationQualifier;quantityOfEaches;regulated;sPack;sequenceId;shadowSku;smpcItemGroup;smpcOilViscosity;smpcSalesUnit;sortSkuCode;sourceSystem;specialOrderVendorSku;startLineNumber;subBrandLabel;subCategory;subCategoryDesc;subCode;thirdPartyVendor;typeCode;variantType(code);vendorName;vendorNumber;vendorSubNumber;vocPercentage;warrantyLine1;warrantyNumber;weight

    "#% impex.exportItems( ""SELECT {p.pk} FROM {PBYProduct as p},{category as c},{catalogVersion as cv},{categoryproductrelation as cpr} WHERE {p.pk}={cpr.target} AND {p.catalogVersion} = {cv.pk} and {c.pk}={cpr.source} AND {cv.version} ='Online' and {c.code}='14231746' "" , Collections.EMPTY_MAP, Collections.singletonList (Item.class) , true, true, -1, -1 );"

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.