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.
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?
Unable to load End of Sale/ End of Support Not available fields with Boolean 1
Hello Batchloader team I am trying to load End of Sale Not available and End of Support Not available fields with Boolean 1 against unique P/Ns in the Manufacture Parts table I loaded the data correctly with txt file as shown in the preview. I think the template (which is auto-generated) is incorrect <Item type='Manufacturer Part' action='edit'> <id> <Item type='Manufacturer Part' action='get' select='id'> <keyed_name>@1</keyed_name> </Item> </id> <_end_of_sale_blank_flag>@2</_end_of_sale_blank_flag> <_end_of_support_blank_flag>@3</_end_of_support_blank_flag> </Item> What would be the solution to not get a failed result ?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.
Log changes made by Batchloader on part history
Hi. When I create and then release an ECN, I can see some descriptions and comments if I go to Views/History. However, I would like to find a way to also add some description on the History of the part when I use the batchloader to update any part properties. Is there a way to accomplish this? Also, I am wondering if there is a way to also add comments when a manual change has been made (let's say, a manual release of a part, or manually promoting a part due to unforeseen circumstances). Thanks in advance! PMateoCan you "send to ERP" using Batchloader?
Hello, I recently updated 400 parts using the Batchloader. However, during a manual update we would have to use the "Send to ERP" to use these parts in transactions. Is there a way to do this with the Batchloader? I would hate having to go through 400 parts manually and start sending to ERP. I have the feeling this can be done, I just have not found any resources describing how. Kind regards, PmateoDelete a complete BOM (if any) using Batch Loader
Hello, I am learning how to use the batch loader to add a BOM to a specific part, but now I would like to do the opposite: I would like to come up with a script I can run with the Batch Loader that would delete a BOM regardless of how many components it has. How could I get started on this? Regards, PMateo
