Issue: We are wanting to delete a resource under an operation. Example, under Method Tracker we ahve part 123-XYZ, then we pick a revision, in the left pain we select Operation 60, the it shows Resources-for us that is 20, and it is the 20 line we want to delete. I can build the BAQ to get the info, but i am very unsure as to which colomn headers to use in DMT. I can’t find a template that matches.
Want to do: Delete Resource 20 from select parts.
To help this discussion some, here is wher eI am pulling the info from. Help is needed in translating it to DMT.
[ECOOpDtl].[OpDtlDesc] as [ECOOpDtl_OpDtlDesc]
from Erp.Part as Part
inner join Erp.PartRev as PartRev on
Part.Company = PartRev.Company
And
Part.PartNum = PartRev.PartNum
inner join Erp.ECOOpDtl as ECOOpDtl on
PartRev.Company = ECOOpDtl.Company
And
PartRev.PartNum = ECOOpDtl.PartNum
And
PartRev.RevisionNum = ECOOpDtl.RevisionNum
And
PartRev.AltMethod = ECOOpDtl.AltMethod
and ( ECOOpDtl.OpDtlDesc like ‘XYZ$#%GTHYL’ )
where (Part.PartDescription like ‘XYZ%’)
Think I figured this out. I used the Bill of Operations to generate the template and that seemed to work. Testing it now and see how it all works out. My first test went pretty good.
I was able to delete the entire operation and not just the resources in the operation. Anyone have any ideas how to do this?
If you run the DMT Bill Of Operations Import in Delete mode and set the ECOOpDtl#RowMod field to D, this tells DMT that you want to delete the Scheduling Resource rather than the whole Operation.
E.g.
Company,ECOGroupID,PartNum,RevisionNum,AltMethod,OprSeq,OpCode,ECOOpDtl#OpDtlSeq,ECOOpDtl#RowMod
EPIC06,Eng1,001MP,A,10,NoHours,20,D
Gotcha! I new it was something simple like that! Thanks! I’ll give it try!
So i have this:
Company PartNum RevisionNum OprSeq OpCode Plant ECOGroupID ECOOpDtl#PartNum ECOOpDtl#RevisionNum ECOOpDtl#OpDtlSeq ECOOpDtl#OpDtlDesc ECOOpDtl#RowModAnd it is not deleting the resource. Any insight? I’m in test mode and it says it was done correctly but when you look there is no changes that had been done.
I’m not sure what test mode is. You need to run the DMT Import in Delete mode.
Sorry, bad verbage. I meant i am in Test Database. I am assuming that Delete mode is when you select the delete option instead of update or add new line, correct?
Correct. I ran a Bill Of Materials Import in Delete Mode with your import columns and it correctly deleted the Scheduled Resource.
Well, I was doing it from the bill of operations. Should this be done through the bill of materials instead?
Sorry, I meant Bill Of Operations
Does my info/columns/whatever the verbiage is- look correct that I posted for this?
So, I have the delete selected. If this doesn’t work, I am thinking I am not using the right columns or something.
Figured it out! I was pulling info from the live database and the Test is not 100% identical the active. So, once I adjusted for that variance, it all worked out perfectly. Thanks!
Hi guys & @Arthur - I just ran into the same issue.
Our current version 4.0.32.0 of DMT (we’re on 10.0.700.4) does not contain ECOOpDtl#RowMod in the template. When I run the delete, DMT states ‘OpDtlRow not found’.
I tried adding ECOOpDtl#IsPartOpDtl, but no change. I’ve tried adding duplicate company, part, revision, etc as additional ECOOpDtl# columns, but no change.
Where am I going wrong?
I’m trying to delete Operation Resources (ex: OpDtlSeq 20) via the BOM DMT. Unfortunately - it deletes the entire operation, rather than just the operation’s scheduled resource. Doing it manually via Engineering Workbench works.
| Company | ECOGroupID | Plant | PartNum | RevisionNum | OprSeq | OpCode | ECOOpDtl#OpDtlSeq | ECOOpDtl#ResourceID | ECOOpDtl#IsPartOpDtl |
|---|---|---|---|---|---|---|---|---|---|
| BlahBlah | DMT_20180619 | MfgSys | 108380 | A | 10 | POPROD | 20 | PRPROD | TRUE |
Thanks for the help!
