Service Connect - Delete Warehouse

Yahoo Archive
1
If it was me, I would delete the revision and add it back in. With only
13 lines, you could rebuild it quickly and find out if you just happen
to have a corrupt revision/BOM.



Russell Wright

Controller

Triton Industries

Phone (517) 322-3822

Fax (517) 322-3872




I suspected the same thing. The BOM that won't check in consists of 1
assembly and a line drawing. The subassembly BOM checks in although it
takes hours. That subassembly consists of 9 materials and 4
subassemblies all of which check in. I haven't found any circular
references and all subassemblies validate.

I'm sure that there is something wrong in the BOM but don't know where
else to look.

Allen Tucker
IT Vantage Manager
Espey Mfg. & Electronics Corp.
Email: atucker@... <mailto:atucker%40espey.com>
PH: 518-245-4252
Fax: 518-245-4421





[Non-text portions of this message have been removed]
2
I created an SC workflow to add warehouse and bin to newly created
parts. I ran this workflow for 4000 parts. Afterwards I found out that
the person who supplied me the information gave me the wrong warehouse
code. So now I have to create a SC workflow that will delete the
warehouse. I'm stuck on the actual "delete" part. The webservice it
calls for is Part.Update but I'm not sure where I specify the delete
value. Can someone steer me in the right direction?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



[Non-text portions of this message have been removed]
3
If you want to delete the PartWarehouse record, you'll need to
populate that portion of the Part.Update DataSet with I'm guessing
minimally the Company, PartNum, and WarehouseCode, and then set the
RowMod value in that part of the DataSet to 'D'.

The Web Services developers guide will tell you some about this:

-----
Q: How do I delete a row from an object (dataset)? If I delete it in my
client application it
does not get deleted in the Progress database after I call the Update
method.

A: The Update method has logic to support instructional processing tags
which can be
passed in the RowMod column of a data row.
Supported tags are:
[Delete] - indicates the row is to be deleted
[Clear=colName,colName, ...] - indicates that you want to clear
the value of the specified column/columns. Columns names are passed as a
comma separated list. Note that you still would need to null out the
actual data
value in the column even if you specify it in the Clear tag.
-----

I haven't tested this but I'm guessing the entire range of supported
values for RowMod are:

A / [Add]
U / [Update]
D / [Delete]
[Clear=colName1,colName2,...]

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Wednesday, October 06, 2010 10:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect - Delete Warehouse

I created an SC workflow to add warehouse and bin to newly created
parts. I ran this workflow for 4000 parts. Afterwards I found out that
the person who supplied me the information gave me the wrong warehouse
code. So now I have to create a SC workflow that will delete the
warehouse. I'm stuck on the actual "delete" part. The webservice it
calls for is Part.Update but I'm not sure where I specify the delete
value. Can someone steer me in the right direction?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



[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've tried setting the Row Mod value to D, but that didn't work.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Wednesday, October 06, 2010 11:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect - Delete Warehouse





If you want to delete the PartWarehouse record, you'll need to
populate that portion of the Part.Update DataSet with I'm guessing
minimally the Company, PartNum, and WarehouseCode, and then set the
RowMod value in that part of the DataSet to 'D'.

The Web Services developers guide will tell you some about this:

-----
Q: How do I delete a row from an object (dataset)? If I delete it in my
client application it
does not get deleted in the Progress database after I call the Update
method.

A: The Update method has logic to support instructional processing tags
which can be
passed in the RowMod column of a data row.
Supported tags are:
[Delete] - indicates the row is to be deleted
[Clear=colName,colName, ...] - indicates that you want to clear
the value of the specified column/columns. Columns names are passed as a
comma separated list. Note that you still would need to null out the
actual data
value in the column even if you specify it in the Clear tag.
-----

I haven't tested this but I'm guessing the entire range of supported
values for RowMod are:

A / [Add]
U / [Update]
D / [Delete]
[Clear=colName1,colName2,...]

-bws

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Wednesday, October 06, 2010 10:57 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Service Connect - Delete Warehouse

I created an SC workflow to add warehouse and bin to newly created
parts. I ran this workflow for 4000 parts. Afterwards I found out that
the person who supplied me the information gave me the wrong warehouse
code. So now I have to create a SC workflow that will delete the
warehouse. I'm stuck on the actual "delete" part. The webservice it
calls for is Part.Update but I'm not sure where I specify the delete
value. Can someone steer me in the right direction?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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





[Non-text portions of this message have been removed]
5
I'd do a client Trace with the full dataset and see what the client
does to accomplish this. :-)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Wednesday, October 06, 2010 11:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect - Delete Warehouse

I've tried setting the Row Mod value to D, but that didn't work.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Wednesday, October 06, 2010 11:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect - Delete Warehouse





If you want to delete the PartWarehouse record, you'll need to
populate that portion of the Part.Update DataSet with I'm guessing
minimally the Company, PartNum, and WarehouseCode, and then set the
RowMod value in that part of the DataSet to 'D'.

The Web Services developers guide will tell you some about this:

-----
Q: How do I delete a row from an object (dataset)? If I delete it in my
client application it
does not get deleted in the Progress database after I call the Update
method.

