Spectrum Release 2015.2.0 - Revision history

>Johno: /* Vital Signs Changes */

2015-10-09T17:10:11Z

‎Vital Signs Changes

>Johno: /* Vital Signs Changes */

2015-10-09T17:08:14Z

‎Vital Signs Changes

>Johno: /* Vital Signs Changes */

2015-10-09T17:00:33Z

‎Vital Signs Changes

>Johno: /* Vital Signs Changes */

2015-10-09T16:31:11Z

‎Vital Signs Changes

>Kevint at 22:57, 7 October 2015

2015-10-07T22:57:17Z

>Johno: /* Vital Signs Changes */

2015-09-23T18:37:21Z

‎Vital Signs Changes

>Johno: /* Vital Signs Changes */

2015-09-23T18:32:37Z

‎Vital Signs Changes

>Johno: /* Vital Signs Changes */

2015-09-23T18:16:48Z

‎Vital Signs Changes

>Johno: /* Vital Signs Changes */

2015-09-23T16:35:38Z

‎Vital Signs Changes

>Johno: /* AskPlus/Visimage Macro Changes */

2015-09-23T15:25:20Z

‎AskPlus/Visimage Macro Changes

@@ Line 128: / Line 128: @@
 :*Edit the file '''scripts/VSLOAD-LNFILE''' and change:
 <blockquote>
 <pre>
@@ Line 134: / Line 135: @@
 </pre>
 </blockquote>
-::To '''Updated Oct 9, 2015''':
+::To:
 <blockquote>
 <pre>
@@ Line 144: / Line 145: @@
 :*Edit the file '''scripts/VSLOAD-LOOKUP''' and change:
 <blockquote>
 <pre>

@@ Line 134: / Line 134: @@
 </pre>
 </blockquote>
-::To:
+::To '''Updated Oct 9, 2015''':
 <blockquote>
 <pre>

@@ Line 137: / Line 137: @@
 <blockquote>
 <pre>
-D1, STATE-2                  , 1
+newreg STATE:X2
 </pre>
 </blockquote>

@@ Line 154: / Line 154: @@
 <pre>
 #BR-CSZ    = !propername(CITY-16) splice "," join STATE-2
-#BR-CSZ    = #BR-CSZ join !cvt:z5(ZIP-CODE), if ZIP <= 99999
+#BR-CSZ    = #BR-CSZ join !cvt:z5(ZIP-CODE), if ZIP-CODE <= 99999
-#BR-CSZ    = #BR-CSZ join !cvt:z5(ZIP-CODE / 10000), if ZIP > 99999
+#BR-CSZ    = #BR-CSZ join !cvt:z5(ZIP-CODE / 10000), if ZIP-CODE > 99999
 </pre>
 </blockquote>

@@ Line 23: / Line 23: @@
 :*%FZIP - Returns MEMBER-FILE.ZIP as a formatted zip code.
 :*%CVT-FZIP(insert-zip) - Returns a formatted zip code for the specified field, for example %CVT-FZIP(ADDRESS-INFO.ZIP).
-::These macros will return a zero filled US zip-code (5 or 9 digits whatever is stored in the database) or an international zip-code.  US 9 digit zip-codes are formatted 12345-4321 if the zip-code is numeric and exactly 9 digits long, otherwise the macro returns the zip-code as it is stored in the database.
+::These macros will return a zero filled US zip-code (5 or 9 digits whatever is stored in the database) or an international zip code.  US 9 digit zip codes are formatted 12345-4321 if the zip code is numeric and exactly 9 digits long, otherwise the macro returns the zip code as it is stored in the database.
 :*%ZIP5 - Returns MEMBER-FILE.ZIP as a '''5 digit zip code'''.
 :*%CVT-ZIP5(insert-zip) - Returns a '''5 digit zip code''' for the specified field, for example %CVT-ZIP5(ADDRESS-INFO.ZIP).
-::These macros will return a zero filled US '''5 digit''' zip-code.  If the zip-code is numeric and exactly 5 or 9 digits long, the first 5 digits will be returned, otherwise the macro returns 0 for all other zip-codes.  An incorrectly entered US zip-code that is not 5 or 9 digits long will return 0.  International (non-numeric) zip-codes will also return 0.
+::These macros will return a zero filled US '''5 digit''' zip code.  If the zip-code is numeric and exactly 5 or 9 digits long, the first 5 digits will be returned, otherwise the macro returns 0 for all other zip codes.  An incorrectly entered US zip code that is not 5 or 9 digits long will return 0.  International (non-numeric) zip codes will also return 0.
 :*%ZIP9 - Returns MEMBER-FILE.ZIP as a '''9 digit zip code'''.
 :*%CVT-ZIP9(insert-zip) - Returns a '''9 digit zip code''' for the specified field, for example %CVT-ZIP9(ADDRESS-INFO.ZIP).
