I'm on Vantage 8.03.409a SQL and Service Connect 8.03.3981 SP1. One other item of note is that I've overwritten and deleted the main and sub workflow schemas several times. It seems that when creating the new schema and "overwriting" the old one it doesn't seem to actually overwrite it... I have to delete it first (very odd).
--- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
>
> Ok, that all sounds good, the first schema you posted is what I'm accustomed to seeing when I do the same thing. All too often you see some differences between the outbound schema from Epicor and the ones in service connect. What version of vantage and what version of service connect? You've got me curious. I'd like to see if I can replicate it.. I've got installations of 9.05.700b and 8.03.409c I can work from. I'm running 9.05.700 service connect in both cases..
>
> 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 Jeff Rogers
> Sent: Tuesday, June 26, 2012 10:57 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Service Connect Help - Call workflow from BPM and use subworkflow
>
>
>
> Rob - I'm using a pre-process BPM to trigger a dependent post-process BPM that calls the service connect workflow through the action. So, when dumping the incoming data using a poster (without a conversion configured) and then using the exttoint conversion plug-in to build the schema I get the following output:
>
> <?xml version="1.0" encoding="utf-16"?>
> <xs:schema xmlns:tns="http://www.epicor.com/Mfg/UpdateRequest" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.epicor.com/Mfg/UpdateRequest" xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:import />
> <xs:element name="UpdateRequest">
> <xs:complexType>
> <xs:sequence>
> <xs:element ref="ds" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
> When I use the anyxml2xml conversion plugin to build the schema I get the following schema:
>
> <?xml version="1.0" encoding="utf-16"?>
> <xs:schema xmlns:tns="http://Epicor.com/InternalMessage/1.1" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://Epicor.com/InternalMessage/1.1" xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:import namespace="http://www.epicor.com/Mfg/UpdateRequest" />
> <xs:import />
> <xs:element name="msg">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="req">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="dta">
> <xs:complexType>
> <xs:sequence>
> <xs:element xmlns:q1="http://www.epicor.com/Mfg/UpdateRequest" ref="q1:UpdateRequest" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="wfl">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="WflID" type="xs:string" />
> <xs:element name="PrcID" type="xs:string" />
> <xs:element name="ElemID" type="xs:string" />
> <xs:element name="MsgID" />
> <xs:element name="MsgType" />
> <xs:element name="Action" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="cfg">
> <xs:complexType>
> <xs:sequence>
> <xs:element ref="IsUTFBOM" />
> <xs:element ref="PoolSize" />
> <xs:element ref="PoolPeriod" />
> <xs:element ref="IsLaunched" />
> <xs:element ref="CodePage" />
> <xs:element ref="cfg" />
> <xs:element ref="schedule" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="ctx">
> <xs:complexType>
> <xs:sequence>
> <xs:element ref="IsUTFBOM" />
> <xs:element ref="CodePage" />
> <xs:element ref="SenderName" />
> <xs:element ref="SenderSubName" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> <xs:attribute name="tag" type="xs:string" use="required" />
> </xs:complexType>
> </xs:element>
> <xs:element name="trc">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="PrcID" type="xs:string" />
> <xs:element name="TrcSessionID" type="xs:string" />
> <xs:element name="CallMode" type="xs:string" />
> <xs:element name="TrcID" type="xs:string" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
> I have tried calling a subworkflow (and creating a subworkflow schema) by using both schemas above, but I cannot get the data to transform into a new schema (I can see the data in the start node of the subworkflow and into a message extension that is based on the subworflow schema).
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Rob Bucek <rbucek@> wrote:
> >
> > just to clarify... you used a post process action to call the workflow correct? Can you post your generated schema?
> >
> > 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%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Jeff Rogers
> > Sent: Monday, June 25, 2012 6:08 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Service Connect Help - Call workflow from BPM and use subworkflow
> >
> >
> >
> > I need some assistance in getting this to work. I'm using a BPM to initiate a service connect workflow on the custship.update method. It does not appear the format of the data coming into the workflow from the BPM matches the CustShip.UpdateRequest schema, so I figured I'd immediately dump an xml file using a poster to see create a new schema (I didn't use a conversion for the file poster). This seems to work, but the main problem arises when I call a subworkflow and create a new schema for it. I can see the data coming into the subworkflow (and into a message extension through a conversion), but when I try to map the data to fields in salesorder.getrowsrequest nothing comes across (there is nothing under the dta node in message tracking). For some reason there is same odd namespace stuff in the data and message extension (see below). Does anyone have any ideas???
> >
> > XML Example:
> > <msg:dta>
> > <dta:GetRowsRequest xmlns:dta="http://Epicor.com/SalesOrderService/GetRowsRequest"/>
> > </msg:dta>
> > <msg:wfl>
> > <msg:usr>
> > <msg:InboundDataSet>
> > <ext_UpdateRequest:ShipDtl xmlns:ext_UpdateRequest="http://www.epicor.com/Mfg/UpdateRequest">
> > <Company xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">PDUS</Company>
> > <PackNum xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">4486</PackNum>
> > <PackLine xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">1</PackLine>
> > <OrderNum xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">4036</OrderNum>
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>