Delete a complete BOM (if any) using Batch Loader
Hello, I am learning how to use the batch loader to add a BOM to a specific part, but now I would like to do the opposite: I would like to come up with a script I can run with the Batch Loader that would delete a BOM regardless of how many components it has. How could I get started on this? Regards, PMateo21KViews0likes12CommentsHow to get items with all of its revisions with maximum generation
Hi, I am trying to get part all revision with maximum generation using IOM: below are the entries: Item Number Generation Revision Testnumber1 1 00 Testnumber1 2 00 Testnumber1 3 00 Testnumber1 4 00 Testnumber1 5 00 Testnumber1 6 00 Testnumber1 7 00 Testnumber1 8 01 Testnumber1 9 01 Testnumber1 10 02 so from above entries I want: Item Number Generation Revision Testnumber1 7 00 Testnumber1 9 01 Testnumber1 10 02 I got this result with below SQL: select item_number, MAX(generation) as generation, major_rev from innovator.PART group by item_number, major_rev order by generation but how to do this with IOM? Regards, Maddy.10KViews0likes4CommentsModified Multilevel BOM Report
Hello, I have modified the existing multilevel BOM report to get all the levels of the BOM. The OOTB feature only lets you fecth till the 5th level. I have modified the existing report to fetch till 18th level which was my initial requirement, this part is hardcoded and I want to make it dynamic. Please advice me on this topic. Just to gave a background, I have increased the indenture level in the Report stylesheet to 18 and made other changes accordingly, please let me know if this can be done dynamically. Please let me know. Thanks in advance, Mithun8.7KViews0likes6CommentsAdjusting the visualization of graph
Hi everyone, a few months ago I had asked a question about displaying relations: https://community.aras.com/f/applications/8963/displaying-relation-between-parts-found-in-different-product-structures which led to creating a graph/web as shown below. I've got 2 follow up questions: Is there a way to hide/remove the middle blocks with randomly generated ID numbers when I expand an 'Assembly'. Is there a way to give each "type" of block a different colour? (e.g. Assembly = red, Component = blue, Software = Purple") Thanks in advance! I truly appreciated the help I got earlier. I'm happy to answer questions if necessary.8.4KViews0likes4CommentsHow do you import Excel BOM data into Aras Innovator open version?
Hello, I currently use the open, free version of Aras Innovator and am having difficulty figuring out how to store BOM data within the tool. I have seen from other posts that subscribers have access to a direct import functionality and also some kind of batch loader. For the latest free version of ARAS, what are the exact steps to import an excel file containing BOM data into Aras? Any help would be greatly appreciated.6KViews1like7CommentsAras REST API - How do you navigate / create a BOM Structure using the REST API?
Hello Aras Community Members Does the ARAS REST API allow you to navigate the BOM structure, starting with a Part? For example, if I have a BOM structure as shown below, I would like to start with any Part in the structure and navigate down the BOM tree. Can anyone share the REST API endpoint for making this work, or point to a specific section in the API guide? Part A - Part A1 - Part A2 --- Part A21 --- Part A22 ------Part A221 Second question: Does the REST API allow users to create a BOM structure, e.g. a BOM tree as above? Third question: Does the REST API allow users to update the BOM structure?Solved5.2KViews0likes2CommentsDisplaying relation between parts found in different product structures.
Hi everybody, I'm hoping someone can help me with this! Basically I would like to visualize how parts are related to one another if found in multiple subsystems (instead of determining it yourself through expanding the BillOfMaterials). Some thing like a spiderweb idea or maybe just a Matrix. Does anyone know if this is possible and how ??? Thanks in advance! I'm happy to answer questions if necessary.4.9KViews0likes2CommentsBOM feature
Hi, Is it possible to modify BOM that we can see all parts levels, not just top-level, something like in the 'BOM Structure'? I think it would be helpful to see this information when building a BOM. You could even have a feature that lets you add a part directly to another level. This could speed up work by creating the BOM. Many thanks Best Regards, Erlandas4.5KViews0likes1CommentExport Relationships to Import to Another ItemType
Good day all. I would like to export all of the Relationship info from one ItemType so I can import it to another ItemType. Currently our database is configured so the Parts List (BOM) is a document and not part of the Part, both are custom ItemTypes. I would like to be able to export the BOM information from the Parts List so I can add it to the Part (trying to bring our database closer to OOTB). Thank you for any recommendations that you can provide.2.2KViews0likes1Comment