Importing from CSV
Hi Yury I have issues updating with a regular CSV-import. The field just becomes empty (even removing previous values).
I use this functionality quite a lot.
Is this a known issue?
(Still very happy with the add-on)
Comments (6)
-
-
repo owner Hi! Thank for report. I'm checking this problem right now.
-
repo owner Jira importers plugin not work correctly with third-party customfield types ;(
But I found solution - use field mapping.
-
Start import and click «Map field value» click «Next»
-
Do not change anything on maping page and click next.
-
Click «save the configuration» and edit it
-
Find "config.value.mappings" section and replace your values from this:
"config.value.mappings" : { "Single tree" : { "Option1" : "Option1", "Option2/Option3" : "Option2/Option3" } },
to this:
"config.value.mappings" : { "Single tree" : { "Option1" : "36", "Option2" : "23" "Option2/Option3" : "24", "Option2/Option4" : "25", "Option2/Option5" : "26", "Option6" : "27" } },
where "Option1" - value from csv and 36 - ID of value.
You can receive IDs of values via sql (AO_AA9326_OPTION table) or rest:
http://jirasite/rest/treecf/1.0/option/field/customfield_xxxxx
- Start new import, select csv file, and modified configuration file
- Profit
-
-
Hi Yury
Thanks for taking a look at this.
I'll consider this if I'll ever have to import 100+ issues with a tree custom field value. Otherwise it seems a bit excessive.
-
repo owner - changed status to closed
-
repo owner related
#37 - Log in to comment
Just got this error now: Cannot add value [ [AB - The arts: general issues] ] to CustomField Thema 1 in Issue with summary 'Test'. Probably value was in incorrect format Cannot add value [ [1D - Europe] ] to CustomField Qualifier 1 in Issue with summary 'Test'. Probably value was in incorrect format