import csv file

[Karim Belhadj]

hello team

i read that :

For example, this is valid:

Summary, Assignee, Reporter, Issue Type, Description, Priority
"Test issue", admin, admin, 1, ,

... but this is not valid:

Summary, Assignee, Reporter, Issue Type, Description, Priority
"Test issue", admin, admin, 1

but i do not understand really why ? 

first :   why after priority we do not set a comma (,) ?

Second : why at the end of example 1 there are 2 comma ?

third : why we make "test issue "  like a string ?

I need the help thank you .

Regards 

[Ravi Varma · Accepted solution]

Hi @Karim Belhadj,

You may want to look at any CSV file which has some data in it. Typically, they are comma separated values.

first :   why after priority we do not set a comma (,) ? - The first row in any CSV file is the header row which are column names separated by Comma(,). If you put a comma after Priority, it would mean there is one more column after Priority field

Second : why at the end of example 1 there are 2 comma ? - It means the Description and Priority field value in example 1 is blank/empty

third : why we make "test issue "  like a string ? - If you look at the column headings,

1. Summary field in JIRA is of type String. If Summary has only one word (which is very unlikely) then you don't need to put them in quotes.
2. Assignee and Reporter are of type user in JIRA which means you need to provide the username.
3. Issue type can be provided as a issue type id that is denoted by the underlying configurations or the issue type name as a string. Both will work
4. Description is of type String, similar to Summary
5. Prioirity can be provided as a Priority id that is denoted by the underlying configurations or the Priority name as a string. Both will work

Hope this addresses your concern.

Regards,

Ravi Varma

[Vishnukumar Vasudevan]

Well explained Ravi Varma.

[Karim Belhadj]

@Ravi Varma  tank you very much , so please can you tell

me why we usue "" add"" double quotes ?

"Clicking the " "Add" " button results in a page not found error"

second and last :  i do not understand this comment , if you can tell me please . and thank you.

If you are importing a username-based CSV field (e.g. Reporter or Assignee) and you do not check the Map field value option for this field, then the import process will automatically map imported usernames from the CSV file to (lowercase) Jira usernames. 

regards

[Ravi Varma]

Hi @Karim Belhadj,

Please note that double quote (") and comma (,) are reserved characters as they have a specific meaning, with regard to how the CSV file would be processed.

If your text field has double quote as part of your string data, you have to escape it by prefixing an escape character. You may want to refer to online documentation about CSV files.

Regarding the second query:- JIRA CSV import has mapping feature where you can map CSV column data to any of the configured field options. For example: CSV field value Completed in your CSV file can be mapped to Resolution field value "Done"

Same logic applies to other JIRA fields (Username, Select list, Issue Type). You need to select the Map check box (on the extreme right) while selecting the JIRA field. 

If you don't select Map checkbox, then it is your responsibility to ensure that Reporter or Assignee CSV value is a valid JIRA username. So, care should be taken while preparing the CSV value for Rerporter and Assignee. 

References: 

https://confluence.atlassian.com/adminjiraserver073/importing-data-from-csv-861253680.html

Regards,

Ravi Varma