Data Load Utility in WebSphere Commerce

This is not a very sexy topic but I think it is important to many people who integrate WebSphere Commerce with other systems or do mass data loads. This video is not one of my normal videos in that I do show some slides up front but I end with some live demonstration. This presentation was actually designed for a customer and I generalized it for broader consumption. I do read a few of the slides but hopefully if you are interested in this utility you will have a basic understanding once you have watched it.

Really the goal of the video was to show how flexible the utility is and how you can use comma delimited files (CSV’s) for the import format. This makes editing files very easy because you can do it in a spreadsheet application – which many eCommerce product managers still do today.


2 thoughts on “Data Load Utility in WebSphere Commerce

  1. Hi Bob,

    The information here is good although your big relationship diagram does not quite match up the naming of the files in the samples shipped with commerce, as they are wc-loader-…. as you show when you look at the file in detail.

    One thing that might also be quite useful here is also looking in a little more detail about what the mediators mean. For example the samples that ship look more at loading the data they don’t look at some of the mediators that are just for updating certain components. So in the IC says the following under Catalog best practises for data load.

    Use the right mediator for the purpose

    The CatalogEntryMediator is general enough to load catalog entries, their descriptions, relationships, prices, calculation codes, attributes, SEO data, and other related information within one input file. However, if you are loading only a particular piece of information, say description, then use the CatalogEntryDescriptionMediator for it specifically. The specific mediators are more focused and efficient.

    It then has no examples for this and in best IC fashion could be described as leaving readers in the dark. Perhaps an opportunity on your blog to have something, given how important getting the right data on the system is.


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.