Cannot import ACCOUNT field to project from CSV File

[Antonio Colin]

Hi Guys,

I'm trying to import a CSV file into a Scrum project.

All fields are imported successfully, except the Account field. I put the full log in the link below.

It's important to mention that the account exists, the project has a Custom field called Account and the account in Tempo Timesheets is linked to the project. If I edit the account field manually for any issue from the web interface, I am able to do it.

Jira Import Log 

Thank you for your help.

[Damian Wodzinski]

What field type is that?

[Antonio Colin]

Hi Damian,

It is "Account Type". But it is imported as a custom field since it is not a jira field.

I made another test, exporting a project that has this field and it is exported as 'Custom field (Account)' in the CSV file and the text is plane, like any other field.

I really need to fix this since the account field will be used for billing purposes.

Thank you !

[Antonio Colin]

I got the right type:

Tempo Account Custom Field

It's shown as LOCKED in the default field configuration.

[Damian Wodzinski]

If it is Tempo Account Custom Field, it accepts data stored in the Accounts Manager.
If you can manually set "bulk account" to it, it seems that you are providing data in wrong format.

For example, in Jira you have field type of "User Picker". In order to import data to it, you need to paste username into it, that means in most cases you cannot put First and Last Name of user into excel spreadshead, you need to use logins if you want it to work. I think you need to do similar thing with it - provide data in correct format.

I suggest you adding manually the value on some Issue and trying to see if there is any prompt about it.

[Antonio Colin]

The format I am using in the imported file is CSV. I also attached an image of how the CSV looks like to clarify the format I am using. The cell format is plain text.

As per your example, how am I supposed to paste the text "bulk account" in the Account field? OR... how am I supposed to use logins??

Don't get that, sorry.

As I mentioned before, I can manually add the value.

But what I thnk is causing the trouble is that the Account Field is filled using a drop-down menu, it's not filled by typing text directly into it.

Hope that makes sense. I think I have provided all the information needed to clarify the problem.

Thanks.

[Damian Wodzinski]

That does not matter, the data in excel file must be exacly the same as one option aviable from the dropdown menu.

[Antonio Colin]

If you had watched the images and log I attached, you would have already noticed that in fact IT IS exactly the same.

How many errors are possible when copying & pasting this text? bulk account

[Damian Wodzinski]

In image I can only see screenshot from excel file, not from Jira, so I do not know what options you have in the custom field.

Look at this:
https://confluence.atlassian.com/adminjiraserver072/importing-data-from-csv-829827152.html

And if you have scriptrunner, this will be helpful:
https://www.adaptavist.com/doco/display/SFJ/Set+a+select+list+custom+field+value