Mass delete scheduled resources - dmt partopdtl records

Yahoo Archive
1
JUST A NOTE to those who MAY be interested.

delete and reload WORKS BUT...

(1) delete removes entire operation - but actually need to set material operation linkage to "0" because you cant delete ops with materials associated to them

(2) operation master must be editted to remove extra scheduled resources before reload
2
Good afternoon.

i've been having a tough time trying to use the DMT to remove a large group of unnecessary scheduled reources from part MOMs.

I know how to reference the PartOpDtl headings to add/chg the scheduled reources info..
ECOOpDtl#PartNum,
ECOOpDtl#Company,
ECOOpDtl#GroupID,
ECOOpDtl#RevisionNum,
ECOOpDtl#OprSeq,
ECOOpDtl#OpDtlSeq

but my objective is to DELETE the scheduled resources.

And in the DELETE MODE the DMT refuses to take action unless the operation headings are referenced ..
Company,
GroupID,
PartNum,
RevisionNum,
OprSeq

in which case, the DMT then deletes the OPERATION.

Anyone tackled this issue before? (V8.03)
3
could you spell out what you are trying to accomplish a bit more? if i interpret your language literally, there is no association with scheduled resources and the eco tables, which in essence are really temporary housings for mom's while they are being changed/modified. info for scheduled resources related to operations (i.e. jobs) are kept elsewhere..


Sent from my Verizon Wireless 4G LTE Smartphone

erp07052 <erp07052@...> wrote:


Good afternoon.

i've been having a tough time trying to use the DMT to remove a large group of unnecessary scheduled reources from part MOMs.

I know how to reference the PartOpDtl headings to add/chg the scheduled reources info..
ECOOpDtl#PartNum,
ECOOpDtl#Company,
ECOOpDtl#GroupID,
ECOOpDtl#RevisionNum,
ECOOpDtl#OprSeq,
ECOOpDtl#OpDtlSeq

but my objective is to DELETE the scheduled resources.

And in the DELETE MODE the DMT refuses to take action unless the operation headings are referenced ..
Company,
GroupID,
PartNum,
RevisionNum,
OprSeq

in which case, the DMT then deletes the OPERATION.

Anyone tackled this issue before? (V8.03)





[Non-text portions of this message have been removed]
4
Sure thing.

Our MOMs were created with a little more detail than we're willing to endure or support. Case in point, we have several scheduled resources on every operation of every part MOM - for machines, employees, tools etc. Needless to say, job scheduling is difficult. So we're come up with the plan to REDUCE the number of SCHEDULED RESOURCES on all operations to the base minimum (machine). To xeecute the plan we created a BAQ export of operations and the scheduled resources, exported it to excel, editted it, and now wish to use that list - (22,000+ entries) - TO DELETE THE UNWANTED SCHEDULED RESOURCES - using the DMT tool and the delete option.

But cant get the DMT to delete the SCHEDULED RESOURCES (that we want to remore) without ALSO deleting the opertions (that we DONT want to remove).

Do you have maybe another option/method you could share?
that would be great
thanks



--- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
>
> could you spell out what you are trying to accomplish a bit more? if i interpret your language literally, there is no association with scheduled resources and the eco tables, which in essence are really temporary housings for mom's while they are being changed/modified. info for scheduled resources related to operations (i.e. jobs) are kept elsewhere..
>
>
> Sent from my Verizon Wireless 4G LTE Smartphone
>
> erp07052 <erp07052@...> wrote:
>
>
> Good afternoon.
>
> i've been having a tough time trying to use the DMT to remove a large group of unnecessary scheduled reources from part MOMs.
>
> I know how to reference the PartOpDtl headings to add/chg the scheduled reources info..
> ECOOpDtl#PartNum,
> ECOOpDtl#Company,
> ECOOpDtl#GroupID,
> ECOOpDtl#RevisionNum,
> ECOOpDtl#OprSeq,
> ECOOpDtl#OpDtlSeq
>
> but my objective is to DELETE the scheduled resources.
>
> And in the DELETE MODE the DMT refuses to take action unless the operation headings are referenced ..
> Company,
> GroupID,
> PartNum,
> RevisionNum,
> OprSeq
>
> in which case, the DMT then deletes the OPERATION.
>
> Anyone tackled this issue before? (V8.03)
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
If you have the data exported, can you create 2 DMT files? - One to delete everything and the other to re create what you want to keep...

