PartPlant Update through Service Connect

For future reference, this was a bad schema issue.

My original schema was Part.GetByIDResponse. However, when putting it through a cycle to the sub-workflow where I had the choice, I had it restricted to Part.GetByIDResponse/result/Part/Partplant. When I redid the schema and remapped my choice it started working perfectly.

Thanks a lot to Rob Bucek for pointing some tips out to me offline.
Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Tuesday, October 20, 2009 9:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: PartPlant Update through Service Connect



I've got what I think will work, but I'm having issues with "Choice" syntax. I'm taking the data returned by Part.GetByID, putting it through a sub-workflow per plant.

I'm trying to do a Yes/No based on if the PartPlant/Plant = MfgSys. Some of the syntax I've tried:

/msg:msg/msg:req/msg:dta/dta:GetByIDResponse/result/PartDataSet/PartPlant[dta:Plant = 'MfgSys']
/msg:msg/msg:req/msg:dta/dta:GetByIDResponse[dta:result/PartDataSet/PartPlant/Plant = 'MfgSys']
/msg:msg/msg:req/msg:dta/dta:GetByIDResponse/dta:result/PartDataSet/PartPlant/Plant = "MfgSys"

When I look through the log, I can see clear as day "Plant = MfgSys", but for some reason my choice refuses to see it. It always goes the same way regardless of which Plant shows up for that sub-workflow.

Anxious for any help someone can offer to get a choice to work in this case.

Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: Monday, October 19, 2009 5:45 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] PartPlant Update through Service Connect

I've got a workflow that allows for updating of Part information. It works well for what I need it to, at the Part master level. I also need to update information at the PartPlant level (VendorID to be specific). The VendorID can be different per Plant.

My workflow looks something like this:

Excel -> Conversion -> PartService.GetByID -> Conversion -> PartService.ChangePartPlantID -> Conversion -> PartService.Update

The problem I'm having is getting it to apply the VendorID to a specific Plant. The behavior I'm seeing currently is it takes my VendorID and applies it to the first Plant returned.

I've tried a lot of functoid = from all parts of the Workflow, but I can't get it to work based on Plant being equal to MfgSys (for instance).

To rephrase my issue, my data set looks like:

Part PartDesc Plant VendorID
123 Test Mfgsys VENDOR
Plant2 VENDOR2

How do I make the change to Mfgsys only, not Plant2?

Hope this makes sense to someone :). Let me know how I can clarify the issue.

Thanks,
Ken

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

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



[Non-text portions of this message have been removed]
I've got a workflow that allows for updating of Part information. It works well for what I need it to, at the Part master level. I also need to update information at the PartPlant level (VendorID to be specific). The VendorID can be different per Plant.

My workflow looks something like this:

Excel -> Conversion -> PartService.GetByID -> Conversion -> PartService.ChangePartPlantID -> Conversion -> PartService.Update

The problem I'm having is getting it to apply the VendorID to a specific Plant. The behavior I'm seeing currently is it takes my VendorID and applies it to the first Plant returned.

I've tried a lot of functoid = from all parts of the Workflow, but I can't get it to work based on Plant being equal to MfgSys (for instance).

To rephrase my issue, my data set looks like:

Part PartDesc Plant VendorID
123 Test Mfgsys VENDOR
Plant2 VENDOR2

How do I make the change to Mfgsys only, not Plant2?

Hope this makes sense to someone :). Let me know how I can clarify the issue.

Thanks,
Ken



[Non-text portions of this message have been removed]
I've got what I think will work, but I'm having issues with "Choice" syntax. I'm taking the data returned by Part.GetByID, putting it through a sub-workflow per plant.

I'm trying to do a Yes/No based on if the PartPlant/Plant = MfgSys. Some of the syntax I've tried:

/msg:msg/msg:req/msg:dta/dta:GetByIDResponse/result/PartDataSet/PartPlant[dta:Plant = 'MfgSys']
/msg:msg/msg:req/msg:dta/dta:GetByIDResponse[dta:result/PartDataSet/PartPlant/Plant = 'MfgSys']
/msg:msg/msg:req/msg:dta/dta:GetByIDResponse/dta:result/PartDataSet/PartPlant/Plant = "MfgSys"

When I look through the log, I can see clear as day "Plant = MfgSys", but for some reason my choice refuses to see it. It always goes the same way regardless of which Plant shows up for that sub-workflow.

Anxious for any help someone can offer to get a choice to work in this case.

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Monday, October 19, 2009 5:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] PartPlant Update through Service Connect



I've got a workflow that allows for updating of Part information. It works well for what I need it to, at the Part master level. I also need to update information at the PartPlant level (VendorID to be specific). The VendorID can be different per Plant.

My workflow looks something like this:

Excel -> Conversion -> PartService.GetByID -> Conversion -> PartService.ChangePartPlantID -> Conversion -> PartService.Update

The problem I'm having is getting it to apply the VendorID to a specific Plant. The behavior I'm seeing currently is it takes my VendorID and applies it to the first Plant returned.

I've tried a lot of functoid = from all parts of the Workflow, but I can't get it to work based on Plant being equal to MfgSys (for instance).

To rephrase my issue, my data set looks like:

Part PartDesc Plant VendorID
123 Test Mfgsys VENDOR
Plant2 VENDOR2

How do I make the change to Mfgsys only, not Plant2?

Hope this makes sense to someone :). Let me know how I can clarify the issue.

Thanks,
Ken

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



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