AML Report Exported as Excel Doc
Good day all. I have a customer that wants to export a list of all documents in Aras to an Excel document. Is it possible to do this with an Aras report? I have tried searching & it seems that all of the answers that have been given do not apply. Most of my searches turn up information on how to import an Excel document. I would be good with a CSV file also. Thank you for the help.
Is it possible to use make a ACE OLEDB connection from a server Method?
Hi community, I want to connector to an OLEDB provider via server Method for loading Excel content into Innovator. (I cannot use the batch loader for my use case). The basic connection is done like this: OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.4.0;Data Source="+filename+";Extended Properties=Excel 8.0"); con.Open(); I have added the necessary oledb using directive to the method_config.xml in the codetree, so the basic syntax should be correct. But when I run the Method I will get the following error message: "The 'Microsoft.ACE.OLEDB' provider is not registered on the local machine" This is a typcial oledb related error message. There are tons of related threads in the internet. This one normally indicates a missing or wrong redistributable. The server itself doesn´t contain Microsoft Office, but I have installed the necessary AccessDatabaseEngine redistrbutable package. And the same code works when run it from a independent visual studio project, which I assume uses the same engine. Are there some specific settings required, when we want to use oledb ACE or JET connections directly within Innovator? Thanks for any hint!
ArasModules.vault.saveBlob() JS Function.
Does anyone know where the JavaScript function ArasModules.vault.saveBlob() is defined? It is called out in the saveContentToFile function in the client/javascript/ExportToOfficeHelper.js file. The reason for the question is that the saveBlob() function is not preserving leading zeros from a table's outerHTML value when exporting the table to Excel.
Read only fields in Excel Export
Hi, I am currently looking to customize my excel export functionality, is it possible to have some columns in excel sheet to be read only, when it is exported ? I am passing the treegrid to the method as an input, but i don't want some columns like "ID or Name" not to be modified. Method i am using is : aras.export2Office(exportXMLDOM.xml, 'export2Excel');
