Content Migration with Websphere commerce server FEP8

Problem Statement:

Often we may end up in a situation where business will configure all the contents and pages in an environment and wants the same needs to migrate to the higher environment. Before FEP8 there is only an option to load the contents or pages. There is no utility to extract the content.

Before we begin:

(a)  This works only with WCS 7 FEP8 and higher.
(b) On top of FEP8 make sure the following APAR’s are  applied.
JR53438.fep and APAR JR53438.fp.
(c) After applying the APAR,

Verify that the below folders available in this path WC_installdir/components/foundation/samples/

DataExtract/CommerceComposer
DataExtract/Marketing

How Data Extraction works?

(a) Copy the folder DataExtract to the environment where we need to extract the content

(b) Modify the wc-dataextract-env-xml with the environment details like DB name and password.
Update the sheet from which store this data needs to be extracted.
(c) Run the Data extract utility
For Marketing - ./dataload.sh /../../../DataExtract/Marketing/wc-dataextract.xml
For Commercecomposer –
./dataload.sh  /../../../DataExtract/CommerceComposer/wc-dataextract-template.xml
./dataload.sh  /../../../DataExtract/CommerceComposer/wc-dataextract-widget.xml
./dataload.sh  /..../../../DataExtract/CommerceComposer/wc-dataextract-layout.xml

./dataload.sh  /../../../DataExtract/CommerceComposer/wc-dataextract-page.xml

Data Load:

(a) Copy the output csv files generated from extraction utility into appropriate data load utility file location

(b) Load the marketing data first before loading commerce composer.

(c) Load the commerce composer files in the below order

• Template
• Widget
• Layout
• Page