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

Import CSV under Kanban software simple project

Hi,

I'm trying to import data from CSV into Kanban software simple project, 

From some reason the Task / Subtask under issue type doesn't work for me and I need to Map them manually,

Further,

My subtask being created without a relation to Parent ( Task ).

image.pngimage.png

1 answer

0 votes
John Funk Community Leader Apr 27, 2021

Hi Tal,

Take a look at this previous post for guidance. 

https://community.atlassian.com/t5/Jira-questions/Importing-Subtasks-into-existing-Story/qaq-p/1313594

Is that how you setup your CSV for the import? 

Hi,

First of all thanks for quick replay, 

I didn't provide the Parent ID issue number because it's still doesn't exists ... 

I'm trying to migrate Asana project into Jira and relate between the Task and Sub-tasks together under my CSV file, Attaching screen shot...

image.png

At this way I managed to Import full project last time under Business Task Tracking template and it's work perfect.

Must admit that beside this feature that not working, I also pay attention that under Business Task Tracking template the issue type of Sub-Task is named "Sub-task" and under Software Kanban simple project it's call "Subtask"

Maybe this is the root cause ?   

I was thinking to do it under two iterations,

First create the Tasks, Second the subtasks... 

Try to do what were written at :

https://community.atlassian.com/t5/Jira-questions/Importing-Subtasks-into-existing-Story/qaq-p/1313594

But still the same result... 

image.png

The actual result is subtask without any parent relation :-( 

Adding detailed import log file text

2021-04-27 14:42:16,718 INFO - Import started by admin using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2021-04-27 14:42:17,410 WARN - Unable to parse created date: 11/11/2020
2021-04-27 14:42:17,428 INFO - ------------------------------
2021-04-27 14:42:17,428 INFO - Importing: Users
2021-04-27 14:42:17,428 INFO - ------------------------------
2021-04-27 14:42:17,428 INFO - Only new items will be imported
2021-04-27 14:42:17,473 ERROR - Cannot create user eladweinstein: User eladweinstein has an invalid e-mail address [eladweinstein@]
2021-04-27 14:42:17,482 ERROR - Cannot create user eladweinstein: User eladweinstein has an invalid e-mail address [eweinstein@]
2021-04-27 14:42:17,485 INFO - 4 users associated with import. All of them imported as inactive, this can be changed after import in User Access step.
2021-04-27 14:42:17,485 INFO - ------------------------------
2021-04-27 14:42:17,485 INFO - Finished Importing : Users
2021-04-27 14:42:17,485 INFO - ------------------------------
2021-04-27 14:42:17,486 INFO - 0 users successfully created.
2021-04-27 14:42:17,489 INFO - Retrieving projects...
2021-04-27 14:42:17,504 INFO - Project ExternalProject{id='null', key='SR', externalName='null', name='Strategic Roadmap', type='null', template='null'} exists and found correctly.
2021-04-27 14:42:17,508 INFO - ------------------------------
2021-04-27 14:42:17,508 INFO - Importing: Versions
2021-04-27 14:42:17,508 INFO - ------------------------------
2021-04-27 14:42:17,508 INFO - Only new items will be imported
2021-04-27 14:42:17,508 INFO - ------------------------------
2021-04-27 14:42:17,508 INFO - Finished Importing : Versions
2021-04-27 14:42:17,508 INFO - ------------------------------
2021-04-27 14:42:17,508 INFO - ------------------------------
2021-04-27 14:42:17,508 INFO - Importing: Components
2021-04-27 14:42:17,508 INFO - ------------------------------
2021-04-27 14:42:17,508 INFO - Only new items will be imported
2021-04-27 14:42:17,508 INFO - ------------------------------
2021-04-27 14:42:17,508 INFO - Finished Importing : Components
2021-04-27 14:42:17,508 INFO - ------------------------------
2021-04-27 14:42:17,515 INFO - Retrieving custom fields...
2021-04-27 14:42:17,524 INFO - ------------------------------
2021-04-27 14:42:17,524 INFO - Importing: Issues
2021-04-27 14:42:17,524 INFO - ------------------------------
2021-04-27 14:42:17,524 INFO - Only new items will be imported
2021-04-27 14:42:17,609 INFO - Importing issue: [externalId='1', summary='Characterization- Ori']
2021-04-27 14:42:17,873 WARN - Commenter named null not found. Creating issue with currently logged in user instead
2021-04-27 14:42:18,061 INFO - Importing issue: [externalId='autoid-6554552542281928020', summary='null']
2021-04-27 14:42:18,063 WARN - Issue skipped [externalId='autoid-6554552542281928020', summary='null']: Blank summary detected. Such issue cannot be imported
2021-04-27 14:42:18,071 INFO - 1 out of 2 issues successfully created
2021-04-27 14:42:18,076 INFO - ------------------------------
2021-04-27 14:42:18,076 INFO - Finished Importing : Issues
2021-04-27 14:42:18,076 INFO - ------------------------------
2021-04-27 14:42:18,119 INFO - ------------------------------
2021-04-27 14:42:18,119 INFO - Importing: Issue Links & Subtasks
2021-04-27 14:42:18,119 INFO - ------------------------------
2021-04-27 14:42:18,119 INFO - Only new items will be imported
2021-04-27 14:42:18,131 INFO - Linking 'SR-30' and 'SR-28' as sub-task-link
2021-04-27 14:42:18,274 INFO - Created parent-child (sub-task) relationship between SR-30 and SR-282021-04-27 14:42:18,278 INFO - ------------------------------
2021-04-27 14:42:18,278 INFO - Finished Importing : Issue Links & Subtasks
2021-04-27 14:42:18,278 INFO - ------------------------------
2021-04-27 14:42:18,280 INFO - ------------------------------
2021-04-27 14:42:18,280 INFO - Importing: Issue remote links
2021-04-27 14:42:18,280 INFO - ------------------------------
2021-04-27 14:42:18,280 INFO - Only new items will be imported
2021-04-27 14:42:18,284 INFO - ------------------------------
2021-04-27 14:42:18,284 INFO - Finished Importing : Issue remote links
2021-04-27 14:42:18,284 INFO - ------------------------------
John Funk Community Leader Apr 27, 2021

Yes, when I read your first response, I was thinking it was best for two iterations. Create the story/issue first and then update your CSV to include the parent key. And then create the sub-tasks on the second pass. 

Yes,

I try this one but, still not working even due the log written it's relate the sub-task to task, 

But still under Jira there is no relation between the Import sub-task and the existing Jira task...

I found that under issue navigator advanced search it's appear like it relate to the parent ...

ACE947C0-FC32-4019-B802-D8ACE213BC8F.jpeg

 

While checking same "Deposit amount" subtask I can see this ... 

image.png

And also can't see any child related to parent the task itself...

 

John Funk Community Leader Apr 27, 2021

What is Strategic Roadmap? Is that a Roadmap Plan or an Issue? What do you see if you click on that? 

The Strategic roadmap is the name

of project and click on it take me to the board itself,

That board of course show me just Task and the child related to them.

As mention before it’s seems like the task are already hooked to child’s when I’m searching an issues under issue advanced search but from some reason it’s hooked only there, at other places of the system it’s not hooked..

John Funk Community Leader Apr 28, 2021

I would go ahead and submit a support ticket with Atlassian:

https://support.atlassian.com/contact/#/

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Why everyone using Jira must be GDPR-compliant

Did you know that penalties up to 4 % of the yearly company turnover are possible in case of GDPR violations? GDPR regulations are currently mainly relevant for companies in the EU, but countries lik...

56 views 0 0
Read article

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