Forum Discussion

Parth's avatar
Parth
Ideator II
5 years ago

Batch Loader displays fail message when uploading mass data in PLMA

I am trying to update PLMA with values in the field which are currently blank using a primary key in a Tab delimited Text file. I am getting an autogenerated template in Batch loader <Item type='...
Gopikrishnan's avatar
Gopikrishnan
Accelerator II
5 years ago

Hi Parth

Edit action in AML should have where attribute. Update your query like below


<Item action="edit" type="Part" where="[Part].item_number ='@1'">
<_stuff_master_uid>@2</_stuff_master_uid>
</Item>

Note: Above query will create new generation of Part item and update only latest generation. If you don't want to create new generation then use below query

<Item action="edit" type="Part" where="[Part].item_number ='@1'" version="0">
<_stuff_master_uid>@2</_stuff_master_uid>
</Item>

Thank You

Gopikrishnan R

solana_callaway_bd_com's avatar
solana_callaway_bd_com
Ideator II
2 months ago

This helped me 4 years later, thank you [emoticon:c4563cd7d5574777a71c318021cbbcc8]