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 

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 > 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

If an export file with the same name already exists, EmpowerHR adds a unique number to the end of the query name.  For example:

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 

To import a query:

  1. Go to Enquiries > 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. 
InformationTo avoid this issue, we recommend you always import any drill-down queries and union queries before importing the calling query.



Next topic

Show generated SQL



© 2023 Fusion5. All rights reserved.