Fraska Portal

Exploring the WebSphere Commerce world

Import a Wish List

Posted by on in Data Load
  • Font size: Larger Smaller
  • Hits: 3229
  • 19 Comments
  • Subscribe to this entry
  • Print

If you need to populate the Commerce User's Wish List you cannot demand it to an Out Of The Box Business Mediator (like it happens- for example- with Catalog Entries, Prices or Attribute Dictionaries) but you will need to use a generic TableObjectBuilder/TableObjectMediator.

The tables to populate are the following:

- IITEMLIST (http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.database.doc/database/iitemlist.htm)

- CIITEMLIST (http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.database.doc/database/ciitemlist.htm)

- IITEM (http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.database.doc/database/iitem.htm)

 

A possible loader- using the TableObjectMediator- is the following:

<_config:BusinessObjectBuilder className="com.ibm.commerce.foundation.dataload.businessobjectbuilder.TableObjectBuilder" >

<_config:Table name="IITEMLIST" excludeUnListedColumns="true">

<_config:Column name="IITEMLIST_ID" value="itemlist_id"></_config:Column>

<_config:Column name="MEMBER_ID" value="cust_id"></_config:Column>

</_config:Table>

<_config:Table name="IITEM" excludeUnListedColumns="true"> 

<_config:Column name="CATENTRY_ID" value="catentry_id"></_config:Column>

<_config:Column name="IITEMLIST_ID" value="itemlist_id"></_config:Column>

<_config:Column name="STOREENT_ID" value="storeent_id"></_config:Column>

<_config:Column name="MEMBER_ID" value="cust_id"></_config:Column>

<_config:Column name="QUANTITY" value="quantity"></_config:Column>

</_config:Table>

<_config:BusinessObjectMediator className="com.ibm.commerce.foundation.dataload.businessobjectmediator.TableObjectMediator" >

</_config:BusinessObjectMediator>

</_config:BusinessObjectBuilder>

The reported configuration and indications are valid just when you need to import a single Wish List for user. Otherwise you will need to populate different tables like GRGFTREG (indeed used to store multiple wish list for each user).

 

Rate this blog entry:
0

Comments

Leave your comment

Guest
Guest Tuesday, 22 October 2019

Most Popular Post

WebSphere Commerce, the curious life of a front-end catalog request
Core
Rate this blog entry:
5
WebSphere Commerce, the SOLR extension index
Administration
Rate this blog entry:
4
WebSphere Commerce, Data Load and SOLR Delta Index
Data Load
Rate this blog entry:
0

Latest Blogs

WebSphere Commerce, CommandLevelAuthorizationCache
Cache
Rate this blog entry:
0
WebSphere Commerce v8, toolkit exception, ClassNotFound db2
Administration
Rate this blog entry:
1
WebSphere Commerce, ATP migration
Store
Rate this blog entry:
0
WebSphere Commerce, the curious life of a front-end catalog request
Core
Rate this blog entry:
5
WebSphere Commerce, Performance analysis of few European stores
Performance
Rate this blog entry:
0