How to export page status report into an excel

[Meera_Amanullah]

Hi,

I am using the Comala Document Management app for applying workflow to my Confluence space. I am using their Document States Report macro to generate a list of Confluence pages and their states, but I'm not able to export that as an Excel file, which I need for status reporting.

Any leads will be helpful and much appreciated.

Thank you. 

[Connor]

Hi @Meera_Amanullah I don't think this is possible, at least not natively within Confluence or the Comala Document Management app. After reading through Comala's documentation, there might be methods to achieve your goal, but if feasible, they'll require extra work outside of Confluence/Comala app.

• Export the page as HTML, then use a custom script to parse the HTML and create a CSV file containing the desired data.
• Use the send-email macro and trigger an export of the page as HTML. Send to an email connected to an automation platform that can parse the HTML data and create a CSV file containing the desired data. E.g. Power Automate, Zapier, Workato, n8n, etc.
• Use the "Document Report" found in the Space sidebar instead of exporting a page.
• Use Comala's "Status REST API" to retrieve the desired information and store it into a CSV file.

To be clear, I don't know if these methods will work, they're simply the ideas I thought of while pondering your question. Here's links to the documentation I was reading:

• https://support.appfire.com/space/CDML/649562443/Document+States+Report+Macro#Exporting-the-page
• https://support.appfire.com/space/CDML/649924039/send-email+macro 
• https://support.appfire.com/space/CDML/649825673/Document+Report+-+Space+Sidebar 
• https://support.appfire.com/space/CDML/649692021/Status+REST+API