Importing data from CSV

[AbrahamA]

Hi

I have a excel sheet of data that got exported out of test jira install.

Now I want to import the data back into another JIRA installation.

In the exported data there is a custom field called options (select list) which takes any of five values opt1..opt5. Now this field is limited to only few issue types. So when I exported data into excel all issues which are not belonging to those issue types which had options has blank.

When I am importing using the csv wizard, I cannot map options to options as I cannot see options in custom field.

So when I import without mapping the data for that field is not available.

Can you please let me know how this can be resolved, so that I slected option into the system when it exists.

I am on Atlassian JIRA (v4.4#649-r158309) on windows.

Thanks

Abe

[Wojciech Seliga · Accepted solution]

Current version of JIRA Importers Plugin does support importing into select list. You need to choose that a column from your CSV file maps to such existing custom field and best check "Map field value", Then the importer on the value mapping page will not display combo box with available options in JIRA (which would be great I know), but it will display a number of edit boxes, where you can type the corresponding names of the existing options you want to use for the mapping.

[AbrahamA]

Thanks for the response.

I use external system import in Admin page.

But my issue here is that "options" custom field is only available for certain issue types.

When I try to map I have "Options" available in the external system, Even though I have options custom field to which I can import in the new one, the custom field is not showing up.

So on the lefthand side of import mapping page I have options, but on the right side where I need to map "options" is not shown.

What I think is because "options" is not available for all issue types, and the data that I am importing has issue types which does not have options (I have empty cell when I exported) , JIRA is not showing option to map.

My understanding may be wrong. Can you please let me know if anyone faced similar situation.

[Wojciech Seliga]

OK, Now I understand better your situation.

Indeed JIRA Importers Plugin does not support importing into non-global custom fields. That's a known limitation (cast your vote on https://studio.atlassian.com/browse/JIM-606 to help prioritize it).

The only reasonable workaround I know is to temporarily (just for the time of the import) make these custom fields global (i.e. applicable for all projects and issue types) and after the import restore the original configuration. Far from perfect, but better than nothing.

[AbrahamA]

Thanks I followed your suggestion and got all issues imported.

However after import when I checked the imported issues:

1. Issue Types did not get imported correctly: There are multiple issue types in the input csv. After import all issues came into one issue type "Defect"
2. Has put created and updated date to current date instead of putting what was in csv
3. Issue priority is the only one that got imported fine. I.e what priority I have in input issues corresponding imported issues had same priority.
4. Status field did not get imported. All statuses are shown same "UNRESOLVED"

CAn you please let me know what configuration is needed for it to import data properly.

[Wojciech Seliga]

Could share a screenshot of your configuration screen? Alternatively raise a support request at https://support.atlassian.com providing your CSV file (or at least excerpt of it) and your import config file.

Ad 1. It looks like you haven't mapped Issue Type column to JIRA Issue Type. By default CSV importer will create "Bug" issue type (which is in your instance probably called as "Defect").

Ad 2. Have you imported these columns into "Date Created" and "Date Modified"?

Ad 4. You have to also import a status (a CSV column with status value into Status in JIRA) and usually you need to click on "Map field value"

[AbrahamA]

WThanks Wojciech for you pointers.

Your hints and logs told me where I went wrong.

For anyone else who might be interested:

1. Look at the date formats in the file that you import. Match it in the import. I also changed the format in the user look and feel.
2. See if all states are present in the default workflow. Else map to known states. Questions: what if I do not want default workflow. I.e I want to create a new workflow where I have all states instead of mapping it to existing states that I have done now.
3. There is link below after the import is done to log files see it :-(
4. Hope for Wojciech to show interest if things do not work.

[ab185178]

I assume you are using the External System Import option available in the Administration tab to import data into another instance of JIRA. Using this you can map the fields as well as the values in the CSV file. But to map the fields, the new fields must be available in the new JIRA instance.