Part Rev SC Blank Title 74623

Yahoo Archive
1
I got it knocked out thanks for the help!

~Charlie
________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Tuesday, February 24, 2009 7:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part Rev SC

Using the BL Tester tool, I did a GetByID then GetNewPartRev which
made a 'copy' of the existing part rev, with one big difference. The
RowMod of the new partrev has a value of 'A' When you invoke the
Update method, only the record with the 'A' will be updated...

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> Basically where I'm getting shafted is the conversion between
> getnewpartrevresponce and updaterequest.
>
> I can't figure out how to have my data end up in the new record and
not the
> pre-existing revision record so that when my update runs it leaves
the
> pre-exsisting record under partrev alone and modifies the new one
so that it
> contains the values I want.
>
> And ideas
>
> ~Charlie
> ________________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Charlie Wilson
> Sent: Tuesday, February 24, 2009 6:29 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Part Rev SC
>
> Sure did.
>
> GetbyID
> GetNewPartRev
> Update
>
> I now have it running with out any errors but now it does not
actually
> create the alt method. I don't know if this is progress or notÂ…
>
> ~Charlie
> ________________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> bw2868bond
> Sent: Tuesday, February 24, 2009 5:44 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Part Rev SC
>
> I have heard the only silly question is the one not asked...
> Are alt methods created using part maintenance?
>
> Have you traced the creation of an alt method using the Vantage UI
> apps and then modelled your SC along that process?
>
> Just trying to help...
>
> bw
>
> --- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@>
> wrote:
> >
> > Yep that is what I think too but why isn't it populating.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Mark Wonsil
> > Sent: Tuesday, February 24, 2009 5:17 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Part Rev SC
> >
> >
> >
> > Hi Charlie,
> >
> > 'Company, PartNum, RevisionNum, AltMethod' is constrained to be
> unique.
> > Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
> > ^ ^ ^ ^AltMethod
> > ^ ^ ^Rev
> > ^ ^Part
> > ^Company
> >
> > This seems to indicate that the Rev already exists. It appears
that
> you're
> > not assigning (or SC isn't passing) the AltMethod to the call
since
> it looks
> > blank for the call. Usually, the AltMethod is non-blank for
> alternate
> > methods.
> >
> > Mark W.
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date:
> 02/24/09
> > 13:35:00
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
All,

I'm doing a SC to add a new alternate method to a part.

Has any one done something like this and can help me out?

~Charlie
3
I'm down to the point where I need to run the part.update method and it
tells me that par_num,rev_num,alt_method_num needs to be unique which it is
but it doesn't seem to be picking up the fact that I have a alt method
number entered. It ignores it. It is clearly seen in the part data set yet
it gives me this message.



Any suggestions?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Monday, February 23, 2009 6:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Rev SC



All,

I'm doing a SC to add a new alternate method to a part.

Has any one done something like this and can help me out?

~Charlie



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date: 02/23/09
07:17:00




[Non-text portions of this message have been removed]
4
Hopefully this comes through but here is the XML with the error message.


<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<msg:msg xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://Epicor.com/InternalMessage/1.1
http://scshost/schemas/epicor/ScaInternalMsg.xsd"
xmlns:msg="http://Epicor.com/InternalMessage/1.1">
<msg:req tag="PartService.Update">
<msg:ers>
<msg:error type="unexpected error">
<msg:number>2147220990</msg:number>
<msg:description>System.Web.Services.Protocols.SoapException: Column
'Company, PartNum, RevisionNum, AltMethod' is constrained to be unique.
Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
</msg:description>
<msg:source>Client proxy error
Original exception: System.Web.Services.Protocols.SoapException
Code:http://schemas.xmlsoap.org/soap/envelope/:Server
Actor:
Detail: <detail> at
System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction
action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args,
DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32
proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position,
Boolean fireEvent, Exception&amp; deferredException)
at System.Data.DataTable.SetNewRecord(DataRow row, Int32 proposedRecord,
DataRowAction action, Boolean isInMerge, Boolean fireEvent)
at System.Data.DataRow.EndEdit()
at System.Data.DataRow.set_Item(DataColumn column, Object value)
at System.Data.DataRow.set_Item(Int32 columnIndex, Object value)
at Epicor.Mfg.WS.Adapters.PartAdapter.Update(XmlNode PartData)
at Epicor.Mfg.WS.Services.PartService.Update(String CompanyID, XmlNode
PartData)</detail></msg:source>
</msg:error>
</msg:ers><msg:dta
xmlns:msg="http://Epicor.com/InternalMessage/1.1"><ext_0:UpdateRequest
xmlns:ext_0="http://Epicor.com/PartService/UpdateRequest"><ext_0:CompanyID>C
omapnyID=FDI;PlantID=FF</ext_0:CompanyID><ext_0:PartData><PartDataSet><Part>
<Company>FDI</Company><PartNum>SEL-11018171</PartNum><PartDescription>1.97x1
7.5x17.5 70PPI
Casthouse</PartDescription></Part><PartRev><Company>FDI</Company><PartNum>SE
L-11018171</PartNum><RevisionNum>3010-01REV15</RevisionNum><RevShortDesc>1.9
7x17.5x17.5 70PPI
Casthouse</RevShortDesc><AltMethod>3010-01R15FF</AltMethod><Plant>FF</Plant>
<RowMod>A</RowMod></PartRev></PartDataSet></ext_0:PartData></ext_0:UpdateReq
uest></msg:dta><msg:ctx><Timeout>100</Timeout></msg:ctx><msg:wfl><msg:usr
xmlns:msg="http://Epicor.com/InternalMessage/1.1"><msg:OrigData><ext_7571424
125090539:table
xmlns:ext_7571424125090539="http://Epicor.com/SC/UserSchema/Excel/7571424125
090539"><ext_7571424125090539:row><ext_7571424125090539:Part_Num>SEL-1101817
1</ext_7571424125090539:Part_Num></ext_7571424125090539:row></ext_7571424125
090539:table></msg:OrigData><ext_ProcessVariables:ProcessVariables
xmlns:ext_ProcessVariables="http://epicor.com/Workflow/ProcessVariables"><ex
t_ProcessVariables:Rev>3010-01REV15</ext_ProcessVariables:Rev><ext_ProcessVa
riables:AltMeth>3010-01R15FF</ext_ProcessVariables:AltMeth></ext_ProcessVari
ables:ProcessVariables></msg:usr><msg:ElemID
xmlns:msg="http://Epicor.com/InternalMessage/1.1">{2B295126-8FF1-44A0-96F1-A
0137761F3B0}</msg:ElemID><msg:PrcID
xmlns:msg="http://Epicor.com/InternalMessage/1.1">{2660EDF8-DEDF-4427-A7B6-E
47CC1790C42}</msg:PrcID><msg:WflID
xmlns:msg="http://Epicor.com/InternalMessage/1.1">Method_Update\Method_updat
e_sub</msg:WflID><msg:MsgID
xmlns:msg="http://Epicor.com/InternalMessage/1.1"></msg:MsgID><msg:IsFinishe
d>true</msg:IsFinished></msg:wfl></msg:req>
</msg:msg>



