Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Bulk create projects via csv

Hi, 

I have been searching for information on how to create projects in jira using the bulk csv import feature, but I cannot find a solution for this. 

What I am looking for is possibility to create X projects, with Y epics, and N issues, using a csv file. Does anyone know if this is possible?

Example

project A - Epic A - issue A

project A - Epic B - Issue B

project A - Epic B - isuee C

project B - Epic A - issue A

project C - Epic C - Issue B

project C - Epic B - isuee C

etc. 

 

2 answers

1 accepted

0 votes
Answer accepted

Hey @Simon Rasmussen this support article shows you how to import via CSV -https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

Hope it helps.  

Thanks @Tushar Bhatia I have tried following the section “Importing issues into multiple JIRA projects” but this seems to require the projects are allready created.

I am looking for a way to create the project in the csv import. 
have you seen a Way to Do this?

or is this only possible using webservices and the API?

During the setup section, make sure you check "Defined in CSV" instead of import to project and it will add relevant data to the project you specify.

It will also automatically create projects if they're not already created. You will need to specify the Project Name, Project Key and Project Type. 

Options for Project Type are (case sensitive):

software, business and service_desk

I just tested and it worked with this sample CSV: 

IssueType, Summary, Project Name, Project Key, Project Type
bug, "First issue", Sample, SAMP, software
bug, "Second issue", Sample, SAMP, software
task, "Third issue", Example, EXAM, software
Like # people like this

Awesome @Tushar Bhatia thanks. I will try this. 

Like Tushar Bhatia likes this

So I have done a little testing and found that most of what I am looking to do works. 

I imported:

IssueType;Summary;projectName;projectKey;projectType;Debitor;debitorNr;ordreNr;Description;issue Key;Epic link;template;Category

 this created new projects, with the epic and linked epic tasks I was after. 

However allthough the import log has an attribute for project template, I am not able to choose this in the csv mapping. the last attibute is template=null, I was hoping to set this to template=[project Key for my template project]

Created Project: ExternalProject{id='null', key='UN', externalName='null', name='Unique North', type='software', template='null'} successfully

csv import.JPG

I also tried adding the category in csv, however I could not find mapping for this either. 

 

Would it just be easier to import using JSON if it can handle all these things?

I have not actually tried it, but I have seen posts that it is possible. Have you tried including Project Name and Project Key as columns in your import data, and using a Configuration File for the field mapping?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Asked in Jira Service Management

JSM June ask me anything (AMA)

Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...

270 views 13 14
View question

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you