Is there a way to import users from csv file in jira?

I am new to jira, everytime I need to give access to a user I need to manually create them, it there a way to automate from a feed file?

5 answers

1 accepted

  1. JIRA Command Line Interface has a couple of ways. You can use the addUser action. Use that in combination with the runFromCsv action. The csv file will need a header row something like:
userId, userEmail, userFullName, userPassword

An example would be

jira --action runFromCsv --common "--action addUser" --file my.csv


Hi Bob,

       Will this allow us to add users to different "User Directories" ? or this works only for Iira-Internal Directory ?

 

Thanks

Andrian

Hi Bob,

 

We are also trying to do this since we have thousands of customers and we don't want to do this manually (we only allow issue creation for existing JIRA users).

I've installed JIRA CLI on the machine, and trying to run the command above a suggested but could you please guide me how I can specify in the command which column in my CSV to use with needed parameters (display name, etc.).

We just need to fill username, full name and email address. I guess they'll get a temporary password ? Can I also notify them at the account creation.

 

I'm sorry for all these questions, it would be cool to have this integrated in JIRA so as the issues/projects CSV import already present.

 

Thanks in advance for your help.

Jonathan

I got it working following your instructions !! Thanks Bob !

Hi

Is there no way of doing this without bying a plugin? For example by using psql commands directly to the database or something?

Or can it be scripted using the REST api?

Did you find a solution?smile

Hi Linus,

 

Yes you can do it, make sure you CSV has the following columns in a specific order :

 

userId, userEmail, userFullName, userPassword

If you don't fill UserPassword column it will generate a generic password.

 

Download JIRA Cli on your JIRA machine https://bobswift.atlassian.net/wiki/display/JCLI/Downloads

Extract you package on your JIRA machine and grant execute permission on Jira.sh script (chmod +x jira-cli/jira.sh)

Make sure you can connect to the server by editing jira.sh settings, should look like the following :

/opt/atlassian/jira/jre/bin/java -jar `dirname $0`/lib/jira-cli-4.0.0-SNAPSHOT.jar --server http://localhost:8080 --user admin_usr --password=root_password "$@"

Then, run the following command to import users in Jira based on the CSV file that you've imported :

 

./jira.sh --action runFromCsv --common "--action addUser" --file /path/Export.csv
 

This will create all users from your CSV file and they'll receive an email asking to connect and change their password.

 

Hopte it helps !

 

John

Hm...did you not read my question? Is there a way of doing this without buying a plugin? The JIRA CLI costs money. User handling in JIRA kind of sucks.

Yes the plugins is not free, but I didn't pay for it and was able to proceed anyway. You can also use the free trial. Don't install it on your Jira instance (Web) but try what I suggested for the import, it should do the job.

Hi again. I tried this once more but it complaints about the following since I have not installed the plugin in JIRA (which I don't want because it isn't free): Client error: CLI connector is not installed or enabled on the server. See https://bobswift.atlassian.net/wiki/display/ACLI/Installation+and+Use.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,233 views 14 19
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot