Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Validation Warnings from CSV External Import

Deleted user October 23, 2018

We have a JIRA 7.10. project up and running in Production and as jira-administrator, just tried to import 100 new Issues by going to Admin->External Import and selected CSV <= the actual wording might be a little off.

The 1st thing we noticed was our saved configuration file only mapped to a handful of custom fields whereas all fields had previously mapped - so we manually remapped everything.

The import seemed to have no errors but when we ran Validate we had many warnings that basically said,

  1. The value <some value> "cannot be added to the custom field."
  2. "The value NULL="<some value>"cannot be found or is in the incorrect format."

It seems if a value was not already present in a Single/Multi-list custom field - that value was not being added to the list and not used in the imported Issue.

Example: If I have a single-list "Example" that has the values

  • A
  • B

and I wanted to add an Issue that contained single-list Example value "C" - I would get the Warning

  1. The value C cannot be added to the custom field.
  2. The value NULL="C" cannot be found or is in the incorrect format.

I've read some of the previous situations that people have had with importing CSV files but haven't seen anything quite like this.

Any suggestions or things I can try to make this work?

What will happen if I just ignore the warnings and allow the import to finish?

Note:  Before trying this import in Production I ran the import multiple times on my laptop using the exact same Project, Issues, Screens, FIelds, CSV and Configuration files and it worked every time without Errors or Warnings.

Jim

2 answers

1 accepted

2 votes
Answer accepted
Deleted user October 25, 2018

DO NOT use

  • Issues->Import from CSV

ALWAYS USE

  • Admin->System->External Import->CSV
0 votes
Andrew
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 23, 2018

Hi @[deleted]!

You sure the custom filed/schema/permission not different between test and prod? 

Custom field name, list of values, visible etc. has identical customization?

Deleted user October 24, 2018

Thanks for replying Andrew.

That's exactly what I'm checking on today because something must be different somewhere.

I'll get back to you to know what I find.

Jim

Deleted user October 25, 2018

Quess what?

The problem was that the user was using the

  • Issues->Import from CSV

and not

  • Admin->System->External Import->CSV

Running Admin->System->External Import->CSV produced a perfect import.

Jim

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events