Customization help

Just an FYI on the older platforms at least - 9.04 and 9.05 - but on this character count topic:

We had a person here who quietly discovered that if a user copies out comment or description field into a separate editor and continues to add to them, that upon copying and pasting back into those fields, he could keep virtually limitless data.  We have part descriptions exceeding 4500 characters and comment fields approaching 16K characters.  Forms when used, simply showed their visible limits as they will.  His mistake was that he happened to also paste in data with a bunch of ASCII character code 30 - RS or the record separator.  It is of course unprintable and invisible in most editors like notepad and WORD.  But because it is unprintable, it broke a report that included the description field of one of his records.


Needless to say, as we deploy Epicor 10, I've ratcheted down the character limits in Extended Properties and the copy/paste bypass also seems to have been patched.  Thought you all might find this amusing and perhaps a warning if you were not aware of the loophole.

-Henry

Does anyone have code that will count the number of characters in a field within Epicor? We are running Epicor 9.05.702a on a 64bit Progress database and in the QuoteDtl Line Comments the field length is set to 16000x but the ODBC restriction is 1000x. I would like to add a customized field to the form that will show the character count while a user is typing information into the Quote Comment field. Seems like is should be easy enough but, I have not found a way to do this and I am not a coder.

Any help is appreciated, thanks!
 
Lori Gustafson
IR Manager
Precision, Inc.

I used this to check and see if the reason entered had a space in it.  You should be able to use it to do about the same thing, just if it is not blank add one to your counter.

 

   DO iCount = 1 TO lenny:

               iSub = Substring(ttCallContextBPMData.Character01, iCount, 1).

               IF isub = " " THEN FOUND = TRUE.

   END.

 

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 02, 2016 12:47 PM
To: yahoogroups
Subject: [Vantage] Customization help

 

 

Does anyone have code that will count the number of characters in a field within Epicor? We are running Epicor 9.05.702a on a 64bit Progress database and in the QuoteDtl Line Comments the field length is set to 16000x but the ODBC restriction is 1000x. I would like to add a customized field to the form that will show the character count while a user is typing information into the Quote Comment field. Seems like is should be easy enough but, I have not found a way to do this and I am not a coder.

 

Any help is appreciated, thanks!

 

Lori Gustafson

IR Manager

Precision, Inc.

OR… duh…  lenny = Length(ttCallContextBPMData.Character01).  

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 02, 2016 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization help

 

 

I used this to check and see if the reason entered had a space in it.  You should be able to use it to do about the same thing, just if it is not blank add one to your counter.

 

   DO iCount = 1 TO lenny:

               iSub = Substring(ttCallContextBPMData.Character01, iCount, 1).

               IF isub = " " THEN FOUND = TRUE.

   END.

 

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 02, 2016 12:47 PM
To: yahoogroups
Subject: [Vantage] Customization help

 

 

Does anyone have code that will count the number of characters in a field within Epicor? We are running Epicor 9.05.702a on a 64bit Progress database and in the QuoteDtl Line Comments the field length is set to 16000x but the ODBC restriction is 1000x. I would like to add a customized field to the form that will show the character count while a user is typing information into the Quote Comment field. Seems like is should be easy enough but, I have not found a way to do this and I am not a coder.

 

Any help is appreciated, thanks!

 

Lori Gustafson

IR Manager

Precision, Inc.

Sometimes I just try to do to much at one time and miss the actual right code – sorry one of those days.

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 02, 2016 1:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization help

 

 

OR… duh…  lenny = Length(ttCallContextBPMData.Character01).  

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 02, 2016 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization help

 

 

I used this to check and see if the reason entered had a space in it.  You should be able to use it to do about the same thing, just if it is not blank add one to your counter.

 

   DO iCount = 1 TO lenny:

               iSub = Substring(ttCallContextBPMData.Character01, iCount, 1).

               IF isub = " " THEN FOUND = TRUE.

   END.

 

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 02, 2016 12:47 PM
To: yahoogroups
Subject: [Vantage] Customization help

 

 

Does anyone have code that will count the number of characters in a field within Epicor? We are running Epicor 9.05.702a on a 64bit Progress database and in the QuoteDtl Line Comments the field length is set to 16000x but the ODBC restriction is 1000x. I would like to add a customized field to the form that will show the character count while a user is typing information into the Quote Comment field. Seems like is should be easy enough but, I have not found a way to do this and I am not a coder.

 

Any help is appreciated, thanks!

 

Lori Gustafson

IR Manager

Precision, Inc.

I don’t know how to display the count as you type, but if you go to Utilities > Extended Properties

 

Enter quotedtl and look for QuoteComment field.  Then enter X(999) as the format, it will limit to 999 characters.  I think the default is 1000, but in the form it is 16000.

 

The user wont know how many characters are there but they will get a Pop up warning.  You can put a text field stating they are limited to 1000 Characters.

 

