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

  • Please keep me informed on any feedback

  • Hi Izzul & Andreas

    You can write a custom ARAS method to import BOM or using the below AML query, you can add the Part BOM

    Prerequisites

    Parent Part and Child Part should exist in ARAS

    For Loading One Part BOM (Inputs are highlighted)

    <AML>
    <Item action='add' type='Part BOM'>
    <quantity>10</quantity>
    <source_id><Item type='Part' action='get'><item_number>ParentPart001</item_number></Item></source_id>
    <related_id><Item type='Part' action='get'><item_number>ChildPart001</item_number></Item></related_id>
    </Item>
    </AML>

    Input File

    Create a Excel file with Column  (Parent Part, Child Part and Quantity) - Columns are mapped to below query @1 - Parent Part and @2- Child Part and @3 - Quantity. save it as inputfile.csv (Tab Delimited)

    (Note: You can include any other field inputs in below query and add as @4, @5 etc.. and modify the below query.

    AMLQuery.xml (Copy Paste the below query to notepad and save it as AMLQuery.xml)

    <AML>
    <Item action='add' type='Part BOM'>
    <quantity>@3</quantity>
    <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>
    </AML>

    Steps to load multiple Part BOM using Batch Loader are

    Open Batch Loader.exe (Available in ARAS Installation CD)

    Select ‘New’ in Batch Loader

    Update the below parameters in Batch Loader
    • Server : ARAS URL (Example : localhost/InnovatorServer
    • Database : Innovator Server (Select from the drop-down menu)
    • User : root
    • DataFilePath : inputfile.csv (Select the input file)
    • Delimiter : \t (Select tab delimiter)
    • WorkerProcess : 2
    • Threads : 4
    • LinesPerProcess : 100
    • Encoding : Unicode (UTF-8)
    • FirstRow : 1
    • LastRow : -1
    • LogFilePath : outputfile.txt(Create any text file and select)
    • LogLevel : 2
    • PreviewRows : 1000
    • MaxColumns : 10
    • FirstRowColumnNames: False (True in case if input file has header)

    Click load and select AMLQuery.xml
    Click Verify and provide the root password
    Verification Message: Verification successfully Passed: the template does not contain invalid item types or properties.
    Click Load

    You can also create Parent and Child Part first and connect by modifying the AML query like below. You can also use batch loader for this

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

    Thank You

    GK

  • So, parts must be created first? Is there any possibility to import parts from a list into ARAS?

  • So, parts must be created first?

    Is there any possibility to import parts from a list?

  • So, parts must be created first? Is there any possibility to import parts from a list into ARAS?

  • So, parts must be created first? Is there any possibility to import parts from a list into ARAS?

  • So, parts must be created first? Is there any possibility to import parts from a list into ARAS?

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

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

  • I know this is a relatively old post, but I am wondering how to go about adding a document instead of adding a BOM