• Replies 15 replies
  • Subscribers 41 subscribers
  • Views 31109 views
  • Users 0 members are here
Options
Related

Import BOM in Excel file to ARAS

izzul
Offline

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 Reply Children
  • Offline in reply to [email protected]

    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>