A: The Update method has logic to support instructional processing tags
which can be
passed in the RowMod column of a data row.
Supported tags are:
[Delete] - indicates the row is to be deleted
[Clear=colName,colName, ...] - indicates that you want to clear
the value of the specified column/columns. Columns names are passed as a
comma separated list. Note that you still would need to null out the
actual data
value in the column even if you specify it in the Clear tag.
-----

I haven't tested this but I'm guessing the entire range of supported
values for RowMod are:

A / [Add]
U / [Update]
D / [Delete]
[Clear=colName1,colName2,...]

-bws

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Wednesday, October 06, 2010 10:57 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Service Connect - Delete Warehouse

I created an SC workflow to add warehouse and bin to newly created
parts. I ran this workflow for 4000 parts. Afterwards I found out that
the person who supplied me the information gave me the wrong warehouse
code. So now I have to create a SC workflow that will delete the
warehouse. I'm stuck on the actual "delete" part. The webservice it
calls for is Part.Update but I'm not sure where I specify the delete
value. Can someone steer me in the right direction?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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





[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
6
Did that already too.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Wednesday, October 06, 2010 11:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect - Delete Warehouse





I'd do a client Trace with the full dataset and see what the client
does to accomplish this. :-)

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Wednesday, October 06, 2010 11:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Service Connect - Delete Warehouse

I've tried setting the Row Mod value to D, but that didn't work.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Wednesday, October 06, 2010 11:09 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Service Connect - Delete Warehouse

If you want to delete the PartWarehouse record, you'll need to
populate that portion of the Part.Update DataSet with I'm guessing
minimally the Company, PartNum, and WarehouseCode, and then set the
RowMod value in that part of the DataSet to 'D'.

The Web Services developers guide will tell you some about this:

-----
Q: How do I delete a row from an object (dataset)? If I delete it in my
client application it
does not get deleted in the Progress database after I call the Update
method.

A: The Update method has logic to support instructional processing tags
which can be
passed in the RowMod column of a data row.
Supported tags are:
[Delete] - indicates the row is to be deleted
[Clear=colName,colName, ...] - indicates that you want to clear
the value of the specified column/columns. Columns names are passed as a
comma separated list. Note that you still would need to null out the
actual data
value in the column even if you specify it in the Clear tag.
-----

I haven't tested this but I'm guessing the entire range of supported
values for RowMod are:

A / [Add]
U / [Update]
D / [Delete]
[Clear=colName1,colName2,...]

-bws

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Wednesday, October 06, 2010 10:57 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Service Connect - Delete Warehouse

I created an SC workflow to add warehouse and bin to newly created
parts. I ran this workflow for 4000 parts. Afterwards I found out that
the person who supplied me the information gave me the wrong warehouse
code. So now I have to create a SC workflow that will delete the
warehouse. I'm stuck on the actual "delete" part. The webservice it
calls for is Part.Update but I'm not sure where I specify the delete
value. Can someone steer me in the right direction?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/>
<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

[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





[Non-text portions of this message have been removed]
7
Try [DELETE] including the braces

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> I've tried setting the Row Mod value to D, but that didn't work.
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Brian W. Spolarich
> Sent: Wednesday, October 06, 2010 11:09 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Service Connect - Delete Warehouse
>
>
>
>
>
> If you want to delete the PartWarehouse record, you'll need to
> populate that portion of the Part.Update DataSet with I'm guessing
> minimally the Company, PartNum, and WarehouseCode, and then set the
> RowMod value in that part of the DataSet to 'D'.
>
> The Web Services developers guide will tell you some about this:
>
> -----
> Q: How do I delete a row from an object (dataset)? If I delete it in my
> client application it
> does not get deleted in the Progress database after I call the Update
> method.
>
> A: The Update method has logic to support instructional processing tags
> which can be
> passed in the RowMod column of a data row.
> Supported tags are:
> [Delete] - indicates the row is to be deleted
> [Clear=colName,colName, ...] - indicates that you want to clear
> the value of the specified column/columns. Columns names are passed as a
> comma separated list. Note that you still would need to null out the
> actual data
> value in the column even if you specify it in the Clear tag.
> -----
>
> I haven't tested this but I'm guessing the entire range of supported
> values for RowMod are:
>
> A / [Add]
> U / [Update]
> D / [Delete]
> [Clear=colName1,colName2,...]
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Blake Clemens
> Sent: Wednesday, October 06, 2010 10:57 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Service Connect - Delete Warehouse
>
> I created an SC workflow to add warehouse and bin to newly created
> parts. I ran this workflow for 4000 parts. Afterwards I found out that
> the person who supplied me the information gave me the wrong warehouse
> code. So now I have to create a SC workflow that will delete the
> warehouse. I'm stuck on the actual "delete" part. The webservice it
> calls for is Part.Update but I'm not sure where I specify the delete
> value. Can someone steer me in the right direction?
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> [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
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
8
Do you have any transactions that were made against these warehouses for
the parts in question? If so it won't let you delete the warehouses.



Jerry W. Rodden

Staff Administrator

Production Planning

Cardington Yutaka Technologies Inc

Phone: 419-864-8777 ext. 6209

FAX: 419-864-7771

jrodden@...







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