Visimage FAQ - Revision history

Johno at 22:33, 6 June 2023

2023-06-06T22:33:43Z

Johno at 20:46, 6 June 2023

2023-06-06T20:46:33Z

Johno at 17:25, 6 June 2023

2023-06-06T17:25:02Z

Johno at 17:24, 6 June 2023

2023-06-06T17:24:42Z

Johno at 17:24, 6 June 2023

2023-06-06T17:24:06Z

Johno: /* Convert Error */

2023-06-06T16:38:37Z

‎Convert Error

Johno at 16:31, 6 June 2023

2023-06-06T16:31:24Z

Johno at 16:26, 6 June 2023

2023-06-06T16:26:00Z

Johno at 16:19, 6 June 2023

2023-06-06T16:19:53Z

Johno: Created page with "==Visimage3 Frequently Asked Questions=="

2023-06-05T20:08:53Z

Created page with "==Visimage3 Frequently Asked Questions=="

New page

==Visimage3 Frequently Asked Questions==

← Older revision		Revision as of 22:33, 6 June 2023
Line 35:		Line 35:
	*Maximum field name length is 20 characters.		*Maximum field name length is 20 characters.
	*Warning: Do '''not''' create a global variable with the same name as the SD Indexed filename.		*Warning: Do '''not''' create a global variable with the same name as the SD Indexed filename.
		+
		+	===Date Formatting===
		+	:* '''!datint(date, ["format"])'''
		+	::* If no format is specified, "CYMD" will be used
		+	::* When converting dates, !datint now supports the formatting characters '-' and '/', if the specified format is one of CYMD, YMD, MDCY, MDY, DMCY and DMY. For example: "3/15/2016" and "9/9/2009" can be converted using the format "MDCY".
		+
		+	:* '''!datext(int-date, ["format"])'''
		+	::* Where "int-date" is any date in internal format (usually a call to !datint)
		+	::* If no format is specified, "CYMD" will be used
		+	<div id="DateFormats"></div>
		+	::* New date formats for displaying and converting dates:
		+	:::* The characters d (day), m (month) and y (year) have a special meaning according to the table shown below.
		+	:::* All other characters are treated as insertion characters - see examples.
		+	:::* When DDD, DDDD, MMM or MMMM appear in all caps, the corresponding name will also be all upper case.
		+	:::: (Any other combination will display the day/month name using initial caps. Case has no meaning for d, dd, m, mm, yy and yyyy.)
		+
		+	{\| class="wikitable" style="margin-left: 80px;"
		+	\| '''Format Chars''' \|\| '''Meaning''' \|\| ''' Output Length'''
		+	\|-
		+	\| d, dd \|\| Day of month \|\| One or two digits. (dd is always two).
		+	\|-
		+	\| ddd, dddd \|\| Day name \|\| Three chars (ddd) or full name (dddd).
		+	\|-
		+	\| m, mm \|\| Month number \|\| One or two digits. (mm is always two).
		+	\|-
		+	\| mmm, mmmm \|\| Month name \|\| Three chars (mmm) or full name (mmmm).
		+	\|-
		+	\| yy, yyyy \|\| Year \|\| Two digits (yy) or four (yyyy).
		+	\|}
		+
		+	::*Examples:
		+
		+	{\| class="wikitable" style="margin-left: 80px;"
		+	\| '''Date Value''' \|\| '''Format''' \|\| ''' Result'''
		+	\|-
		+	\| 20160704 \|\| "mm/dd/yyyy" \|\| 07/04/2016
		+	\|-
		+	\| 20160704 \|\| "dd-MMM" \|\| 04-JUL
		+	\|-
		+	\| 20160704 \|\| "d-m-yy" \|\| 4-7-16
		+	\|-
		+	\| 20160714 \|\| "ddd mmmm d, yyyy" \|\| Thu July 14, 2016
		+	\|-
		+	\| 20160714 \|\| "DDDD MMMM DD, YY" \|\| THURSDAY JULY 14, 16
		+	\|}
		+
		+	::*For CYMD dates, these formats can be used as print formats (Visimage & AskPlus) and with '''!format()'''

← Older revision		Revision as of 20:46, 6 June 2023
Line 30:		Line 30:
	::(The user was intending to check the ASSOC-CODE, but selected the wrong field from the item list.)		::(The user was intending to check the ASSOC-CODE, but selected the wrong field from the item list.)
	:*Change ACCOUNT to ASSOC-CODE to clear the error.		:*Change ACCOUNT to ASSOC-CODE to clear the error.
		+
		+	===Creating SD Indexed Files===
		+	*Maximum filename length is 11 characters (for permanent files).
		+	*Maximum field name length is 20 characters.
		+	*Warning: Do '''not''' create a global variable with the same name as the SD Indexed filename.

