Audit log export cannot be opened.

James Malgieri October 9, 2019

Hi,

I just received this question, have no idea and was hoping someone might be able to help.

There is a button for Export that allows you to export the Jira audit log to csv. Unfortunately when testing this, the export runs, but ability to open the file is blocked.  The export to CSV in a filter view runs just fine, so it’s as if there is something else embedded in the audit log csv that limits it from opening (trust center issue).

Is there a way to change the export type of the audit log to Excel?

Does anyone know of a workaround?

Thanks,

Jim

2 answers

1 accepted

0 votes
Answer accepted
James Malgieri October 16, 2019

We resolved this by discovering this is happening because the first two characters match the first two characters of the SYLK file format which is ID.

To fix this, open the file in Notepad and modify ID to be anything else. The easiest way is to add another character. Save and close Notepad. Then it should open in Excel correctly.

https://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)

0 votes
Angélica Luz
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
October 10, 2019

Hi James,

Thank you for reaching out to Atlassian Community!

The CSV type should work with Excel or Google Sheets.

Can you please open the file directly on Excel menu instead of clicking on the file to open?

If possible, send us a screenshot of the error that you see when trying to open the file.

Regards,
Angélica

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events