How to create a user or ticket using excel file in jira service management, is there any possibility

[harish.thakare]

Hello,

I just wanted to know is there any possibility of creating user or ticket using excel file in jira service management, where can it will automatically pull the information from excel sheet and create request or user with provided information.

[Rilwan Ahmed]

Hi @harish.thakare ,

Welcome to the community !!

1. You can import tickets (i.e. Create new tickets) using CSV import.
First prepare a csv file as described here.

Then Go to admin settings --> system --> External system Import --> CSV

Upload the csv file and select project and map the fields. 
Please note: Try import only one ticket (row). If all OK, then proceed with multiple tickets

Full details about import process is in https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/#Preparing-your-CSV-file

2. To import users, please contact the Atlassian Cloud Support Team here

[harish.thakare]

@Rilwan Ahmed  Thank you for the response, but i am looking for automation will it possible through rest API, if you have more info on this it will be very helpful.

Thank you.

[Nic Brough -Adaptavist-]

Automating this means writing a script or program that can read your file and make the appropriate REST calls to create the issues.

Jira's import from CSV functions do not have any automation functions.

The other option would be to create something that can "do the clicks" - pretend to be a human clicking on stuff in the browser.  There's plenty of tools out there that can do that.

[harish.thakare]

Hi @Nic Brough -Adaptavist- 

Thank you for the response