Once again we are sharing a technical feature about Aras Innovator on this blog because we see it as an easy feature to implement and it could be useful for you to have this in order to perform a proper evaluation of this PLM solution and of course to understand the flexibility of the solution.
So today’s presentation explains how you can list in a nice way the result of a reverse query based on a property relationship. You can see on the following image the two kind of relationship you can have in Aras Innovator. The most customisable one is the Relationship throught a relationship type item. But sometime you need to easily implement a (N) to (1) relationship and you can use a property of type Item to do so.
The next image shows you a relationship that exists in the Aras Innovator demo database available on the project portal of the Aras website. This relation allow the user to link a customer to a project. For each project, there is a customer attached.
Our goal is then, from the Customer form to be able to list all the projects related to this customer.
In order to do so, we need first, to create a null relationship in orderb to provide a tab to the customer form. From this tab we need to call the html page that was provided in Innovator 9.3 with the following path :
And you need to provide the following string as parameters:
I present the full customizing in the following video:
Feel free to leave a comment if you have any question or any interest in such customizing, I will show soon how to implement the same reverse relationship with a normal Relationship Type.
Have fun customizing your Aras instance !!
With the upcoming Aras Community Event 2012 in Detroit, MI starting on may 1st, the vote for the Aras Collaborate & Contribute award has been launched. This award is mainly rewarding the work that has been done in order to improve the Aras Innovator experience by providing shared solutions to the community. These new solutions are mainly coming from customer projects. But sometimes it also comes from partners who want to bring something new, either to help companies to discover the project like a language pack (italian has been made by Focus PLM this year) or to bring some new fresh feature like we did with our Alternative Structure Browser or more recently with our Excelator project which allows to edit Innovator’s data in Excel. We won that price two years ago (through our french branch) with our Aras2UML project which was converting Aras Innovator Datamodel into a UML Diagram (That project is still maintained if you want to try it).
Without further due, here are the nominees for the 2012 Aras Collaborate & Contribute Award. Please vote for the 3 best solutions and share the survey!
- Ability to easily copy previous item versions – Seiko Epson
- Alternative structure browser for large assemblies – Minerva
- AML Studio Editor – Gentex Corporation
- Aras connector to SolidWorks EPDM workflow state triggering definition – Fisher-Unitech
- Classification dialog filtering – Lear Corporation
- Client refresh synchronization improvement – Mitsubishi Heavy Industries
- Configurable grid fill/copy down – Lear Corporation
- Discover Innovator community edition search solution – NorthRidge Software
- Enterprise search integration open source option – Alcove9
- Expanded grid control customization capabilities – GETRAG FORD Transmissions
- File converter plug-in API enhancements – Softech
- Drag & drop files to desktop – Carestream Health
- Gantt chart filtering range capabilities for printing – Mitsubishi Power Systems
- Get item repeat config API enhancements – xPLM
- Improved security capabilities for single user identity with over 300 groups & roles – COMPAL
- Italian Language Pack – Focus PLM
- Item save efficiency streamlining – Maxion Wheels / Hayes Lemmerz International
- Enhanced replication transaction resubmit – ECCO
- Enhancements to connector support for multiple CAD file types in SolidWorks EPDM – Spartan Motors
- Firefox browser client for Mac/Apple – ECCO
- Glyf button to launch secondary screens from grids – Sonnax
- Impact matrix item optimization – Lear Corporation
- Language pack administration improvements – GETRAG FORD Transmissions
- Multiple new views of project data – MOTOROLA
- Named baseline comparison capabilities – Sandia National Laboratories
- Recursive event handling improvement – Mitsubishi
- Retrieval of multiple different CAD assembly configurations enhancement – Carnaud Metalbox Engineering
- Simplified export to Excel – Carestream Health
- Team security permissions structure improvement – Lear Corporation
- Workflow enhancements for versionable items – NSK Steering
At Minerva we recently enhanced our product delivery process in order to make sure we use our ressources the best way to deliver the products which provide you with the most efficient features. As we get bigger these days with an Increase of the Aras Innovator subscribers, we needed to enhance that process. This new process gives us a better framework to know what anyone does on a specific product and why he does that. But as at Minerva, we are mixing competencies of PLM consulting with technical development capabilities, we allow each one to come up with new idea of new products sometimes just by taking a day developping an Idea. So the latest example is this “Excelator” tool which is an Microsoft Excel Add-in I started to develop based on some customers request.
Editing Aras Innovator Data within Microsoft Excel
This is a pretty simple development answering a feature request we had from many customers. “Can we get a list of information from Aras, like a list of Part’s price, in Microsoft Excel to edit the information and send them back in Aras Innovator”. So that ‘s what we did. The main concern was to make sure we have a very flexible and a framework which we can enhance by adding features. So in the following video, you can see this first draft of the tool. It has taken one day to developp it, mainly because we capitalized a lot from our previous developments and we are now able to use a lot from these existing products. Now I leave you with the video, feel free to comment this post if you like the video or if you think of some feature you would like to see in the future version. And if you want a closer look at it we share the software for free until it becomes v1.0 (just like we do with the Structure Browser). For now, we invite you to ask us for it, before we put it in place the download link on our corporate website.