Activity Log Export Fails

Resolved

Activity Log Export Fails

avatar
rich

We are trying to export the activity log from RDM to XLS format for the last 30 days, but receiving the following attached error (states the connection to the data source is unavailable). If we select Yes, we get a prompt to re-log into RDM again. If we select No, we then get the next error that is attached. On the error it states to use XLXS format, but there is no option to export to this file type (3rd attachment).

This is using RDM version 2019.39.0 with DPS server.

----

Also, when exported less data (1 days worth for example) we noticed that not all the information from the activity log is exported, with some details from the Message column missing, and some of the log date data also missing and showing only the actual date (i.e. 20/11/2019) with no time stamp. This is done when exported via CSV and XLS. Attached are examples.

Thanks
Rich



Activity Log with Dates and Times.png

Activity Log Export Only Dates.png

Export Types.png

RDM Error 2.PNG

RDM Error.PNG

All Comments (5)

avatar
Erica Poirier

Hello,

What DPS version are you using?

If you are using DPS 2019.1.20, could you please try with the latest RDM version 2019.2.19 to see if you can get all information in the CSV file?

About the XLSX export file, I will check with the engineering team if we can add it in RDM as an export file type.

Best regards,

Érica Poirier

avatar
rich

Hi Erica,

Thanks for getting back to me soo quickly regarding this.

We are running DPS server 2019.20.1 and so have updated our RDM client version to 2019.2.19 as suggested. Unfortunately when running the Activity log export to XLS the Log Date data is still missing the time stamp.

When exporting to CSV however, the full time and date stamp data is shown so this problem looks to be just with the export to Excel based file format?

Thanks
Rich

avatar
Erica Poirier

Hello,

Could you please verify the column format in the Excel file? I got the same issue and was able to display the time by modifying the column with a custom format like the following.



Best regards,

Érica Poirier

avatar
rich

Hi Erica,

Sorry for taking so long getting back to you regarding this.

Have finally been able to test the export, and setting the format in Excel to Custom, and then selecting Date and Time format option. This now works, and does indeed display all the log date information for the entry.

Thank you for your help on this.

Kind Regards
Rich

avatar
Erica Poirier


Hello,

Thank you for your feedback and glad that the provided solution worked!

Best regards,

Érica Poirier