How can I fill a customfield with a CSV file?

[Eduard Diez]

Hi community.

How can I fill a customfield with a CSV file?

I mean, users have an employee number, and now they want to use a CSV or EXCEL file to fill in all the issues of a project. for example

User	Number
Pako Pil	254455
Aitor Tilla	544454

And I don't know how to do it, can you help me?
P.S.-> I don't have script runner, that makes things more complicated.

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Eduard Diez 

Take a look at this documentation https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

The most important thing is to include the issue key in order to update the proper issue.

[Alex Koxaras _Relational_]

@Eduard Diez to answer your question:

Hi again.

What I need is to put the data of an employee number in all the issues of a project, all employees have a company identifier and have several issues assigned, so I need a CSV that I pass to put in all the issues.

I know that if I download by a jql all the issues of a project and I add the identifier by hand, and then I import it, it can be done, but I want to know if there is another simpler way.

No there isn't a simpler way for what you want to achieve. If you want to import different employee numbers to different issues, then this is the way to go.

If you want to import the same number to different issues, then this could be achieved by bulk edit. But that's not your case.

[Eduard Diez]

Hi @Alex Koxaras _Relational_ 

that's fine and I understand what you are telling me, just like importing the issues and putting the number of employees, but let's assume there are 500 employee, how can I make the new isses without script runner, because with script runner I can think of a lot of ways.

Thanks to all of you

[Alex Koxaras _Relational_]

@Eduard Diez I'm confused as to what your business requirement is. Can you please describe it in a sentece? E.g. "I want to create new issues on a specific jira project and these issues must be populated with certain fields. In addition I want for each of these issue a specific field to have a different value".

[Eduard Diez · Accepted solution]

Hi again.

What I need is to put the data of an employee number in all the issues of a project, all employees have a company identifier and have several issues assigned, so I need a CSV that I pass to put in all the issues.

I know that if I download by a jql all the issues of a project and I add the identifier by hand, and then I import it, it can be done, but I want to know if there is another simpler way.

Thanks to all

@RISHAV KUMAR GUPTA , @Alex Koxaras _Relational_ 

[RISHAV KUMAR GUPTA]

Hi @Eduard Diez ,

As they contains different values for user and Number The better option would be the Bulk import as I have mentioned in excel sheet.

Thanks,
Rishav

[RISHAV KUMAR GUPTA · Accepted solution]

Hi @Eduard Diez ,

Here you go , I have attached a sample format from where you can import via CSV.

>

Thanks,
Rishav

[Eduard Diez]

Thank's