Run "External System Import" (CSV) automated from script

[christoph.ackermann@marquardt.com]

Hi

I am looking for a way to run the function that is available in:

System -> External System Import -> CSV

in an automated way.

Can anybody point me to a way how I can achieve this?

Thank you 

Christoph

[Petter Gonçalves]

Hello christoph.ackermann@marquardt.com

Thank you for reaching out.

To automate the execution of the CSV export automatically over a period of time you can either create your own script/app or use one of the existing apps in our Atlassian marketplace. Allow me to provide you with more details:

1. If you want to create your own Script, you can refer to the documentation below, using the source code used to send the request to the server under development tools of your browser:
   Atlassian server developer documentation 
2. For an existing solution, we have the app Better Excel Automation, which is a free app that allows you to schedule your CSV export to run periodically. Other apps with more functionalities and scripting options can be found in our Marketplace, as Scriptrunner and Power Scripts.

P.S: If you choose to create your own script and need further information about the code and integration with Jira, the best place to ask for help is our Atlassian Developer Community:

https://community.developer.atlassian.com/ 

The mentioned portal was specifically created for development questions, where you will find articles and suggestions from other third-party partners and Atlassian developers. Feel free to open a new topic about your question there! :)

Let us know if you have any questions.

[Michael Mohr]

Hi  @Petter Gonçalves , the question was if it is possible to automate the "External System Import" (CSV). But your answer is stating how to automate the execution of the CSV export. But that was not the question.

Up to now I did not find a function in Jira's Developer Community page, that you reference, that allows to call the "External System Import" (CSV) as function.

Could you please point me this function if it is available for import at all.

Background is that we have the need to keep two projects in different Jira instances exactly the same, including the issue key, what seems to be only possible with the "External System Import" (CSV) as you could update issues with this and also create new issues with a given issue-key.
These projects are used as kind of Master data for Customer Names and for reporting purposes the issue key of a customer need to be identically on both projects