Sample: Loading Commerce Composer layout templates

Before you begin

• Review the Commerce Composer data load best practices. Follow these best practices when you load Commerce Composer assets with the Data Load utility.

About this sample

A layout template is a reusable starting point that can be used when you are creating a layout. A layout template is a wireframe that includes a specific arrangement of slots. When a user creates a layout in the Commerce Composer tool, widgets are assigned to these slots.

If you are using this sample to help you create Commerce Composer layout templates that exist in another instance, you can use the Data Extract utility to generate the input files for loading your template data. You can use the Data Extract utility to extract the existing template data. Then, you can edit configuration files for this sample to load the files that are generated by the Data Extract utility. For a sample that demonstrates how to use the Data Extract utility to extract template data, see Sample: Extracting Commerce Composer layout templates.

Note: You must apply the interim fixes for APAR JR53438.fep and APAR JR53438.fp to add support to the Data Extract utility for extracting Commerce Composer data.

Procedure

1. Open a command-line utility and go to the appropriate directory:
   • WC_installdir/bin
   • WC_installdir\bin
   • WCDE_installdir\bin
2. Enter the following command to run the sample data load order file for a Commerce Composer layout template and load the information for this sample:
   • ./dataload.sh ../components/foundation/samples/DataLoad/CommerceComposer/template/wc-dataload-template.xml
   • dataload.bat ..\components\foundation\samples\DataLoad\CommerceComposer\template\wc-dataload-template.xml
   • dataload ..\components\foundation\samples\DataLoad\CommerceComposer\template\wc-dataload-template.xml
   The load order configuration file identifies the order that the Data Load utility loads the sample CSV files. The load order file also identifies the appropriate business object configuration file to use to load each input file. For more information about load order configuration files, Configuring the data load order.

   For more information about configuring and running the Data Load utility, see Configuring and running the Data Load utility.

Verifying results

Verify that the Commerce Composer tool page information is loaded by reviewing the data load summary report. For more information about the location and contents of this summary report, see Verifying the results of the data load.

select * from PLWIDGET where PAGELAYOUT_ID in (select PAGELAYOUT_ID from PAGELAYOUT where name like 'Sample%');
select * from PLWIDGETDEF where IDENTIFIER like 'Sample%';
select * from PLWIDGETDEFDESC where PLWIDGETDEF_ID in (select PLWIDGETDEF_ID from PLWIDGETDEF where IDENTIFIER like
'Sample%');
select * from PLSTOREWIDGET where PLWIDGETDEF_ID in (select PLWIDGETDEF_ID from PLWIDGETDEF where IDENTIFIER like
'Sample%');
select * from PAGELAYOUT where name like 'Sample%';
select * from PLWIDGETREL where PLWIDGET_ID_CHILD in (select PLWIDGET_ID 
 from PLWIDGET where PAGELAYOUT_ID in (select PAGELAYOUT_ID from PAGELAYOUT where name like 'Sample%'));
select * from PLWIDGETSLOT where PAGELAYOUT_ID in (select PAGELAYOUT_ID from PAGELAYOUT where name like 'Sample%');

In Management Center, verify that users can use the layout template in the Commerce Composer tool by Creating a layout for a page. When you are creating the layout, select a template to use for your layout. Ensure that the templates you loaded are in the New Layout Template Selection window. The following image shows the new layout templates within the New Layout Template Selection window.

Removing the sample data from the WebSphere Commerce database

To remove the sample data from your database, run the sample again but with the value for the delete column for all entries within the files set to 1. By setting the value for this column to 1, the Data Load utility deletes the data that is identified in the CSV file from your database.

• WC_installdir/components/foundation/samples/DataLoad/CommerceComposer/template
• WC_installdir\components\foundation\samples\DataLoad\CommerceComposer\template
• WCDE_installdir\components\foundation\samples\DataLoad\CommerceComposer\template

• ij -f ..\components\foundation\samples\DataLoad\CommerceComposer\template\Cleanup.sql

• db2 -tvf ../components/foundation/samples/DataLoad/CommerceComposer/template/Cleanup.sql
• db2 -tvf ..\components\foundation\samples\DataLoad\CommerceComposer\template\Cleanup.sql

• sqlplus user_name/password@ database_name@ ../components/foundation/samples/DataLoad/CommerceComposer/template/Cleanup.sql
• sqlplus user_name/password@ database_name@ ..\components\foundation\samples\DataLoad\CommerceComposer\template\Cleanup.sql