--- In vantage@yahoogroups.com, "erp07052" <erp07052@...> wrote:
>
> Sure thing.
>
> Our MOMs were created with a little more detail than we're willing to endure or support. Case in point, we have several scheduled resources on every operation of every part MOM - for machines, employees, tools etc. Needless to say, job scheduling is difficult. So we're come up with the plan to REDUCE the number of SCHEDULED RESOURCES on all operations to the base minimum (machine). To xeecute the plan we created a BAQ export of operations and the scheduled resources, exported it to excel, editted it, and now wish to use that list - (22,000+ entries) - TO DELETE THE UNWANTED SCHEDULED RESOURCES - using the DMT tool and the delete option.
>
> But cant get the DMT to delete the SCHEDULED RESOURCES (that we want to remore) without ALSO deleting the opertions (that we DONT want to remove).
>
> Do you have maybe another option/method you could share?
> that would be great
> thanks
>
>
>
> --- In vantage@yahoogroups.com, Rob Bucek <rbucek@> wrote:
> >
> > could you spell out what you are trying to accomplish a bit more? if i interpret your language literally, there is no association with scheduled resources and the eco tables, which in essence are really temporary housings for mom's while they are being changed/modified. info for scheduled resources related to operations (i.e. jobs) are kept elsewhere..
> >
> >
> > Sent from my Verizon Wireless 4G LTE Smartphone
> >
> > erp07052 <erp07052@> wrote:
> >
> >
> > Good afternoon.
> >
> > i've been having a tough time trying to use the DMT to remove a large group of unnecessary scheduled reources from part MOMs.
> >
> > I know how to reference the PartOpDtl headings to add/chg the scheduled reources info..
> > ECOOpDtl#PartNum,
> > ECOOpDtl#Company,
> > ECOOpDtl#GroupID,
> > ECOOpDtl#RevisionNum,
> > ECOOpDtl#OprSeq,
> > ECOOpDtl#OpDtlSeq
> >
> > but my objective is to DELETE the scheduled resources.
> >
> > And in the DELETE MODE the DMT refuses to take action unless the operation headings are referenced ..
> > Company,
> > GroupID,
> > PartNum,
> > RevisionNum,
> > OprSeq
> >
> > in which case, the DMT then deletes the OPERATION.
> >
> > Anyone tackled this issue before? (V8.03)
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
6
I would say yes, I have created 2 separate spreasheets with Data to be modified and then Data to be deleted. Just remember that the Data you are deleting may be linked in other tables so you could have a lot of clean up a head of you. I was working on one table and had to clean up 6 others before my data would delete.


________________________________
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Friday, November 2, 2012 10:34 AM
Subject: [Vantage] Re: MASS DELETE SCHEDULED RESOURCES - DMT PARTOPDTL RECORDS


Â

If you have the data exported, can you create 2 DMT files? - One to delete everything and the other to re create what you want to keep...

--- In mailto:vantage%40yahoogroups.com, "erp07052" <erp07052@...> wrote:
>
> Sure thing.
>
> Our MOMs were created with a little more detail than we're willing to endure or support. Case in point, we have several scheduled resources on every operation of every part MOM - for machines, employees, tools etc. Needless to say, job scheduling is difficult. So we're come up with the plan to REDUCE the number of SCHEDULED RESOURCES on all operations to the base minimum (machine). To xeecute the plan we created a BAQ export of operations and the scheduled resources, exported it to excel, editted it, and now wish to use that list - (22,000+ entries) - TO DELETE THE UNWANTED SCHEDULED RESOURCES - using the DMT tool and the delete option.
>
> But cant get the DMT to delete the SCHEDULED RESOURCES (that we want to remore) without ALSO deleting the opertions (that we DONT want to remove).
>
> Do you have maybe another option/method you could share?
> that would be great
> thanks
>
>
>
> --- In mailto:vantage%40yahoogroups.com, Rob Bucek <rbucek@> wrote:
> >
> > could you spell out what you are trying to accomplish a bit more? if i interpret your language literally, there is no association with scheduled resources and the eco tables, which in essence are really temporary housings for mom's while they are being changed/modified. info for scheduled resources related to operations (i.e. jobs) are kept elsewhere..
> >
> >
> > Sent from my Verizon Wireless 4G LTE Smartphone
> >
> > erp07052 <erp07052@> wrote:
> >
> >
> > Good afternoon.
> >
> > i've been having a tough time trying to use the DMT to remove a large group of unnecessary scheduled reources from part MOMs.
> >
> > I know how to reference the PartOpDtl headings to add/chg the scheduled reources info..
> > ECOOpDtl#PartNum,
> > ECOOpDtl#Company,
> > ECOOpDtl#GroupID,
> > ECOOpDtl#RevisionNum,
> > ECOOpDtl#OprSeq,
> > ECOOpDtl#OpDtlSeq
> >
> > but my objective is to DELETE the scheduled resources.
> >
> > And in the DELETE MODE the DMT refuses to take action unless the operation headings are referenced ..
> > Company,
> > GroupID,
> > PartNum,
> > RevisionNum,
> > OprSeq
> >
> > in which case, the DMT then deletes the OPERATION.
> >
> > Anyone tackled this issue before? (V8.03)
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>




[Non-text portions of this message have been removed]
7
Hey thanks.
Yes - we're going to try the "delete everything"
and "reload only the good" approach

using a complete DMT load to DELETE and
an adjusted DMT load to LOAD.

Thanks to all for your help.
I'll post an update - after completion.