Automated Jira import from database

Exists a supported Jira import from a database that runs automatically and also imports custom fields?

What we have to do is the synchronisation of a ticket system with Jira. The ticket system is used by our customers (external communicatin) whereas Jira is used by our developers (internal communication). The external tickets have to be imported into Jira after creating and after closing they have to be exported. The ticket system provides the possibility to export and import the issue data in/from a database (possible would also be to export/import in/from a csv file).

4 answers

1 accepted

This widget could not be displayed.

JIRA Command Line Interface can help with part of this. Specifically, runFromSql or runFromCsv. You can use from your favorite job scheduler or better, use Bamboo with CLI Plugin for Bamboo.

This widget could not be displayed.

Yes. There's an "importers" plugin which allows you to import from various other systems via several routes. Jira can also import from CSV.

However, these are not suitable for what you're talking about. They are aimed at one-off imports, not regular updates (i.e. migrating off those systems and on to Jira is by far the main use-case for them), they're one way, and there's no functions to do them regularly (a human has to run them each time). There's also nothing for pushing the other way.

My instincts would be to say that you're going to need to code something and in two different ways.

1. For the updates into Jira, I'd try to get your other system to push the data in via REST. If that's not possible, then I'd be looking at your import-from-database solution next, using either Jelly scripts, a scripted service or even a whole plugin that does the work

2. For the push out, I'd be looking at writing a listener or post-function that picks up the specific changes to Jira issues that say "this needs to go to other system" and pushing them out.

This widget could not be displayed.

How can I create my own service?

I created a class that extends Abstract Service and implements the methods run and getObjectConfiguration. Then I added the *.jar file to WEB-INF/classes and/or WEB-INF/lib.

I tried to add a service, but the entry in 'class' is not found. What have I to enter in this field?

This widget could not be displayed.

were you able to automate it 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

121 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you