Vital Signs Upgrade to 1.5 - Revision history

>Jeremyb at 22:03, 13 August 2013

2013-08-13T22:03:46Z

>Jeremyb: /* HPUX */

2013-06-19T19:12:14Z

‎HPUX

>Jeremyb: /* Patch QVD Files */

2013-06-19T19:07:23Z

‎Patch QVD Files

>Jeremyb: /* Windows */

2013-04-18T21:22:34Z

‎Windows

>Jeremyb at 21:20, 18 April 2013

2013-04-18T21:20:48Z

>Jeremyb at 19:38, 13 March 2013

2013-03-13T19:38:49Z

>Jeremyb at 19:35, 13 March 2013

2013-03-13T19:35:13Z

>Jeremyb at 19:32, 13 March 2013

2013-03-13T19:32:00Z

>Jeremyb at 19:29, 13 March 2013

2013-03-13T19:29:33Z

>Jeremyb at 19:29, 13 March 2013

2013-03-13T19:29:04Z

@@ Line 328: / Line 328: @@
 </pre>
-Extract the past 60 days of Datachange information for Spectrum_Data_Change where CCYYMMDD is 60 days ago
+Extract the past 30 days of Datachange information for Spectrum_Data_Change where CCYYMMDD is 60 days ago
 <pre>
 login as bolive
-/VSJOBS/JVSLOAD_HIST CCYYMMDD TYPE=DC DAYS=10 LOOP=6
+/VSJOBS/JVSLOAD_HIST CCYYMMDD TYPE=DC DAYS=10 LOOP=3
 </pre>

@@ Line 175: / Line 175: @@
 <pre>
-[vsdata_bolive]
+[vsdata_live]
 login=bolive
 Directory=/var/summit/spectrum/LIVE/vsdata
@@ Line 210: / Line 210: @@
 Macro VS-TRBAL-LOAN     = (LOAN-FILE.BALANCE <> 0 OR LOAN-FILE.CREDIT-LIM > 0)
-** Set the following to 1 if you want to include non-zero escrow balance loans in the trial bal chart
+*** Use the following macros if you want to include non-zero escrow balance loans in the trial bal chart
-** - If the escrow logic is disabled, ALL OF THE $FALSE macros must be active.
+*** - The macros with the same names (below) MUST be disabled with comments.
-** - If the logic is enabled, you MUST USE the "complex" macro code.
+*Macro VS-TRBAL-INC-ESCTOTS = 1
-Macro VS-TRBAL-INC-ESCTOTS = 1
+*Macro VS-TRBAL-ESCROW-LINK = link l1, account splice "-" splice !format("99", suffix) :: esctots.acct-sfx-key
-Macro VS-TRBAL-ESCROW-MBR = (!range((LOAN-ADDENDUM.BALANCE <> 0), "1/"))
+*Macro VS-TRBAL-ESCROW-MBR = (!range((LOAN-ADDENDUM.BALANCE <> 0, $MISSING), "1/"))
-**Macro VS-TRBAL-ESCROW-MBR = $FALSE
+*Macro VS-TRBAL-ESCROW-LN = (ESCTOTS.ESCROW_BALANCE <> 0, $MISSING)
 Macro VS-TRBAL-ESCROW-LN = (ESCTOTS.ESCROW_BALANCE <> 0)
-**Macro VS-TRBAL-ESCROW-LN = $FALSE
+*** Use the following macros if zero balance escrow loans Should NOT be included
-Macro VS-TRBAL-ESCROW-FLAG = (ESCTOTS.ESCROW_BALANCE <> $MISSING and ESCTOTS.ESCROW_BALANCE <> 0)
+*** - The macros with the same names (above) MUST be disabled with comments.
-**Macro VS-TRBAL-ESCROW-FLAG = $FALSE
+Macro VS-TRBAL-INC-ESCTOTS = 0
 </pre>
@@ Line 261: / Line 264: @@
 FTP_PASV=Yes
 FTP_VERBOSE=No
 </pre>
@@ Line 268: / Line 272: @@
 *jobs/ into /ASKPLUS/vsdata/jobs
 *scripts/ into /ASKPLUS/vsdata/scripts
 ==Going Live==

@@ Line 86: / Line 86: @@
 Append missing TRAN-DATE field to HISTCCYYMMDD.qvd files
 *Open and Reload v15_vitalsigns/YOURCU/data/Reload_Qvd_Fix_Hist_Tran_Date.qvw
-*This should not be run at the same time as the Fix_Hist_Tran_Date.qvw
+*This should not be run at the same time as the Reload_Qvd_Fix_Hist_Distinct.qvw
 Append Hist_Distinct field to HISTCCYYMMDD.qvd files
 *Reload_Qvd_Fix_Hist_Distinct.qvw
 ====Verify Data Integrity====

@@ Line 6: / Line 6: @@
 ===Windows===
 Login to the Windows server as the vitalsigns administrator
@@ Line 128: / Line 129: @@
 ***Select the Mbr Select Sheet
 ***Save the document
 ===HPUX===

@@ Line 4: / Line 4: @@
 ==Staged Upgrade==
-'''Windows'''
+===Windows===
 Login to the Windows server as the vitalsigns administrator
