Batch Loader displays fail message when uploading mass data in PLMA

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)

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>

Thank you Gopikrishnan

It worked perfectly fine!

I have 1 more use-case with which I need to resolve- 

I need to ADD new vendor to Table of Content PID table - under AVL Tab.

I have information of PID, AVL name in my csv template. What should be my AML template in batchloader ?

I am attaching a picture of what and where vendor needs to be added -

Hi

You have use below AML query. Changes needed in bold.

AVL should be the name of the AVL relationship. 

avl_name should be the name of the AVL name property

@1 -- PID Number

@2 -- AVL Name in Excel

<AML>
<Item action ="add" type="AVL">
<avl_name>@2</avl_name>
<source_id>
<Item action ="get" type="Part" where="[Part].item_number='@1'">
<source_id>
</AML>