Need Integration between Jira and Smartsheet without Using Smartsheet connector

[Asha Goyal]

Hello, 

Is there any way to have one way syncronization between Jira Cloud and Smartsheet? I don't want to use the Smartsheet Connector as it seems to be too expensive for our use case. 

Any help would be appreciated.

Thanks

[Ravi Varma]

Hi @Jon,

Get the 40 sub tasks data as CSV file with two fields (IssueKey, LoadNumber)

Refer the below image:

Import the CSV file into JIRA. Refer the Atlassian documentation - https://confluence.atlassian.com/adminjiracloud/importing-data-from-csv-776636762.html

Once, the CSV file is imported, all the 40 sub tasks will have the Load Number field value updated, based  on the data provided in the CSV file

Regards,

Ravi Varma

[Jon]

hi Ravi, 

Since im importing so many fields is there any way to get around having to use the issuekey and/or summary key? 

[Jon]

hi ravi, another question on this. 

im trying to import the data to subtasks only  but when I try to put the summary or issuekey on the cvs it populates on the parent issue too. then I saw this comment. 

Sub-tasks

To import issues as sub-tasks define the column mapping for: Issue Id, Parent Id and Issue Type

How would I change my CSV file to accommodate this? Then same question as above, do I need to have the Summary and IssueKey on the CVS when doing this? 

[Ravi Varma]

Hi @Jon,

• Once the issues are created, you can specify the Issue->Sub task relationship between them using the IssueId and ParentId and import the CSV file.
• The issues and sub tasks are identified by IssueKey. In a single CSV file, you can add all those 40 sub tasks and their custom fields with appropriate values. When we import the CSV file, all the issues/sub tasks mentioned in the CSV file will be updated in a single stretch.

Regards,

Ravi Varma