Import BOM in Excel file to ARAS

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