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

  • @angelap Angela - The above variant actually worked for me. The whole purpose for using batch-loader at my organization is to load data in bulk instead of manual data entry.

    Some use cases- 

    1) Add/Update EOS/EOL dates to already existing manufacturing parts

    2) Add additional vendor and vendor_product _cost (under AVL) linked to the main product table (TOC)

  • Here Part number is a unique ID (part table). This table is linked to AVL. the task is to add vendor and cost for 150 unique part numbers. Considering 3columns:  part number (part table), vendor name (AVL table) and Cost (AVL table) - what should my query be ?

Reply
  • Here Part number is a unique ID (part table). This table is linked to AVL. the task is to add vendor and cost for 150 unique part numbers. Considering 3columns:  part number (part table), vendor name (AVL table) and Cost (AVL table) - what should my query be ?

Children
  • What have you tried so far? Your AVL probably contains Vendor items that already exist. Try to learn more about regular AML queries. You will notice that these kind of queries are pretty standard: 

      <Item type='Part' action='edit' where="keyed_name= '@1'">
         <Relationships>
         <Item type='your Part AVL' action='add'>
           <related_id>
    <Item action="get" type="your Vendor type" select="id">
    <keyed_name>@7</keyed_name>
    </Item>
            </related_id>
         </Item>     
      </Relationships>  
     </Item>