1
0
-1

Hi everyone!


Our company is migrating from Jira server to Jira cloud. My question is that we woud like to migrate the in progress issues as well but also would like to keep them in synced.


My use case is the following right now: We have a zendesk instance for our customer support requests and it is synced to Jira server using exalate. But we are moving to Jira cloud. How can we be able to configure exalate to remember the connections from the server? 


I know that there is a bulk connect button but where can I get the list of issues that are under synced and with which issue(I tried already the support zip, but no luck (smile) )?

    CommentAdd your comment...

    1 answer

    1.  
      3
      2
      1

      The steps to follow are (on high level)


      • Setup the connection between zendesk and Jira cloud - make sure that all is working as expected
      • Download the twins using following sql query on the Jira database

        Postgres Query to extract the twins
        SELECT LR."ISSUE_URN" AS local_issue, RR."ISSUE_URN" AS remote_issue
        FROM "AO_08F1AF_TWIN_TRACE" TT
        LEFT JOIN "AO_08F1AF_REPLICA" LR ON TT."LOCAL_REPLICA_ID" = LR."ID"
        LEFT JOIN "AO_08F1AF_REPLICA" RR ON TT."REMOTE_REPLICA_ID" = RR."ID"
        JOIN "AO_08F1AF_RELATION" R ON TT."RELATION_ID" = R."ID"
        WHERE R."NAME" IN ('Connection Name');


        The sql will need to be adapted if Jira is using another database type (mssql, mysql, oracle ...).  Replace 'connection name' with the name of the connection ...

      • Use bulk connect to restore the connection



      1. Sándor Jankovics

        Thanks, this sql really saved a lot of work (smile)

      2. Sándor Jankovics

        After the bulk import will exalate know that it is not the firstsync? 


        In our use case: We only allow to modify the description and summary on the first sync therefore in the code we use:


        if(firstSync){
        	issue.summary=replica.summary
        }

        Is it going to be able to not fall into the 'if'?

      3. Francis Martens (Exalate)

        The firstSync is false if there is a twin registered for that (local) issue and that connection.
        The proof is in the pudding (smile)

      CommentAdd your comment...