CSV import with select fields

[Jonathan García]

Good afternoon,

When importing from a CSV a select field with several options (Preproduction||Production), it only inserts the first value Preproduction.

How can I solve this problem?

Thank you very much,

Thanks a lot.

Buenas tardes,

Al importar desde un CSV un campo select con varias opciones (Preproducción||Producción), sólo inserta el primer valor Preproducción.

¿Cómo se puede solucionar el problema?

Muchas gracias,

Saludos. 

[Joseph Chung Yin · Accepted solution]

@Jonathan García 

Welcome to the community.  What you need is to prepare your CSV file by -

For multi-select field, your CSV file will need to have multiple columns example -

IssueType, Summary, Custfield, Custfield, Custfield, Custfield

bug, "First issue", option1, option2, option3

Afterward when you execute the import process, you will map the custom field to the same Jira custom field in the configuration.

Take a look at the following reference link - https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/  Look under the section named "Aggregating multiple values into single fields"  The example uses the Component/s and Fix version/s fields to illustrate the point.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[Jonathan García]

@Joseph Chung Yin  Thank a lot, I will try it :)

[Jonathan García]

I tried it but it doesn't work for me, I probably didn't do the right steps, sorry.

The field "Entorno" is a select that has several possible values "Producción", "Integración" and I want to import in an object "Entorno=Producción Integración". In my csv, I have created a new field called "Entorno2".

Then I mapped the field "Entorno=Preproducción" and "Entorno2=Integración" to "Entorno".

When importing, it does not add the two values (Producción, Integración" to the "Entorno" field.

Thank you in advance for your help.

[Joseph Chung Yin]

@Jonathan García -

When you map the CSV file field, you need to map the first column to the Entorno Jira field, and then map the 2nd field to same field again.  

Are you using the out the box import process, or you are using a third party add-on?  It is because the out of the box UI will not allow you to map two fields (columns in your CSV file) to a given Jira field within the same line.

Best, Joseph