Service Connect Question

system · February 4, 2014, 1:46pm

The XML mapper does not create a â€œfor-eachâ€ for the row element

The table to table link produces this (which copies all the rows)

<xsl:element name="msg:dta">

<xsl:if test="msg:dta/dta:table/*">

<xsl:element name="dta:table">

<xsl:copy-of select="msg:dta/dta:table/*"></xsl:copy-of>

</xsl:element>

</xsl:if>

</xsl:element>

The row to row link produces this (which copies all the data into a single row element??)

<xsl:element name="msg:dta">

<xsl:element name="dta:table">

<xsl:if test="msg:dta/dta:table/dta:row/*">

<xsl:element name="dta:row">

<xsl:copy-of select="msg:dta/dta:table/dta:row/*"></xsl:copy-of>

</xsl:element>

</xsl:if>

</xsl:element>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Tuesday, February 04, 2014 9:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect Question

If I link row to row and apply the link condition, the correct data maps but the table / row structure is broken â€“ I am not sure what you mean here? As long as your link shows â€œfor eachâ€ you should get all rows that meet the conditionâ€¦

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bwalker@...
Sent: Monday, February 03, 2014 6:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Question

I have a csv file to process. The data could contain hundreds of rows I do not wish to process and a few that I do. How can I configure my first conversion to only map the rows that I want to process? If I link table to table then apply a link condition on a column in the row, no data is mapped. If I link row to row and apply the link condition, the correct data maps but the table / row structure is broken

system · January 13, 2008, 7:26pm

Hi all,

Is there anyway that I can deploy a Service Connect package into a site
server with only Service Connect Runtime license installed?

I am using Vantage 8.03.4

Many thanks for any response.

Tew
TDS

system · May 27, 2010, 7:50pm

For reasons I don't care to go into, Our ESCDB database was inaccesible for a period of time. Service Connect input channels continued to run on schedule. Workflows that did not have logging enabled ran without incident. Others, including some that pick up a text file every 30 minutes to write data to Vantage errored when they could not write logging info. The input channel obviously deleted the text files.....

Data has been lost and I will be needing a ring for my chair at work....

Has anyone come up with a way to archive the incoming data for later reference using standard Service connect tools?

If not I will be adding that as a 'feature' to the text conversion dll

system · May 28, 2010, 10:01am

