Export (CSV) settings and output file structure

Export settings

Both global user and group overview pages and the space level effective user permission tab allows to export the results into CSV format.

Currently, please specify 0 (zero) in the Maximum row limit to export all users/groups. This will be changed in the future, export will save all rows without limitation.

The CSV separator can be comma, semicolon, tabulator or any custom value

The space details format sets how the space should appear in the column header. There a few built-in formats, like

  • space key
  • space name
  • space key - space name
  • space key - space name (description)

Custom formats can be defined in Velocity format. The following variables can be used for generating space details: $key, $name, $desc

Using #if condition is possible. In this example, space description in parentheses is added only after space name if space description is not empty:
$name#if("$!desc" != "") ($desc)#end

Output file structure

The export always 3 fix columns: Username, Display name and Permission name. The following columns represents the spaces. For every user or group multiple lines are generated with a T (true) or F (false) value. Each line contains the effective permission state for the different Confluence permissions. 

Sample showing user "admin" has all permissions:

UsernameDisplay namePermissionSAMPLE-SPACE-KEY
adminAdminpage-addT
adminAdminpage-removeT
adminAdminblog-addT
adminAdminblog-removeT
adminAdmincomment-addT
adminAdmincomment-removeT
adminAdminattachment-addT
adminAdminattachment-removeT
adminAdminmail-removeT
adminAdminpage-restrictT
adminAdminspace-exportT
adminAdminspace-adminT
Last modified on May 28, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.