Can I import a whole Space in Confluence Database

[Aurelie MBIANDA]

Hello, 

I want to reorganize an existing Space using Confluence DB. I have tried to connect the DB to Confluence in the Database setup parameters, but I can only filter on the editor name or updated date for a given page. This is not restrictive and precise enough however, I would like to import all pages based on a given label or all pages belonging to a given space. Is that possible ?

[Kristian Klima]

HI @Aurelie MBIANDA and welcome to the Community.

You can - but it's not a straightforward journey.

I wrote a little article here on Community a while ago on the subject - just please read the comments too, especially the latest ones as Databases keep evolving and changing. So I hope the update in my latest comments still stands :) 

Anyway... depending on what you want to do with Databases, you might also consider apps like

• Panorama by Kolekti
• Pages Manager by Ricksoft (I believe it's still free)
• Space Content Manager by EasyApps
• And there's also Content Manager in Confluence.... 

All these apps can replicate and/or extend Databases (and the other way round). So typically, you will find yourself using one of the apps and Databases for slightly different purposes.

[Aurelie MBIANDA]

Hello @Kristian Klima

thank you very much for the welcome, and for the detailed answer, I will give all this documentation a look !

[marc -Collabello--Phase Locked-]

Confluence databases are quite limited in their features.  What do you want to achieve with all pages being listed in the database?

[Aurelie MBIANDA]

Hi Marc, 

thank you for taking the time to answer. I was reading this article how-to-structure-confluence-content-for-long-term-success  , and it mentioned using databases as an alternative or complement to page properties for better organization.

I have a large existing Space with lots of documentation but no page properties set up. Adding them manually to every page would be time-consuming, and any updates would require editing each page again.

I was hoping to use a database to leverage existing labels and get a more dynamic, filterable view—for audits or inventory. I also tried using the "filter by label" macro, but it’s too static, especially with 20+ labels. Ideally, I’d like a table that lists all pages with their labels and allows filtering.

Is something like that possible in Confluence?

[marc -Collabello--Phase Locked-]

Not sure it helps, but we make the free addon Keep it up to date!

This allows you to list all pages in a space, by asking it to list all pages older than 0 (zero) days.  Unfortunately it does not allow you to filter the pages, however it shows page status and page owner.

[Kristian Klima]

@marc -Collabello--Phase Locked- Can it tell me which pages from the space are not in the database? 'Cause that would be perfect :) 

[marc -Collabello--Phase Locked-]

Unfortunately not.  Databases have no API access.