Move custom field value to another custom field ?

[jrii]

Hi,

Need to modify several project data from one field to another (custom fields). Tried exporting and importing.. unsuccesfully.. (perhaps there are better solutions than export-import...).

Tried following:

1. Constructed limited column view in issue management and exported content to CSV - file.

2. Manipulated data in excel where I cut and pasted data part (not header..) from column "A" to "B", saved file. In this phase first modified column is empty and "B" column has values, which were previously in A. 

3. Exported CSV and mapped values accordingly.

Output: No data in column "B" ... 

I'm JIRA admin so if there is a plugin what I could use... Already have automation of Jira if that can be used ... ?

-Jouni

[Patrick Cartier [Candylio]]

Hi @jrii,

I'm not seeing how the export/import isn't working.  If the result is "no data in column b" then you should check to make sure field b accepts the values that you are trying to import into it.

If this still isn't working you can try to use scriptrunner and run a script that moves the field values one time.  Try looking through this answer and their documentation for some tips on what script you would write: https://community.atlassian.com/t5/Jira-Core-questions/Copy-Custom-field-value-from-one-field-to-another/qaq-p/73207

I still think the export import is possible and probably faster.  Please check your field configuration in the destination field.  If I could know what the data type is it might help.

[jrii]

Hi @Patrick Cartier [Candylio],

Field types in both field is Text Field (multi-line), don't understand why field B woudn't accept values as haven't done any kind of restrictions.

Will try export and import still ...

-Jouni

[jrii]

Ticket can be closed as I managed to import few tickets successfully, this time I just didn't map field values .. strange thing still that in importing phase I cannot find Issue Key value from the dropdown list.

[Patrick Cartier [Candylio]]

ok @jrii glad you got it to work.

This isn't exactly a helpdesk so we won't close the issue but you can mark it as 'accepted' so others know you got it to work.

I will add this ticket that I just found from another answer where people had issues importing multiple lined text before:

https://jira.atlassian.com/browse/JRASERVER-46365?_ga=2.42169510.2019710780.1545018989-1760366298.1538725681

Anyway, glad you figured it out!