Import BOM in Excel file to ARAS

オフライン

Hi all,

I'm new to ARAS innovator and I'm not sure on how to import BOM in Excel file to ARAS. I have read from forum and they ask to use Batch Loader but I don't know how to do it. Can anyone explain step by step on how to do this.

Thanks.

Regards,

Izzul

Parents
  • So, parts must be created first?

    Is there any possibility to import parts from a list?

  • Yes, Part must be created first. But you can create and import BOM in one shot using below query

    Copy the below query to AMLQuery.xml file and follow the steps in initial reply.

    <Item action='add' type='Part'>
    <item_number>@1</item_number>
    </Item>
    <Item action='add' type='Part'>
    <item_number>@2</item_number>
    </Item>
    <Item action='add' type='Part BOM'>
    <quantity>@3</quantity> //@3 column in Excel
    <source_id><Item type='Part' action='get'><item_number>@1</item_number></Item></source_id>
    <related_id><Item type='Part' action='get'><item_number>@2</item_number></Item></related_id>
    </Item>

Reply
  • Yes, Part must be created first. But you can create and import BOM in one shot using below query

    Copy the below query to AMLQuery.xml file and follow the steps in initial reply.

    <Item action='add' type='Part'>
    <item_number>@1</item_number>
    </Item>
    <Item action='add' type='Part'>
    <item_number>@2</item_number>
    </Item>
    <Item action='add' type='Part BOM'>
    <quantity>@3</quantity> //@3 column in Excel
    <source_id><Item type='Part' action='get'><item_number>@1</item_number></Item></source_id>
    <related_id><Item type='Part' action='get'><item_number>@2</item_number></Item></related_id>
    </Item>

Children
No Data