How to import multiple csv lines in one single issue?

Question

Hello, I am trying to import multiple csv lines into one single issue.

The reason for this is that I have different descriptions, users and time spent on the same issue and I would like to import all these lines in a single shot.

eg

summary, time spent (in seconds), user

Issue1, 200, abc

Issue1, 300, def

Issue1, 100, abc

I would like to enter this as csv file, but it creates three different issues with the same name, instead of one issue with cumulated time spent (in this case, 600). I have also tried to use the same issue key for each line, but it just overwrite the data and only the last line is created.

Can anyone help me with this?
Is there a solution?

Ippokratis G · Answer

There is a tool that can convert your csv files with advanced settings that can be saved and reused on subsequent imports. Then you may modify the content or apply advanced filters and export in excel. I think it is called TurboDA.

Trudy P Claspill · Answer

Hello @Jacopo Paganelli

Welcome to the community.

When importing from CSV, each line will create a separate issue. That is how CSV works.

If you want to import values for one issue in an area that supports multiple entries, such as Components, Labels, and Time Spent, you need to create a column for each entry and give those columns the same title. For example, if you have three time entries you want to import for one issue you would use a format like this:

Issue Type,Summary,Time Spent,Time Spent,Time Spent
Story,My summary,3600,7200,1800

Here is a link to the reference document for importing from CSV. There is a section titles Work Log Entries that specifically details importing Time Spent information.

https://support.atlassian.com/jira-core-cloud/docs/create-issues-using-the-csv-importer/