I have a sheet and document usage tool that uses the Audit Logs on the server to look at which sheets in which documents are being used and by how much, the problem is that the Audit Log files contain just the Document Name and Sheet ID, but not the sheet title. Currently I have an excel file that sits alongside the document and this file contains the combination of document name and sheet id to join to a sheet name.
I'm wondering though if there is a process I can put in place that would on perhaps a weekly basis export a document definition xml file, because this does include the information I need and I could then read it and convert it to a qvd.
You can load the corresponding qvw file in the script as a table using xml format. In the script a table will be created named 'Sheet' for the sheets, as well as other tables for sheetobjects, expressions, dimensions, and a lot more other stuff.
In these tables you have the ID's and titles/names, then just map away. Hope this helps!
That's a good suggestion for Sheet Names Gysbert, a bit impractical for objects and bookmarks though. Back to what Nigel said it would be great if there was a way you could automate a process to export definitions via XML file.
As of now the options I know of are to create the XML file manually, or to export structure into an excel and load it back in the Audit Log/User Stats application
You can load the corresponding qvw file in the script as a table using xml format. In the script a table will be created named 'Sheet' for the sheets, as well as other tables for sheetobjects, expressions, dimensions, and a lot more other stuff.
In these tables you have the ID's and titles/names, then just map away. Hope this helps!