9.05.702A Prog 64

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 2, 2016 9:47 AM
To: yahoogroups <vantage@yahoogroups.com>
Subject: [Vantage] Customization help

 

 

Does anyone have code that will count the number of characters in a field within Epicor? We are running Epicor 9.05.702a on a 64bit Progress database and in the QuoteDtl Line Comments the field length is set to 16000x but the ODBC restriction is 1000x. I would like to add a customized field to the form that will show the character count while a user is typing information into the Quote Comment field. Seems like is should be easy enough but, I have not found a way to do this and I am not a coder.

 

Any help is appreciated, thanks!

 

Lori Gustafson

IR Manager

Precision, Inc.



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

Thank you so much for sharing this information, Miguel's solution works perfect for what we need but I will keep the other codes for future reference.
 
Lori Gustafson
IR Manager
Precision, Inc.


On Wednesday, March 2, 2016 12:14 PM, "Miguel Santillan msantillan@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-1798883362yiv1655878734ygrp-text">
  
  
  <div>
 
Enter quotedtl and look for QuoteComment field.  Then enter X(999) as the format, it will limit to 999 characters.  I think the default is 1000, but in the form it is 16000.
 
The user wont know how many characters are there but they will get a Pop up warning.  You can put a text field stating they are limited to 1000 Characters.
 
9.05.702A Prog 64
 
Miguel A. Santillan
Compass Manufacturing Systems
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 2, 2016 9:47 AM
To: yahoogroups <vantage@yahoogroups.com>
Subject: [Vantage] Customization help
 
 
Does anyone have code that will count the number of characters in a field within Epicor? We are running Epicor 9.05.702a on a 64bit Progress database and in the QuoteDtl Line Comments the field length is set to 16000x but the ODBC restriction is 1000x. I would like to add a customized field to the form that will show the character count while a user is typing information into the Quote Comment field. Seems like is should be easy enough but, I have not found a way to do this and I am not a coder.
 
Any help is appreciated, thanks!
 
Lori Gustafson
IR Manager
Precision, Inc.


Disclaimer
The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

</div>
 


<div class="ygrps-yiv-1798883362yiv1655878734yqt6712855615" id="ygrps-yiv-1798883362yiv1655878734yqt42832"><div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734 -- #ygrps-yiv-1798883362yiv1655878734ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mkp #ygrps-yiv-1798883362yiv1655878734hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mkp #ygrps-yiv-1798883362yiv1655878734ads {
margin-bottom:10px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mkp .ygrps-yiv-1798883362yiv1655878734ad {
padding:0 0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mkp .ygrps-yiv-1798883362yiv1655878734ad p {
margin:0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mkp .ygrps-yiv-1798883362yiv1655878734ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-sponsor #ygrps-yiv-1798883362yiv1655878734ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-sponsor #ygrps-yiv-1798883362yiv1655878734ygrp-lc #ygrps-yiv-1798883362yiv1655878734hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-sponsor #ygrps-yiv-1798883362yiv1655878734ygrp-lc .ygrps-yiv-1798883362yiv1655878734ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734activity span {
font-weight:700;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734activity span span {
color:#ff7900;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734activity span .ygrps-yiv-1798883362yiv1655878734underline {
text-decoration:underline;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734attach div a {
text-decoration:none;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734attach label a {
text-decoration:none;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734bold a {
text-decoration:none;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 dd.ygrps-yiv-1798883362yiv1655878734last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 dd.ygrps-yiv-1798883362yiv1655878734last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 dd.ygrps-yiv-1798883362yiv1655878734last p span.ygrps-yiv-1798883362yiv1655878734yshortcuts {
margin-right:0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734attach-table {
width:400px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734file-title a, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734file-title a:active, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734file-title a:hover, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734photo-title a, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734photo-title a:active, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734photo-title a:hover, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div.ygrps-yiv-1798883362yiv1655878734photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 div#ygrps-yiv-1798883362yiv1655878734ygrp-mlmsg #ygrps-yiv-1798883362yiv1655878734ygrp-msg p a span.ygrps-yiv-1798883362yiv1655878734yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734green {
color:#628c2a;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 o {
font-size:0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734photos div {
float:left;width:72px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734reco-category {
font-size:77%;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734reco-desc {
font-size:77%;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 .ygrps-yiv-1798883362yiv1655878734replbq {
margin:4px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mlmsg select, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 input, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mlmsg pre, #ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 code {
font:115% monospace;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-mlmsg #ygrps-yiv-1798883362yiv1655878734logo {
padding-bottom:10px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-msg p#ygrps-yiv-1798883362yiv1655878734attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-reco #ygrps-yiv-1798883362yiv1655878734reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-sponsor #ygrps-yiv-1798883362yiv1655878734ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-sponsor #ygrps-yiv-1798883362yiv1655878734ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-sponsor #ygrps-yiv-1798883362yiv1655878734ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1798883362 #ygrps-yiv-1798883362yiv1655878734 #ygrps-yiv-1798883362yiv1655878734ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1798883362