Urgent Help Custom field Import from CSV

[Samir Freelance]

Hi , I am trying to import using CSV to a custom checkbox list

<col style="width: 48pt;" span="3" width="64"/>

ImpactInBusinessVelocity	ImpactInBusinessVelocity	ImpactInBusinessVelocity
Velocity	Revenue Generating	NULL
Velocity	Revenue Generating	NULL
Velocity	Revenue Generating	NULL
Velocity	Revenue Generating	Cost Saving
Velocity	NULL	Cost Saving
NULL	Revenue Generating	NULL
NULL	NULL	NULL
NULL	NULL	NULL
NULL	NULL	NULL
NULL	NULL	NULL
NULL	NULL	NULL
NULL	NULL	NULL

please tell me how to import to a custom field called Impact in business that i already created

when mapping using csv i failed ...i can see only one value or (one marked) in case i have more are checked

ImpactInBusinessVelocity

ImpactInBusinessVelocity

ImpactInBusinessVelocity

Velocity

Revenue Generating

NULL

in issue i see only Revenue genarting and there is no Velocity

[Samir Freelance · Accepted solution]

I downloaded the latest plugin and now it is working ..Thanks Nic

https://plugins.atlassian.com/plugin/details/32645?versionId=456211

[Nic Brough -Adaptavist-]

Right. That is covered in the documentation, as usual. Read http://confluence.atlassian.com/display/JIRA/Importing+Data+From+CSV and pay close attention to the section "valid file format", which tells you how to import multiple values into a multi-select field.

[Samir Freelance]

please have a look on the csv format:

ImpactInBusiness,ImpactInBusiness,ImpactInBusiness,ImpactInBusiness
Velocity,Revenue Generating ,Cost Saving,Increase Quality
Velocity,NULL,Cost Saving,Increase Quality
NULL,Revenue Generating ,NULL,Increase Quality
NULL,NULL,NULL,Increase Quality

[Samir Freelance]

please have a look on the csv format:

ImpactInBusiness,ImpactInBusiness,ImpactInBusiness,ImpactInBusiness
Velocity,Revenue Generating ,Cost Saving,Increase Quality
Velocity,NULL,Cost Saving,Increase Quality
NULL,Revenue Generating ,NULL,Increase Quality
NULL,NULL,NULL,Increase Quality

I am maping ImpactInbusiness to existing custom field then i choosed a custom field Impact In Business

again not all values are imported

[Samir Freelance]

http://tinypic.com/r/mww0f8/7

http://i51.tinypic.com/mww0f8.png

[Nic Brough -Adaptavist-]

Are you mapping the incoming data?

Can you try moving all the nulls to the end of each line?

[Samir Freelance]

I am mapping the incoming data, and I removed all the nulls; My CSV format

Summary,ImpactInBusiness,ImpactInBusiness,ImpactInBusiness,ImpactInBusiness,Description,IssueType
Test 01,Velocity,Revenue Generating,,Increase Quality,Test 01,Bug
Test 02,Velocity,,Cost Saving,Increase Quality,Test 02,Bug
Test 03,Velocity,Revenue Generating,Cost Saving,Increase Quality,Test 03,Bug
Test 04,,,,Increase Quality,Test 04,Bug
Test 05,,Revenue Generating,,Increase Quality,Test 05,Bug

Can you please try it ?

[Nic Brough -Adaptavist-]

Can you make sure you are selecting the same Jira field for each of the impact fields in the CSV? It should be asking you about each column separately.

[Samir Freelance]

Yes I am sure just I also opened a ticket

https://support.atlassian.com/browse/JSP-88487

please check the steps I followed

[Nic Brough -Adaptavist-]

That project is not public - we can't see stuff you raise in there.

I've just tried to run your file into a test system, it's working fine for me.

[Samir Freelance]

Following are the steps i made

1. Create a custom field called "Impact In Business" of type Multi Checkboxes.
2. Load up the test.csv file for import in JIRA.
3. Map the field "ImpactInBusiness" on the next screen:
   
   
4. Continue straight to importing.
5. After importing, you can edit the issue and notice that the field "Impact In Business" has checkboxes with the values you've imported earlier

NIC Can you please tell me your steps.. are you sure you have more than 1 checked?

take the test 03 Test 03,Velocity,Revenue Generating,Cost Saving,Increase Quality,Test 03,Bug

I can only see that Velocity is Marked ..

I guess it only marks the first value it find and ignors the rest for each line

I am really stuck!!

[Nic Brough -Adaptavist-]

That still doesn't tell us whether you have mapped ImpactInBusiness many times? Just to make it entirely clear, could you rename the columns in the CSV as (say) ImpactInBusiness_1, ImpactInBusiness_2, ImpactInBusiness_3 and so on.

Also, I apologise, I was not entirely clear when I was talking about "mapping". There's two things to look at - first, you need to link ImpactInBusiness_1, ImpactInBusiness_2, ImpactInBusiness_3 and so on to the same Jira field, "Impact in Business". Second, can you check that you ticked the "map field" check box next to each one of the columns on the screen where you link them?

[Samir Freelance]

do you think because I changed the design layout here

https://answers.atlassian.com/questions/2762/multi-checkboxes-design

I tried to import to using new custom fiels instead of exitsing but same result

[Nic Brough -Adaptavist-]

The screen layout is not important - the CSV imports data into fields, it's got nothing to do with how they are displayed.

[Samir Freelance]

still no change

1-I renamed the CSV columns

2-mapped them to existing field Impact In business

3-I checked Additionally map field value for each of the columns

4-CSV header row Additionally map field value
ImpactInBusiness1
(imported as existingCustomField) Value from importer Target value in JIRA
Velocity:

ImpactInBusiness2
(imported as existingCustomField) Value from importer Target value in JIRA
Revenue Generating:

ImpactInBusiness3
(imported as existingCustomField) Value from importer Target value in JIRA
Cost Saving:

ImpactInBusiness4
(imported as existingCustomField) Value from importer Target value in JIRA
Increase Quality:

[Nic Brough -Adaptavist-]

I'm sorry, that makes no sense what so ever. When importing into a custom field, you tell Jira which column in your CSV contains the data, and if it's a select field, you map the options (Check boxes are a form of select list by the way - the difference is in the way they are displayed, not the actual data structures). I can't make out what you're even doing here, let alone what you are trying to do.

[Samir Freelance]

Hi Nic thank for your comment ,

I am trying to import 3 columns to the 1 custome field

if you think you do have another way please share it with me

[Samir Freelance]

in the old database these checkboxes are stored in 3 columns