IBM Sterling Ideas

formerly Watson Supply Chain

Submit new product ideas for IBM Sterling solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed. Order Management, Store Engagement, Watson Order Optimizer, Inventory Visibility, CPQ and Call Center are now part of Watson Supply Chain

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

Code Lists with many records difficult to support

Individual code lists that contain hundreds of rows are very difficult to support. Searching is impossible. Deployment is all or nothing - need an append new rows option for deploy. Web interface for viewing does not show enough rows of data.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 19 2017
  • Uncommitted Candidate
How will this idea be used?
What is your industry?
What is the idea priority? Medium
DeveloperWorks ID DW_ID38807
Link to original RFE
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    September 24, 2018 13:41

    I agree codlist viewing/maintenance needs revision.

    For viewing I had to write a VBS script that pulls the data from the B2B database and writes it to an Excel file. We have codelists with 6,000+ rows. The UI only shows sender/receiver/description. It doesn’t display TEXT1-9. It also only displays 15 rows at a time. A search would also be helpfull.

    For deploying new rows an append would help immensely. What I have to do is:

    1. Create an Excel comma delimited file with sender/receiver/description/text1-9.
    2. Run the Excel file through a map to create a deploy XML file (export XML file format)
    3. Do an export of the production codelist and combine the two of them. Then do an import.