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

[bhaskarg2]

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.

[rohit31_raj92]

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 );"

[bhaskarg2]

Raj I appreciate your immediate response. I wanted to know is it possible to make one script to export the data instead of each table export. Or there is any simple way to do this ? I accept that your above solution will work for me. Thanks.

[rohit31_raj92]

No for each table you have to export data, like for CMSComponent there will be 1 export script to be created, Media, any custom components etc. you can export all data at once but you need to have all tables export scripts.