Skip to content

Reclaim Flag

Overview

The purpose of ReclaimFlag.exe is to pull reclaim flag values from the Sharp host database, which itself receives data from the ODS layer. The reclaim flag values are stored in SupplierProduct.SMI. All screen references to 'SMI' have been renamed to 'Reclaim Flag'

{{% notice warning %}} Only Grand Rapids DcArea/commodities are supported at this time. {{% /notice %}}

Installation

Setup ReclaimFlag as a Scheduled Task that runs 1x per day.

Before First Run at HQ Site

The first time ReclaimFlag.exe runs against an HQ database, a very large # of items will be changed. In order to not clog the pipe to attached CS databases, changes are not tracked in the HQ database the first run only. So, prior to first run at HQ, the following steps are required:

  • Stop using HQ and CS
  • Run HqExport and then disable it
  • allow StoreImport a few minutes to run at each store
  • Connect to each CS server and execute this query n the SmartGrocer database: update SupplierProduct set SMI='N' WHERE SupplierId IN (1,2,3,4,5,6,7) AND SMI NOT IN ('N')

This will make all ReclaimFlg=N in all CS, and only items with ReclaimFlg=Y will flow from HQ->CS.

First Execution

The first time ReclaimFlag.exe runs all existing reclaim flag values are set to N, and then all items with Y values are download and updates in SmartGrocer.

Successive Execution

On future executions, only changes are downloaded that have been made since the most recent execution of ReclaimFlag.exe.

Configuration

Filename

C:\Program Files (x86)\SmartGrocer[HQ]\ReclaimFlag.exe.config

Content

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <appSettings  file="global.config">
    <add key="BaseUrl" value="http://grwrclm01" />
  </appSettings>
  <startup> 
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
  </startup>
</configuration>