SOP: RBDNLOAD FWHIP CONFIG

New process eliminates multiple errors which occur like duplicate orders already shipped. Eliminates the Macro Scheduler and allows emails on Client Customer relationships

1. Create the proper email alias in Interchange if using multiple persons to send the report to.

   

    

    

2. Open the table J:\FWHIP\DATA\MRG\CLIENTCUSTEDI.DBF

   1. Add a record either by client-name and customer or by client name only and add the alias to the rbdnload field for emails to be sent out to the proper person(s)

   2. 

3. Open up the table J:\fwhip\data\rb\rbconfig.dbf and create client variables

   1. Folder variables are required and must end with a backslash

      1. DNLDSAVE J:\FWHIP\EDI\OUT\RB\BMR\ ( CLIENT DATA SAVE )

      2. DNLDTO \\FARRB2\RBWMS\RBIN\BMR\ ( RADIO BEACON FOLDER )

      3. LABELFLDR J:\FWHIP\EDI\LABELS\RB\ ( TEMPORARY FOLDER IF RB IS DOWN)

   2. Proper server must be chosen to distinguish between test server and live servers and is called in call to Connect(). Note that servers must be setup in ODBC as listed in J:\FWHIP\src\Reportcode\connect.prg. (SEE PICTURE 1 BELOW)

      1. Rbtest = sqlconnect( 'rbtest','rbship','rbwms99')

      2. Farrb2 = sqlconnect( 'FARRB2','rbship','rbwms99')

      3. Accellos = sqlconnect( 'ACC1','rbship','rbwms99')

      4. Gentran = sqlconnect( 'newgentran','sa','5tv10665') (FYI)

   3. The REPLACE command field has two requirements the command and what table to apply the command on. There is a work table J:\FWHIP\DATA\WORK\RBPH.DBC AND RBPD.DBC

      1. CTBL = RBPH OR RPBD

      2. CODESTR = REPLACE CUST_PSLIP WITH 'BMRPS.RPT' ALL

         1. This can be customized as necessary for the client

   4. There are two REPLACE fields not commonly understood but setup the Handle and N of M Label in Radio Beacon

      1. HANDLE ( if used will not allow runtimer to operated on the file )

      2. Cc_label the N of M label to send to Radio Beacon

   5. Last is the setup for runtimer to do the additional field updates not able to be handled in the download

      1. There is a required field of ctype CONFIG to call this client updates

      2. Then on tables pickhead and pickdetl updates can be done (see picture 2 below )

         1. Clientname = our client

         2. Ctable = table to execute the update on

         3. Ctype = VALUE to execute the update functionality

         4. Cfield = the field to update

         5. Cdefault the value to update the Cfield in SQL Server

         6.