IBM Sterling Ideas

formerly Watson Supply Chain

Submit new product ideas for Watson Supply Chain 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

Submit ideas for other Watson Customer Engagement Products:

Watson Marketing
Watson Campaign Automation
Watson Commerce

ITX output validation

ITX has option to validation the input file against schema by using the Schema-validation Option on the input card. Same can be disabled by choosing Well-formed. This option is not available for output file that is generated by the map.

It would be really helpful for all the client maps that use industry standards, to be able to validation if the output file generated was with values in all the mandatory fields and satisfy the conditions. This feature is not present at the moment.

It would be really good as a product, if the tool throws a warning or error when no value is mapped to a mandatory field or when it is run, the input does not hold a value that is mapped to a mandatory output field.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jun 6 2018
  • Already exists
How will this idea be used?

A Retail customer which uses say for example GS1 standard does translation from Json/xml to GS1 xml standard. There are many systems where there are limitations to add an additional validation map or external validation process. It will be much simpler if the map on itself is able to fail when the output generated is not valid per the schema that is invoked. This will help avoid invalid files from being sent to end customer or further processing and fail right in the middle-ware application.

What is your industry? Other
What is the idea priority? Medium
DeveloperWorks ID
RTC ID
Link to original RFE
  • Attach files
  • Admin
    Luke Raiano commented
    August 28, 2018 18:39

    This can likely be handled currently using more advanced techniques in mapping (for example, turning on map audit for or re-parsing the data).  We will consider this for a blog topic to give additional detail

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    20 Feb 08:45

    This doesn't work in all cases. We have come across scenarios where we cannot use multiple output card or use any run map. So the option to re-parse data is not possible. A simple output validation which exists in other transformation tools would be the ideal solution here.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    11 Apr 09:02

    When a output layout with no values populated in mandatory fields, it is expected to throw us some warning or error. That would be logical and more helpful. This will really be good, as I notice many other tools throwing this kind of error for missing mandatory values on output side. 

    It would be really good as a product, if the tool throws a warning or error when no value is mapped to a mandatory field or when it is run, the input does not hold a value that is mapped to a mandatory output field.