Forum Discussion

Parth's avatar
Parth
Ideator I
5 years ago

Unable to load End of Sale/ End of Support Not available fields with Boolean 1

Hello Batchloader team I am trying to load End of Sale Not available and  End of Support Not available fields with Boolean 1 against unique P/Ns in the Manufacture Parts table I loaded the dat...
Batch Load
AngelaIp's avatar
AngelaIp
Ideator I
5 years ago

Hi Parth,

Not sure if you can really do an edit in this way with the embedded "get" query.

Try this variant:

<Item type="Manufacturer Part" action="edit" where="keyed_name= '@1' ">

   <_end_of_sale_blank_flag>@2</_end_of_sale_blank_flag>
   <_end_of_support_blank_flag>@3</_end_of_support_blank_flag>

</Item>

Best regards!

Angela

AngelaIp's avatar
AngelaIp
Ideator I
5 years ago

Edit: You mentioned your template was autogenerated. I assume you replaced the original 'add'-action with 'edit'? The Batchloader Wizard is mainly optimized for adding stuff. Each other use case you normally have to optimize by yourself to work.