nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create bulk users in jira from csv file.

Salwadi Edukondal_y5bd8w

Hi Team,

I have written groovy code like below but getting errors can anyone help me how to rectify this.

import com.atlassian.jira.bc.user.UserService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.bc.user.UserService.CreateUserRequest
import com.atlassian.jira.bc.user.UserService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.ComponentAccessor
import com.onresolve.jira.groovy.user.FieldBehaviours
import com.onresolve.jira.groovy.user.FormField
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.IssueManager
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField
import com.atlassian.jira.issue.customfields.manager.OptionsManager
import com.atlassian.jira.issue.fields.config.FieldConfigImpl
import groovy.transform.BaseScript

File file = new File("C:/Users/edukondal.salwadi/Desktop/file.csv")
def csvMapList = []

file.eachLine { line ->
def columns = line.split(",")
def tmpMap = [:]

tmpMap.putAt("userName", columns[0])
tmpMap.putAt("userEmail", columns[1])
tmpMap.putAt("userFullName", columns[2])
csvMapList.add(tmpMap)
}

return csvMapList

Error:Getting below even though i have given correct path

java.io.FileNotFoundException: C:\Users\edukondal.salwadi\Desktop\file.csv (The system cannot find the path specified) at Script5775.run(Script5775.groovy:31)

Accepted answers

All comments

Niranjan

Hi ,

You may be running into this issue - https://productsupport.adaptavist.com/browse/SRJIRA-2330?

Ensure that directory name has no spaces. You can copy and paste the exact path by doing a dir of that file in the command prompt. Seems like a permission issue to me. Try to use the path for which jira has all the permissions.

Ismael Jimoh

Hi @Salwadi Edukondal

Why not use Rest API to create the users?

You can use a csv with all information about users:

Build your CSV with the basic information required by JIRA (username, name, email) see: https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/#api/2/user
Build a collection based on this.
Run the collection to create the users.

This makes it easier.

Regards

Salwadi Edukondal_y5bd8w

I have checked everything looks fine path and permissions.

Can you check any change required in code?

Srikanth Ganipisetty_3xgf81

@Ismael Jimoh Did you mean to write a REST API Script that can check mapping from this CSV file and doing post method hitting our Instance directly? Sorry, I am not much into Code.

Ismael Jimoh

You do not need a special script as I mentioned build a collection (please look up building collection in postman).

You can pass environment information like url, username, password that you store in Postman.

Anyway read or watch a video that explains using collection in postman and how to manage environments.

Srikanth Ganipisetty_3xgf81

@Ismael Jimoh Yeah, I know how to use collections in postman. Of course, we have the script to add the user and check the user status against AD and then put the user in relevant group. But, I thought using the methods you shared above from Atlassian is only helping to add 1 user, not the bulk users right? Correct me if I wrong. I thought that we can post JSON in the REST API methods above for user by user only.

Thanks,

Srikanth Ganipisetty.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-service-desk

jira-server