Vital Signs Upgrade to 1.5

From Vital Soft Wiki
Revision as of 19:06, 13 March 2013 by >Jeremyb
Jump to: navigation, search

Summary

Instructions for Upgrading to 1.5 from older releases

From 1.1

From 1.2

From 1.3

From 1.4

Windows

Login to the Windows server as the vitalsigns administrator

Make a copy of the current vitalsigns directory and rename it : v15_vitalsigns

Extract the 1.5 Vitalsigns zip files

Copy the extracted bin files to v15_vitalsigns/bin/

Open the following presentation level application in 2 QlikView windows (1.5 extracts and current 1.4 copies in v15_vitalsigns). Compare the bookmarks/reports/Custom Charts. Export/Import any custom reports/bookmarks to the new Qvw files, copy any Custom Charts to the new Qvw files

  • Daily_Membership_Summary.qvw
  • Weekly_Membership_Summary.qvw
  • Monthly_Membership_Summary.qvw
  • Membership_Analysis_by_ACCOUNT.qvw
  • Transaction_Analysis.qvw
  • Loan_Application.qvw


Copy the extracted presentation level documents into v15_vitalsigns/YOURCU/

Copy the extracted MBRSHLN load level qvw file into v15_vitalsigns/YOURCU/data/mbrshln/

  • Load_Qvd_MBR_SHARE_LOAN.qvw


Copy the extracted HIST load level qvw file into v15_vitalsigns/YOURCU/data/hist/

  • Load_Qvd_Hist.qvw


Copy extracted read level qvw files into v15_vitalsigns/YOURCU/data/

  • Read_Qvd_Membership_Analysis
  • Read_Qvd_Membership_Analysis_by_ACCOUNT
  • Read_Qvd_Monthly_Membership_Summary
    • Delete Read_Qvd_Daily_Membership_Summary and Read_Qvd_Weekly_Membership_Summary
    • Copy Read_Qvd_Monthly_Membership_Summary twice and rename copies:
      • Read_Qvd_Daily_Membership_Summary
      • Read_Qvd_Weekly_Membership_Summary
  • Read_Qvd_Transaction_Analysis
  • Read_Qvd_Loan_Application
  • Reload_Qvd_Fix_ChgOff


Copy extracted config files into v15_vitalsigns/YOURCU/data/config/

  • Carefully merge vitalsigns.xls with vitalsigns-samp.xls
    • In the vitalsigns.xls on the GlobalVars sheet
      • Make sure vUseAcctXref = 1
      • Make sure that vReportFrequencies exists : Daily, Weekly, Monthly
    • Save vitalsigns-samp.xls to vitalsigns.xls


Carefully merge membership_analysis.xls with membership_analysis-samp.xls

  • Save membership_analysis-temp.xls to membership_analysis.xls


Carefully merge documentdistribution.xls with documentdistribution-samp.xls

  • Save documentdistribution-samp.xls to documentdistribution.xls


Carefully merge VS_BRANCH_INFO.xls with the VS_BRANCH_INFO-samp.xls

  • Save VS_BRANCH_INFO-samp.xls to VS_BRANCH_INFO.xls
  • BranchReassign.xls
    • If this files doesn't exist, review the Vital Signs-v15 - Transaction Analysis Setup.pdf
    • Rename BranchReassign.xls BranchReassign-temp.xls until you have all of the Branch Numbers for the Credit Union and their corresponding drawer numbers (Including Virtual Branches)
    • Get a list of the Branch numbers and associated drawer numbers for the CU
      • Virtual Branches are supported as well - A Virtual Branch is a Branch number that does not exist in Spectrum but can be assigned to real drawer numbers and tracked in Transaction Analysis
    • Important - If BranchReassign.xls is found without being completely filled out, any matching drawer numbers with a 0 branch will be dropped from Vital Signs. It is VERY important to get all of the branch information correct the first time. It is important to also list reserved drawer numbers that can potentially be assigned to a branch in the future.

Copy Data_Change-samp.xls as Data_Change.xls


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 : 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

  • Open and Reload v15_vitalsigns/YOURCU/data/Reload_Qvd_Fix_ChgOff.qvw

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

Append Hist_Distinct field to HISTCCYYMMDD.qvd files

  • Reload_Qvd_Fix_Hist_Distinct.qvw


Verify Data Integrity

Membership_Analysis_by_ACCOUNT

  • Open v15_vitalsigns/YOURCU/data/Read_Qvd_Membership_Analysis.qvw
    • Click File->Reload
    • Save the document when it has finished reloading
  • Open v15_vitalsigns/YOURCU/data/Read_Qvd_Membership_Analysis_by_ACCOUNT.qvw
    • Click Filed->Reload
    • Save the document when it has finished reloading
  • Open v15_vitalsigns/YOURCU/Membership_Analysis_by_ACCOUNT.qvw
    • Click File->Reload
    • Save the document when it has finished reloading
    • Keep this document open to compare with the Production Document
    • When reloading Membership_Analysis_by_ACCOUNT for the very first time do the following:
      • Select the Mbr Select tab
      • Click the "Clear and Set all to Open" button
      • Select the Current Date in the upper left
      • Right click the Date select box and click properties and browse to the General Tab
      • Enable the "Always 1 selected" option, hit OK
      • Save the document.
  • Open vitalsigns/YOURCU/Membership_Analysis_by_ACCOUNT.qvw and verify the same date is selected in the upper left as the v15 document
  • Compare the totals at the bottom of the Mbr Select Sheet with the totals from the v15 document
  • Look at the Mbr Attributes as well to make sure things look as they should
    • If attributes are missing, click Settings->Variable Overview
      • Find the variable named InitMacro and change the value from 0 to 1
      • Note : This may be set to 1 in later 1.5 versions
      • Press OK
      • Browse to the Overview Sheet and click the button labeled "Post Reload (Local Access Only)"
      • Verify that the Attributes now look correct
      • Click Settings->Variable Overview and set InitMacro back to 0
      • Hit Clear
      • Select the Mbr Select Sheet
      • Save the document