@@ Line 27: / Line 27: @@
 </pre>
 *In this example, Visimage3 is trying to convert an X2 value "JT" into an numeric (I2).
-:*This error was caused by using an invalid selection criteria: ADDRESS-INFO.ACCOUNT = "JT".  (The user was intending to check the ASSOC-CODE, but selected the wrong field from the item list.)
+:*This error was caused by using an invalid selection criteria: ADDRESS-INFO.ACCOUNT = "JT".
 :*Change ACCOUNT to ASSOC-CODE to clear the error.

@@ Line 11: / Line 11: @@
 :*The value in the original X10 field is:  OX5 2LD
 :*The expression is: #add-own-zip = ADDRESS-INFO.ZIP
-:*In this example, the convert error is being caused by a foreign zip-code. Change the variable definition for ADD-OWN-ZIP from Numeric to '''Character, length 10'''.
+:*In this example, the convert error is being caused by a foreign zip-code.
 <pre>
 Error #138 in list execution:
@@ Line 19: / Line 20: @@
 :*Again we see that a Character value (X2) is being converted to a numeric (P20).
 :*The value that cannot be converted to a number is: TX
-:*This error was caused by attempting to total the MEMBER-FILE.STATE column. Remove the Total option to clear the error.
+:*This error was caused by attempting to total the MEMBER-FILE.STATE column.
 <pre>
 Error #138 in selection:
@@ Line 25: / Line 27: @@
 </pre>
 *In this example, Visimage3 is trying to convert an X2 value "JT" into an numeric (I2).
-*This error was caused by using an invalid selection criteria: ADDRESS-INFO.ACCOUNT = "JT".  (The user was intending to check the ASSOC-CODE, but selected the wrong field from the item list.) Change ACCOUNT to ASSOC-CODE to clear the error.
+:*This error was caused by using an invalid selection criteria: ADDRESS-INFO.ACCOUNT = "JT".  (The user was intending to check the ASSOC-CODE, but selected the wrong field from the item list.)

@@ Line 22: / Line 22: @@
 <pre>
 Error #138 in selection:
-Convert Error - Invalid Digit:(X5 -> I2) "JOINT"
+Convert Error - Invalid Digit:(X2 -> I2) "JT"
 </pre>

@@ Line 3: / Line 3: @@
 ===Convert Error===
 <pre>
 Convert Error - Invalid Digit:(X10 -> P20) OX5 2LD
 reg:#add-own-zip exp:ADDRESS-INFO.ZIP
@@ Line 13: / Line 14: @@
 <pre>
 Error #138 in list execution:
 Convert Error - Invalid Digit:(X2 -> P20) TX
 </pre>
@@ Line 20: / Line 20: @@
 :*The value that cannot be converted to a number is: TX
 :*This error was caused by attempting to total the MEMBER-FILE.STATE column. Remove the Total option to clear the error.

← Older revision		Revision as of 16:26, 6 June 2023
Line 11:		Line 11:
	:*The expression is: #add-own-zip = ADDRESS-INFO.ZIP		:*The expression is: #add-own-zip = ADDRESS-INFO.ZIP
	:*In this example, the convert error is being caused by a foreign zip-code. Change the variable definition for ADD-OWN-ZIP from Numeric to '''Character, length 10'''.		:*In this example, the convert error is being caused by a foreign zip-code. Change the variable definition for ADD-OWN-ZIP from Numeric to '''Character, length 10'''.
		+	<pre>
		+	Convert Error - Invalid Digit:(X2 -> P20) TX
		+	</pre>
		+	*In this example, there is less information displayed. That indicates, that this error does not involve a variable compute statement.
		+	:*Again we see that a Character value (X2) is being converted to a numeric (P20).
		+	:*The value that cannot be converted to a number is: TX
		+	:*This error was caused by attempting to total the MEMBER-FILE.STATE column. Remove the Total option to clear the error.

← Older revision		Revision as of 16:19, 6 June 2023
Line 1:		Line 1:
	==Visimage3 Frequently Asked Questions==		==Visimage3 Frequently Asked Questions==
		+
		+	===Convert Error===
		+	<pre>
		+	Convert Error - Invalid Digit:(X10 -> P20) OX5 2LD
		+	reg:#add-own-zip exp:ADDRESS-INFO.ZIP
		+	</pre>
		+	*The error message contains useful information to help isolate the issue:
		+	:*Visimage3 is trying to convert a character, length 10, value (X10) to a numeric (P20) value.
		+	:*The value in the original X10 field is: OX5 2LD
		+	:*The expression is: #add-own-zip = ADDRESS-INFO.ZIP
		+	:*In this example, the convert error is being caused by a foreign zip-code. Change the variable definition for ADD-OWN-ZIP from Numeric to '''Character, length 10'''.