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 data correctly with txt file as shown in the preview.

I think the template (which is auto-generated) is incorrect

<Item type='Manufacturer Part' action='edit'>
<id>
<Item type='Manufacturer Part' action='get' select='id'>
<keyed_name>@1</keyed_name>
</Item>
</id>
<_end_of_sale_blank_flag>@2</_end_of_sale_blank_flag>
<_end_of_support_blank_flag>@3</_end_of_support_blank_flag>
</Item>

What would be the solution to not get a failed result ?

Parents
  • 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

  • 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.

Reply Children
No Data