I regularly export the elements out of our DMS from with the Cube GUI which I use this data for a variety of other purposes, some automated, outside of dataminer.
I'm trying to figure out how to automate the export to CSV of elements in our DMS where no user interaction is required.
Any wizardry ideas of a good way to achieve this?
My initial thoughts was Microsoft Power Automate to replicate the GUI steps, but would be awesome if it could be done without a GUl.
Another possible option is using DataAggregator. This DxM allows you to execute GQI queries remotely and store the results of these queries in a CSV file. You could install this DxM in one of the DMAs or in an external server as well. Using the DataAggregator you could perform the following actions:
- Create a GQI query that contains the list of elements (there is already a data source that allows you to retrieve this information, see Get Elements)
- Export this GQI query to the DataAggregator. When configuring the job (a job is an action executed by the DataAggregator), you can configure multiple settings, but here the most important settings are the query to be executed (should be the exported query), the frequency (how frequent is the job executed) and the destination of the results (the CSV files)
Hope it helps.
I would recommend looking into User-Defined APIs | DataMiner Docs
You could create an API call that returns all elements in DM. The tutorials might be a good way to get you started as it is very similar to what you want to do. Creating an API to retrieve elements in alarm | DataMiner Docs