APM and MS Fax Blank Title 117455

Yahoo Archive
1
Actually, that was part of the problem. With APM expecting a digit to recognize the value, we couldn't have a leading left parenthesis that Microsoft says is required for them to detect dialing rules. Striping them off fixed APM, but broke MS Fax. (Yes, we could have changed APM to expect the right parenthesis, but then international numbers wouldn't work) We have just opted to add the 1 digit ourselves and not rely on MS Fax and the dialing rules.

--- In vantage@yahoogroups.com, Karen Schoenung wrote:
>
> We are not yet using FAX, but there are several "integrated" forms for Epicor that come with APM 2.6 and they show the Documents matching these criteria (in the routing list)...Primary Fax number (property), begins with (condition), [1234567890](Value1). I don't know if this will help you or not...The value has brackets, not parenthesis...
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Vonderhaar
> Sent: Wednesday, January 16, 2013 8:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] APM and MS Fax
>
>
>
> We are using APM with MS Fax and have run into an issue with long distance fax numbers. According to Microsoft, the fax number needs to be in canonical format +1 (123) 456-7890 for the dialing rule to detect US long distance correctly. Doc-link out of the box is looking for only digits to detect if the data is a valid fax number. Anyone with experience to say what the fax number format really needs to be and what they have done with Doc-link to deal with this? I can easily change Doclink to expect a left parenthesis, but what about international numbers that won't have parentheses.
>
> Thanks,
> Tim
>
>
>
> [Non-text portions of this message have been removed]
>
2
We are using APM with MS Fax and have run into an issue with long distance fax numbers. According to Microsoft, the fax number needs to be in canonical format +1 (123) 456-7890 for the dialing rule to detect US long distance correctly. Doc-link out of the box is looking for only digits to detect if the data is a valid fax number. Anyone with experience to say what the fax number format really needs to be and what they have done with Doc-link to deal with this? I can easily change Doclink to expect a left parenthesis, but what about international numbers that won't have parentheses.

Thanks,
Tim
3
APM uses VB coding, so you can do an manipulations needed in the ERM Script to convert your inputs into what MS Fax needs.

Greg Payne

here is an elaborate sample from their admin guide.




To extract a value that floats on the page (in this example an order total that looks like "** ORDER TOTAL ** 1603.95"):

'Declare variables used in script.

Dim strText

Dim strNumb

Dim strSearch

Dim strTemp

Dim intPos

Dim i

'If not value found in Property Value, then exit.

if Len(PropertyValue) = 0 then

Exit Function

end if

'String to search for.

strSearch = "** ORDER TOTAL **"

'Put text found in variable for manipulation.

strText = PropertyValue

'Search for "** ORDER TOTAL **" in text.

intPos = InStr(1, strText, strSearch, vbTextCompare)

'If header string not found, then exit.

if intPos = 0 then

Exit Function

end if

'Trim off header.

strText = Trim(Right(strText, Len(strText) - (intPos + Len(strSearch))))

'Loop through remaining text to dig out number.

For i = 1 To Len(strText)

strTemp = Mid(strText, i, 1)

'If it is numeric, then build number string.

If IsNumeric(strTemp) Then

strNumb = strNumb & strTemp

'Make sure we include decimal in number.

Else if strTemp = "." Then

strNumb = strNumb & strTemp

Else

'Number is done, so exit loop.

Exit For

End If

Next

'Return the results.
TextOut = strNumb

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Vonderhaar
Sent: Wednesday, January 16, 2013 9:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] APM and MS Fax



We are using APM with MS Fax and have run into an issue with long distance fax numbers. According to Microsoft, the fax number needs to be in canonical format +1 (123) 456-7890 for the dialing rule to detect US long distance correctly. Doc-link out of the box is looking for only digits to detect if the data is a valid fax number. Anyone with experience to say what the fax number format really needs to be and what they have done with Doc-link to deal with this? I can easily change Doclink to expect a left parenthesis, but what about international numbers that won't have parentheses.

Thanks,
Tim


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
4
We are running the same environment.

I did not see that parentheses are required, only that a 1 was needed
for calls outside of our area code.

I'm formatting the phone number in Doc-link to prefix the number with a
1 if the first digit is not a "1" or "0".

I did this by creating a script on the ERM Property for the fax number.
We also have the added code to make sure the fax number is at least 10
characters long. If it is not, I blank it out so that an email is sent
telling the CS rep that there was a bad fax number.

What I don't have any experience with is international numbers.

My hope is that it is entered into Epicor correctly.



Here is my script:



if (Len(PropertyValue) < 10) then

TextOut = ""

else

If ((Left(PropertyValue, 1) <> "1") AND (Left(PropertyValue, 1) <> "0"))
Then

TextOut = "1-" & PropertyValue



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tim Vonderhaar
Sent: Wednesday, January 16, 2013 9:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] APM and MS Fax





We are using APM with MS Fax and have run into an issue with long
distance fax numbers. According to Microsoft, the fax number needs to be
in canonical format +1 (123) 456-7890 for the dialing rule to detect US
long distance correctly. Doc-link out of the box is looking for only
digits to detect if the data is a valid fax number. Anyone with
experience to say what the fax number format really needs to be and what
they have done with Doc-link to deal with this? I can easily change
Doclink to expect a left parenthesis, but what about international
numbers that won't have parentheses.