HPUX

Login as the askplus user

Check to see what version of Askplus the client is running. 

		
/ASKPLUS/askplus

If pre 8.2.3 then modify the vsdata/jobs/JVS* files to call /ASKPLUS/askplus e8051 NOTE: It is highly recommended to upgrade to Askplus e.8.3.3 or later to fix a critical update bug

Place the new Spectrum_Data_Change file for the specific CPU type (Itanium/PA-Risc) in /ASKPLUS

  • datachng.sl (.so for Itanium)
  • (owner askplus:users and executable)

Confirm that the /VSJOBS symbolic link exists : 

Example:

$ ls /VSJOBS
JVSLOAD_GLDATA      JVSLOAD_HIST        JVSLOAD_MBRSHLN     JVSLOAD_PSCU
JVSLOAD_GLDATA.old  JVSLOAD_HIST.old    JVSLOAD_NEWHIST     JVSRELOAD
JVSLOAD_GLDATA.txt  JVSLOAD_HIST.txt    JVSLOAD_OANR

If the /VSJOBS symbolic link does not exist, login as root and create it : 

ln -s /ASKPLUS/vsdata/jobs /VSJOBS


Update the Directory and Temp paths in /ASKPLUS/vsrvtcp.ini to new larger volume paths

NOTE : This should only be the case for a site running an original 1.4 install

Example : 


[vsdata_bolive]
login=bolive
Directory=/var/summit/spectrum/LIVE/vsdata
TEMP=/var/summit/spectrum/LIVE/vsdata/temp
EQ_DBSERVER=localhost:eloq-LIVE
script_path=/ASKPLUS/vsdata/scripts
custom_path=/ASKPLUS/vsdata/custom/live
Vmgr=/ASKPLUS/vsdata/custom/live/vmgr

Copy the vsdata directory to vsdata-bkup-YYYYMMDD 

cd /ASKPLUS
cp -Rp vsdata vsdata-v14


Check for custom attributes in the /ASKPLUS/vsdata/scripts/VSCALC-CUSTOM-ATTR file

  • If they exist, make a note to not overwrite the existing VSCALC-CUSTOM-ATTR when bringing over the new scripts directory files

Verify the following macros in /ASKPLUS/vsdata/custom/live/vsmacdef

  • If the escrow logic is disabled, ALL OF THE $FALSE macros must be active.
  • If the logic is enabled, you MUST USE the "complex" macro code.
Macro VS-TRBAL-INC-ESCTOTS = 1
Macro VS-TRBAL-ESCROW-MBR = (!range((LOAN-ADDENDUM.BALANCE <> 0), "1/"))
**Macro VS-TRBAL-ESCROW-MBR = $FALSE
Macro VS-TRBAL-ESCROW-LN = (ESCTOTS.ESCROW_BALANCE <> 0)
**Macro VS-TRBAL-ESCROW-LN = $FALSE
Macro VS-TRBAL-ESCROW-FLAG = (ESCTOTS.ESCROW_BALANCE <> $MISSING and ESCTOTS.ESCROW_BALANCE <> 0)
**Macro VS-TRBAL-ESCROW-FLAG = $FALSE
  • If site uses OANR
Macro VS-EXTRACT-OANR = 1
  • If the site has visa info in Spectrum
Macro VS-EXTRACT-VISAINFO = 1
  • If the site uses lender
Macro VS-EXTRACT-LOANAP = 1


Verify vmgr and vmgr_eom are opening: 

dfiles;
loanap.loanap;

Links should be : 

Links:
REG = MEMBRS.MEMBER-FILE, MEMBRS.SHARE-FILE,
MEMBER-FILE.ACCOUNT :: SHARE-FILE.ACCOUNT;

SFX0 = MEMBRS.MEMBER-FILE, MEMBRS.SHARE-FILE,
MEMBER-FILE.ACCOUNT :: SHARE-FILE.ACCOUNT FORWARDS COUNT=1;


Loan_Application changes to /ASKPLUS/vsdata/vsreload.ini

  • If the CU uses lender, uncomment the loanap read and presentation level tasks in the [MBRSHLN_Daily] group
[MBRSHLN_Daily]
...
#task15=Read_Qvd_Loan_Application
task16=Read_Qvd_Data_Change
task21=Membership_Analysis_by_ACCOUNT
task22=Membership_Analysis_by_SSN
task23=Daily_Membership_Summary
#task24=Loan_Application
task25=Spectrum_Data_Change


Copy new v15 UNIX files into vsdata

Copy custom/live/ files into /ASKPLUS/vsdata/custom/live Do NOT overwrite ATTRFILE or any ifiles that are used in ATTRFILE

Copy jobs/ into


Going Live

Retrieved from "https://wiki.vital-soft.com/index.php?title=Vital_Signs_Upgrade_to_1.5&oldid=1047"