nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Importing Excel File;Can't Proceed Past Map Fields Page

KDEUS IT

Hello,

I'm currently exporting an Excel .xls file (1 MB) to no success. I was able to upload the file successfully and assigned it to a specific project as intended. When I get to the "Map Fields" page I'm being notified that " A JIRA Summary field mapping is required to enable import". The only CVS Field is see is "<html xmlns:o=urn:schemas-microsoft-com:office:office" but I'm unable to select it. I get the option to select a "JIRA Field" and "Map Field Value" but any JIRA Field I select does not allow me to proceed beyond the MAP Field page. The NEXT button is grayed out.

Any help is greatly appreciated on helping resolving this issue.

Thank You

JIRA Version 6.2-OD-03 OnDemand

Accepted answers

Nic Brough -Adaptavist-

When you export to Excel from Jira, what it actually creates is an XML file that says "I'm a spreadsheet" to anything that opens it. This is not a csv file, it's xml.

When you save a new Excel spreadsheet, it defaults to Excel format. This also is not a csv file, it's an Excel file.

Neither of these file types can be imported, as the csv importer expects csv. You need to convert your data to csv, which is actually a doodle - open the file in your spreadsheet and then use either "save as" or "export to csv" and save the result. Then upload that into the csv importer instead.

All comments

Nic Brough -Adaptavist-

When you export to Excel from Jira, what it actually creates is an XML file that says "I'm a spreadsheet" to anything that opens it. This is not a csv file, it's xml.

When you save a new Excel spreadsheet, it defaults to Excel format. This also is not a csv file, it's an Excel file.

KDEUS IT

Hi Nic,

Thank you much for replying to my question, unfortunately, I'm still encountering the issue. I opened up the .xsl file and saved it as a CVS file. I uploaded the file successfully and assigned it to a specific project. When I get to the MAP Fields page, I chose any JIRA Field option and the NEXT button still appears grayed out. I upload the file.

My steps:

Upload CVS file.

I keep the default UTF-8 file encoding.

Assign to a specific project.

Stuck on Map Fields page.

I have attached a screenshot of my issue.

Thanks!

KDEUS IT

Hi Nic,

Unfortunately, I'm still encountering the same issue even after converting the file to CVS.

KDEUS IT

The following text appears on the Map Field page:

Working with multiples

For issues with multiple attachments, versions, components or comments use multiple columns in your CSV file. Use either: Different column names like Attachment 1, Attachment 2 then map each column to a corresponding JIRA field, or use the same column name (they will be mapped to the selected field).

Custom fields

Existing custom fields must be global to all projects.

Sub-tasks

To import issues as sub-tasks define the column mapping for: Issue Id, Parent Id and Issue Type

Empty headers

CSV file has at least one empty header, corresponding column will not be imported.

Nic Brough -Adaptavist-

Ok, could you take the csv file and open it in a simple text editor (vi, nano, notepad - not wordpad or anything more clever). No need to change anything, we just want to check the format.

Tell us what the first three lines say (feel free to obscure any data you don't want to share - we're interested in format, not data)

KDEUS IT

Here's are the first lines that appear after opening the csv file with Notepad

KFF Task Tracker,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Displaying 243 issues at 19/Nov/13 5:29 PM.,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Project,Key,Summary,Issue Type,Status,Priority,Resolution,Assignee,Reporter,Created,Last Viewed,Updated,Resolved,Affects Version/s,Fix Version/s,Component/s,Due Date,Watchers,Images,Original Estimate,Remaining Estimate,Time Spent,Work Ratio,Sub-Tasks,Linked Issues,Description,Progress,? Progress,? Time Spent,? Remaining Estimate,? Original Estimate,Labels,Story Points,Flagged,Testing Status,Epic Link,Rank,Sprint,Platform,MANTIS_ID,Epic/Theme,Raised During,Test Sessions,[CHART] Date of First Response,Milestone

Peter Lindsay_2psybf

Taiga does not include a 'Summary' field. Just add (import to Excel, add 'Summary' column as header, export again as CSV. Mapped 'Summary' and worked fine!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud