Bulk create users

Jason Pepper February 14, 2012

Anyone on here done a bulk create of users in confluence ?

I found this ENH https://jira.atlassian.com/browse/CONF-19714 which indicates it's not a system feature.

I also found this

https://studio.plugins.atlassian.com/wiki/display/BULKUSER/Bulk+User+Upload

which I might try..

Advice, guidance, horror stories gladly accepted !

3 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

4 votes
Answer accepted
Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 14, 2012

Confluence Command Line Interface has actions to add users and users to groups either in a script or via specially formated csv file. Also, runFromSql or runFromCsv actions can help automate the single user actions.

Brendan Patterson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2012

I agree with Bob, the CLI is an excellent way to do this. The CLI is very capable of doing this and many other amazing things.

Jason Pepper February 15, 2012

Thanks Bob, I had a play with CLI when I installed our first Confluence instance.. I will take a look..

Still doesn't negate my comment regarding the missing OOTB functionality.. If Atlassian are looking to service the SME intranet market which is what I am looking to use Confluence for then they should provide a bulk loader. A minor gripe, so far I'm chuffed with the product.. as an ex enterprise portal vendor product manager I'd say that was praise indeed ;-)

Joe Clark
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 16, 2012

Bob, you should just write a script that adds an answer to every question that says "Use the CLI". 3/4 times it will be the correct answer! :-)

Like Srikanth Ganipisetty likes this
Jason Pepper February 16, 2012

For those other newbies reading this.. the CLI rocks !

Took me about 15 mins to write a script that created 80 users and added them to a group. Thanks Bob !

Can I ask a simple question ?

I couldn't find the doc for the correct way to format the CSV if I wanted to use addUserWithFile ?

Like Srikanth Ganipisetty likes this
Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 16, 2012

An example is in the shipped examples directory, or its easier to just look here: https://bitbucket.org/bob_swift/confluence-cli/src/tip/src/main/resources/examples . addUserWithFile is the original way this was done, however, the newer run action support is more flexible for doing this and other things :).

Jason Pepper February 19, 2012

top man !

many thanks

Sherif Mansour
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 21, 2012

or maybe, all that's missing from the CLI tool is answers.atlassian.com support... just responds with every question automatically with Joe's suggestion "use the CLI"..... ;-)

Like Srikanth Ganipisetty likes this
suedti November 8, 2012

Hi Jason and all others,

I was not able to figure out the right format for the csv files. Is there a documentation somewhere? I did neither find details or an example-csv concerning addUserWithFile nor concerning runFromCsv.

@Jason: you wrote that you wrote a script to import 80 users. Can you give me some hints about your way to the solution. Or even better: can you post the script here.

Thanks a lot
philipp
Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 8, 2012
  1. addUserWithFile - there is an example file in the examples directory of the distribution.
  2. runFromCsv - this is a more general capability, How to import JIRA issues using CSV is an example
suedti November 8, 2012

Thanks Bob!

I found the examples.

I ll give it a try tonight.

phil

suedti December 10, 2012

One more question, Bob:

Do you have an idea how special chars (like german umlauts) can be preserved during the "addUserWithFile" action? They all get scrumbled and every line with an umlaut is importet twice....

I used the same encoding like in the example files (UTF-8).

Thanks

Philipp

Bob Swift OSS (Bob Swift Atlassian Apps)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 10, 2012

Good question. Please open an issue with specifics on what you tried. For instance, Windows or not and did you use the --encoding parameter?

1 vote
Brendan Patterson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 14, 2012

Hi,

I wrote that about seven years ago :) but it has been updated several times by multiple people including myself recently. I'm pretty sure it works correctly up through v3.5 If you are on Conf v4+ I think it does not (yet).

Brendan

Jason Pepper February 14, 2012

thanks.. I'm on 4.1 so I guess I won't bother trying it..

It seems like the sort of feature that should be built in and that people would be crying out for.. I guess if you *really* need it you would be using an LDAP server which would have that facility..

We don't have an LDAP server (not yet anyway) so I just wanted to load in my 80 odd users using a CSV or something..

Thanks for replying ;-)

0 votes
Ty Satrang January 29, 2013

I wrote a script for iMacros for Firefox because we use an OnDemand instance, and it was much simpler than trying to convince anyone to spend money on a plugin. http://pastebin.com/KifqV4ZM

TAGS
AUG Leaders

Atlassian Community Events