Forums

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

Jira Cloud Bulk Upload

nfarmer December 10, 2019

Watchers → The value is invalid.

When attempting to bulk upload with CSV, I cannot add watchers automatically, it says the value is invalid. On this https://confluence.atlassian.com/adminjiraserver071/importing-data-from-csv-802592885.html it says "Watchers" is a valid field, but it's not importing.

Has anyone else come across this issue and found a solution? 

1 answer

0 votes
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 11, 2019

Hello @nfarmer ,

The error you noted being a "The value is invalid" indicates the field is properly located and directing the information from the CSV file in but the formatting or data listed is incorrect in some way causing the import to fail.

The watchers field is a multi select field and can have multiple users in the single field, and one possibility is if you have multiple users you would need to have multiple watcher columns for the import.  

As an super simplified EXE issue 1 would have two watchers and issue 2 would have 1 watcher:

summary,Description,watcher1,watcher2
Summary of issue 1,Description,user1@example.com,user2@example.com
summary issue 2,description,user1@example.com,

if this is not the case, and you do already have multiple watcher columns can you include  an exe of how your csv file is formatted, with the header row and al least one row of example data, making sure to scrub any sensitive data points like the users email addresses for the watcher field.

Regards,
Earl

nfarmer December 12, 2019

@Earl McCutcheon  When I attempted to map watcher1, there was no JIRA field to map it to. 

Summary, Description,watcher1, Assignee, Reporter, Issue Type, Priority,Labels
Test issue, Testing bulk upload options.,email@test.com,email@test.com,email@test.com,Email request,,cybersecurity
nfarmer December 12, 2019

@Earl McCutcheon When I attempted to map the watcher1 field, it said there was no field to map it to. Here is my csv

Summary, Description,watcher1, Assignee, Reporter, Issue Type, Priority,Labels
Test issue, Testing bulk upload options.,email@test.com,email@test.com,email@test.com,Email request,,cybersecurity

  

Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 13, 2019

Hello @nfarmer ,

There are two locations for CSV import, A bulk issue create option and a Data Import option.   

If you are using the one located under the issue navigator, this is a Bulk Issue Create option that requires less privileges to access and is therefore more limited in functionality and the watchers field as well as several other fields will not be present at this location for mapping.

Make sure you are using the the Issue Importer option located under the admin menu at:  "Admin drop down > System > IMPORT AND EXPORT > External System Import > CSV"

Regards,
Earl

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events