@@ Line 75: / Line 75: @@
-Patch QVD Files
+====Patch QVD Files====
 ''NOTE : The following patch qvw files can be launched in 2 separate QlikView x64 applications and run at the same time.''
@@ Line 91: / Line 91: @@
-Verify Data Integrity
+====Verify Data Integrity====
 Membership_Analysis_by_ACCOUNT
@@ Line 130: / Line 130: @@
-'''HPUX'''
+===HPUX===
 Login as the askplus user
@@ Line 273: / Line 273: @@
 ==Going Live==
-'''Windows'''
+===Windows===
 Login to Windows as the Vital Signs admin user
@@ Line 318: / Line 318: @@
-'''HPUX'''
+===HPUX===
 Gather the latest CMNDFILE
@@ Line 344: / Line 344: @@
-'''UC4'''
+===UC4===
 Modify the UC4 jobs to use the new symbolic link and to cd to new path as shown here :

@@ Line 77: / Line 77: @@
 Patch QVD Files
-''NOTE : The following patch qvw files can be launched in 2 separate QlikView x64 applications and run at the same time.
+''NOTE : The following patch qvw files can be launched in 2 separate QlikView x64 applications and run at the same time.''
-NOTE : If you need to patch a few days, place these qvd files in their own qvd directory after renaming the current qvd directory.  Patch the files and then merge them with the other patch qvds before going live.''
+''NOTE : If you need to patch a few days, place these qvd files in their own qvd directory after renaming the current qvd directory, patch the files and then merge them with the other patch qvds before going live.''
 Append SH_CHGOFF_FLAG and LN_CHGOFF_FLAG fields to existing 1.4 SHFILE and LNFILE qvd files
@@ Line 274: / Line 274: @@
 '''Windows'''
-*Login to Windows as the Vital Signs admin user
-*Open Task Manager and end the process named python.exe *32  - This is the Vital Signs Listener
+Login to Windows as the Vital Signs admin user
-*Open the Administrative Tools->Services window and stop the QlikView Server services
-*Open Windows Explorer and browse to the vitalsigns directory
+Open Task Manager and end the process named python.exe *32  - This is the Vital Signs Listener
-*Copy the bin directory to v14-bin
-*Change directory into YOURCU/data
+Open the Administrative Tools->Services window and stop the QlikView Server services
-*Create a folder v14-Presentation-Level
-*Copy all of the vitalsigns/YOURCU/ qvw files into vitalsigns/YOURCU/data/v14-Presentation-Level
+Open Windows Explorer and browse to the vitalsigns directory
-*Create a directory named v14-Read-Level
-*Copy all of the vitalsigns/YOURCU/data/*.qvw files into vitalsigns/YOURCU/data/v14-Read-Level/
+Copy the bin directory to v14-bin
-*Copy config to v14-config
-*Copy mbrshln to v14-mbrshln
+Change directory into YOURCU/data
-*Copy hist to v14-hist
-*Copy all of the files from v15_vitalsigns/YOURCU/data/config/ to vitalsigns/YOURCU/data/config/
+Create a folder v14-Presentation-Level
-*Copy all of the Read Level documents from v15_vitalsigns/YOURCU/data/mbrshln/ to vitalsigns/YOURCU/data/mbrshln/
-*Copy all of the Read Level qvw files from v15_vitalsigns/YOURCU/data/hist/ to vitalsigns/YOURCU/data/hist/
+Copy all of the vitalsigns/YOURCU/ qvw files into vitalsigns/YOURCU/data/v14-Presentation-Level
-*Copy all of the Read Level qvw files from v15_vitalsigns/YOURCU/data/ to vitalsigns/YOURCU/data/
-*Copy all of the Presentation Level qvw files from v15_vitalsigns/YOURCU/ to vitalsigns/YOURCU/
+Create a directory named v14-Read-Level
-*Rename the directory vitalsigns/YOURCU/data/qvd to v14-qvd
-*Cut the v15_vitalsigns/YOURCU/data/qvd to vitalsigns/YOURCU/data/
+Copy all of the vitalsigns/YOURCU/data/*.qvw files into vitalsigns/YOURCU/data/v14-Read-Level/
-*Browse to vitalsigns/YOURCU/data/config and double click start_vsigns_srv.vbs - (Starts the Vital Signs listener so manual tests can be seen communicating)
 '''HPUX'''
-*Gather the latest CMNDFILE
+Gather the latest CMNDFILE
 <pre>
 login as bolive
@@ Line 305: / Line 326: @@
 </pre>
-*Extract the past 60 days of Datachange information for Spectrum_Data_Change where CCYYMMDD is 60 days ago
+Extract the past 60 days of Datachange information for Spectrum_Data_Change where CCYYMMDD is 60 days ago
 <pre>
 login as bolive
 /VSJOBS/JVSLOAD_HIST CCYYMMDD TYPE=DC DAYS=10 LOOP=6
 </pre>

@@ Line 1: / Line 1: @@
 == Summary ==
 Instructions for Upgrading to 1.5 from 1.4
 '''Windows'''
@@ Line 126: / Line 128: @@
 ***Select the Mbr Select Sheet
 ***Save the document