---
title: "Export/import a query"
id: "export-import-a-query"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/export-import-a-query"
updated: 2026-10-19T00:54:09Z
---

# Export/import a query

EmpowerHR offers the following options:

* Export Query - available when you select an individual query
* Import Query - available to use at any time (however, EmpowerHR warns you if the query is active)

## Export a query![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png) 

EmpowerHR automatically generates the name of a query export:

* using the alphanumeric characters of the query name
* stripping out special characters
* replacing spaces with underscores

For example:

| **Query name** | **Export file name** |
| --- | --- |
| Sample Percentage of Employee Chart’s !@#$% | Sample\_Percentage\_of\_Employee\_Charts.qmx |

To export a query:

1. Go to **Enquiries**&gt; **Query Manager**.
2. In the **Catalogue** panel, select the individual query you want to export.
3. Click **Tools**,****and then select **Export Query** from the menu.
4. At the **Select the Query File to Export to** screen, enter the **File name** for the exported query file.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | If an export file with the same name already exists, EmpowerHR adds a unique number to the end of the query name. For example:<br><br>Sample\_Percentage\_of\_Employee\_Charts\_1183368332.qmx |
| --- | --- |

1. Click **Open**.
2. EmpowerHR confirms the export, displaying the message,**Query successfully exported to...** with the directory pathname and filename of the exported query.

## Import a query![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png) 

To import a query:

1. Go to **Enquiries**&gt; **Query Manager**.
2. Click **Tools**,****and then select **Import Query** from the menu.
3. At the **Query File to Import** screen, browse to, and select, the query export file you want to import.
4. Click **Open**. EmpowerHR displays the **Query Manager Import**  **** screen, with the import details.
5. At **Details of Query for Import**, make any changes to the fields you want EmpowerHR to apply during the import. If the **Folder Category** or **Folder Sub-Category** is not valid for the import, EmpowerHR prompts you to select a different category/sub-category.

## Troubleshooting query import warnings

Here's what to do when EmpowerHR encounters a problem during the query import process and displays a warning message.

### Unique query number, different query name

The unique query number exists and the query has a different name.

When EmpowerHR prompts you about this issue, if you:

* want to overwrite the existing query, adopting the different name, then click **OK**. EmpowerHR completes the import.
* don't want to overwrite the existing query, then click **Cancel**. When EmpowerHR prompts, if you want to:
    * import the query as a new query, allocating a new query number, then click **OK**. EmpowerHR completes the import.
    * terminate the import process, click **Cancel**, and then at the **Details of Query for Import screen**, click **Cancel**.

### Creation date or last changed date is earlier than existing query

The imported query has a creation date or last changed date that is earlier than the existing query.

When EmpowerHR prompts you about this issue, if you want to:

* overwrite the existing query, then click **OK**. EmpowerHR completes the import.
* terminate the import process, then click **Cancel**. Check whether you need to retain any changes to the existing query.

### Drill-down queries do not exist or refer to different query

Drill-down queries related to the query you are importing do not already exist, or else refer to a different query altogether.

When EmpowerHR prompts you about this issue, if you want to:

* remove the drill-down link and go ahead with the import, then click **OK**. EmpowerHR completes the import.
* terminate the import process, then click **Cancel**.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | To avoid this issue, we recommend you always import any drill-down queries and union queries *before* importing the calling query. |
| --- | --- |

| Next topic<br><br>[Show generated SQL](/articles/ehr-user-guide/show-generated-sql) |
| --- |

© 2023 Fusion5. All rights reserved.