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.
Project view for Sub WBS Elements
Hello Community, I am trying to customize the Project item view to be able to view sub WBS elements as separate projects so that Project Managers at different levels can view and interact with the schedule of their own project without having to view or modify the other WBS Elements. While also enabling the Program manager to have a complete view including interdependencies of activities between multiple projects. I expected Program item to do this, but it doesn't really do anything as far as I know. Anyway, I was able to achieve what I set out to do(sort of) in a couple of different ways but I am faced with multiple issues. Case 1: I tried replacing the property wbs_id of a project with a Sub WBS Element of a different project, the view is generated as expected. Case 2: I create project items for each Sub WBS Element I expect to have and then add them to the Sub WBS relationship of the a program level WBS Element. Again, the view is generated as expected. In both cases I'm not really respecting the property "is_top" of the WBS Element, I haven't found it really being used anywhere. But in both cases, whenever I try to edit any of the project items I get the error : "WBS Activity2 already exists" or "Sub WBS already exists." Error details: <af:legacy_detail>WBS Activity2 already exists.</af:legacy_detail> <af:legacy_faultstring>Violation of PRIMARY KEY constraint.</af:legacy_faultstring> I tried to fix this by changing the "action" attribute from 'add' to 'create' of the relationship item xml elements inside the AML generated inside the method Project_saveProjectTree(This server method updates all the items whenever a change is made in the project view.) This seems to have fixed the issue in some scenarios, and it lets me edit the lower tier project items as intended. However in some other cases, such as when I edit a program level project item I get the error: "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. Warning: Null value is eliminated by an aggregate or other SET operation. Warning: Null value is eliminated by an aggregate or other SET operation. ..." The last sentence repeats about 17 times. The error details don't provide any additional information. The perplexing part about the issue is that I DO NOT get this error when I extract the AML query that is generated inside the method Project_saveProjectTree, and then submit it through Nash or Innovator Admin. It only fails inside the method. So, I'm not quite sure why this is happening or if my approach is wrong from the beginning. Any inputs on the issues or a better way to achieve what I want to do with respect to the project item are appreciated. Thanks in advance, -PrasanthAras - ECO Impact Matrix - Email body additional fields mapping
Hello Aras experts, I am currently working on customizing the Aras ECO e-Mail settings. Currently, the workflow triggers fields such as Activity, Instructions, Eco number, and Title in the email content. However, I've received a request from our business users to incorporate more information from the ECO impact matrix. Integrating fields like ChangeReason and Description was straightforward, as they are available in the same API call as the email query string. On the other hand, attempting to retrieve details from the ECO Impact matrix (ECO-PartBOM) presents a challenge. This requires a separate API that takes the ECO's ID as input and responds with the associated ECO PartBOM information. This matrix includes data like PartBOM number, PartBOM name, Classification, subClass, Unit, and more. I've constructed an AML query string, but I've encountered difficulty when trying to insert the Indexed xPath Item ID, specifically using the format id="${Item[2]/@id}". This action results in an exception, leading to the failure of the API execution. I have a couple of inquiries: 1) Could someone kindly assist me in accessing the ECO ID or provide a potential solution for achieving this dynamic parameter insertion? 2) Is there a method to view the complete API RESPONSE and xPath directly on the page? My query String: ( The bold AML ID has the problem in Xpath access ) <Item type="Activity" id="${Item/ActivityId}" action="get" select="name,message"/> <Item type="${Item/@type}" id="${Item/@id}" action="get" select="item_number,title,id,change_reason,description"/> <Item type="ItemType" id="${Item/@typeId}" action="get" select="label,name"/> <Item type="Express ECO" id="${Item[2]/@id}" relName="Express ECO Affected Item" action="getItemRelationships"> <related_id> <Item> <Relationships> <Item type="Affected Item Property" action="get" select="new_item_id"></Item> </Relationships> </Item> </related_id> </Item> My HTML body: <BODY> <font size="+1"> <p>You have been assigned a new change management activity in Aras Innovator (details below). Please log in to Aras to complete the work.</p> <p><font size="+0" style="font-variant: small-caps">Activity:</font> ${Item[@type="Activity"]/name}<br/> <font size="+0" style="font-variant: small-caps">Instructions:</font> ${Item[@type="Activity"]/message}</p> <p><font size="+0" style="font-variant: small-caps">${Item[@type="ItemType"]/label}:</font> ${Item[2]/item_number}<br/> <font size="+0" style="font-variant: small-caps">Title:</font> ${Item[2]/title}<br/> <font size="+0" style="font-variant: small-caps">Change Reason:</font> ${Item[2]/change_reason}<br/> <font size="+0" style="font-variant: small-caps">Description:</font> ${Item[2]/description}</p><br/> </font> <B> ${substring("Some information needed to form this email was not found. Please contact your system administrator to ensure that the sender has privileges to view the items.", 1, (1-count(Item[2]))*158)} </B> <query_string>Type: ${Item/@type}</query_string></br> <query_string>ID : ${Item/@id}</query_string> </br> <query_string> ECO ID : ${Item[2]/id} <query_string> </BODY> Notification details: Item[2]/@id error screen shot(xpath doesnot support for such index) ECO Impact matrix screenshot ( these fields needs to access through AML and map HTML body. Regards, S. Senthurpari
Batchloading multiple Document items - but some reference/link to others via template_file_container. Possible to batchload all documents and their dependent items in one go?
Hey all, I am developing a batchloading schema for uploading template files. Pretty straightforward, here is my AML for a simple document load: <AML> <Item type="Document" action="add"> <name>@1</name> <description>@2</description> <state>@3</state> <classification>@4</classification> <authoring_tool>@5</authoring_tool> <is_template>@9</is_template> <Relationships> <Item type="Document File" action="add"> <related_id> <Item type="File" action="add"> <actual_filename>@6</actual_filename> <filename>@7</filename> </Item> </related_id> </Item> </Relationships> </Item> </AML> However, I am trying to utilize template file containers for office connector templates. Template file container is a property on the document itemtype that lets a template document item to reference another template document item in order to reference and "use" its file. Useful if you want to have templates across multiple document classifications without adding the file individually to all those differently classified template doc items. I have about 10 templates and about 20 document classifications, so wanted to create around 200 document items (templates) but have only 10 hold the actual files, and 190 just reference the 10 via template_file_container property. A few questions: Am I able to accomplish this in one batchload procedure/one AML script? How do I write the AML for the latter document items to reference the file-holding document items? I imagine it is something like:<template_file_container></template_file_container>, but will the code require the actual item code (BFA3BE03444448F5916133D874712CF4 or something similar) or is there a way to use the name/item numbers? Or is there a way to easily find the item code of the created template-holding document items from earlier in the "batchloading process"? And if so, how would I go about writing that? What would be the most robust and simplest script I can write to accomplish my goals?How to fetch details of nested relationships using AML query?
I have a requirement like Main Phase can have relationship with Activities and Phases, also Phases can have child phases eg: i want to get the id of all activity (itemtype2) if i provide id of main phase is provided ? A phase can have no activity also.
Suggestion: Best place to learn AML language to use correct template in batchloader
Hello Community I have recently started using PLMA tool and batchloader. Is there any best resource to learn aml language to load data in batch through batchloader. This will also help me in aml search in PLMA. Thanks
Uploading a local file to Innovator using the Batch Loader
I'm having issues uploading a local file to an instance of Innovator using the Batch Loader. I have the following XML: <Item type="Document File" action="add"> <related_id> <Item type="File" action="add"> <actual_filename>C:\some\file\path\@1</actual_filename> <filename>@1</filename> </Item> This currently fails. I had to search to find out the <actual_filename> tag is used for the fully qualified path of the file, yet it is not present in the File Item when inspecting it through Innovator Client. Any help with this would be appreciated.
Can't do a bulk ALM code input.
Hello, not sure if anyone is having this problem but I seem to not be able to do a bulk item creation with AML. I'm using Nash which has worked before but when I put this code in for example: <AML> <Item type='Part' action='add'> <item_number>234-17351-0001</item_number> <description>A test assembly</description> </Item> <Item type='Part' action='add'> <item_number>131-87171-0001</item_number> <description>Another test assembly</description> </Item> </AML> All that gets added is the first part number and the second number is never created. Is there something I am missing from my code?
Update Part Document Relationship
Hi, I'm trying to update PART DOCUMENT relationship but facing issue: AML: <AML> <Item type="Part Document" action="edit" where="[Part_Document].id='C080331098D24F00B635418D823D97AC'"> <related_id>AFF14CBFFD074494B00E3D247D8D11FE</related_id> </Item> </AML> getting Object reference not set to an instance of an object error. how to edit this relationship as I want to attach different document on some condition. Thanks, Maddy.
join the data of multiple item type using aml
Hi, I am new to this platform. Suppose I have an item type Part with two properties that is part ID and Part Name and the other Item Type is Supplier with properties partID and Suplliers wherein for one partID there can be multiple Suppliers. Is there any aml query or any other way where in we can fetch the result which consist part ID , Part Name and Supplier as output of the query
