Service Connect - Workflow Programming Question

Yahoo Archive
1
I'm wondering why the Scala developers didn't do something a bit more complete here. This may be a limitation of the underlying XSLT support that SC uses: XSLT 1.0 doesn't have regular expressions or string replacement, XSLT 2.0 does.

I wonder if you can roll your own in some way?

http://geekswithblogs.net/Erik/archive/2008/04/01/120915.aspx

Ultimately the field mapping editor is just creating an XSLT document. The above example shows a recursive approach using an XSLT template. You might be able to do this anyways with a little fiddling.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Blake Clemens
Sent: Monday, June 15, 2009 10:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect - Workflow Programming Question

I am using the translate functoid. I guess I was hoping for an easy
solution like just encasing the word with a certain kind of punctuation.




Thanks,

Blake Clemens

DMC

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Monday, June 15, 2009 9:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect - Workflow Programming Question








Blake, I assume you're using the translate functoid. As I read the
definition of this functoid, it says that it "returns the first argument
with occurrences of characters in the second argument that have been
replaced by the character located at the corresponding position in the
third argument".

This is basically the equivalent of the Unix "tr" command.

I'm not sure there's a direct way to do what you want. You could try
something like a multi-step functoid chain where you use
substring-before and substring-after to return the portions of the
description containing the first occurrence of "right" and manually
substitute "left" in a string built via "contact" but that wouldn't
handle multiple occurrences, and you'd have to also handle the case
where you have no more substitutions to make (otherwise you'd get an
empty string).

Huh.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Blake Clemens
Sent: Monday, June 15, 2009 9:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Service Connect - Workflow Programming Question

I am trying to modify an existing workflow, one that will update the
Date on existing sales orders and their jobs. I want to also change
words within the description as well. I have this working but there is a
"glitch" that I can't seem to figure out. Its easier for me to show
examples of what is happening. I want to replace the word "Left" with
the word "Right". But it's taking each letter and replacing them
sperately through the entire description instead of looking for the word
"Left" and replacing it with the word "Right". See example below. My
question is what do I have to do to program Service Connect to look for
the entire word and not just individual letters. I've tried putting ""
around the words and %% around the words but neither of them worked.
Does anyone out there in user group land have the solution?

Correct description:

2-Panel OX Left Hand Patio Unit 6/0x6/8 D15 Low E Smooth Fiberglass
Raise/Lower GBG Low E 2-Bore 2-3/8 Backset 5-1/2 On Center 6-9/16
Primed Jambs US32D 4x4 5/8xSQ Hinges PVC Brickmould No Screen No
Transom

Description after workflow:

2-Panil OX Righ Hand Pahio Unih 6/0x6/8 D15 Row E Smoohh Fibirglass
Raisi/Rowir GBG Row E 2-Bori 2-3/8 Backsih 5-1/2 On Cinhir 6-9/16
Primid Jambs US32D 4x4 5/8xSQ Hingis PVC Brickmould No Scriin No
Transom

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
I am trying to modify an existing workflow, one that will update the
Date on existing sales orders and their jobs. I want to also change
words within the description as well. I have this working but there is a
"glitch" that I can't seem to figure out. Its easier for me to show
examples of what is happening. I want to replace the word "Left" with
the word "Right". But it's taking each letter and replacing them
sperately through the entire description instead of looking for the word
"Left" and replacing it with the word "Right". See example below. My
question is what do I have to do to program Service Connect to look for
the entire word and not just individual letters. I've tried putting ""
around the words and %% around the words but neither of them worked.
Does anyone out there in user group land have the solution?



Correct description:

2-Panel OX Left Hand Patio Unit 6/0x6/8 D15 Low E Smooth Fiberglass
Raise/Lower GBG Low E 2-Bore 2-3/8 Backset 5-1/2 On Center 6-9/16
Primed Jambs US32D 4x4 5/8xSQ Hinges PVC Brickmould No Screen No
Transom



Description after workflow:

2-Panil OX Righ Hand Pahio Unih 6/0x6/8 D15 Row E Smoohh Fibirglass
Raisi/Rowir GBG Row E 2-Bori 2-3/8 Backsih 5-1/2 On Cinhir 6-9/16
Primid Jambs US32D 4x4 5/8xSQ Hingis PVC Brickmould No Scriin No
Transom





Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



***Privileged & Confidential***



This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.