Thanks,
Tim










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
5
We are not yet using FAX, but there are several "integrated" forms for Epicor that come with APM 2.6 and they show the Documents matching these criteria (in the routing list)...Primary Fax number (property), begins with (condition), [1234567890](Value1). I don't know if this will help you or not...The value has brackets, not parenthesis...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Vonderhaar
Sent: Wednesday, January 16, 2013 8:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] APM and MS Fax



We are using APM with MS Fax and have run into an issue with long distance fax numbers. According to Microsoft, the fax number needs to be in canonical format +1 (123) 456-7890 for the dialing rule to detect US long distance correctly. Doc-link out of the box is looking for only digits to detect if the data is a valid fax number. Anyone with experience to say what the fax number format really needs to be and what they have done with Doc-link to deal with this? I can easily change Doclink to expect a left parenthesis, but what about international numbers that won't have parentheses.

Thanks,
Tim



[Non-text portions of this message have been removed]
6
Ah, there's the key. If Microsoft isn't going to decode the area code properly, I can do it myself with the ERM property. I can leave everything alone, just strip off any non-digits, do a right(value,3) and test for not equal to my area code and concatenate a 1 digit to the value.

Thanks!

--- In vantage@yahoogroups.com, Joe Rojas wrote:
>
> We are running the same environment.
>
> I did not see that parentheses are required, only that a 1 was needed
> for calls outside of our area code.
>
> I'm formatting the phone number in Doc-link to prefix the number with a
> 1 if the first digit is not a "1" or "0".
>
> I did this by creating a script on the ERM Property for the fax number.
> We also have the added code to make sure the fax number is at least 10
> characters long. If it is not, I blank it out so that an email is sent
> telling the CS rep that there was a bad fax number.
>
> What I don't have any experience with is international numbers.
>
> My hope is that it is entered into Epicor correctly.
>
>
>
> Here is my script:
>
>
>
> if (Len(PropertyValue) < 10) then
>
> TextOut = ""
>
> else
>
> If ((Left(PropertyValue, 1) <> "1") AND (Left(PropertyValue, 1) <> "0"))
> Then
>
> TextOut = "1-" & PropertyValue
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Tim Vonderhaar
> Sent: Wednesday, January 16, 2013 9:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] APM and MS Fax
>
>
>
>
>
> We are using APM with MS Fax and have run into an issue with long
> distance fax numbers. According to Microsoft, the fax number needs to be
> in canonical format +1 (123) 456-7890 for the dialing rule to detect US
> long distance correctly. Doc-link out of the box is looking for only
> digits to detect if the data is a valid fax number. Anyone with
> experience to say what the fax number format really needs to be and what
> they have done with Doc-link to deal with this? I can easily change
> Doclink to expect a left parenthesis, but what about international
> numbers that won't have parentheses.
>
> Thanks,
> Tim
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>
7
I don't think you have to make it that complicated, assuming we are
talking about US phone numbers.

You can just prefix the number for a "1" every time, even if it is in
your area code.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tim Vonderhaar
Sent: Wednesday, January 16, 2013 3:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: APM and MS Fax





Ah, there's the key. If Microsoft isn't going to decode the area code
properly, I can do it myself with the ERM property. I can leave
everything alone, just strip off any non-digits, do a right(value,3) and
test for not equal to my area code and concatenate a 1 digit to the
value.

Thanks!

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Joe
Rojas wrote:
>
> We are running the same environment.
>
> I did not see that parentheses are required, only that a 1 was needed
> for calls outside of our area code.
>
> I'm formatting the phone number in Doc-link to prefix the number with
a
> 1 if the first digit is not a "1" or "0".
>
> I did this by creating a script on the ERM Property for the fax
number.
> We also have the added code to make sure the fax number is at least 10
> characters long. If it is not, I blank it out so that an email is sent
> telling the CS rep that there was a bad fax number.
>
> What I don't have any experience with is international numbers.
>
> My hope is that it is entered into Epicor correctly.
>
>
>
> Here is my script:
>
>
>
> if (Len(PropertyValue) < 10) then
>
> TextOut = ""
>
> else
>
> If ((Left(PropertyValue, 1) <> "1") AND (Left(PropertyValue, 1) <>
"0"))
> Then
>
> TextOut = "1-" & PropertyValue
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Tim Vonderhaar
> Sent: Wednesday, January 16, 2013 9:06 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] APM and MS Fax
>
>
>
>
>
> We are using APM with MS Fax and have run into an issue with long
> distance fax numbers. According to Microsoft, the fax number needs to
be
> in canonical format +1 (123) 456-7890 for the dialing rule to detect
US
> long distance correctly. Doc-link out of the box is looking for only
> digits to detect if the data is a valid fax number. Anyone with
> experience to say what the fax number format really needs to be and
what
> they have done with Doc-link to deal with this? I can easily change
> Doclink to expect a left parenthesis, but what about international
> numbers that won't have parentheses.
>
> Thanks,
> Tim
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]