Not that its something you want to do every time, or even if this method
is the best one out there, but in some applications its standard
practice for me to immediately save the file (typically in its native
format (csv, xml, xls) into a network drive location before you do
anything else with your work flow. This has saved us several times when
things went awry. Depending on traffic, obviously you may want to think
about how you'll manage that archive if drive space is a concern.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: Thursday, May 27, 2010 6:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Question

For reasons I don't care to go into, Our ESCDB database was inaccesible
for a period of time. Service Connect input channels continued to run on
schedule. Workflows that did not have logging enabled ran without
incident. Others, including some that pick up a text file every 30
minutes to write data to Vantage errored when they could not write
logging info. The input channel obviously deleted the text files.....

Data has been lost and I will be needing a ring for my chair at work....

Has anyone come up with a way to archive the incoming data for later
reference using standard Service connect tools?

If not I will be adding that as a 'feature' to the text conversion dll

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

system · May 2, 2012, 1:37pm

In Service Connect I want to put the date 03/15/2011 into a date field.
My csv input file contains the text string "03/15/2011" and I'm trying to use the toDateTime functiod but I'm getting an error. Is there a specific format for the input value?

Or how else can I do this?

system · May 2, 2012, 2:06pm

Vantage Dates must be in yyyy-mm-DD format through Service Connect. You can use a data string functoid to convert it.

Christopher W. Marsch
IT/Database Administrator
Mechanical Dynamics & Analysis, Ltd.
19E British American Blvd.
Latham, NY 12110
(518) 399-3616 x272
Cell: (518) 795-0200

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of carl.heeder
Sent: Wednesday, May 02, 2012 1:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Question

In Service Connect I want to put the date 03/15/2011 into a date field.
My csv input file contains the text string "03/15/2011" and I'm trying to use the toDateTime functiod but I'm getting an error. Is there a specific format for the input value?

Or how else can I do this?

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

system · May 2, 2012, 2:13pm

Use the DateTimeFromString functoid, and use MM/DD/YYYY as your format. Should convert it to something usable by service connect.

--Matt

--- In vantage@yahoogroups.com, "carl.heeder" <carl.heeder@...> wrote:
>
> In Service Connect I want to put the date 03/15/2011 into a date field.
> My csv input file contains the text string "03/15/2011" and I'm trying to use the toDateTime functiod but I'm getting an error. Is there a specific format for the input value?
>
> Or how else can I do this?
>

system · May 2, 2012, 3:15pm

Some other pertinent date time info for service connect as well... essentially I believe in most cases service connect follows the W3C standard for xml. If you go to places like W3C.org or www.w3schools.com<http://www.w3schools.com> there is a lot of helpful information there if you find yourself having to dig deep on an xml format or issue. Granted it's not service connect specific, but they are using several of those protocols I believe. See below..

"Date-time and Duration formats are compatible with the w3org specification (http://www.w3.org/TR/xpath-functions/). So, for date-time the format is YYYY-MM-DDThh:mm:ss.(s), for duration: PnYnMnDTnHnMnS "

Specifically, the format is as follows:

Format for duration is PnYnMnDTnHnMnS

[-] P [?Y] [?M] [?D] [T [?H] [?M] [?.?S] ]

Optional "-" negative sign
Mandatory "P" signature
Optional years count (e.g. 25Y)
Optional months count (e.g. 13M)
Optional days count (e.g. 87D)
Optional time part, including:
6.1. Mandatory "T" time part signature

6.2. Optional hours count (e.g. 5H)

6.3. Optional minutes count (e.g. 17M)

6.4. Optional seconds count, can be fractional (e.g. 33S or 3.3S)

Zero duration can be written as PT0S. No blanks between any parts.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of carl.heeder
Sent: Wednesday, May 02, 2012 12:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Question

In Service Connect I want to put the date 03/15/2011 into a date field.
My csv input file contains the text string "03/15/2011" and I'm trying to use the toDateTime functiod but I'm getting an error. Is there a specific format for the input value?

Or how else can I do this?

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

system · May 2, 2012, 3:31pm

Worked great. I hadn't seen that functoid. Thanks

--- In vantage@yahoogroups.com, "mattcald_73" <matt@...> wrote:
>
> Use the DateTimeFromString functoid, and use MM/DD/YYYY as your format. Should convert it to something usable by service connect.
>
> --Matt
>
> --- In vantage@yahoogroups.com, "carl.heeder" <carl.heeder@> wrote:
> >
> > In Service Connect I want to put the date 03/15/2011 into a date field.
> > My csv input file contains the text string "03/15/2011" and I'm trying to use the toDateTime functiod but I'm getting an error. Is there a specific format for the input value?
> >
> > Or how else can I do this?
> >
>

system · October 3, 2012, 2:55pm

I have a ESC question I've been fighting with for a while. I'm bringing in orders via ESC that contain customer, header, and line information. To add the lines, I call a subworkflow. This works well as the Part Lines are an unbounded tag, so I can pass a single line to the subworkflow until all lines are added.

The area that I'm having problems is that the comments for each line are also within this cycle. But I need to roll them all up as a single comment that can be added to a memo. I haven't found a successful way to cycle through and add all these comments together so taht I can process them.

Does anyone know how to do this?

Thanks,

Ivan A. Wright
ivan@...

system · October 3, 2012, 3:16pm

I would think that you could use the string concatenation functoid, and append each line comment to the current header comment as it cycles through the lines.

--Matt

--- In vantage@yahoogroups.com, "vampman_gmail" <ivan@...> wrote:
>
> I have a ESC question I've been fighting with for a while. I'm bringing in orders via ESC that contain customer, header, and line information. To add the lines, I call a subworkflow. This works well as the Part Lines are an unbounded tag, so I can pass a single line to the subworkflow until all lines are added.
>
> The area that I'm having problems is that the comments for each line are also within this cycle. But I need to roll them all up as a single comment that can be added to a memo. I haven't found a successful way to cycle through and add all these comments together so taht I can process them.
>
> Does anyone know how to do this?
>
> Thanks,
>
> Ivan A. Wright
> ivan@...
>

system · October 3, 2012, 9:33pm

If Matt's suggestion doesn't work, you could always throw a really simple
BPM on it.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*

On Wed, Oct 3, 2012 at 3:16 PM, mattcald_73 <matt@...> wrote:

> **
>
>
> I would think that you could use the string concatenation functoid, and
> append each line comment to the current header comment as it cycles through
> the lines.
>
> --Matt
>
>
> --- In vantage@yahoogroups.com, "vampman_gmail" <ivan@...> wrote:
> >
> > I have a ESC question I've been fighting with for a while. I'm bringing
> in orders via ESC that contain customer, header, and line information. To
> add the lines, I call a subworkflow. This works well as the Part Lines are
> an unbounded tag, so I can pass a single line to the subworkflow until all
> lines are added.
> >
> > The area that I'm having problems is that the comments for each line are
> also within this cycle. But I need to roll them all up as a single comment
> that can be added to a memo. I haven't found a successful way to cycle
> through and add all these comments together so taht I can process them.
> >
> > Does anyone know how to do this?
> >
> > Thanks,
> >
> > Ivan A. Wright
> > ivan@...
> >
>
>
>

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

system · October 4, 2012, 1:51pm

If I'm doing a single call to SalesOrder UpdateExt with all the header and
detail information (so one call for an order of 10 lines rather than 11
calls through cycling) is there a way to roll up those comments to the
header level without cycling? This is something I've never found out how
to do in Service Connect.

Ivan

On Wed, Oct 3, 2012 at 6:33 PM, John Driggers <waffqle@...> wrote:

> If Matt's suggestion doesn't work, you could always throw a really simple
> BPM on it.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Wed, Oct 3, 2012 at 3:16 PM, mattcald_73 <matt@...> wrote:
>
> > **
> >
> >
> > I would think that you could use the string concatenation functoid, and
> > append each line comment to the current header comment as it cycles
> through
> > the lines.
> >
> > --Matt
> >
> >
> > --- In vantage@yahoogroups.com, "vampman_gmail" <ivan@...> wrote:
> > >
> > > I have a ESC question I've been fighting with for a while. I'm bringing
> > in orders via ESC that contain customer, header, and line information. To
> > add the lines, I call a subworkflow. This works well as the Part Lines
> are
> > an unbounded tag, so I can pass a single line to the subworkflow until
> all
> > lines are added.
> > >
> > > The area that I'm having problems is that the comments for each line
> are
> > also within this cycle. But I need to roll them all up as a single
> comment
> > that can be added to a memo. I haven't found a successful way to cycle
> > through and add all these comments together so taht I can process them.
> > >
> > > Does anyone know how to do this?
> > >
> > > Thanks,
> > >
> > > Ivan A. Wright
> > > ivan@...
> > >
> >
> >
> >
>
>
> [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
>
>
>
>

--

*Thanks,*

**

**
**

*Ivan A. Wright* | Systems Interface Development | NRS, Inc.

*2009 S. Main St. Moscow, ID 83843*

**

**ivan@... | www.nrsweb.com

p: 208.883.7834 Ext.262 | f: 208.882.1744

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

system · October 4, 2012, 4:36pm

What are you using to pass the data to Service Connect, XML, CSV, Excel, Another Application web service?

Christopher W. Marsch
IT/Database Administrator
Mechanical Dynamics & Analysis, Ltd.
19E British American Blvd.
Latham, NY 12110
(518) 399-3616 x272
Cell: (518) 795-0200

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ivan A. Wright
Sent: Thursday, October 04, 2012 1:51 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Service Connect Question

If I'm doing a single call to SalesOrder UpdateExt with all the header and
detail information (so one call for an order of 10 lines rather than 11
calls through cycling) is there a way to roll up those comments to the
header level without cycling? This is something I've never found out how
to do in Service Connect.

Ivan

On Wed, Oct 3, 2012 at 6:33 PM, John Driggers <waffqle@...<mailto:waffqle%40gmail.com>> wrote:

> If Matt's suggestion doesn't work, you could always throw a really simple
> BPM on it.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...<mailto:waffqle%40usdoingstuff.com>
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Wed, Oct 3, 2012 at 3:16 PM, mattcald_73 <matt@...<mailto:matt%40kerusso.com>> wrote:
>
> > **
> >
> >
> > I would think that you could use the string concatenation functoid, and
> > append each line comment to the current header comment as it cycles
> through
> > the lines.
> >
> > --Matt
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "vampman_gmail" <ivan@...<mailto:ivan@...>> wrote:
> > >
> > > I have a ESC question I've been fighting with for a while. I'm bringing
> > in orders via ESC that contain customer, header, and line information. To
> > add the lines, I call a subworkflow. This works well as the Part Lines
> are
> > an unbounded tag, so I can pass a single line to the subworkflow until
> all
> > lines are added.
> > >
> > > The area that I'm having problems is that the comments for each line
> are
> > also within this cycle. But I need to roll them all up as a single
> comment
> > that can be added to a memo. I haven't found a successful way to cycle
> > through and add all these comments together so taht I can process them.
> > >
> > > Does anyone know how to do this?
> > >
> > > Thanks,
> > >
> > > Ivan A. Wright
> > > ivan@...
> > >
> >
> >
> >
>
>
> [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
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>

--

*Thanks,*

**

**
**

*Ivan A. Wright* | Systems Interface Development | NRS, Inc.

*2009 S. Main St. Moscow, ID 83843*

**

**ivan@...<mailto:%2A%2Aivan%40nrsweb.com> | www.nrsweb.com<http://www.nrsweb.com>

p: 208.883.7834 Ext.262 | f: 208.882.1744

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

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

system · October 4, 2012, 7:22pm

Data is coming in as XML.

Thanks,

Ivan

On Thu, Oct 4, 2012 at 1:38 PM, Marsch, Chris <cmarsch@...>wrote:

> **
>
>
> What are you using to pass the data to Service Connect, XML, CSV, Excel,
> Another Application web service?
>
> Christopher W. Marsch
> IT/Database Administrator
> Mechanical Dynamics & Analysis, Ltd.
> 19E British American Blvd.
> Latham, NY 12110
> (518) 399-3616 x272
> Cell: (518) 795-0200
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ivan A. Wright
> Sent: Thursday, October 04, 2012 1:51 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: Service Connect Question
>
>
> If I'm doing a single call to SalesOrder UpdateExt with all the header and
> detail information (so one call for an order of 10 lines rather than 11
> calls through cycling) is there a way to roll up those comments to the
> header level without cycling? This is something I've never found out how
> to do in Service Connect.
>
> Ivan
>
> On Wed, Oct 3, 2012 at 6:33 PM, John Driggers <waffqle@...<mailto:
> waffqle%40gmail.com>> wrote:
>
> > If Matt's suggestion doesn't work, you could always throw a really simple
> > BPM on it.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...<mailto:waffqle%40usdoingstuff.com>
>
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> >
> >
> > On Wed, Oct 3, 2012 at 3:16 PM, mattcald_73 <matt@...<mailto:
> matt%40kerusso.com>> wrote:
> >
> > > **
> > >
> > >
> > > I would think that you could use the string concatenation functoid, and
> > > append each line comment to the current header comment as it cycles
> > through
> > > the lines.
> > >
> > > --Matt
> > >
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> "vampman_gmail" <ivan@...<mailto:ivan@...>> wrote:
> > > >
> > > > I have a ESC question I've been fighting with for a while. I'm
> bringing
> > > in orders via ESC that contain customer, header, and line information.
> To
> > > add the lines, I call a subworkflow. This works well as the Part Lines
> > are
> > > an unbounded tag, so I can pass a single line to the subworkflow until
> > all
> > > lines are added.
> > > >
> > > > The area that I'm having problems is that the comments for each line
> > are
> > > also within this cycle. But I need to roll them all up as a single
> > comment
> > > that can be added to a memo. I haven't found a successful way to cycle
> > > through and add all these comments together so taht I can process them.
> > > >
> > > > Does anyone know how to do this?
> > > >
> > > > Thanks,
> > > >
> > > > Ivan A. Wright
> > > > ivan@...
> > > >
> > >
> > >
> > >
> >
> >
> > [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
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
> >
>
> --
>
> *Thanks,*
>
> **
>
> **
> **
>
> *Ivan A. Wright* | Systems Interface Development | NRS, Inc.
>
> *2009 S. Main St. Moscow, ID 83843*
>
> **
>
> **ivan@...<mailto:%2A%2Aivan%40nrsweb.com> | www.nrsweb.com<
> http://www.nrsweb.com>
>
>
> p: 208.883.7834 Ext.262 | f: 208.882.1744
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>

--

*Thanks,*

**

**
**

*Ivan A. Wright* | Systems Interface Development | NRS, Inc.

*2009 S. Main St. Moscow, ID 83843*

**

**ivan@... | www.nrsweb.com

p: 208.883.7834 Ext.262 | f: 208.882.1744

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

system · January 27, 2014, 1:23pm

I am hoping someone has a quick answer...

I need to process a character seperated file (think CSV) where the seperator is a dollar sign - not a comma

Is that possible without generating my own dll?

I tried configurating the conversion plugin with:

<DefaultNamespace>http://testnamespace</DefaultNamespace>
<Separator>$</Separator>
<FirstRowContainsFieldNames>false</FirstRowContainsFieldNames>

but it did not seem to work.

system · January 27, 2014, 2:10pm

It appears that <Separator>$</Separator>
Â Â Â <TextQualifier>"</TextQualifier>
Â Â Â <FirstRowContainsFieldNames>false</FirstRowContainsFieldNames> works for me.

Could it be that it is failing on TextQualifier and not the serparator?

Â

Ivanâ€‹

On Mon, Jan 27, 2014 at 10:23 AM, <bwalker@...> wrote:

Â

<div> <p><p>I am hoping someone has a quick answer...</p><p>I need to process a character seperated file (think CSV) where the seperator is a dollar sign - not a comma</p><p>Â </p><p>Is that possible without generating my own dll?</p>

Â

I tried configurating the conversion plugin with:

<DefaultNamespace>http://testnamespace</DefaultNamespace> <Separator>$</Separator> <FirstRowContainsFieldNames>false</FirstRowContainsFieldNames>

Â

but it did not seem to work.

</div> <div style="color:rgb(255,255,255);min-height:0px;"></div>

--

Thanks,

Ivan A. Wright | Systems Interface Development SpecialistÂ

NRS -- 100% Employee OwnedÂ

Â

2009 S. Main St. Moscow, ID 83843

ivan@... | www.nrs.com

p: 208.883.7834 ext.262 | f: 208.882.1744

system · January 27, 2014, 2:25pm

The 'stock' CSVtoXML wont take anything but comma

I compiled the CustomCSVtoXML from the sample and it works

Thanks

system · February 3, 2014, 7:41pm

I have a csv file to process. The data could contain hundreds of rows I do not wish to process and a few that I do. How can I configure my first conversion to only map the rows that I want to process? If I link table to table then apply a link condition on a column in the row, no data is mapped. If I link row to row and apply the link condition, the correct data maps but the table / row structure is broken

system · February 4, 2014, 9:38am