Using Confluence to Auto Generate Project List & Finance List

Hi,

We use confluence extensivly as a knowledge base, and each Project has its own space within Confluence with a standard stucture.


We also maintain a central list in confluence of projects with their status against them, as well as a finance page for each project with various finance details.

What I'd like to be able to do is have a page on each confluence space for a project with the finance details and project status, and have this summarized in a single (or two) pages for the project status and finance status.

Has anyone done something like this, and if so, how was it done?


My suspicion is that it might require the Scaffolding plugin from what I've seen, but I'd appreciate any advice thats available.

1 answer

Sebastian,

I have done something similar to this. What I did was use the CustomWare Scaffolding and Reporting plugins. The Scaffolding pluging allows you to create forms and store data on pages. The Reporting plugin allows you to report that information - essentially rolling up data across multiple wiki pages (and even wiki spaces). Reports can be rolledup into a single page or separate pages or even in a dashboard using the Charts macro.

A Live Template is used to create the project home page containing the data that is reported on. Being a Live Template this means that if you need to change or add values to the data collected on each project home page, you are able to change the Live Template and have the change propagated out to all the project home pages.

As part of the Live Template I assign a label which assists in accessing data across all wiki spaces. By assigning the label as part of the template it is automatically reapplied (if removed) each time the page is rendered.

Ideally the project home page should be a global template. If not, you will need to replicate the the template in each wiki space. Templates created at a wiki space level are only available to that wiki space. Creating a template (live or otherwise) requires space admin access to place it in the wiki space or system adminstrator privileges to place it in as a global template.

The CustomWare Scaffolding and Reporting plugins are extremely powerful, the resulting data can be rolled up or displayed in a variety of ways. The learning curve is a little steep and probably benefits from a programming background, documentation it ok and some examples have been provided as Recipes on CustomWare's site.

I learned a lot through using the CustomWare community support forum at:

http://community.customware.net/customware

lots of good people there who helped. It functions similar to this support forum (which is also a good source of information).

The key is laying out your data structure (and data options for the fields) as best you can on paper before you being. The Scaffolding forms allows you to control data input so you get consistent data entry.

Underneath the project home page - all other pages related to the project are created. This allows a wiki space to host multiple projects. In our case the wiki spaces are broken up by application and projects related to an application are contained within the wiki space. We currently are using this methodology to report across 20 wiki spaces for a total of a couple of hundred projects. Not all the projects are active, but provide a historical reference.

Hope this helps.

Chuck, that sounds exactly what I needed to know. Thank you, thats been really helpful!

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

370 views 20 10
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you