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 UserNumber Pako Pil254455 Aitor Tilla544454 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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Alex Koxaras -Relational-

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.

RISHAV KUMAR GUPTA

Hi @Eduard Diez ,

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

ATL comm1.png >

Thanks,
Rishav

Eduard Diez

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-

All comments

Alex Koxaras -Relational-

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.

RISHAV KUMAR GUPTA

Hi @Eduard Diez ,

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

ATL comm1.png >

Thanks,
Rishav

Eduard Diez

Hi again.

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

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

Thank's

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

custom-field

cloud

jira-software

jira-software-cloud

ms-excel