SWEM (SPIRIT WIC EBT Middleware) Release Notes

1.0.0.1007

Release Date April 16, 2016 Patch Release

Issues Addressed

• Redemption Script SPIRIT_RECON_Total Is Not Equal To The SettledAmount.
• Redemption Transaction That Are Split Due Number of items Greater Than 99 Are Not Splitting The Quantity.
• Coupon Unique Benefit Issuance Starts With A 03 When WIC EBT Program ID C4 Is Expected.

Known Issues

• Void Current And Future Benefits Receiving Error Message "There Are Not Enough Benefits Remaining On The Household Account To Void Current Benefits. Current Benefits Cannot Be Voided."
• Support retrieving files using a "key file" from an alternate FTP area.
• Saving XXWACTYYMMDD00, XXWEXPYYMMDD00, and XXWURDYYMMDD00 Files Are Being Saved To The Root.
• Add SFTP Support.

1.1.0.1008

Release Date: April 26, 2016

Added support secure file transfer (SFTP).

Issues Addressed

• Added SFTP Support requiring configuration changes as indicated below:

  • SFTP/FTP is controlled fully in the application configuration files (both the Message Processing and Windows Service).

  • This means that these two .config files must be updated as this update is installed.

    • In particular they will need all of the following keys:

      <appSettings>
        ...
        <!-- File Processing -->
        <add key="FTPProtocol" value="sftp" />                      <!-- This can be ftp or ftps -->
        <add key="FTPHost" value="ftp.yourftphost.com" />           <!-- The host name provided by the EBT Processor -->
        <add key="FTPPort" value="51111" />                         <!-- The port number provided by the EBT Processor -->
        <add key="FTPUsername" value="u99" />                       <!-- The ftp username provided by the EBT Processor -->
        <add key="FTPPassword" value="SuperSecret123" />            <!-- The ftp password provided by the EBT Processor, and/or set by you -->
        <add key="FTPInboxName" value="./Inbox/" />                 <!-- The path to the inbox relative to the user's initial landing -->
        <add key="FTPOutboxName" value="./Outbox/" />               <!-- The path to the outbox relative to the user's initial landing -->
        <!-- The ssh thumbprint of the SFTP server to which you are connecting, this only applies to SFTP connections --->
        <add key="FTPSSH-Thumbprint" value="ssh-dss 1024 1b:01:cb:8d:13:de:a3:00:23:98:d9:cb:21:c6" />                       
        ...
      </appSettings>
                              
      

    • Values should be specific to the environment.
    • Note that FTP or SFTP are valid entries for the FTPProtocol field. If this field is set to "FTP", then it will use FTP for communication, if it is set to "SFTP", then it will use SFTP for communication.
    • Most of these keys already exist, but particularly the Protocol and FTPSSH-Thumbprint keys are new (in the message processing configuration file, may need to be added in full to the windows service app config.
    • Also the Inbox and Outbox names are formatted differently.
  • The installer will include winscp.exe in both the Windows Service and Message Processing root folders.
  • The scheduled task that gets files from WIC Direct will also have to be changed. It will no longer invoke PowerShell, instead it will invoke an instance of the Client Endpoint windowsservice.exe with an -ftpdownload switch.
  • The SWEM FileUploader and FileDownloader ps1 scripts will no longer be used.

Known Issues

• N/A

2.0.0.0

Release Date: May 19, 2016

Merged the code bases for the two separate versions of SWEM (CN and Mainline). This included a few changes that involved bringing the two code bases into alignment.

Issues Addressed

• Migrate database scripts from 1.1.0.5 branch to CN branch.
• Support APL Type Flag in the UPC and Vendor files in SWEM conditionally based on attached SPIRIT version.
• Add SFTP Support (Note this was completed in 1.0.0.1008 but that version was never released.
• (DT1019) Error When Sending Household Info With Zip Code Containing Leading Zero / "Invalid/Missing Cardholder Mailing Address Zip Code.

Known Issues

• DT1315 error occurs on HH Demographics in SPIRIT.
• Any Peer Group with an id of "0" will be ignored.

2.0.1.0

Release Date: July 18, 2016

Corrective release for 2.0.0.0 that fixes the known issues.

Issues Addressed

• [CDP-71] Random/Frequent DT1315 Error Occurs When Accessing EBT Household Demographics Screen Via SPIRIT / Households Being Deactivated Accidentally.
• Peer Group "0" is not being handled correctly.

Known Issues

• N/A

2.0.1.1

Release Date: August 23, 2016

Addresses an issue found in reconciliation.

Issues Addressed

• Reconciliation is off between the EBT and MIS systems for transactions occurring after 11:00pm when DST is in effect.

Known Issues

• N/A

2.0.1.2

Release Date: September 16, 2016

Addresses an issue found in how version 2.0.1.0 handled Zero Peer group.

Issues Addressed

• Peer Groups in UPC file contains zero filled peer groups for all extraneous entries.

Known Issues

• N/A

Prior Versions

*Release notes were not created for versions prior to 1.1.0.1007.