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
Thank you Gopikrishnan.
I used this template in batchloader.
I am getting the following error now:
Code: SOAP-ENV:Server.InsufficientPermissionsException
Message: You have insufficient permissions to perform 'update' operation.
Details: You have insufficient permissions to perform 'update' operation.
Is this an access issue ? I am already an admin in PLMA
Yes it is an permission issue. Can you check the permission for Part item ? or can you try using root user account
Thank you - It worked now
Also, When I want blank (null values) in a field and try to use batchloader, the output shows @2 in the main application
I am using this template:
<Item action="edit" type="Part" where="[Part].item_number ='@1'">
<_uin_na>@2</_uin_na>
</Item>
Here, item_number = primary key
uin_na needs to be blank (currently it has value)
In this case, you need to use the life below
<Item action="edit" type="Part" where="[Part].item_number ='@1'">
<_uin_na condition="is null"></_uin_na>
</Item>
