Klaus Wroblewski さんのグループアクティビティ

Group Identity Member AML

Klaus Wroblewski — Thu, 15 Mar 2018 09:45:47 GMT

How can I add members to a group identity with AML code using Batch Loader? I appreciate your comments.

Discussion Starter I

Wed, 06 May 2020 21:37:57 GMT

Start a discussion in a forum that receives 5 replies.

Community profile e-mail address update?

Klaus Wroblewski — Fri, 09 Aug 2019 09:35:19 GMT

Hello,

how can I update my e-mail address to login to this community?

Best regards
Klaus

AML Basics

Christopher Gillis — Tue, 19 Feb 2019 15:00:00 GMT

The Adaptive Markup Language, sometimes referred to as Aras Markup Language, serves as the backbone of Aras Innovator. Almost every action that a user performs in the client sends an AML request to the Aras Innovator server to process the business logic. In this blog post, we'll cover the basic structure of an AML request so you can write your own queries.

Testing AML Queries

As part of this blog post, we'll be offering a few different sample AML queries which you may wish to test in your development environment. You can do this in a couple of different ways.

Nash

Nash is a lightweight application available in every instance of Aras Innovator which lets you run AML queries directly against your server. You can access Nash by appending `\Client\scripts\nash.aspx` to the end of the URL you typically use to access your Aras Innovator instance (e.g. http://localhost/InnovatorServer/Client/scripts/nash.aspx). The Aras Homepage community project also features a handy link to access Nash on your instances.

InnovatorAdmin

As an alternative to Nash, you can also check out InnovatorAdmin, an extremely useful tool written by a member of the open Aras community. In addition to some other helpful features, InnovatorAdmin lets you run AML queries just like the built-in Nash application does. InnovatorAdmin also features IntelliSense to make writing your AML queries even easier.

The AML Structure

<AML>

If you are running your queries through Nash with the default settings, they should begin and end with this tag. You'll notice all of the sample queries you will find in this blog post are wrapped in AML tags so you can easily copy and paste them directly into Nash for testing.

<Item>

The most used tag in AML. As most administrators of Aras Innovator know, everything in Innovator is an Item. Even ItemTypes themselves are stored in Innovator as Items. This tag lets you query for Items in the database by defining a few different attributes.

id - The unique ID of the item in the database
type - The name of the ItemType you want to query on
action - The type of query you want to perform

As a simple example, let's try querying for the Administrators Identity by passing in the ID.

<AML>

<Item type="Identity" action="get" id="2618D6F5A90949BAA7E920D1B04C7EE1"/>

</AML>

Note: If you're testing this AML through Nash, you must wrap your entire query inside of an <AML/> tag like the example above.

<property>

Property tags in AML exist as children to an <Item/> tag. The name of these tags correspond with the names of the ItemType's properties. For example, we could rewrite the query above to search for the name of the Identity rather than searching directly on the ID.

<AML>

<Item type="Identity" action="get">

<name>Administrators</name>

</Item>

</AML>

When using the get action, any property tags that you specify will be used as conditions to define which Items you want to get. However, when you use actions like add, edit, or update, the property tags define what changes to the item you want to make. In the example below, we'll add a new Identity with some property values.

<AML>

<Item type="Identity" action="add">

<name>My Group Identity</name>

<is_alias>0</is_alias>

<description>A group identity that we will add members to later</description>

</Item>

</AML>

Note that these property tags use the names of the properties on the ItemType which may not match the labels that you see in the Client. All property names will be lowercase and any spaces are typically replaced with underscores.

Item properties are stored at a database level as an ID. We can query on an Item property by passing in this ID, or we can use an <Item/> tag to expand our AML query and pass in additional parameters. Below you'll find a find a simple query to look up all Parts managed by my Identity.

<AML> <Item type="Part" action="get"> <managed_by_id> <Item type="Identity" action="get"> <name>Chris Gillis</name> </Item> </managed_by_id> </Item> </AML>

You can continue to nest <Item/> tags like this to easily build quite complex queries.

<Relationships>

We can use this tag to query on the relationships that exist between items in Aras Innovator. The Relationships tag is merely a container and will never have any attributes defined on it. You can see an example of how to use this tag below when we search for the Members of our Administrators Identity.

<AML>
<Item type="Identity" action="get">
<name>Administrators</name>
<Relationships>
<Item type="Member" action="get"/>
</Relationships>
</Item>
</AML>

Just like with properties, we can also add or edit Relationships through this tag. Note that nested item properties can perform different actions than their parents like in the example below.

Now that we've learned a few different core AML techniques, let's combine them all together into one query. Let's try to find all of the Group Identities in our system that a specific user is a member of.

<AML> <Item type="Identity" action="get"> <is_alias>0</is_alias> <Relationships> <Item type="Member" action="get"> <related_id> <Item type="Identity" action="get"> <name>Chris Gillis</name> </Item> </related_id> </Item> </Relationships> </Item> </AML>

We can also use these same concepts to add or edit Relationships as well. Note that nested <Item/> tags can perform different actions than their parents. In the example below you can see how to add Members to the Group Identity we created earlier.

<AML>
<Item type="Identity" action="get">
<name>My Group Identity</name>
<Relationships>
<Item type="Member" action="add">
<related_id>
<Item type="Identity" action="get">
<name>Chris Gillis</name>
</Item>
</related_id>
</Item>
<Item type="Member" action="add">
<related_id>
<Item type="Identity" action="get">
<name>Eli Donahue</name>
</Item>
</related_id>
</Item>
</Relationships>
</Item>
</AML>

With just a few key concepts under your belt, you're already on your way to being an AML wizard.

Conclusion

I hope this brief introduction to AML has been helpful. In future blog posts, we'll cover more advanced topics in AML like using different attributes to configure your query and using custom actions. If you have any questions about AML or suggestions for AML topics to cover in the future, please leave a comment!

Ask A Question I

Wed, 12 Dec 2018 22:57:00 GMT

Ask a question in a forum.

Adding document with file error - AML Batch Loader

Klaus Wroblewski — Tue, 17 Jul 2018 10:08:57 GMT

Hi, I like to add new documents with attached files. Generally that works. But when a file does not exist I get the Error: File xy.dwg does not exist and the document will not be created. Is there a possibility that the document will still be created without file? I am using this AML template with Batch Loader <Item type="Document" where="pbu_id='@1'" action="merge" version="0"> <pbu_id>@1</pbu_id> ... <viewable_file> <Item type="File" action="add"> <actual_filename>@7</actual_filename> <filename>@8</filename> <Relationships> <Item type="Located" action="add"> <related_id>xy</related_id> </Item> </Relationships> </Item> </viewable_file> <Relationships> <Item type="Document File" action="add"> <related_id> <Item type="File" action="add"> <actual_filename>@9</actual_filename> <filename>@10</filename> <Relationships> <Item type="Located" action="add"> <related_id>xy</related_id> </Item> </Relationships> </Item> </related_id> </Item> </Relationships> </Item> I appreciate your comments. Regards Klaus

AML New User Password

Klaus Wroblewski — Wed, 18 Apr 2018 08:11:53 GMT

Hi, I would like to create new users with user password by AML in Batch Loader. I have done this but password in Innovator is not added/updated. <Item type="User" where="login_name='@1'" action="merge"> <login_name>@1</login_name> <password>@2</password> <logon_enabled>@3</logon_enabled> <first_name>@4</first_name> <last_name>@5</last_name> <email>@6</email> ... and <Item type="User" where="login_name='@1'" action="add"> <login_name>@1</login_name> <password>123</password> <logon_enabled>@2</logon_enabled> <first_name>@3</first_name> <last_name>@4</last_name> <email>@5</email> ... Best regards Klaus

Innovator Admin - loading data from flat file

Klaus Wroblewski — Fri, 19 Jan 2018 05:15:40 GMT

Hi, Is there any possibility with Innovator Admin tool loading data from a flat file into Aras Innovator? How do I reference to the data file? I know this is possible with Batch Loader like this example <Item type="LT_OEM" where="lt_oem_code='@1'" action="merge"> <lt_oem_code>@1</lt_oem_code> <lt_oem_name>@2</lt_oem_name> <description>@3</description> </Item>

Part Numbering System - Migration Environment

Klaus Wroblewski — Mon, 19 Dec 2016 02:56:58 GMT

We are migrating from Enovia to Aras and most probably we will use a different part numbering system. Currently the part numbers are also used in our CAD and ERP systems. There is no integration. We just "synchronize" manually. Question:

When we change to a new part numbering system, how do we manage this change in our CAD and ERP?
How do we manage old and new part numbers to avoid any conflicts?

Any ideas are appreciated.

Klaus Wroblewski さんの グループ アクティビティ