Publishing extended RTAM fields to a CSV file

Answer

1. 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.
   
   
   
2. Configure the REALTIME_AVAILABILITY_CHANGE_LIST event to invoke the syncInvChangesCSV Action. You can find the action under SCWC SDF Integration Action Group.
   
   
   
3. Modify the template for REALTIME_AVAILABILITY_CHANGE_LIST.xml and the template for SendAvailabilityChangeToInventoryAvailabilityCSV.xsl
   
   
   
4. 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