Load xClass and xProperties, and link xProperties to multiple xClasses from AML
We want to load 1k+ xclasses to Aras, we are talking about 4k+ xproperties here. When we are running AML for creating relations xClass_xProperty_Flatten and xClass_xPropertyDefinition to link them to class tree, it fails with error : <faultstring><![CDATA["xClass_xProperty_Flatten" can be added or deleted or updated only in XTree context]]></faultstring> <detail> <af:legacy_detail><![CDATA["xClass_xProperty_Flatten" can be added or deleted or updated only in XTree context]]></af:legacy_detail> <af:exception message=""xClass_xProperty_Flatten" can be added or deleted or updated only in XTree context" type="System.ArgumentException" /> </detail> I can load property definitions, but not classes, but can’t map the properties to classes. How can we mass create and reuse these xProperty definitions in more than one class from AML, by creating relations correctly?
xClass Implementation Considerations for Performance
Community, My current client wants to use xClass Properties on Itemtypes: Document, CAD, and Part. Current Configuration The Document and CAD Itemtypes will use xClass in a straight forward way therefore predictable data generation. The question is Part. The Part Itemtype is being used for Engineering Parts (Classification: Assy, Comp, Material, Software, etc.) and Manufacturing Part (Classification: Manufacturing). So for every Eng. Part there can be 1 to 3 duplicate Mfg. Parts created with the same xClass data. Currently the client has 240 xClass Properties defined and this is just the start. I can predict that the property count will be close to 500 + when Part, CAD, Document are fully defined. Current: Each xclass Property requires 4 columns and each Itemtype assigned to an xClassTree (Part, CAD, Document) their item_id, and their Itemtype_id are added to each of the xp.XPROPERTYVALUE tables. This results in five xp.XCLASSPROPERTYVALUES tables generated: xp.XCLASSPROPERTYVALUES; xp.XCLASSPROPERTYVALUES1; xp.XCLASSPROPERTYVALUES2; xp.XCLASSPROPERTYVALUES3; xp.XCLASSPROPERTYVALUES4; xp.XCLASSPROPERTYVALUES5... Each of these tables has 100 property values stored in the 100 Columns and managed by 300 columns. Currently only 1, of many Division, is using the Parts Classified as Manufacturing. Goals The client wants to use the xClass Data to do: 1) eBOM validations so performance in gathering xClassPropertyValues is key. 2) Product development regulatory definition and tracking. Questions 1) Are there any configuration issues that should be considered? 2) Are there xClassProperty implementation considerations that you suggest? 3) Are there performance issues that should be considered? Thanks for your time and insight. Scott
Adding an xClass-specific image to a form
With standard classification, it is pretty straightforward to add an image to a form that is only seen when viewing an item of that specific class. But how to achieve this with xClassifications? I noticed that there is not even an image property type for xProperties. Use case: We have a xClassification "Countersunk screws". For these, we need to define certain measurements according to DIN standards. To make it clearer what the measurements mean, it would be very useful to also provide a diagram, e.g. as below. Any idea how to achieve this with xClassifications? Thank you!xclassification dialog from custom method
hello i'm begining a project, the idea is to have a an action launch a dialog to select a xclass. I would like to launch the same dialog as the one that pops up when adding a part xclass and x property(see below): after the user selected a class i want to retrieve the name of the class he chose. The following step is to have a second dialog (depending on the classification chosen) this second dialogs might be hard coded or dynamically buit i'm still unsure and they are going to look like the form used to fill the xproperty after you choose your part class but slightly different: i want to add a column of check boxes for future business logic. i've tried to search for the xclass tree selection dialog but couldn't find it i've tried to display some that i could find in the code tree but without sucess, i used the dialog api, here is my code:[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:84128d64-2f8e-495b-800a-afbacbd16030:type=text&text=var%20param%20%3D%20%7B%0D%0A%09aras%3A%20top.aras%2C%0D%0A%09type%3A%20%22HTMLEditorDialog%22%2C%0D%0A%09sHtml%3A%22here%20i%27ve%20tried%20to%20put%20just%20the%20name%20and%20the%20full%20path%20but%20it%20didn%27t%20seem%20to%20work%20as%20even%20when%20i%20changed%20form%20i%20was%20always%20getting%20same%20form%20opening%20%22%2C%0D%0A%09dialogWidth%3A%201000%2C%0D%0A%09dialogHeight%3A%20500%2C%0D%0A%7D%3B%0D%0A%0D%0A%2F%2F%20This%20will%20be%20called%20after%20the%20dialog%20is%20closed%0D%0Afunction%20callback%28res%29%20%7B%0D%0A%09if%20%28res%29%20%7B%0D%0A%09alert%28res%20%2B%20%22%20loves%20learning%20about%20new%20opening%20HTML%20pages%20as%20dialogs%21%22%29%3B%0D%0A%09%7D%0D%0A%7D%3B%0D%0A%0D%0A%2F%2F%20Open%20the%20dialog%0D%0Avar%20topWnd%20%3D%20top.aras.getMostTopWindowWithAras%28%29%3B%0D%0Avar%20wnd%20%3D%20topWnd%20%3F%20topWnd%20%3A%20window%3B%0D%0Awnd.ArasModules.Dialog.show%28%27iframe%27%2C%20param%29.promise.then%28callback%29%3B] any help is welcome thanks lucasScript for importing items with xProperties from Excel using Batch Loader
I just went through this process as part of learning Aras. Importing items from Excel using the Batch Loader is pretty straightforward if you only have simple properties that all belong directly to the Item Type. See documentation for the Batch Loader. Note that you should save the Excel file as a tab-delimited .txt file. It gets more difficult, however, when you need to import properties over relationships. In this case Costs over the Part Goal relationship and xProperties over Part_xClass. I found no documentation to help me with this, so the script below is the result of a lot of trial and error. Comments and improvements welcome" It is my first import script! Copy the text below into Notepad++ for better readability. A big difficulty was working out how to explicitly identify the xClass. I used the xClass Property "name". This used just the simple name of the "Leaf" xClass in the xClass tree. Hope it saves someone a bit of time :) (Extract to show the highlights...) <Item type='Part' action='add'> <!--Use Action='edit' when updating items--> <!--@10, etc. denotes the column in the data file and is independent of the header row contents--> <item_number>@2</item_number> <name>@4</name> <classification>@5</classification> <Relationships> <!--Part Goal is the relationship item that links to item type Goal--> <Item type="Part Goal" action="add"> <goal>@7</goal> <!--e.g. Cost--> <actual_value>@8</actual_value> <!--Further fields available, see Loader docs--> </Item> <!--Part_xClass is the relationship item from part to xClass--> <!--Note that "name" (lower case) is the easiest of several field options for identifying xClass--> <!--Format is, e.g. "Fuel Tanks" (name of leaf, spaces OK)--> <Item type="Part_xClass" action="add"> <related_id> <Item type="xClass" action="get" select="id"> <name>@10</name> </Item> </related_id> </Item> </Relationships> <!--The properties below can only be loaded once the xClass relationship has been established as above--> <xp-mass_full set="value">@14</xp-mass_full> </Item>Lessons Learned from importing data for Parts with xClassification data and a thumbnail image
With the attached document, I just want to share my experiences and struggles with the hope that it helps someone else trying to do similar things. It follows on from my posts https://community.aras.com/f/getting-started/35943/script-for-importing-items-with-xproperties-from-excel-using-batch-loader https://community.aras.com/f/getting-started/35979/how-to-import-thumbnail-images-for-parts-using-batch-loader I eventually worked out for myself how to import thumbnails, but - unless I've missed a trick somewhere - it isn't as straightforward as one would hope. Should you be able to provide feedback / improvements / information about useful reference documents or if you have any questions I'd be happy to hear from you! Tim --------- This is just a record of my experience (as a non-programmer) trying to work out how to import the data for a demo system just using AML and Batch Loader. A lot of it was picking clues out from various sources plus a lot of educated guesses. The documentation is insufficient. What I did find was as below: A nice introduction, but just an introduction by Christopher Gillis on the Aras Forum The Programmer’s Guide in the Innovator Documentation. This includes a three-page reference, which feels a bit short. The documentation for Batch Loader includes some examples at the end I would love to see further documentation and references, in particular: The full extent of what AML can and can’t do. Specifically: Can it include logic such as IF statements that depend on the content of the file being imported (i.e. an SQL where condition doesn’t help here) Can one concatenate input data. See below where this would have been useful for loading the thumbnail images. Can one import files (e.g. image files) along with the data by using pointers to the file locations with the import sheet? A full description of the error messages returned within Batch Loader. These are mostly very obscure and singularly unhelpful. Software used Excel for Data Lookup for GUIDs to enable importing of Thumbnails Generating AML for Batch Loader Batch Loader. I assume that the reader has a basic understanding of using this program. If not MS SQL Studio. Other options also available. Used to get a list of files in the vault along with their GUID ... Please see attached file for the rest of the document: [View:/cfs-file/__key/communityserver-discussions-components-files/6/Lessons-Learned_2C00_-xClass-import-with-thumbnail-images_2C00_-forum.pdf:40:40]Extended Properties Permissions Issue
Hi Team I have configured extended properties for Part Item type and I'm able to select and add the xProperties in Part item using super user. But when I try to get / add xProperties using normal user, I was not able to get or add the xProperties. I'm getting the below error You have insufficient permissions to perform 'classify' operation for item id '46F261DDEDEA40F784EA2C51687BB519' by xClass id 'F4C365C728574ADEAE8EB1C4E5A50D25'. Attached screenshot as normal user and super user for reference. Do I need to add permission anywhere to see / add xProperties on Part as normal user ? Thank YouLimited property types in Extended Classifications?
I'm trying to create a system using both types of classification to work out which might be best in which circumstances and have discovered that there seems to be quite a number of property types that can be used with standard classifications, but not extended classifications, e.g.: Foreign properties Sequence Federated Image ... Am I missing something here? If not, are any of these likely to be coming to extended classifications? Thank you! Tim
