Topics Import Tabular Report Search:  
Introduction: In PrognoCIS, the Import Tabular Report popup allows the import of tabular reports between different pool names.

Field Descriptions:

* Import URL: Enter the source URL through which the import of tabular reports is expected into the destination URL. This field is available in the form of a dropdown which saves the last three URLs for which the Reports list was generated. You can select any of the URLs from the suggestions. This must be a valid URL; otherwise, data is not generated. Clicking the adjacent Clear link removes the selected URL from the field.

* Password: Enter the Query Analyzer Update key for the current month. Example: If the Query Analyzer key for the month of Feb 2024 is 80009, then the update Password for Feb 2024 will be b1z80009.

Source Patch Number: This icon appears only after the list of reports has been generated from the source URL. Hovering over this icon displays the Patch Number of the source URL. If the Source Patch Number differs from the Destination Patch Number, a validation message prompts the user: "The Source Patch No and Destination Patch Number do not match. Do you want to continue with the Import?" The user can choose to continue or cancel the import by clicking OK or Cancel, respectively.

Go Button: Click the Go button to generate a list of Report Names and Report Codes available on the source URL.

Sel: Select the checkboxes for the reports in the list that are to be imported.


Figure: Reports selected on the Import Tabular Report popup

An alert is displayed if a report containing a Database Object (DBO) or View not present in the destination database is selected. This alert simplifies the report selection process and helps prevent crashes due to missing DBOs or Views. The following validations are shown:


Figure: Validation displayed when both DBO functions and View tables are not present in the source database


Figure: Validation displayed when both DBO functions are not present in the source database


Figure: Validation displayed when both View tables are not present in the source database

Report Name: Shows the names of the tabular reports in the source database.

Report Code: Shows the codes of the tabular reports in the source database.

Module: Shows the module of the tabular reports that are present. The modules that can be shown in this column are EMR and BILL.
Note: If the destination URL has the BILL module set to Off, only the EMR reports from the source URL are displayed in the list.

Report ID: Shows the unique Report ID of the tabular reports in the source database.

Action Button:

IMPORT Button: Click the IMPORT button after selecting reports in the Import Tabular Report popup.

The following scenarios are observed:
  • Only when the Report Code or Report Name is identified in the destination URL, a confirmation popup named Import Existing Reports appears. Report names and their Report IDs are listed in the popup. All reports are selected by default. You can uncheck any existing reports you do not wish to import from the Import Existing Reports popup. This popup has a confirmation message that asks "Reports found in (source url). Do you want to continue with the import?"
    1. Click "Cancel" to close the confirmation popup and redirect the user back to the Import Tabular Report popup to modify their selection.
    2. Click "OK", which triggers the Tabular Report - Import popup. The "CopyOf_" prefix is added to the report names in this popup that are already present in the destination URL.


    Figure: Confirmation popup when trying to import a Tabular Report already present on the destination URL

  • When the Report Code or Report Name is not present in the destination URL, the Tabular Report - Import popup is directly invoked without any confirmation message. For those reports that do not have a matching report in the destination URL, no prefix is added.
The Tabular Report - Import popup shows a summary of the import, including details such as Report ID, Report Name, and Import Status, with the Import Status column showing the "SUCCESS" or "FAILURE" status depending on whether the respective report was imported or not. You can click the hyperlinked Report ID to navigate to the Tabular Report Design Master screen of the specific report. Click the Close button of the Tabular Report - Import popup once you are done viewing the details to close the popup.


Figure: Tabular Report - Import popup


Note: The following details are not considered for import:
  • Report ID
  • Sequence No.
  • Last Modified User Details
  • Last Days
  • Last Period
  • Last From
  • Last Up To
  • Last DocID
  • Last TempID
  • Last Location Code
  • Last Business Code
  • Last Run Date
  • Run Count
  • EAT ID of Existing Tabular Report
  • User ID for Template Record
  • Temporary Record
  • Other Filters
  • Last selected DocIDs
See Also: Tabular Report Definition | Tabular Report | Tabular Report History