Hi . I am looking to manage the page/space configuration (not content) in Confluence(5.5) as part of the release process.
Is there a way to do that ? I know about Bandana table . I can migrate the themes (RefinedWiki) across environments by picking on spacekey in Bandana table but cannot get the relation b/w spaces and categories working under Oranize Spaces page in Admin.
Can anyone please show me a relation b/w these three entities.
I'm guessing you already used google with something like 'atlassian confluence data model' and found this page?
The second paragraph about how the data model can change, while true, is not exactly something to get highly concerned over - most the queries I wrote back in 2005 during my first Confluence implementation still work.
The first paragraph will be you answer for any confluence managed (opposed to 3rd party plugin managed) data - quoted here for effect:
The Hibernate mapping files are the authoritative reference for the Confluence data model. These are the
*.hbm.xmlfiles which you will find in the main Confluence JAR file (
If you've gone through a similar exercise with JIRA these are like the entity-model.xml file describing the tables and their relationships. It's all based on (at it's core) the Apache OFBiz project (I believe) and has a summary of the approach for handling data here Open for Biz Data Model (along with a lot of other doc).
maybe that'll get you somewhere close to what you are looking for. I'm thinking, though, that you're mixing 3rd Party Plugin names/concepts with Confluence ones - and it'd help a lot if you mentioned the 3rd party plugin you were working with (providing the 'Themes').
Hi Will, You are spot on and yes I am using a lot of 3rd party plugins like RefinedWiki Theme , Adhoc Workflows ,Archiving plugins ,Arsenale Lockpoint ..
As long as I am able to maintain the line between config and content , things should be ok. I can migrate spaces with Workflows too. Will be trying on spaces with attachments next.
Your anwer confirmed that I am doing the right thing.
These are my references and the migration script works fine on our test spaces/Theme Admin page with Space Categorization.
hbm Files : Label.hbm.xml , ConfluenceBandanaRecord.hbm.xml , Space.hbm.xml
DB Tables : Bandana, Label , Content_Label
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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!
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