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?
Office Connector with Document Sequencing Not Working
When attempting to create or open a document in Office Application and save to Aras we get the following error, and none of the Document Dialog files are editable expect the Document Type: "Document Type "Document" is not configured properly for use with Office Connector (Number is defined as Sequence). Please Contact your Administrator." The Office Connector is installed, and configured for Sequencing in the Office Connector Settings: Document Numbering = Sequence Document Numbing Sequence = Default Document The Document Item item_number is also setup to use the Default Document Sequence: What are we missing?
Customization in Office Connector to restrict edit/save from MS office
After installing office connector, While opening the ARAS files from MS office using "Open from ARAS" menu, user can both edit and save the file back to ARAS. Is there any way to restrict the edit and also save access to the files that are opened using the menu. Only view option or access to be enabled to the user for the files opened using "Open from ARAS" menu of open office.
Office Connector with Authentication
Hi, we use SP9 with windows authentication (single sign-on) and we installed Office Connector 11.0R7. On the client machine, we open an Excel and a login pop-up shows up. We pushed the login button and we get this error : "object reference not set to an instance of an object" can anybody help? thanks, Duygu