~Charlie
________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Tuesday, February 24, 2009 5:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Rev SC

I'm down to the point where I need to run the part.update method and it
tells me that par_num,rev_num,alt_method_num needs to be unique which it is
but it doesn't seem to be picking up the fact that I have a alt method
number entered. It ignores it. It is clearly seen in the part data set yet
it gives me this message.

Any suggestions?

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Monday, February 23, 2009 6:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Rev SC

All,

I'm doing a SC to add a new alternate method to a part.

Has any one done something like this and can help me out?

~Charlie

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date: 02/23/09
07:17:00

[Non-text portions of this message have been removed]
5
Any clue on this one I'm really getting backed into a corner.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Tuesday, February 24, 2009 8:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Rev SC



Hopefully this comes through but here is the XML with the error message.

<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<msg:msg xmlns:xsi="http://www.w3.
<http://www.w3.org/2001/XMLSchema-instance> org/2001/XMLSchema-instance"
xsi:schemaLocation="http://Epicor. <http://Epicor.com/InternalMessage/1.1>
com/InternalMessage/1.1
http://scshost/ <http://scshost/schemas/epicor/ScaInternalMsg.xsd>
schemas/epicor/ScaInternalMsg.xsd"
xmlns:msg="http://Epicor. <http://Epicor.com/InternalMessage/1.1>
com/InternalMessage/1.1">
<msg:req tag="PartService.Update">
<msg:ers>
<msg:error type="unexpected error">
<msg:number>2147220990</msg:number>
<msg:description>System.Web.Services.Protocols.SoapException: Column
'Company, PartNum, RevisionNum, AltMethod' is constrained to be unique.
Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
</msg:description>
<msg:source>Client proxy error
Original exception: System.Web.Services.Protocols.SoapException
Code:http://schemas. <http://schemas.xmlsoap.org/soap/envelope/:Server>
xmlsoap.org/soap/envelope/:Server
Actor:
Detail: <detail> at
System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction
action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args,
DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32
proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position,
Boolean fireEvent, Exception&amp; deferredException)
at System.Data.DataTable.SetNewRecord(DataRow row, Int32 proposedRecord,
DataRowAction action, Boolean isInMerge, Boolean fireEvent)
at System.Data.DataRow.EndEdit()
at System.Data.DataRow.set_Item(DataColumn column, Object value)
at System.Data.DataRow.set_Item(Int32 columnIndex, Object value)
at Epicor.Mfg.WS.Adapters.PartAdapter.Update(XmlNode PartData)
at Epicor.Mfg.WS.Services.PartService.Update(String CompanyID, XmlNode
PartData)</detail></msg:source>
</msg:error>
</msg:ers><msg:dta
xmlns:msg="http://Epicor. <http://Epicor.com/InternalMessage/1.1>
com/InternalMessage/1.1"><ext_0:UpdateRequest
xmlns:ext_0="http://Epicor. <http://Epicor.com/PartService/UpdateRequest>
com/PartService/UpdateRequest"><ext_0:CompanyID>C
omapnyID=FDI;PlantID=FF</ext_0:CompanyID><ext_0:PartData><PartDataSet><Part>
<Company>FDI</Company><PartNum>SEL-11018171</PartNum><PartDescription>1.97x1
7.5x17.5 70PPI
Casthouse</PartDescription></Part><PartRev><Company>FDI</Company><PartNum>SE
L-11018171</PartNum><RevisionNum>3010-01REV15</RevisionNum><RevShortDesc>1.9
7x17.5x17.5 70PPI
Casthouse</RevShortDesc><AltMethod>3010-01R15FF</AltMethod><Plant>FF</Plant>
<RowMod>A</RowMod></PartRev></PartDataSet></ext_0:PartData></ext_0:UpdateReq
uest></msg:dta><msg:ctx><Timeout>100</Timeout></msg:ctx><msg:wfl><msg:usr
xmlns:msg="http://Epicor. <http://Epicor.com/InternalMessage/1.1>
com/InternalMessage/1.1"><msg:OrigData><ext_7571424
125090539:table
xmlns:ext_7571424125090539="http://Epicor.
<http://Epicor.com/SC/UserSchema/Excel/7571424125>
com/SC/UserSchema/Excel/7571424125
090539"><ext_7571424125090539:row><ext_7571424125090539:Part_Num>SEL-1101817
1</ext_7571424125090539:Part_Num></ext_7571424125090539:row></ext_7571424125
090539:table></msg:OrigData><ext_ProcessVariables:ProcessVariables
xmlns:ext_ProcessVariables="http://epicor.
<http://epicor.com/Workflow/ProcessVariables>
com/Workflow/ProcessVariables"><ex
t_ProcessVariables:Rev>3010-01REV15</ext_ProcessVariables:Rev><ext_ProcessVa
riables:AltMeth>3010-01R15FF</ext_ProcessVariables:AltMeth></ext_ProcessVari
ables:ProcessVariables></msg:usr><msg:ElemID
xmlns:msg="http://Epicor. <http://Epicor.com/InternalMessage/1.1>
com/InternalMessage/1.1">{2B295126-8FF1-44A0-96F1-A
0137761F3B0}</msg:ElemID><msg:PrcID
xmlns:msg="http://Epicor. <http://Epicor.com/InternalMessage/1.1>
com/InternalMessage/1.1">{2660EDF8-DEDF-4427-A7B6-E
47CC1790C42}</msg:PrcID><msg:WflID
xmlns:msg="http://Epicor. <http://Epicor.com/InternalMessage/1.1>
com/InternalMessage/1.1">Method_Update\Method_updat
e_sub</msg:WflID><msg:MsgID
xmlns:msg="http://Epicor. <http://Epicor.com/InternalMessage/1.1>
com/InternalMessage/1.1"></msg:MsgID><msg:IsFinishe
d>true</msg:IsFinished></msg:wfl></msg:req>
</msg:msg>

