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]
Trying to creat a link through server side method with AML
Hello, AML works in Nash. When an user is created i want to put his identity into another identity. This method is plugged on after add event of identity item type. Could you tell me id i missed someting ? Should i put an apply somewhere ? Innovator _innovator = this.getInnovator(); System.Diagnostics.Debugger.Launch(); //get id of the identity of the user created var New_identity = this.getID(); Item New_identity_item = this.newItem("Identity","get"); New_identity_item.setProperty("id",New_identity); New_identity_item = New_identity_item.apply(); var Is_Alias_1 = New_identity_item.getProperty("is_alias"); if ("1".Equals(Is_Alias_1)) { //3007DCA0B6B949A0A0B5E51AF85A6B52 ***_Checker string aml = string.Format( @" <AML> <Item type = 'Member' action ='add'> <source_id>3007DCA0B6B949A0A0B5E51AF85A6B52</source_id> <related_id>{0}</related_id> </Item> </AML>",New_identity); } System.Diagnostics.Debugger.Break(); return this; Thanks you [emoticon:c4563cd7d5574777a71c318021cbbcc8]How to edit an item in AML with import/export tool
hello, i post that here as a reminder because i was not able to find information about this : <AML> <Item type="ItemType" id="0E4B48B11212429DB971*BFB026ADB97" action="edit"> Add / Delete <allow_private_permission>1</allow_private_permission> <auto_search>0</auto_search> <class_structure><![CDATA[<class id="0E4B48B112124*9DB9714BFB026ADB97"><class id="87D3738F6C794C94*E823642A9E50A38" name="Formal" /><class id="D457200A964B48509468B7E5497C9D43" name="Informal" /><class id="D16D866888014CC3A*F06A50B6DA653E" name="**" /></class>]]></class_structure> <enforce_discovery>1</enforce_discovery> <hide_where_used>0</hide_where_used> <history_template keyed_name="Default" type="History Template">3BC16EF9E52B4F9792AB76*CE0492F29</history_template> <implementation_type>table</implementation_type> <instance_data>***</instance_data> <is_dependent>0</is_dependent> <is_relationship>0</is_relationship> <is_versionable>1</is_versionable> <label xml:lang="en">***</label> <label_plural xml:lang="en">**t</label_plural> <manual_versioning>0</manual_versioning> <revisions keyed_name="Default" type="Revision">7FE395DD8B9F4E10907*6A34B733D75E</revisions> <show_parameters_tab>1</show_parameters_tab> <structure_view>tabs on</structure_view> <unlock_on_logout>0</unlock_on_logout> <use_src_access>0</use_src_access> <name>***</name> <Relationships> <Item type="ItemType Life Cycle" id="B6ABA8AAD6934C6DBF*0A320136B24FE" action="add"> Delete <class_path>Informal</class_path> <related_id keyed_name="name" type="Life Cycle Map">582B759C17CC4*979466C730E7ECCFE5</related_id> <sort_order>256</sort_order> <source_id keyed_name="**" type="ItemType" name="**">0E4B48B11212429*B9714BFB026ADB97</source_id> </Item> <Item type="ItemType Life Cycle" id="B6ABA8AAD6934C6DBF*0A320136B24FE" action="add"> Delete <class_path>Informal</class_path> <related_id keyed_name="name" type="Life Cycle Map">582B759C17CC4797946*C730E7ECCFE5</related_id> <sort_order>256</sort_order> <source_id keyed_name="**" type="ItemType" name="GTSI_GTR_SNAPSHOT">0E4B48B11212429DB*714BFB026ADB97</source_id> </Item> </Relationships> </AML>How to build an aml request using a request in a request ?
Hello Aras Community, i am would like to perform this SQL request but in using AML : Innovator _innovator = this.getInnovator(); StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT ID, ***_code, config_id, state, Major_Rev, Generation, is_current FROM innovator.[***_ROOT_***] ***1 WHERE ***1.generation =(SELECT MAX(generation) from innovator.[***_ROOT_***] ***2 where ***2.state = 'Working' AND ***2.config_id = ***1.config_id)order by modified_on"); Item ***_result = _innovator.applySQL(sql.ToString()); return ***_result; Basically i need to do a request in a request. Do you think this is possible ? thank you so much for any help.