Question & Answer
Question
How do you publish extended RTAM fields to a CSV file in IBM Sterling Order Management?
Cause
You are unable to publish extended RTAM Field to CSV file
Answer
- Define and deploy the ValueMaps.xml file. This file maps values between Sterling Order Management and external applications. To define and deploy the ValueMaps.xml file, copy
<INSTALL_DIR>/properties/ValueMaps.xml.sample to <INSTALL_DIR>/properties/ValueMaps.xml
and change it for your Organization Code and Ship Node.
- Configure the REALTIME_AVAILABILITY_CHANGE_LIST event to invoke the syncInvChangesCSV Action. You can find the action under SCWC SDF Integration Action Group.
- Modify the template for REALTIME_AVAILABILITY_CHANGE_LIST.xml and the template for SendAvailabilityChangeToInventoryAvailabilityCSV.xsl
- In the customer_overrides.properties file, configure the following properties:
- yfs.scwc.value.mapping.file - This property specifies the location of the ValueMaps.xml file.
- yfs.scwc.sdf.csvformat - This property specifies the format of the output .csv file.
By default, the file format is
mm:PartNumber,mm:OnlineStoreUniqueID,mm:physicalStoreIdentifier,mm:AvailableQuantity,mm:FutureAvailableQuantity,mm:FutureAvailableDate
For example:yfs.scwc.sdf.csvformat=mm:PartNumber,mm:OnlineStoreUniqueID,mm:physicalStoreIdentifier,mm:AvailableQuantity,mm:FutureAvailableQuantity,mm:FutureAvailableDate,mm:ExtnBatchNo
- yfs.scwc.sdf.csv.dir - This property specifies the directory where the .csv file is exported.
For example: yfs.scwc.sdf.csv.dir=C\:\\Payments\\CSV
[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Maintenance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.5;9.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg22004914