What is the correct format of the csv to upload bulk users with Atlassian-CLI plugin

Andrian Fernandopulle February 15, 2018

An earlier version of CLI plugin allowed to upload users in bulk (including multiple groups). I used to format the csv as below

Username, Password, Email, Fullname, Groups

admin, ,hello@gmail.com,Admin,jira-users,jira-developers

user, ,hi@gmail.com,User,jira-users

But now I cannot figure the correct format and the correct commands to use to do a similar task. Any help would be really appreciated. We are depending on this feature a lot.

Is this the correct way now (In your documentation it says to use frunFromCsv & addUser) ?

./jira.sh --action runFromCsv --file "examples/test.csv" --common "--action addUser --autoGroup --continue"

It would be a great help if you posted some examples.

1 answer

0 votes
Rama Krishna Anumola _Appfire_ April 9, 2018

We noticed that you have not provided the property file which allows you to map the columns in the CSV file to the JIRA field. Please use the query as shown below.


-v --action runfromcsv --file "JIRACLI/addUser.csv" --propertyFile "JIRACLI/importer.properties" --common "--action addUser" --continue


Note: Please modify the location of CSV file and the property file accordingly along with your server, username and password information.

You need to create a file with the name "importer.properties" and please add the below parameters to the file.

field.userID = userID
field.userEmail = userEmail


The above two are required parameters for adding users to JIRA and please make sure your CSV file has the two columns with respective values.

You can also provide other parameters please see the other parameters from this https://bobswift.atlassian.net/wiki/spaces/JCLI/pages/6684679/Reference#Reference-addUser

values on the left = name of heading in the CSV file
values on the right= name of the field in JIRA
For adding users to groups in Bulk, please see the page https://bobswift.atlassian.net/wiki/spaces/JCLI/pages/274301168/How+to+Add+Users+to+Groups+in+Bulk

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events