---
title: "How to import data from external systems or databases"
canonical: "https://support.appfire.com/space/SUPPORT/89147857/How%20to%20import%20data%20from%20external%20systems%20or%20databases"
format: markdown
---
> Macro (toc)

The CLI can be used to import data into Jira from external systems either dynamically or as a one time load. Various techniques are available.

1. Scripting and executing various individual CLI actions depending on the data
2. Scripting to produce a run file of action then using the **run** action
3. Creating a CSV file from an external source with or without modifications using a script and then using **runFromCsv** action
4. Constructing one or more SQL statements and using **runFromSql** action

More information and examples are needed here! Until more documentation is available, see the [release notes](https://appfire.atlassian.net/wiki/display/ACLI/Release+notes+2.1#Releasenotes2.1-ImportJIRAissues)