Import data from JIRA into Confiform

[Sebastien Carriere]

Hello,

I am trying to add a function to my Confiform but I have not yet identified any solutions. My Confiform is pulls the description field from an existing JIRA ticket. This part works as intended.  I need however for it to pull only a section of it, or at least have that section get submitted. Below is an example of what I am pulling but I only need what is in bold. I looked in numerous places online but haven't been able to locate anything similar.

*Old Intake ID (From Sharepoint):*

*_______________ USER INFO _______________*

*Request Submitter's Name:* Doe, John

*Request Submitter's Email:* John.Doe@ABCDE.com

*Problem / Opportunity Statement:* This is the text I need to capture

*What is the total expected cost for this initiative?:* < $1,000

*Business Impact?:* None

[Alex Medved _ConfiForms_]

Hi @Sebastien Carriere and welcome to this community

Do you store a Jira issue key in ConfiForms (and use the Jira field type)? If the answer is yes, then you can easily access ANY field from your Jira issue directly 

https://wiki.vertuna.com/display/CONFIFORMS/Accessing+Jira+issue+fields+directly+from+ConfiForms+using+Jira+issue+field

Alex

[Sebastien Carriere]

Hi Alex, Pardon my lack of knowledge if this won't make sense.  I am new to this whole Confiform/JIRA/Confluence world. I believe I have JIRA Issue Keys.  The form I want to pull from comes from another team.  That portion I want to extract is encompassed within the Description section of the JIRA Ticket. I am unsure how, if it's even possible, to target it using Confiform.  

I couldn't find anything online either unfortunately.

[Alex Medved _ConfiForms_]

Now I am confused to be honest. Do you want to access data from another form now? Another ConfiForms form?

[Sebastien Carriere]

My apologies Alex.  I'll try to explain in a different approach.

I am building a form via Confiform. I built a function to pull information from an existing JIRA ticket using Lookup and set JIRA issue data.  That JIRA information is located in the Description section of the JIRA Ticket.  

From that Description, I only need a specific portion of it, not the entire section. Currently, I'm only able to pull the entire Description section and not sure how to break that down into the portion needed.

I hope this makes a bit more sense?

[Alex Medved _ConfiForms_]

How would you like to "break down" the description field value?

What do you expect ConfiForms to do for you?

[Sebastien Carriere]

Below is how the Description field appears:

*Request Submitter's Name:* Doe, John

*Request Submitter's Email:* John.Doe@ABCDE.com

*Problem / Opportunity Statement:* Upgrade feature for on-call agent.

*What is the total expected cost for this initiative?:* < $1,000

*Business Impact?:* None

What I need is to get the words between *Problem / Opportunity Statement:* and *What is the total expected cost for this initiative?:*.

In this example, I am looking to retrieve Upgrade feature for on-call agent. I need this to populate into a field in Confiform.

[Alex Medved _ConfiForms_]

Honestly, I dont know how to parse this, sorry

Alex

[Sebastien Carriere]

No worries at all. I wasn't sure if it was possible either.  Thank you,

[Alex Medved _ConfiForms_]

I dont see a pattern on how this can be parsed... does not look like a machine readable format to me

May be you can try with split function from ConfiForms... but still this might be way to difficult - https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

Another option could be the use of custom JavaScript function https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Field+Definition+Rules#ConfiFormsFieldDefinitionRules-RuncustomJavaScript to parse it to your needs

Alex

[Sebastien Carriere]

I will look into these. Thank you!