My company has been awarded contracts (same customer) for multiple sites to do the exact same work. We would like to set up a Project/Plan Roadmap for each one. I currently have the project set up as:
For the first few sites, I created the Epic, then imported the Stories as a csv file, linking them to an Epic. After that import, I changed the Story Parent IDs in a separate sub-task csv file and imported that for the Epic. Create new Epic, import Stories csv file (changing Epic Link), change and import Sub-task csv file... repeat until all sites are created.
Currently, all awarded sites have been created in the project. However, we are working on proposals for several more sites. I would like to avoid the daunting task of uploading multiple csv files for each Epic and just upload 1 file that includes the Epic, the Stories linked to that Epic, and the Sub-tasks linked to that Epic and categorized under their respective Story (i.e., Parent ID).
The main issue is the Parent ID, linking Sub-tasks to the correct Story. The Epic Link also won't work if the Epic is created in the same csv file as the Story. With a csv file, the Parent ID has to be the created identifying number (i.e., "STORY-10" not "September Deliverables") which is created after an Epic, Story, or Sub-task is created. Note - I have the same issue with Sprints - I have to map Sprints in the csv file to the Sprint number, not its name. The other issue is every parent (Epic or Sprint) must be created first if I want to link items in a csv file to a parent. I basically have to import the Story csv file and change the "Parent ID" entries in the Sub-task csv file to match the parent ID numbers of the newly created Stories.
Question (finally): Does JSON work better with total Plan creations (Epic, Stories linked to Epic, and Sub-tasks linked to Story parents)? If so, what is the syntax for doing so? If not, is there a way to copy/clone all Stories and Sub-tasks in an Epic to a different Epic, linking those to the new Epic?
Hi @Eric Greco
You can upload Epics, Stories and Sub-Tasks in the same CSV - the basic layout for just the hierarchical setup is:
^ This allows you to upload the three different levels without three separate upload files.
I don't use JSON as much I'm afraid - but I find this an easy way from a CSV perspective :)
I tried that with the Issue ID (started with 1) prior to creating multiple csv files. My company's Jira account may already have an issue 1 (when I exported the plan, the Issue IDs for this particular project started at like 11900). For the multiple csv files, I was using the Issue ID related to the plan as assigned by Jira (i.e., Epic_1 was Issue ID ABC-1, etc.). I'll try using that syntax in the single, multi-level csv file (i.e., if the highest-numbered project task is ABC-192, so I'll start with ABC-193 for a new Epic, etc.).
One clarification question: Is the Epic Name field only required for the line that creates the Epic, or do you need that for all entries (Epics, Stories, and Sub-tasks)? Epic Link, as you said, will link Stories and Sub-tasks to the correct Epic, so I assume you don't need the Epic Name for Story and Sub-task entries.
Hi @Eric Greco
The Issue ID is just for mapping within the CSV file for Parent/Child - it won't set or override an actual ID in Jira, which is set automatically regardless of what's in the file.
The ABC-193 would be an Issue Key, rather than an ID. I don't believe it will work the same using these and it could become crossed with other issues being created in ABC during uploads. Best to stick to the Issue ID method of using numeric values to relate the stories / sub-tasks.
Epic Name is just needed for Epics. You need to enter the exact name into the Epic Link field for stories - pre-creation, the name is how Jira's import tool understands an Epic has stories below it in the file.
Sub-tasks don't need it as these are children of stories using the Parent ID / Issue ID as noted above.
I tried that and using ABC-193, etc., as Issue IDs and Parent IDs. It still did not work; in both cases, I received the error: "Fatal error during import: Parent Issue cannot be null."
Upon further investigating this issue, I discovered this post: https://jira.atlassian.com/browse/JRACLOUD-65048.
Apparently, this feature is only available to Global Admins... or by accessing the correct import option (I was importing from the Plan itself - Create > Import Issue).
After finding this post: https://community.atlassian.com/t5/Jira-Software-questions/issue-import-Parent-Issue-cannot-be-null-Simple-import-cannot/qaq-p/699498,I tried it from Dashboards: Settings > System > External System Import and it worked.
I did take your advice on design of the csv spreadsheet. Thanks for the help - it will make future Project and Plan creations a LOT easier for my colleagues and me!
Hi community, I’m Roi, a product manager working on Advanced Roadmaps for Jira. While Advanced Roadmaps is a powerful tool to plan and track work at scale, we know it can be challenging to get star...
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