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.
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
Office Connector: Error with properties when creating document type as per ACE 2019 training
I'm going through the Student Training Guide from ACE 2019 called "Configuring Office Connector: Mapping Properties to/from MS Office Applications" I'm following the instructions on Page 11 to create a new document type for PR (Problem Report). On hitting Save, I get the error: The item_number property of selected ItemType has an incorrect data type ItemType is PR and the item_number property causing the problems is Sequence out of the box, based on the Sequence called PR. I have not changed this from default If I change the item_number property to say, string, then the new Office Connector Document Type can be saved without problem. Is this a bug that has come in since last year? If not, can anyone explain what is going on and why using a Sequence should be a problem? Thank you! Tim
How to set Default value thru office connector
Hi, I have to set default value for some of the properties thru office connector, I tried in "MSO_SaveDocument" this method, but value is not getting set on document. (I don't want to map this property with office connector). itemToSave.setProperty("name","Auto Generated"); itemToSave.setProperty("language","en"); itemToSave = itemToSave.apply(); Is there any other approach. Regards, Maddy.
How to print pseudonyms instead of plain names in Office Connector?
Hi, We use Aras PLM to generate various documents generated via the reports tools or the Office Connector. In some documents we lists the persons who reviewed or approved a certain document. Because of the upcoming GDPR requirements, we want to use pseudonyms for naming our employees on documents that are intended for the public. E.g. Karen Smith shall be displayed as KS or John Doe as JD. I currently use properties like created_by_id or reviewed_by_id for displaying the responsible person on the affected documents. My idea is to use an additional string property _pseudonym in the ItemType User or Identity to store the pseudonymized name of the different users. It than should be able to use this additional property as foreign property in the ItemTypes “Part” and “Document”. This way I should be able to easily print the new shortnames on Reports or Word-Documents via the Office connector. So far the theory, only problem: Both User and Identity are core items. I don´t want to change them until I really have to. So I wonder if anybody else is facing this use case or maybe somebody has an idea for a better solution? Thanks in advance for any idea! AngelaOffice 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?Error while saving Document thru Office Connector
Hi, I'm getting error while saving document thru office connector with normal user, but if I saved Document using root user it is getting saved, I am not able to track from which MSO method I'm getting this error. Please find below Image: Which methods are getting triggered when we save the document thru Office Connector? Regards, Maddy.
Instruction: Hiding the Open in Office Button
Hello everyone, Here is a short instruction on how to hide the Open in Office (Microsoft Office Connector) Button when viewing document items. This can be done without uninstalling / disabling MSO in case you want to prevent users from using the Toolbar Action button. Before: After: This can be achieved by taking these steps: Go to the root \Innovator installation directory of your Innovator instance Navigate to \Innovator\Client\styles Append common.min.css with the following CSS: [data-id="MSO_OpenInOfficeMenuButton"]{display: none!important;} I recommend also updating the regular common.css file with the same CSS but indented Save, clear browser cache and reload the Innovator webpage I hope this helps. All the best from Almelo. Daan
