Difference between revisions of "Vital Signs New Install"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(Step 1 - Initial Meeting)
>Jeremyb
Line 47: Line 47:
 
* [[Custom Attributes]]
 
* [[Custom Attributes]]
  
==Install Check List==
+
 
 +
==Step 3 - Installation==
  
 
'''HPUX'''
 
'''HPUX'''
Line 70: Line 71:
  
  
==Post Install Configuration==
+
==Step 4 - Post Install Configuration==
  
 
* [[Membership Analysis Initial Setup]]
 
* [[Membership Analysis Initial Setup]]
 
 
* [[Transaction Analysis Initial Setup]]
 
* [[Transaction Analysis Initial Setup]]
  
  
==Transaction Analysis Initial Run==
+
==Step 5 - Transaction Analysis Initial Run==
  
 
* Extract 23 months of History Data
 
* Extract 23 months of History Data
Line 98: Line 98:
  
  
==Membership Analysis Initial Run==
+
==Step 6 - Membership Analysis Initial Run==
  
 
* Extract Prior EOM (Note replace YYYYMMDD with the prior EOM date)
 
* Extract Prior EOM (Note replace YYYYMMDD with the prior EOM date)
Line 114: Line 114:
  
  
==UC4 Job Setup==
+
==Step 7 - UC4 Job Setup==
  
 
''Note: There is no need to have your job plans pause and wait for completion of these jobs before
 
''Note: There is no need to have your job plans pause and wait for completion of these jobs before
Line 162: Line 162:
 
     Unable to login
 
     Unable to login
 
     Error in uploading the remote file.
 
     Error in uploading the remote file.
 +
 +
 +
==Step 8 - Review Figures==
 +
* Membership totals
 +
* Trial balance
 +
 +
 +
==Step 9 - Schedule Training==
 +
Once Vital Signs has been installed, configured and is running nightly, the initial Training via Webinar can be scheduled.  Contact training@vital-soft.com for more information.

Revision as of 00:31, 6 November 2012

Overview

The following information is a step by step overview of the installation process of Vital Signs.


HPUX Server Requirements

OS

  • HPUX PA-Risc 11.11
  • HPUX PA-Risc/ITANIUM 11.23
  • HPUX PA-Risc/ITANIUM 11.31

Software

  • Python 2.7.3
  • Python configObj Library


Windows Server Requirements

The Windows server does all of the heavy lifting for Vital Signs after the data has been extracted from Eloquence.

OS / Hardware

Software


Step 1 - Initial Meeting

After purchasing Vital Signs you will receive an email requesting to schedule a meeting between Vital Soft and the individuals who will be overseeing the Vital Signs project. During this initial meeting the contact information for the following will be requested by Vital Soft :

  • Project Lead
  • VPN Access
  • HPUX/UC4 Installation and Setup
  • Windows Server Installation and Setup


Step 2 - Configuration Meeting

Share and Loan Product Grouping


Credit Union Specific Customization


Step 3 - Installation

HPUX


Windows

  • Python 32bit
  • Pyparsing Python Module
  • Microsoft Excel 2007 or later (Open Office Calc will limit Document Distribution Functionality)
  • IIS 7+ / FTP 7.5+ (FTPes is currently only supported with FileZilla Server)
  • .NET Framework 3.5+
  • Sftp client (winscp, filezilla, etc..) for HPUX script transfers (optional)
  • Qlikview Client
  • Qlikview Server
  • vitalsigns.zip unzipped to vitalsigns directory


Step 4 - Post Install Configuration


Step 5 - Transaction Analysis Initial Run

  • Extract 23 months of History Data
   login bolive
   cd /var/summit/spectrum/LIVE
   
   # Extract CMNDFILE
   /VSJOBS/JVSLOAD_HIST CMNDFILE=1
   
   # Extract 360 days of History data from 2 years ago 
   # Replace YYYYMMDD with 2 years ago to the current date
   /VSJOBS/JVSLOAD_HIST YYYYMMDD DAYS=30 LOOP=12
   
   # Extract the final year of History data
   /VSJOBS/JVSLOAD_HIST DAYS=30 LOOP=12
   
   # Extract the remaining days  (JVSLOAD_HIST default to extracting 30 days from the last extract Date held in HISTLOG)
   /VSJOBS/JVSLOAD_HIST


Step 6 - Membership Analysis Initial Run

  • Extract Prior EOM (Note replace YYYYMMDD with the prior EOM date)
   login bolive
   cd /var/summit/spectrum/LIVE
   /VSJOBS/JVSLOAD_MBRSHLN EOM YYYYMMDD


  • Extract Current Day
   login bolive
   cd /var/summit/spectrum/LIVE
   /VSJOBS/JVSLOAD_MBRSHLN


Step 7 - UC4 Job Setup

Note: There is no need to have your job plans pause and wait for completion of these jobs before continuing with the next step

Daily Jobs

   ## HIST DAILY
   ## Run nightly- between 12:01 and 1 am, including weekends
   ## Should be run prior to the MEMBERSHIP_ANALYSIS DAILY
   ## Login as bolive
   set -e
   cd /var/summit/spectrum/LIVE
   /VSJOBS/JVSLOAD_HIST


   ## MEMBERSHIP_ANALYSIS DAILY
   ## Run nightly – after JVSLOAD_HIST and prior to 5am
   ## Do not run on days when the EOM job (see below) is scheduled
   ## Login as bolive
   set -e
   cd /var/summit/spectrum/LIVE
   /VSJOBS/JVSLOAD_MBRSHLN


EOM Job

   ## MEMBERSHIP_ANALYSIS EOM
   ## Run after report databases have been created
   ## Login as bolive
   set -e
   cd /var/summit/spectrum/LIVE
   /VSJOBS/JVSLOAD_MBRSHLN eom &YYYYMMDD
   #Where &YYYYMMDD is a UC4 variable containing the last day of the month


UC4 Error Alerts

   #Main Vital Signs Errors
   serious error occurred while processing
   Errors found in log.  Printing last 20 lines
   #Vital Signs Listener Error
   Error xmlrpc exception
   #FTP Errors
   Unable to connect
   Unable to login
   Error in uploading the remote file.


Step 8 - Review Figures

  • Membership totals
  • Trial balance


Step 9 - Schedule Training

Once Vital Signs has been installed, configured and is running nightly, the initial Training via Webinar can be scheduled. Contact training@vital-soft.com for more information.