-::These macros will return a zero filled US '''9 digit''' zip-code with '''no formatting'''.  If the zip-code is numeric and exactly 5 digits, the 5 digit zip-code plus 4 zeros will be returned.  If the zip-code is numeric and exactly 9 digits long, the full 9 digits will be returned, otherwise the macro returns 0 for all other zip-codes.  An incorrectly entered US zip-code that is not 5 or 9 digits long will return 0.  International (non-numeric) zip-codes will also return 0.
+::These macros will return a zero filled US '''9 digit''' zip code with '''no formatting'''.  If the zip code is numeric and exactly 5 digits, the 5 digit zip code plus 4 zeros will be returned.  If the zip code is numeric and exactly 9 digits long, the full 9 digits will be returned, otherwise the macro returns 0 for all other zip codes.  An incorrectly entered US zip code that is not 5 or 9 digits long will return 0.  International (non-numeric) zip codes will also return 0.
 :'''The following new macros were added:'''
-:These macros should be used to format zip-code fields that have '''not been changed''' and are still stored in the database using numeric fields.  These zip-code fields have been renamed in the database as ZIP-CODE.
+:*%FZIP5 - Returns MEMBER-FILE.ZIP as a formatted 5 digit zip code (for US zip codes) or the original value for international ones.
 :*%CVT-FZIP-OLD(insert-zip) - Returns a formatted zip code for the field, for example %CVT-FZIP-OLD(BRANCH-FILE.ZIP-CODE).
-::If the macro is 5 or less digits, returns a zero-filled 5 digit zip-code, otherwise it returns a zero-filled 9 digit zip-code formatted as 12345-4321.
+::If the macro is 5 or less digits, returns a zero-filled 5 digit zip code, otherwise it returns a zero-filled 9 digit zip code formatted as 12345-4321.
 :*%CVT-ZIP5-OLD(insert-zip) - Returns a '''5 digit''' zip code for the field, for example %CVT-ZIP5-OLD(BRANCH-FILE.ZIP-CODE).
-::Returns a zero-filled 5 digit zip-code.  If the zip-code is more than 5 digits, the last 4 digits will be removed.
+::Returns a zero-filled 5 digit zip code.  If the zip code is more than 5 digits, the last 4 digits will be removed.
 :*%CVT-ZIP9-OLD(insert-zip) - Returns a '''9 digit''' zip code for the field, for example %CVT-ZIP9-OLD(BRANCH-FILE.ZIP-CODE).
-::Returns a zero-filled 9 digit zip-code.  If the zip-code is 5 or less digits, the zip-code will be padded with 4 zeros.  The string is not formatted.
+::Returns a zero-filled 9 digit zip code.  If the zip code is 5 or less digits, the zip code will be padded with 4 zeros.  The string is not formatted.
 :*%MEM-CSZ-OLD - Returns the MEMBER-FILE CITY-STATE-ZIP in the format "CITY (max 16 chars), ST (max 2 chars) ZIP"
-::This macro should only be used if you want to truncate the CSZ to a maximum of 31 chars.  The macro uses at most 16 chars of the CITY name and at most 2 chars of the STATE followed by the formatted zip-code using %FZIP.
+::This macro should only be used if you want to truncate the CSZ to a maximum of 31 chars.  The macro uses at most 16 chars of the CITY name and at most 2 chars of the STATE followed by the formatted zip code using %FZIP.
 ===AskPlus Job Changes===

← Older revision		Revision as of 18:37, 23 September 2015
Line 156:		Line 156:
	::During the 2015.2 VUP foreign addresses stored in ADDRESS-LINES(3) (MEMBER-FILE and ADDRESS-INFO) will be moved into the CITY, STATE and ZIP fields. Contact Vital Soft support if you would like to perform the same logic to the existing (previously extracted) MBRFILE and ADDRINFO QVD files. This QVD update process has not been written yet, but we can make it available if clients request it.		::During the 2015.2 VUP foreign addresses stored in ADDRESS-LINES(3) (MEMBER-FILE and ADDRESS-INFO) will be moved into the CITY, STATE and ZIP fields. Contact Vital Soft support if you would like to perform the same logic to the existing (previously extracted) MBRFILE and ADDRINFO QVD files. This QVD update process has not been written yet, but we can make it available if clients request it.

