Loading promotion folders and promotions into promotion folders
This sample demonstrates how to load promotion folders and promotion data to create folders and sort promotions into their corresponding folders. After you load the data, Management Center users can view the folders and sorted promotions in the Promotions tool.
To help business users organize the promotions for a store, promotion folders are available in the Promotions tool. For more information about Management Center folders, see Folders.
About this sample
When you run the Data Load utility to load this sample, the load operation first creates promotion folders for use in Management Center. Then, the load operation creates relationships between promotions and the folders that the promotions are going to be added within. The promotions are sorted based on the starting date time stamp of the promotions. This time stamp is retrieved from the STARTDATE column in the PX_PROMOTION database table. After the load operation completes, you can view the folders in the Promotions tool and browse through the folders to locate the promotions.
If you plan to create many promotion folders for your store or sort many promotions into folders, use the Data Load utility to create the folders and folder relationships. Copy the files that are provided with this sample and modify the files to help you create the input and configuration files for loading your store-specific data. If your store contains many promotions, you can create Java programs to generate the input files for creating your store promotion folders and for sorting promotions into these folders. For more information, see Java classes for generating data load input files for promotion folders and folder relationships.
- WC_installdir/samples/DataLoad/Promotion/Folder
- WC_installdir\samples\DataLoad\Promotion\Folder
- WCDE_installdir\samples\DataLoad\Promotion\Folder
As an administrator, you can configure the Promotions tool so that only promotions that are not in a folder display in the main Promotions - List view. If your store has hundreds or thousands of promotions, preventing promotions that are sorted in folders from displaying in the Promotions - List view can make finding promotions easier. With this configuration enabled, business users can browse through folders to find sorted promotions and browse the main Promotions - List view to find unsorted promotions. For more information, see Organizing promotions with folders.
Sample input and configuration files
Sample CSV input file | Description |
---|---|
PromotionFolders.csv For more information about folder data, see Promotion folder input file |
The Data Load utility uses this sample input file to load the data to create
promotion folders in the Promotions tool. The Data Load utility uses the following business object mediator and business object configuration file to load the data in this input file into the FOLDER database table. Business object mediator com.ibm.commerce.foundation.dataload.businessobjectbuilder.TableObjectBuilder Sample
business object configuration file for loading this information:
|
PromotionFolderItems.csv For more information about the data to sort promotions into promotion folders, see Promotion folder relationship input file |
The Data Load utility uses this sample input file to sort promotions that
exist in the main Promotions List in the Promotions tool into newly created promotion folders. The Data Load utility uses the following business object mediator and business object configuration file to load the data in this input file into the FOLDERITEM database table. Business object mediator com.ibm.commerce.foundation.dataload.businessobjectbuilder.TableObjectBuilder Sample
business object configuration file for loading this information:
Note: This sample PromotionFolderItems.csv file contains promotion ID
values that might not exist for the promotions in your store. Before you load this CSV input file,
ensure that you update the input file to include ID values that exist for promotions in your store.
The promotion ID values for promotions are stored in the PX_PROMOTION_ID column of the PX_PROMOTION database table. |
- wc-dataload.xml
- The data load order configuration file, which 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, see Configuring the data load order.
- wc-dataload-env.xml
- The data load environment configuration file, which includes the environment variables for your
WebSphere Commerce instance. These variables include
the following information:
- Business context variables, including the store identifier, catalog identifier, and the default language and currency for your store.
- Database environment settings, including the database type, name, and schema.
- wc-loader-promotion-folder.xml
- The business object configuration file that defines how promotion folder data is loaded into the database. The file also defines the appropriate business object mediator to use to load the data.
- wc-loader-promotion-folderitem.xml
- The business object configuration file that defines how relationship data between a promotion folder and a promotion is loaded into the database. The file also defines the appropriate business object mediator to use to load the data.
Procedure
- Open a command-line utility and go to the appropriate directory:
- WC_installdir/bin
- WC_installdir\bin
- WCDE_installdir\bin
- Enter the following command to run the sample data load order file and load the information that
included in this sample:
- ./dataload.sh ../samples/DataLoad/Promotion/Folder/wc-dataload.xml
- dataload.bat ..\samples\DataLoad\Promotion\Folder\wc-dataload.xml
- dataload ..\samples\DataLoad\Promotion\Folder\wc-dataload.xml
Verifying results
- Verify that the promotion folder and relationship data 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.
- You can also verify that the sample data is loaded by running the following SQL statements
against your WebSphere Commerce
database:
Ensure that the data within the sample input files exists within the appropriate database tables.select * from FOLDER; select * from FOLDERITEM;
- In Management Center, verify that you can view the promotion folders and the appropriate promotions in the folders in the Promotions tool.
Removing the sample data from the WebSphere Commerce database
Edit the
wc-dataload.xml load order configuration file to change the value of the
dataLoadMode
attribute from "Replace"
to "Delete"
to run the Data Load utility in delete mode. When you run the utility in delete mode, the utility
deletes the data in your database that matches the rows in your CSV file. You do not need to edit
the value for the Delete column in your input CSV
file.
select * from FOLDER;
select * from FOLDERITEM;
The data that you loaded
with this sample should no longer exist in your database.In Management Center, verify that you can no longer view the promotion folders and the appropriate promotions in the folders in the Promotions tool.