Exporting spaces

[Gustavo Delazari Borges]

Hello,

I would like to export all my Confluence spaces and the date of the last modification for each. I was following this documentation in order to get that through SQL query (https://confluence.atlassian.com/doc/finding-unused-spaces-or-pages-107184852.html). However, I don't need the personal spaces. Is there a way to be assertive like this since I don't have the power to simply eliminate unnecessary information?

Any help would be appreciated.

[Radek Dostál · Accepted solution]

Well, for starters, you will need to export the spaces one by one - unless you are fine generating the whole Confluence backup of everything (and even that is not recommended, native SQL backup is simply superior).

When you get the link to export one space, you get the URL structure so that you can automate the process (however.. and I can't stress this enough, do this synchronously, one by one, don't try to export all spaces at once, you might as well crash the instance that way).

Secondly, all personal space keys start with tilda '~', so that's one way to identify them at first sight. And more importantly, it should be very easy to exclude personal spaces from the query. I don't exactly have a db in my hands right now, but I'm fairly sure that there is something like a "personal" boolean somewhere. Just run a few selects on the tables you're querying from that kba.

[Ismael Jimoh]

Hi @Gustavo Delazari Borges 

Why do you want to use SQL to export spaces. You could export each space from the UI and to my knowledge this gives you an xml file which contains all the information you need.

Thanks.

[Gustavo Delazari Borges]

Hi Ismael, 

I couldn't find anything from the UI.

My idea is to get just a report (CSV or Excel file), containing all spaces and their respective last modification date.

Sql query is fine for me since I can specify the columns that I need. I was having a problem only to eliminate personal spaces from the query.

Thank you for your answer.