~Charlie
________________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Tuesday, February 24, 2009 5:43 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Part Rev SC

I'm down to the point where I need to run the part.update method and it
tells me that par_num,rev_num,alt_method_num needs to be unique which it is
but it doesn't seem to be picking up the fact that I have a alt method
number entered. It ignores it. It is clearly seen in the part data set yet
it gives me this message.

Any suggestions?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Monday, February 23, 2009 6:46 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Part Rev SC

All,

I'm doing a SC to add a new alternate method to a part.

Has any one done something like this and can help me out?

~Charlie

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date: 02/23/09
07:17:00

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



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date: 02/23/09
07:17:00




[Non-text portions of this message have been removed]
6
Hi Charlie,

'Company, PartNum, RevisionNum, AltMethod' is constrained to be unique.
Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
^ ^ ^ ^AltMethod
^ ^ ^Rev
^ ^Part
^Company

This seems to indicate that the Rev already exists. It appears that you're
not assigning (or SC isn't passing) the AltMethod to the call since it looks
blank for the call. Usually, the AltMethod is non-blank for alternate
methods.

Mark W.
7
Yep that is what I think too but why isn't it populating.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Tuesday, February 24, 2009 5:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Part Rev SC



Hi Charlie,

'Company, PartNum, RevisionNum, AltMethod' is constrained to be unique.
Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
^ ^ ^ ^AltMethod
^ ^ ^Rev
^ ^Part
^Company

This seems to indicate that the Rev already exists. It appears that you're
not assigning (or SC isn't passing) the AltMethod to the call since it looks
blank for the call. Usually, the AltMethod is non-blank for alternate
methods.

Mark W.



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date: 02/24/09
13:35:00




[Non-text portions of this message have been removed]
8
I have heard the only silly question is the one not asked...
Are alt methods created using part maintenance?

Have you traced the creation of an alt method using the Vantage UI
apps and then modelled your SC along that process?

Just trying to help...

bw

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> Yep that is what I think too but why isn't it populating.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Mark Wonsil
> Sent: Tuesday, February 24, 2009 5:17 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Part Rev SC
>
>
>
> Hi Charlie,
>
> 'Company, PartNum, RevisionNum, AltMethod' is constrained to be
unique.
> Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
> ^ ^ ^ ^AltMethod
> ^ ^ ^Rev
> ^ ^Part
> ^Company
>
> This seems to indicate that the Rev already exists. It appears that
you're
> not assigning (or SC isn't passing) the AltMethod to the call since
it looks
> blank for the call. Usually, the AltMethod is non-blank for
alternate
> methods.
>
> Mark W.
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date:
02/24/09
> 13:35:00
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
>
> Yep that is what I think too but why isn't it populating.
>

We don't have the full version of ServiceConnect but I would guess it's a
mapping issue. Are you passing the value of the AltMethod in from a file or
generating it on fly? Check that it is mapped to the correct field and maybe
turn on logging to see where it's getting lost.

Mark W>
10
Sure did.

GetbyID
GetNewPartRev
Update

I now have it running with out any errors but now it does not actually
create the alt method. I donÂ’t know if this is progress or notÂ…

~Charlie
________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Tuesday, February 24, 2009 5:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part Rev SC

I have heard the only silly question is the one not asked...
Are alt methods created using part maintenance?

Have you traced the creation of an alt method using the Vantage UI
apps and then modelled your SC along that process?

Just trying to help...

bw

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> Yep that is what I think too but why isn't it populating.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Mark Wonsil
> Sent: Tuesday, February 24, 2009 5:17 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Part Rev SC
>
>
>
> Hi Charlie,
>
> 'Company, PartNum, RevisionNum, AltMethod' is constrained to be
unique.
> Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
> ^ ^ ^ ^AltMethod
> ^ ^ ^Rev
> ^ ^Part
> ^Company
>
> This seems to indicate that the Rev already exists. It appears that
you're
> not assigning (or SC isn't passing) the AltMethod to the call since
it looks
> blank for the call. Usually, the AltMethod is non-blank for
alternate
> methods.
>
> Mark W.
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date:
02/24/09
> 13:35:00
>
>
>
>
> [Non-text portions of this message have been removed]
>
11
Basically where IÂ’m getting shafted is the conversion between
getnewpartrevresponce and updaterequest.

I canÂ’t figure out how to have my data end up in the new record and not the
pre-existing revision record so that when my update runs it leaves the
pre-exsisting record under partrev alone and modifies the new one so that it
contains the values I want.

And ideas

~Charlie
________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Tuesday, February 24, 2009 6:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Part Rev SC

Sure did.

GetbyID
GetNewPartRev
Update

I now have it running with out any errors but now it does not actually
create the alt method. I donÂ’t know if this is progress or notÂ…

~Charlie
________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Tuesday, February 24, 2009 5:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part Rev SC

I have heard the only silly question is the one not asked...
Are alt methods created using part maintenance?

Have you traced the creation of an alt method using the Vantage UI
apps and then modelled your SC along that process?

Just trying to help...

bw

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> Yep that is what I think too but why isn't it populating.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Mark Wonsil
> Sent: Tuesday, February 24, 2009 5:17 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Part Rev SC
>
>
>
> Hi Charlie,
>
> 'Company, PartNum, RevisionNum, AltMethod' is constrained to be
unique.
> Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
> ^ ^ ^ ^AltMethod
> ^ ^ ^Rev
> ^ ^Part
> ^Company
>
> This seems to indicate that the Rev already exists. It appears that
you're
> not assigning (or SC isn't passing) the AltMethod to the call since
it looks
> blank for the call. Usually, the AltMethod is non-blank for
alternate
> methods.
>
> Mark W.
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date:
02/24/09
> 13:35:00
>
>
>
>
> [Non-text portions of this message have been removed]
>
12
Using the BL Tester tool, I did a GetByID then GetNewPartRev which
made a 'copy' of the existing part rev, with one big difference. The
RowMod of the new partrev has a value of 'A' When you invoke the
Update method, only the record with the 'A' will be updated...

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> Basically where I'm getting shafted is the conversion between
> getnewpartrevresponce and updaterequest.
>
> I can't figure out how to have my data end up in the new record and
not the
> pre-existing revision record so that when my update runs it leaves
the
> pre-exsisting record under partrev alone and modifies the new one
so that it
> contains the values I want.
>
> And ideas
>
> ~Charlie
> ________________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Charlie Wilson
> Sent: Tuesday, February 24, 2009 6:29 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Part Rev SC
>
> Sure did.
>
> GetbyID
> GetNewPartRev
> Update
>
> I now have it running with out any errors but now it does not
actually
> create the alt method. I don't know if this is progress or notÂ…
>
> ~Charlie
> ________________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> bw2868bond
> Sent: Tuesday, February 24, 2009 5:44 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Part Rev SC
>
> I have heard the only silly question is the one not asked...
> Are alt methods created using part maintenance?
>
> Have you traced the creation of an alt method using the Vantage UI
> apps and then modelled your SC along that process?
>
> Just trying to help...
>
> bw
>
> --- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@>
> wrote:
> >
> > Yep that is what I think too but why isn't it populating.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Mark Wonsil
> > Sent: Tuesday, February 24, 2009 5:17 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Part Rev SC
> >
> >
> >
> > Hi Charlie,
> >
> > 'Company, PartNum, RevisionNum, AltMethod' is constrained to be
> unique.
> > Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
> > ^ ^ ^ ^AltMethod
> > ^ ^ ^Rev
> > ^ ^Part
> > ^Company
> >
> > This seems to indicate that the Rev already exists. It appears
that
> you're
> > not assigning (or SC isn't passing) the AltMethod to the call
since
> it looks
> > blank for the call. Usually, the AltMethod is non-blank for
> alternate
> > methods.
> >
> > Mark W.
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date:
> 02/24/09
> > 13:35:00
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
13
How do I get data into this newly formed record and only this record?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Tuesday, February 24, 2009 7:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part Rev SC



Using the BL Tester tool, I did a GetByID then GetNewPartRev which
made a 'copy' of the existing part rev, with one big difference. The
RowMod of the new partrev has a value of 'A' When you invoke the
Update method, only the record with the 'A' will be updated...

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...>
wrote:
>
> Basically where I'm getting shafted is the conversion between
> getnewpartrevresponce and updaterequest.
>
> I can't figure out how to have my data end up in the new record and
not the
> pre-existing revision record so that when my update runs it leaves
the
> pre-exsisting record under partrev alone and modifies the new one
so that it
> contains the values I want.
>
> And ideas
>
> ~Charlie
> ________________________________________
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> Charlie Wilson
> Sent: Tuesday, February 24, 2009 6:29 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Re: Part Rev SC
>
> Sure did.
>
> GetbyID
> GetNewPartRev
> Update
>
> I now have it running with out any errors but now it does not
actually
> create the alt method. I don't know if this is progress or not.
>
> ~Charlie
> ________________________________________
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> bw2868bond
> Sent: Tuesday, February 24, 2009 5:44 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: Part Rev SC
>
> I have heard the only silly question is the one not asked...
> Are alt methods created using part maintenance?
>
> Have you traced the creation of an alt method using the Vantage UI
> apps and then modelled your SC along that process?
>
> Just trying to help...
>
> bw
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"Charlie Wilson" <foamdesigncsw@>
> wrote:
> >
> > Yep that is what I think too but why isn't it populating.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > Mark Wonsil
> > Sent: Tuesday, February 24, 2009 5:17 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: RE: [Vantage] Part Rev SC
> >
> >
> >
> > Hi Charlie,
> >
> > 'Company, PartNum, RevisionNum, AltMethod' is constrained to be
> unique.
> > Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
> > ^ ^ ^ ^AltMethod
> > ^ ^ ^Rev
> > ^ ^Part
> > ^Company
> >
> > This seems to indicate that the Rev already exists. It appears
that
> you're
> > not assigning (or SC isn't passing) the AltMethod to the call
since
> it looks
> > blank for the call. Usually, the AltMethod is non-blank for
> alternate
> > methods.
> >
> > Mark W.
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release Date:
> 02/24/09
> > 13:35:00
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.3/1970 - Release Date: 02/24/09
13:35:00




[Non-text portions of this message have been removed]
14
Just map your values from your incoming file or assign constants to
the fields. It wont matter if the original record fields are changed.
If the RowMod of that row is blank, it will not be updated.

At least that is how it is supposed to work.

You can also supply values and add a condition - where the condition
is only when rowmod is A - I would have to go back through user
manual and/or other documents from EpicWeb to find that one though

I always test SC workflows on a copy of live data before
implementation....


--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> How do I get data into this newly formed record and only this
record?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> bw2868bond
> Sent: Tuesday, February 24, 2009 7:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Part Rev SC
>
>
>
> Using the BL Tester tool, I did a GetByID then GetNewPartRev which
> made a 'copy' of the existing part rev, with one big difference.
The
> RowMod of the new partrev has a value of 'A' When you invoke the
> Update method, only the record with the 'A' will be updated...
>
> --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com, "Charlie
> Wilson" <foamdesigncsw@>
> wrote:
> >
> > Basically where I'm getting shafted is the conversion between
> > getnewpartrevresponce and updaterequest.
> >
> > I can't figure out how to have my data end up in the new record
and
> not the
> > pre-existing revision record so that when my update runs it
leaves
> the
> > pre-exsisting record under partrev alone and modifies the new one
> so that it
> > contains the values I want.
> >
> > And ideas
> >
> > ~Charlie
> > ________________________________________
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com] On
> Behalf Of
> > Charlie Wilson
> > Sent: Tuesday, February 24, 2009 6:29 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: RE: [Vantage] Re: Part Rev SC
> >
> > Sure did.
> >
> > GetbyID
> > GetNewPartRev
> > Update
> >
> > I now have it running with out any errors but now it does not
> actually
> > create the alt method. I don't know if this is progress or not.
> >
> > ~Charlie
> > ________________________________________
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com] On
> Behalf Of
> > bw2868bond
> > Sent: Tuesday, February 24, 2009 5:44 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: Part Rev SC
> >
> > I have heard the only silly question is the one not asked...
> > Are alt methods created using part maintenance?
> >
> > Have you traced the creation of an alt method using the Vantage
UI
> > apps and then modelled your SC along that process?
> >
> > Just trying to help...
> >
> > bw
> >
> > --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com,
> "Charlie Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > Yep that is what I think too but why isn't it populating.
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com] On
> > Behalf Of
> > > Mark Wonsil
> > > Sent: Tuesday, February 24, 2009 5:17 PM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: RE: [Vantage] Part Rev SC
> > >
> > >
> > >
> > > Hi Charlie,
> > >
> > > 'Company, PartNum, RevisionNum, AltMethod' is constrained to be
> > unique.
> > > Value 'FDI, SEL-11018171, 3010-01REV15, ' is already present.;
> > > ^ ^ ^ ^AltMethod
> > > ^ ^ ^Rev
> > > ^ ^Part
> > > ^Company
> > >
> > > This seems to indicate that the Rev already exists. It appears
> that
> > you're
> > > not assigning (or SC isn't passing) the AltMethod to the call
> since
> > it looks
> > > blank for the call. Usually, the AltMethod is non-blank for
> > alternate
> > > methods.
> > >
> > > Mark W.
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - www.avg.com
> > > Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release
Date:
> > 02/24/09
> > > 13:35:00
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.237 / Virus Database: 270.11.3/1970 - Release Date:
02/24/09
> 13:35:00
>
>
>
>
> [Non-text portions of this message have been removed]
>