How 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.Need to Hide few Columns in Part relationship BOM Tab
Hello Aras Experts, I have a business requirement related to the BOM (Bill of Materials) tab. In my current scenario, there is a need to hide specific columns, illustrated by the black-highlighted sections in the attached screenshot. Typically, to hide a column, one would navigate through ItemType -> Part -> Property -> and check the Hidden & Hidden2 values. However, in my case, these columns seem to be non-existent in this structure. I've also attempted to use JavaScript in the formload and formpopulated events to hide the columns, but unfortunately, this approach has not yielded the desired results. I would greatly appreciate any suggestions or guidance you can provide to address this issue. columns to hide - Transgroup, smallest pack, product type etc ( highlighted below) Regards, S. Senthurpari
How 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.
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, PMateo
