Community
Products
Jira
Questions
Change the Confluence color scheme via SQL or some other automation

Change the Confluence color scheme via SQL or some other automation

From time-to-time we copy our PRD data down to a non-PRD instance. We then manually update the non-PRD color scheme so that we don't mistakenly work in the wrong environment.
We would like to be able to make this change via SQL or some other automation. We recognize this might be risky in a PRD environment, but we would be applying this change to non-PRD only.

3 answers

1 vote

Look to bandana table:

select * from bandana where bandanakey = 'atlassian.confluence.colour.scheme' and bandanacontext = '_GLOBAL';

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Yep, thanks, that is what we ended up doing.

echo "update bandana set bandanavalue = '&lt;colourScheme&gt; &lt;colours&gt; &lt;entry&gt; &lt;string&gt;property.style.topbarmenuselectedbgcolour&lt;/string&gt; &lt;string&gt;#999999&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.menuitemselectedbgcolour&lt;/string&gt; &lt;string&gt;$COLOR&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.spacenamecolour&lt;/string&gt; &lt;string&gt;#999999&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.navtextcolour&lt;/string&gt; &lt;string&gt;#ffffff&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.linkcolour&lt;/string&gt; &lt;string&gt;#330066&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.navselectedtextcolour&lt;/string&gt; &lt;string&gt;#ffffff&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.breadcrumbstextcolour&lt;/string&gt; &lt;string&gt;#111111&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.menuitemtextcolour&lt;/string&gt; &lt;string&gt;#535353&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.headingtextcolour&lt;/string&gt; &lt;string&gt;#000000&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.topbarcolour&lt;/string&gt; &lt;string&gt;$COLOR&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.navselectedbgcolour&lt;/string&gt; &lt;string&gt;$COLOR&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.navbgcolour&lt;/string&gt; &lt;string&gt;$COLOR&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.bordercolour&lt;/string&gt; &lt;string&gt;#999999&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.menuselectedbgcolour&lt;/string&gt; &lt;string&gt;#999999&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.topbarmenuitemtextcolour&lt;/string&gt; &lt;string&gt;#999999&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.menuitemselectedtextcolour&lt;/string&gt; &lt;string&gt;#ffffff&lt;/string&gt; &lt;/entry&gt; &lt;entry&gt; &lt;string&gt;property.style.topbarmenuselectedtextcolour&lt;/string&gt; &lt;string&gt;#111111&lt;/string&gt; &lt;/entry&gt; &lt;/colours&gt; &lt;/colourScheme&gt;'where bandanacontext = '_GLOBAL' and bandanakey = 'atlassian.confluence.colour.scheme';" | psql confluence

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Suggest an answer

Was this helpful?

Thanks!

Jira

Forums

Product Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Change the Confluence color scheme via SQL or some other automation