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 into ARAS?

  • Yes. it must be created first.

    As mentioned in above comment, use the below XML query and follow the same steps to load part followed by BOM in one shot.

    <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. it must be created first.

    As mentioned in above comment, use the below XML query and follow the same steps to load part followed by BOM in one shot.

    <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