[Non-text portions of this message have been removed]
3
Blake, I assume you're using the translate functoid. As I read the definition of this functoid, it says that it "returns the first argument with occurrences of characters in the second argument that have been replaced by the character located at the corresponding position in the third argument".

This is basically the equivalent of the Unix "tr" command.

I'm not sure there's a direct way to do what you want. You could try something like a multi-step functoid chain where you use substring-before and substring-after to return the portions of the description containing the first occurrence of "right" and manually substitute "left" in a string built via "contact" but that wouldn't handle multiple occurrences, and you'd have to also handle the case where you have no more substitutions to make (otherwise you'd get an empty string).

Huh.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Blake Clemens
Sent: Monday, June 15, 2009 9:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect - Workflow Programming Question

I am trying to modify an existing workflow, one that will update the
Date on existing sales orders and their jobs. I want to also change
words within the description as well. I have this working but there is a
"glitch" that I can't seem to figure out. Its easier for me to show
examples of what is happening. I want to replace the word "Left" with
the word "Right". But it's taking each letter and replacing them
sperately through the entire description instead of looking for the word
"Left" and replacing it with the word "Right". See example below. My
question is what do I have to do to program Service Connect to look for
the entire word and not just individual letters. I've tried putting ""
around the words and %% around the words but neither of them worked.
Does anyone out there in user group land have the solution?



Correct description:

2-Panel OX Left Hand Patio Unit 6/0x6/8 D15 Low E Smooth Fiberglass
Raise/Lower GBG Low E 2-Bore 2-3/8 Backset 5-1/2 On Center 6-9/16
Primed Jambs US32D 4x4 5/8xSQ Hinges PVC Brickmould No Screen No
Transom



Description after workflow:

2-Panil OX Righ Hand Pahio Unih 6/0x6/8 D15 Row E Smoohh Fibirglass
Raisi/Rowir GBG Row E 2-Bori 2-3/8 Backsih 5-1/2 On Cinhir 6-9/16
Primid Jambs US32D 4x4 5/8xSQ Hingis PVC Brickmould No Scriin No
Transom





Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



***Privileged & Confidential***



This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.





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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
I am using the translate functoid. I guess I was hoping for an easy
solution like just encasing the word with a certain kind of punctuation.




Thanks,

Blake Clemens

DMC

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Monday, June 15, 2009 9:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect - Workflow Programming Question








Blake, I assume you're using the translate functoid. As I read the
definition of this functoid, it says that it "returns the first argument
with occurrences of characters in the second argument that have been
replaced by the character located at the corresponding position in the
third argument".

This is basically the equivalent of the Unix "tr" command.

I'm not sure there's a direct way to do what you want. You could try
something like a multi-step functoid chain where you use
substring-before and substring-after to return the portions of the
description containing the first occurrence of "right" and manually
substitute "left" in a string built via "contact" but that wouldn't
handle multiple occurrences, and you'd have to also handle the case
where you have no more substitutions to make (otherwise you'd get an
empty string).

Huh.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Blake Clemens
Sent: Monday, June 15, 2009 9:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Service Connect - Workflow Programming Question

I am trying to modify an existing workflow, one that will update the
Date on existing sales orders and their jobs. I want to also change
words within the description as well. I have this working but there is a
"glitch" that I can't seem to figure out. Its easier for me to show
examples of what is happening. I want to replace the word "Left" with
the word "Right". But it's taking each letter and replacing them
sperately through the entire description instead of looking for the word
"Left" and replacing it with the word "Right". See example below. My
question is what do I have to do to program Service Connect to look for
the entire word and not just individual letters. I've tried putting ""
around the words and %% around the words but neither of them worked.
Does anyone out there in user group land have the solution?

Correct description:

2-Panel OX Left Hand Patio Unit 6/0x6/8 D15 Low E Smooth Fiberglass
Raise/Lower GBG Low E 2-Bore 2-3/8 Backset 5-1/2 On Center 6-9/16
Primed Jambs US32D 4x4 5/8xSQ Hinges PVC Brickmould No Screen No
Transom

Description after workflow:

2-Panil OX Righ Hand Pahio Unih 6/0x6/8 D15 Row E Smoohh Fibirglass
Raisi/Rowir GBG Row E 2-Bori 2-3/8 Backsih 5-1/2 On Cinhir 6-9/16
Primid Jambs US32D 4x4 5/8xSQ Hingis PVC Brickmould No Scriin No
Transom

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





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