−	More information on [[Testing Vital Signs Script Changes]].	+	More information on [[Testing Vital Signs Script Changes]] for the Spectrum 2015.2 release.

@@ Line 94: / Line 94: @@
 :*Edit the file '''scripts/VSLOAD-MBRFILE''' and change:
 <pre>
 # Near line 180
@@ Line 105: / Line 106: @@
               IF (MEMBER-FILE.ZIP > 99999)
 </pre>
-:To:
+</blockquote>
 <pre>
 newreg MBR-ZIP:X10
@@ Line 113: / Line 116: @@
 #MBR-ZIP+4 = %FZIP
 </pre>
 :*Edit the file '''scripts/VSLOAD-LNFILE''' and change:
 <pre>
 # Near line 190
 D1, STATE                    , 1
 </pre>
-:To:
+</blockquote>
 <pre>
 D1, STATE-2                  , 1
 </pre>
 :*Edit the file '''scripts/VSLOAD-LOOKUP''' and change:
 <pre>
 # Near line 23
@@ Line 131: / Line 140: @@
 #BR-CSZ    = #BR-CSZ join !cvt:z5(ZIP / 10000), if ZIP > 99999
 </pre>
-:To:
+</blockquote>
 <pre>
 #BR-CSZ    = !propername(CITY-16) splice "," join STATE-2
@@ Line 137: / Line 148: @@
 #BR-CSZ    = #BR-CSZ join !cvt:z5(ZIP-CODE / 10000), if ZIP > 99999
 </pre>
 :*Custom Changes:
@@ Line 144: / Line 156: @@
 ::During the 2015.2 VUP foreign addresses stored in ADDRESS-LINES(3) (MEMBER-FILE and ADDRESS-INFO) will be moved into the CITY, STATE and ZIP fields.  Contact Vital Soft support if you would like to perform the same logic to the existing (previously extracted) MBRFILE and ADDRINFO QVD files.  This QVD update process has not been written yet, but we can make it available if clients request it.
-:*Testing Vital Signs Script Changes:
+More information on [[Testing Vital Signs Script Changes]].

@@ Line 91: / Line 91: @@
 *'''Script File Changes:'''
-:The following scripts will need to modified '''after''' the upgrade to Spectrum 2015.2.0.
+:The following scripts will need to modified '''after''' the upgrade to Spectrum 2015.2.0.  We recommend testing these changes in advance with a test instance of the 2015.02 database.  Instead of editing the script files as they exist, make copies with the extension .2015.02 and edit those copies rather than the original files.  The detailed testing steps are shown below.
 :*Edit the file '''scripts/VSLOAD-MBRFILE''' and change:
@@ Line 114: / Line 114: @@
 </pre>
-:*Edit the file '''scripts/VSLOAD-LOANFILE''' and change:
+:*Edit the file '''scripts/VSLOAD-LNFILE''' and change:
 <pre>
 # Near line 190
@@ Line 143: / Line 143: @@
 :*Foreign Addresses:
 ::During the 2015.2 VUP foreign addresses stored in ADDRESS-LINES(3) (MEMBER-FILE and ADDRESS-INFO) will be moved into the CITY, STATE and ZIP fields.  Contact Vital Soft support if you would like to perform the same logic to the existing (previously extracted) MBRFILE and ADDRINFO QVD files.  This QVD update process has not been written yet, but we can make it available if clients request it.

@@ Line 87: / Line 87: @@
 *'''New Macro Definition File:'''
-:The new macro file described above must be installed.
+:The new macro definition file described above must be installed.
 *'''Script File Changes:'''

@@ Line 16: / Line 16: @@
 Several AskPlus macros have been modified to correctly handle the database changes.  It was not possible to make all of the new macro definitions backwards compatible with the pre 2015.2.0 database structure.  '''Therefore, after installing 2015.2.0 you must rebuild the macro file using the new macro definition file.'''  AskPlus jobs and Visimage contexts that use these address macros will '''not''' need to be changed provided the macro file is rebuilt.
-[[Installing Macro Definition Files]]
+:The following links provide more information on installing and testing macro files:
 :'''The following macros were changed:'''