Create database based on Confluence pages

[Estelle Turbatte]

Hello everyone, 

I've got a question about Confluence databases: Do you think it's possible to fill in the database with data collected into Confluence pages. 

More details: I've got a folder that contains pages, built in with the same template. Each page has the same table with data. I want to know if I can build a database that aggregates each table, with the title of the page. 

Thank you and have a nice day !

[Stiltsoft support · Accepted solution]

Hi @Estelle Turbatte ,

We can suggest a solution using native Confluence tables. Our Table Filter, Charts & Spreadsheets for Confluence app provides the Table Excerpt/Table Excerpt Include macros that can serve as an advanced version of the Page Properties Report.

You'll be able to collect multiple-row tables from child pages, child pages&descendants or pages with specific labels and combine them into one big report. If required, you may also show source page meta data (the source page title with link included).

Furthermore, this combined report may be filtered, aggregated and visualized.

[Estelle Turbatte]

Hi @Stiltsoft support thank you for your response ! 
I will try this today.

[Stiltsoft support]

If you have any questions, you may refer to our support portal (it's confidential, you'll be able to share your screenshots if required) or book a live call with the team (attach the link to this thread via the description field and our engineer will show you this case).

[Kristian Klima · Accepted solution]

Hi @Estelle Turbatte and welcome to the community.

I'm not sure about data aggregation but when it comes building a DB with the pages' details, this article might be a good start.

[Estelle Turbatte]

Hi @Kristian Klima thank you!

Thank you! Your post is very helpful. 

But concerning my use case, I am not sure easier it is made for it. 

Thank you !

[Kristian Klima]

@Estelle Turbatte Well, it's a database, that shows data of the main entry, I think it's designed with a different purpose in mind.

A DB can, however, show contents of an excerpt, so if you put a table into an excerpt, your DB will list all the pages and display individual tables - in a single cell.

It won't do aggregation but, depending on the table's size and what you're looking for, it could provide a visual clue...