Export page status reports to Excel/CSV for further analysis and sharing

Avatar
Levente Szabo
Follow

A user wanted to get CSV for Excel / GoogleDocs purposes:

It's too early in our process for me to assign sections to other supervisors, but as I'm working through old material it would be helpful to be able to separate and share groups of pages (e.g., sending a list of FOOBAR pages to our FOOBAR expert, and then she could indicate in the spreadsheet if a page should be deleted or whatever).

Fields to include: space key, space name, page id, page name, date created and by whom, last edited date and by whom, and a link to the page

(Our note: we may provide some better way for collaborating over these. Exchanging information in CSV may not be the most efficient approach for this, although simplicity has its own merits.)

Have more questions? Submit a request

3 Comments

Date Votes
  • 2
    Avatar
    Greg Della-Croce

    The report the Levente requests would be very valuable to us people that are Admins for the whole Wiki.   Having this in CSV format would allow the widest possibility of import into our favorite tool (spreadsheet or Database).   Is this possible to get soon?

    Greg

  • 0
    Avatar
    Aron Gombas

    UPDATE: We have released the Better Content Archiving app's cloud version just a few weeks ago. It addresses many points criticized in the Data Center version, including also this one.

    (Our plan is that, if there is interest, we will back-port the most valuable changes from the Cloud version to the Data Center one.)

    In the cloud version we implemented several app features using CQL, the query language of Confluence, because structured query languages allow powerful filtering and searching.

    We also make several content properties, most importantly the content status, available as CQL fields. For example, you can write a simple query like this to get the expired pages in those two spaces:

    space in (FOO,BAR) and type=page and arch.status="Expired"

    You can run it with the CQL Search app, choose your columns, then just copy-paste the search results to an Excel spreadsheet. (From Excel, you can save it to CSV if you want to import to another tool.) It is super-easy:

    Note that there are dedicated export feature ideas in our product roadmap, but the approach described above can already be used right now!

    🔥 Try this in action now!

  • 0
    Avatar
    Vsmith

    Hi, Levente!

    Thanks for the link to this article. As requested, I'm commenting here to state that my company recently rolled out content archiving. As you can imagine, there are thousinds of pages that expired right away. The pages are in no particular order, and don't show indenture, so coordinating the effort to review isn't going to be easy. It would be great if the pages could be exported to excel along with their url and some other properties like page owner, parent page, date of last edit, person who made the last edit. 

    I guess it would be helpful too if there was a way to bulk change these pages once reviewed? Looking forward to seeing something on this effort (I was only granted an extension until EOY before these pages are all archived).

Please sign in to leave a comment.