Delete a complete BOM (if any) using Batch Loader

Offline pmateo over 4 years ago

Hello,

I am learning how to use the batch loader to add a BOM to a specific part, but now I would like to do the opposite: I would like to come up with a script I can run with the Batch Loader that would delete a BOM regardless of how many components it has. How could I get started on this?

Regards,

PMateo

Top Replies

AngelaIp over 4 years ago +1

I think it´s possible to delete all elements of type 'Part_BOM' which has the source_id of your parent Part. <Item type="Part_BOM" action="delete" where="[Part_BOM].source_id='123456....'"></Item> …
Offline Gopikrishnan over 4 years ago in reply to pmateo +1

Hi Pmateo It should be on opposite way. You need to use the related_id. (Source ID is ID of Parent Part and Related ID is ID of Child Part) Example: Parent1 --> Child1 Parent2 --> Child1 If you…
Offline Gopikrishnan over 4 years ago in reply to pmateo +1

Hi Pmateo Yes, it will delete Child1 every where it is used and your query is correct and it should delete all bom in parent/ May I know using which account you are running the query ? Also try with…

Parents

AngelaIp over 4 years ago

I think it´s possible to delete all elements of type 'Part_BOM' which has the source_id of your parent Part.

<Item type="Part_BOM" action="delete" where="[Part_BOM].source_id='123456....'"></Item>

Not tested! Use with care :-).
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel
Offline pmateo over 4 years ago in reply to AngelaIp

Thanks! I will give that a try now and see what I get. Cheers!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Offline pmateo over 4 years ago in reply to AngelaIp

Thanks! I will give that a try now and see what I get. Cheers!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data