GNA – Report Criteria Editor

Report Criteria Editor

Overview

User designed Crystal Reports™ are generated from data obtained from the data source. In some instances user input requested by a prompt is required to filter the data, e.g. entering a date range, specifying a fiscal year, etc. In other instances the data must first be extracted and “pre-processed”. For these types of reports it is necessary to configure the preprocessing. This configuration is in the form of prompts for the user to enter required criteria.

 NOTE: Attempting to run reports without configuring required prompts will result in an error.

 

NOTE: Users of Crystal Reports will need to install the Crystal Reports 2013 runtime on the server hosting the application, and on each client computer. Refer to the Crystal Report Runtime section of the Govern Deploy EZ guide.for details.

Display the Report Criteria Editor

To display the Report Criteria Editor…

  1. In the GNA ribbon, select the System Parameters tab.
  2. Click the Report Parameters Editor icon.
  3. Select a report from the List of Reports column on the left hand side.
  4. In the Report Editor, click Report Criteria.

In the Report Criteria Editor, you are able to configure any required user prompts. See Adding one or more Criteria to a Report for details about adding prompts.

Report Criteria Editor Parameters

Report Criteria: The Report Criteria column displays the list of criteria that are associated with the report. When a criteria is selected, its parameters are displayed in the Report Criteria Editor.

Report Criteria Properties group

  • Prompt: Enter a name that will appear in the title bar of the user prompt. Table Selection: Select the table that data is being selected from using the drop-down menu.
  • Field Selection: In the drop-down menu, select the field within the table that is being selected.
  • User Validation Table: If the criteria has to be validated with a user validation table, select the table from the drop-down menu.
  • System Validation Table: If the selected criteria is to be validated with a system validation table, select one from the drop-down menu.
  • Ask for Range: Select Ask for Range to display a range prompt; e.g. entering a date range.

Adding Criteria to a Report

When linking reports to a profile, it may be necessary to customize the report to make it more interactive. This can include requesting that the user enter a date range to define the scope of the report. For example, we can include a report for an Audit Trail Inquiry, but we will need to specify the criterion that we want to user to enter.

To specify the criteria for a report…

  1. In GNA, click the System Parameters tab. Click the icon for the Report Parameters Editor.
  2. In the Report Editor, click to select a report from the List of Reports:
  3. By default the report has a criteria called Tax Map Number. For our report we would like to be able to search for a Last Name as well as a First Name.
  4. Click Report Criteria to display the Report Criteria Editor.
  5. In the Report Criteria Editor, click New to begin adding your criteria. Under the Prompt parameter, enter First Name.
  6. For Table Selection, select na_names.
  7. Under Field Selection, we are looking for the FIRST_NAME; we will not be using any user or system validation tables.
  8. Do not select the Ask for Range option because it is required for these parameters.
  9. Click Add to add the criteria to the Report Criteria list.
  10. Repeat the above steps to add a criteria called Last Name.

Change criteria appearance order

Should you want to change the order that the criteria are presented to the user on the form in Govern…

  1. Select the criteria under the Report Criteria list.
  2. Click Up or Down to move them.
  3. When complete, click Save.
  4. Click the Close button to return to the Report Editor.
  5. In Report Editor, click Save and exit from the form.

In Govern, you can preview your updated profiles. Reports are viewed under the Reports Explorer. The two (2) added criteria appear on the form. Users can now perform a search for specific first names and/or last names in addition to the tax map number.

See Also

Report Parameters Editor

 

 

103-sy-007

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

GNA – Report Editor

Report Editor

Overview

The Report Parameters Editor form is used to configure reports on an individual basis. These reports display query results found in the fields of tables within the data source.
Reports are given access through the default connection key. If required, they may also be configured using an alternate connection key. As long as the alternate connection key has been defined in the Connection Key Management form, it will be available in the Alternate Connection Key list. See Alternate Connection Key Properties group for details about alternate connection keys. In Release 6.0 of GNA, there is enhanced support for SQL Server Reporting Services (SSRS)™. SSRS reports and Crystal Reports™ are configured in the OpenForms General Settings form, see OpenForms™ General Settings for details.

Intelligent Scanning in Reports Editor

There is an underlying intelligence in the functioning of the Reports editor. Both SQL Server Reporting Service (SSRS) and Crystal Reports reports are read, and the data sources are scanned.
Connection options to the database are by default specified as the current connection. If required, secondary sources can be selected from a list of alternate Connection Keys. During the initial scanning phase, if a report is determined to be invalid, i.e. incompatible, a warning is displayed in the form of a window with a list of the offending reports.

NOTEWhen there is no backwards compatibility with a report, the default connection setting will be used.

Details of the Report Scanning Process
When the Report Editor is launched, each report that is selected from the List of Reports list is scanned. The report connection key is tested. When the system encounters either a Crystal Report or an SSRS report that is not associated with a Govern connection key, the system will ask to associate the report with…:

  • The current Connection Key (Default) OR
  • The user can see the path to the data source, and may select a connection key from the list of available Alternate Connection Keys.

During the “Database Verification” process…

After performing an update / general maintenance, or defining database connections, running the Database Verification process is recommended as it will update the database for access by Govern applications.When this process is run in GNA, during the Misc. Corrections phase a script performs the following:

  • Conversion of Alternate Connection Key information (i.e. server, database names, etc.) into the Connection Key in the new table.

The following four (4) fields will be set to NULL:

  • [DTSRC_SERVER]
  • [DTSRC_DBNAME]
  • [DTSRC_UID]
  • [DTSRC_PASSW]

Note: In the SY_REGISTRY screen, four key names were removed,

  • [DTSRC_SERVER]
  • [DTSRC_DBNAME]
  • [DTSRC_UID]

Record Set Key: This option provides the ability to run the report by dataset, e.g. current P_ID, current dataset, or database. In the drop down menu list, select the primary key that will be used by this report, otherwise the user will not be prompted to select a dataset for the report.

NOTEA Record Set Key should be specified.

The report dataset will be filtered with a list of values for the selected key.
Example: SELECT * FROM pc_parcel WHERE p_id = ‘123’ OR p_id = ‘456’ etc.

Report Criteria: Click Report Criteria (A) to display the editor. The Report Criteria Editor is used to configure prompts for reports that require user input. See Report Criteria Editor on page 85 for details on configuring prompts.

The report dataset will be filtered with a unique value for the selected keys.

For Example…
SELECT * FROM pc_parcel WHERE p_id = ‘123’

Criteria Key group

Add Criteria Key: Click Add Criteria Key to display the criteria key list; select one or more criteria to be added, click OK or Cancel.
Remove Criteria Key: Select a criteria key from the Criteria Key list and click Remove Criteria Key to remove it from the list.

Alternate Connection Key Properties group

Although database connection parameters are set in the Govern DeployEZ™, they can be overridden on a report by report basis. If required, each report can be configured with an alternate connection key.

NOTEAll settings made in this section override the current, default, connection key. Users should ensure that the alternate connection
key required has been entered in the Connection Key Management form. See The Connection Key Management form.

Data Source: This is the path to the server that the report will be accessing.
Alternate Connection Key: Select an alternate Connection Key from the list.

Report Group

This parameter contains the Report Grouping for the Report Explorer in Govern.
Upper/Lower Level: Select configure these parameters to indicate the location of the report in the Treeview pane in Govern.
For Example…
When the following report, Mass App.- Inventory Report is configured to appear in the following Report Group; Upper Level: List & Reports, and Lower Level: CAMA. In Govern, the report will appear in the List & Report upper folder (A) and CAMA lower folder (B):

See Also

Report Criteria Editor

 

 

103-sy-006

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

Reporting in OpenForms

Reporting in OpenForms

Version 6.0 and Version 6.1 (In Development)

Overview

The following page reviews General OpenForms reporting features and options specifications.
For additional information, see Standard Feature Reports in Govern (std-fea-013) and Report Editor and Report Criteria setup in Govern Administrator.

Specifications

The following standard features are available for reporting

  • Standard and Custom Reports Definitions
  • SAP Crystal Reports and Crystal Reports server are supported
  • Microsoft SQL Server Reporting Services are supported
  • Reports are setup by Profiles
  • Security can be setup by Profile User and Role
  • Run-Time parameters (required and not required) and selection criteria can be setup by report definition
  • User persistent run-time parameters by user (parameters and criteria entered are saved by user)
  • User defined output report formats
  • Reports can be executed automatically upon a batch definition execution (after batch process completion)
  • Reports can be scheduled using Govern Scheduler
  • Reports output format can be configured

Read More...

System Registry Parameters

Default paths and server information are stored in the system registry.

To access, in the GNA ribbon…

  1. Select Parameters (tab) > System Parameters (group) > General Settings Editors.
  2. In the OpenForms General Settings form, select Report from the Registry Filter combo-box.
  3. Locate the Section Name column.

Configurable paths related to reports are presented in this section of the registry.

NOTE: Errors will be displayed in the Report Editor if paths are not correctly defined.
  • Crystal Report

    • Custom and Standard report paths
  • Log File
    • Standard Log Path – N.B. specified at the report level
  • Report Parameters
  • SSRS configuration parameters, service and connection information

Report Definition Editor

There is an underlying intelligence in the functioning of the Reports editor.
When setting up a report, both SQL Server Reporting Service (SSRS) and Crystal Reports reports are read, and the data sources are scanned.
On run-time, connection key(s), parameters and predefined criteria are used to execute the report.
Multiple report definitions can be configured for the same report. Currently there are two (2) editors:

  • Crystal Report
  • DocX Reports

Crystal Report Definition Editor

The report definition contains:

  • Report Name
    • Physical report name selected from the standard or the custom report path
  • Audit Trail
  • Report Group – now linked to profiles
    • Upper Level
    • Lower Level
  • Recordset Key – that is to be used.
    • List of Govern IDs
  • Report Criteria
  • Criteria Key
    • User Selection Report Criteria Prompts that can be configured using any of the fields of tables used in the report
  • Alternate Connections Key
    • The deployment connection key is used when executing a report. In some cases, a secondary connection key can be provided
  • For detail information, see Report Editor and Report Criteria

Report Parameters

The following are standard report parameters

Parameter Name Value returned
Govern ID code Govern IDs (p_id, na_id, wm_id, etc.)
dept Ids.Dept
dept_label Vt_user WHERE tableName=’depart’ AND code=Ids.Dept
language Cuurent set language
year Ids.Year
rpt_county Sy_registry WHERE sectionName=‘general’ AND keyName-‘county’
rpt_date ‘ShortDate LongDate’ (as string)
rpt_default_date ‘ShortDate’
rpt_login Ids.User
rpt_logo

Path : ‘{RegistryVaue}ReportCompagnyLogo.bmp’

Registry Value is found in the User/System Regostry using those rules:

  • Try to get value from usr_registry WHERE sectionName=’govern’ AND keyName=’bitmap’
  • If no value found, fall back on sy_registry WHERE sectionName=’path’ AND keyName=’bitmap’
rpt_name Report Path
rpt_range Return, as string, all the filter dynamically applied on the Report
rpt_state Sy_registry WHERE sectionName=’general´AND keyName=’state’
rpt_title Report description (as set in GNA)
rpt_ub_max_variation Sy_Registry WHERE sectionName=ub parameters’ AND keyName=’Max Variation’
rpt_uid Ids.User
rpt_username OrganizationName set in GovernNetConfig.xml
uniform Sy_registry WHERE sectionName-‘work_text’ AND key_name=’Assessment Equalisation Rate’

 

Formulas for Crystal Reports

This section lists the recommended, general, read-only and conditional formulas to include when creating reports through Crystal Reports.

Recommended Formulas

Include the following formulas when you create Crystal Reports:

Formula Definition
@rpt_date (totext (currentdate)) Date & Time
@rpt_name Report Name
@rpt_Username Town or Company Name

General Formulas

Govern populates the following Crystal Reports formulas automatically, if they are included in your reports:

Formula Definition
@dept Department (code)
@dept_label Department label
@language Language
@rpt_county County
@rpt_default_date Default Date
@rpt_login User name
@rpt_range Range Text
@rpt_state State
@rpt_title Report Title
@rpt_uid User identification code (UserID)
@uniform Assessment Equalization Rate
@year Fiscal year in use by current user in Govern

 

Read-Only Formulas

The following Crystal Reports formulas are read-only; i.e., they must contain a non-blank value in the report. These formulas trigger specific actions or populate specific formulas:

Formula Action
@acbill Refreshes the AC_POST_MASTER table with the current Aircraft ID or the current Name ID (in duplicate bill printing).
@all_ar_needed_ac Populates the value of several formulas for the current NA_ID and for the all Tax sub-systems. See the Conditional Formulas section on this page.
@all_int
(under revision)
Updates the following fields in the AR_ SUMMARY table for all installments with positive balance, for all Taxation and Assessment sub-systems and for the current NA_ID. (All updated installment records within a sub-system will contain the same information).
LATE_CHARGES (Accrued Penalty or Interest)
CHARGE_DATE (Current date as defined in Govern)
BALANCE_AS_OF_DATE (Total balance due, exclusive of late charges)
@btbill Refreshes the BT_POST_MASTER table with the current Boat ID or the current Name ID (in duplicate bill printing).
@drilldown Enables Crystal Reports Drill Down feature
@govern_tx_interest
*This formula is used when calling a Web Crystal Report
Updates the LATE_CHARGES column in the AR_SUMMARY table.
Use when calling a Web Crystal Report in the Real Property Tax Subsystem.
@govern_ub_interest
*This formula is used when calling a Web Crystal Report
Updates the LATE_CHARGES column in the AR_SUMMARY table.
Use when calling a Web Crystal Report in the Utility Billing Subsystem.
@mv_ar_needed_ac Populates the value of several formulas for the current NA_ID and for the Motor Vehicle Excise Tax sub-system. See the Conditional Formulas section on this page.
@mvbill Refreshes the MV_POST_MASTER table with current Motor Vehicle ID or the current Name ID (in duplicate bill printing).
@mv_int Updates the following fields in the AR_ SUMMARY table with motor vehicle excise tax information, for all installments having a positive balance for the current MV_ID. (All updated installment records will contain the same information).
LATE_CHARGES (Accrued Penalty or Interest)
CHARGE_DATE (Current date as defined in Govern)
BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges.)
@pp_ar_needed Populates the value of several formulas for the current PP_ID and for the Personal Property Tax sub-system. See the Conditional Formulas section on this page.
@pp_ar_needed_ac Populates the value of several formulas for the current NA_ID and for the Personal Property Tax sub-system. See the Conditional Formulas section on this page.
@ppbill Refreshes the PP_POST_MASTER table with the current Personal Property ID or the current Name ID (in duplicate bill printing).
@pp_int Updates the following fields in the AR_ SUMMARY table, for the current PP_ID, with Personal Property Tax information, for all installments having a positive balance. (All updated installment records will contain the same information).
LATE_CHARGES (Accrued Penalty or Interest)
CHARGE_DATE (Current date as defined in Govern)
BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges)
@re_ar_needed Populates the value of several formulas for the current P_ID and for the Real Estate Tax sub-system. See the Conditional Formulas section on this page.
@re_ar_needed_ac Populates the value of several formulas for the current NA_ID and for the Real Estate Tax sub-system. See the Conditional Formulas section on this page.
@re_int Updates the following columns in the AR_SUMMARY table, for the current P_ID, with Real Estate Tax information, for all installments having a positive balance. (All updated installment records will contain the same information).
LATE_CHARGES (Accrued Penalty or Interest)
CHARGE_DATE (Current date as defined in Govern)
BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges)
@td_ar_needed Populates the value of several formulas for the current P_ID and for the Tax Deferral sub-system. See the Conditional Formulas section on this page.
@td_int Updates the following fields in the AR_SUMMARY table for all installments having a positive balance, with Tax Deferral information for the current P_ID. (All updated installment records will contain the same information).
LATE_CHARGES (Accrued Penalty or Interest)
CHARGE_DATE (Current date as defined in Govern)
BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges)
@tt_ar_needed Populates the value of several formulas for the current P_ID and for the Real Property Tax Title sub-system. See the Conditional Formulas section on this page.
@tt_int Updates the following fields in the AR_SUMMARY table, for the current P_ID, with Tax Title/Lien information, for all installments having a positive balance. (All updated installment records will contain the same information).
LATE_CHARGES (Accrued Penalty or Interest)
CHARGE_DATE (Current date as defined in Govern)
BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges)
@txbill Refreshes the TX_POST_MASTER table with the current Property ID or the current Name ID (in duplicate bill printing).

 

Conditional Formulas

The Crystal Reports formulas listed in this table are populated by Govern conditionally, on the presence of the following read-only formulas:

  • @all_ar_needed_ac
  • @mv_ar_needed_ac
  • @pp_ar_needed
  • @pp_ar_needed_ac
  • @re_ar_needed
  • @re_ar_needed_ac
  • @td_ar_needed
  • @tt_ar_needed

 

Formula Action
@ar_interest_1
@ar_interest_2
@ar_interest_3
@ar_interest_4
Calculates the interest and penalties committed for the current fiscal year and the specified installment.
@current_due Calculates the total balance due for the current fiscal year, including late charges.
@daily_interest Calculates the daily interest and penalties.
@prior_ar_fee_1
@prior_ar_fee_2
@prior_ar_fee_3
@prior_ar_fee_4
Calculates the demands, charges and fees committed for prior fiscal years and the specified installment.
@prior_ar_interest_1
@prior_ar_interest_2
@prior_ar_interest_3
@prior_ar_interest_4
Calculates the interest and penalties committed for the prior fiscal years and for the specified installment.
@prior_due Calculates the total balance due for the prior fiscal years, including late charges.

 

Tables/Fields and Naming Standards

Report File Name

  • Physical report name available in the standard or custom report path
  • Report File Name Maximum Length is 15
  • Recorded in VT_SYSTEM where table_name = REPORTS

Report Options

  • Standard report parameters that can be used in the report (ex: Department, City/Town Name, Report Title, etc.)
  • Recorded in VT_SYSTEM where table_name = RPT_OPT

Report Record Set Keys

  • Standard Govern IDs located in table VT_SYSTEM where table_name = BRULE

Report Definition

  • Report definitions are stored in table USR_REPORT_DEF
  • Table contains:
    • File Name (available in Standard or Custom report paths)
    • Audit Trail – deprecated
    • Record Key
    • LK_Brule

Batch Processing and Reports

Parameters defined for a batch process can be used by reports.

100-bp-reporting.png

Batch Process On Completion Report

It is possible to setup a report to be executed upon a batch process definition completion.

Batch Process to Schedule Reports

It is possible to setup a batch process definition to schedule reports.

Report Formats

You can specify the output format of a report that will be generated by a batch process. Verify with IT for the list of file formats allowed for the organization.

Batch Process Parameters

The parameters defined for the batch process can be accessed by the report.

 

Troubleshooting

  • A new installation pack for Crystal ReportTM is required to be installed on each client when upgrading to Release 1706.

 

What’s New

Related Topics

Additional Information related to Reporting

 

 

100-Reporting

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

Quick Search Index Group Editor

Quick Search Index Group Editor

Available in release 6.0.1804 and 6.1.1804

Overview

The Quick Search Index Group Editor will enable users to create groups of indexes that can be used with a Profile, or be made available as a Quick Search Definition in custom controls like generic links. When configuring, i.e. grouping the indexes that are required by users, a “boost” value can be specified for the indexes within a group. The boost value helps to control how the index search results are presented.

Configuration – Quick Search Index Group Editor

In order to create the required table and fields required, users must run the GNA Verify Database process. No additional configuration is required.

Read More...

Provide Access to the Quick Search Index Group Editor

Administrators that need to provide or restrict user access to the Quick Search Index Group Editor, can do so through the Govern Security Manager (GSM). In the GSM, under the left hand pane, locate the Quick Search Index Group Editor node. Refer to the GSM user guide for details about securing nodes.

Using the Quick Search Index Group Editor

In order to access to the Quick Search Index group Editor, in the GNA ribbon…

  1. Select Editors (tab) > Editors (group) > Dynamic Search Configuration > Quick Search Index Group Editor.

Creating a new Quick Search Index Group

When there are no existing search groups, opening the editor will, by default, create a blank form that is ready to be configured. To create a new group, click Create a new item. Parameters for new groups are validated; a code is required and the group must contain at least one index.
All available indexes will be displayed in the Available Indexes pane. Administrators will need to select the checkboxes beside the indexes that they want to include in the group.

Quick Search Index Group – Boost Factor

Upon selecting an index, the user will also be allowed to specify a “boost” value for the index. By default, the index will be assigned a boost factor value of 1. The boost factor influences how results from this index will appear in the Quick Search tab in Govern.
Search results from indexes with higher boost factors will be displayed before search results from indexes with lower boost factors. However, if the searched text string in index is a perfect match, and a partial match in index (B) search results from an index (A) with a lower boost factor may appear above another index (B) with a higher boost factor

Changing the Order of indexes within a group

Selected indexes can be re-positioned with a drag and drop action. The sequence number is displayed at the left of the index. The sequence number corresponds with the order it will appear in the Govern Quick Search pane. Click on the index text, and drag to the space between the indexes.

NOTE: Only selected indexes can be re-ordered.

Documentation

Click to here to the documentation for the Govern Quick Search for details.

Related Topics

Govern Search
Govern Quick Search
Quick Search Index Group Editor
Govern Search Technical Specifications

Saved Datasets
Dynamic Search Objects
Dynamic Search Styles
Dynamic Search Groups
Govern New Administration (GNA)

 

 

103-ED-022

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

Email Template Editor

GNA – Email Template Editor

Version 6.1 – In Development

Overview

The Email Message Template editor is designed for creating email message templates. These are the messages that can be used in Govern modules that offer an email functionality. For example, in the Workflow module, there is an email activity function that when triggered can send a notification email message to specific users or groups. The advantage of the Email Template Editor is the ability for users to use variables and Expressions to modify specific fields. When the email message is sent, it can also be configured to include a report.

Functionality

When created and configured in the OpenForms Designer, an email template can be launched from a form tab. In addition, the email template can be configured as an activity action in the Workflow module. When created and configured in the OpenForms Designer, an email template can be launched from a form tab. In addition the email template can be configured as an activity action in the Workflow module. In the GNA Email Template editor, there are sub tabs, one of which allows users to preset their email messages. The Recipients tab contains the list of predefined recipients of the email message. The TO field on the editor is a freeform field that allows the user to enter any email address. In addition you are able to add recipients from the list of Govern Users or Govern Roles as they appear under the Recipients tab.

Read More...

User Interface

As the purpose of the Email Editor is to create email message templates, the User Interface (UI) is not unlike a standard email message creation interface. The parameters that are specific to the editor are as follows:
To access the Email Template Editor in the GNA:

  1. Locate the GNA ribbon.
  2. On the GNA ribbon, click Editors (tab) > Editors (group) > Email Template Editor.

Email Template Editor – tabs icon

The Email Template tab icons will allow you to create a copy, i.e. duplicate an existing, save, or delete a template.

Create a New Template

Click to create a new template. When a new form is initialized, the Cancel Delete

Duplicate an existing Template

When an existing template is selected, a click on duplicate will create a copy of the template. All aspects of the template are duplicated, except the Code.

Save a Template

After creating a template form and completing any required parameters, click Save to save the form.

Delete a Template

To delete a current template, select the form from the list to make it current click; click Delete.

Cancel current changes

The Cancel Changes icon will only be displayed when a new template is being created, or a modification has been made to an existing one. Click to cancel restore any change made, or to exit from creating a new template.

Refresh

Use Refresh to update the settings of the Govern application, or changes affecting the database. For example when changes are made to a Profile, Menu, External Application, or Search objects.

Email Template (tab) – parameters

Code Name – When generating a new template, the code parameter will not be populated. After the save action, the field will be populated with the Code and the English long description.
Code – Enter a code name. (15 char. Max.)
English Short description – Enter a short description to be displayed for fast data entry, or look-ups where space is limited on the forms.
English Long description – The content in this field is displayed on look-ups, forms, and reports. This content is displayed with the Code to provide a code name that appears list of available codes on the left hand side (LHS).

About the Parameters Expressions field

Some parameters such as the “To” field, although hardcoded, can be overwritten with a query that will allow you to list all, or specific users, within the organization.
Parameters Expression – The Parameter Expression field, users can define Expressions containing variables for all the fields that you would like to make available in your template. Variables can be used in the Subject, the Body, and the parameters for the Report.

NOTE: You cannot type directly into this field, but rather click the ellipsis button […] on the right-hand side (RHS) of the field to access the Govern Expression Selector.

Ex.: In the following example of an expression, To, Name, Amount, and Address, are all variables that will be available in the template.
{
To=’csavage@happyville.com’;
Name=’Dr. Clark Savage Jr.’;
Amount=Format(2500, ‘c’);
Address= 350 5th Ave, Suite 86, New York, NY 10118, USA’
}

From – The “From” field is completed by the user; a value should be entered as a default.
To – In the “To” field you can enter a variable that will auto-complete when it is entered, e.g. @To
Subject – Enter the subject of the email message.

Email Template Editor – Message sub-tab parameters

Messages that are intended for the body section of an email message are composed here. As with the “From” and “To” fields, variables can be introduced. Click to select the Messages tab.
Ex.: The following example is a body message, containing variables for the template.
Dear @Name
The amount of @Amount has been outstanding for more than 90 days. If this amount is not settled soonest, it will lead to receivership proceedings. Please don’t make us angry, you wouldn’t like us when we’re angry. Make the arrangements to settle this amount within 15 days of receiving this message, OR ELSE.
Have an Average Day! 😐
Happy Ville Receivers Office

TIP: When working with the Expression Selector, and you start to define a constant, i.e. “@”, a floating list of system constants and Govern ID’s are displayed for selection. Constants that appear in this list can be added through the GNA Constant Value Editor.

From – The “From” field is completed by the user; a value should be entered as a default.
To – In the “To” field you can enter a variable that will auto-complete when it is entered, e.g. @To
Subject – Enter the subject of the email message.

NOTE: Parameters that are used in the message, and for the To and From fields are defined in the Parameters Expression field.

Email Template Editor – Message sub-tab parameters

Messages that are intended for the body section of an email message are composed here. As with the “From” and “To” fields, variables can be introduced. Click to select the Messages tab.
Ex.: The following example is a body message, containing variables for the template.
Dear @Name
The amount of @Amount has been outstanding for more than 90 days. If this amount is not settled soonest, it will lead to receivership proceedings. Please don’t make us angry, you wouldn’t like us when we’re angry. Make the arrangements to settle this amount within 15 days of receiving this message, OR ELSE.
Have an Average Day!
Happy Ville Receivers Office
The content of the Message field is maintained as Rich Text Format (RTF). It supports text formatting and embedded URL links, but it does not support images. In addition the system spell checker is active at all times; as is standard for spellcheckers, unknown words will be underlined with a jagged red line.
NOTE: Text can be pre-formatted in a word processing application like MS Word, but issues may arise when the text is copies and pasted into the message field. Attempts to re-format the text may be inconsistent. When possible restrict formatting to the message sub-tab parameter. Avoid copying blocks of text with images embedded.

Email Template Editor – Recipients sub-tab parameters

While the To field on the editor is a free-form field that can allow the user to enter any email address, the Recipients tab contains the list of predefined recipients of the email message. Through the Recipients tab, users are allowed to add recipients from the list of Govern Users or Govern Roles. Refer to the 103-ed-017 Email Template Editor – Send to Internal User option document for details on this feature. Note that when a Role is referenced but no longer exists in the system, an error will be displayed. Any emails that were not successfully sent will be logged by the system.
Under the Recipients tab is a split pane user interface. The two panes are titled Available, and Selected. They allow users to monitor the addition or removal of recipients. Under the Available list are the users that can be added as recipients of the email message.

TIP: Below the sub-tabs section is the Used In grid with the arrowhead to collapse the section. If the grid is visible, click the arrowhead to collapse the grid, and create more space for the split pane interface.

Adding Users or Roles as recipients

To select and add a user from the list…

  1. 1. Under the Available grid, click to select a user.
  2. 2. Click [>>] to add the selection to the Available column

OR

  1. 3. A double click on the required selection in the column will also add the selection.

Names Users or Roles that have been added to the Selected column are removed from the Available column.

NOTE: Multiple users can be selected with an extended selection using the Shift or Ctrl keys. Use the Shift key to make multiple selections that are contiguous, use the Ctrl key to make multiple random selections.

Preselecting one or more recipients
To preselect one or more recipients, i.e. add them to the To field in the email, after adding them to the Selected column, enable the checkbox beside their name.

Impact of Preselecting a Recipient

The impact of this option is seen if the user generating the email message does not have the security rights to access the To field. This situation arises when the Send Email action is configured as an Action button. Without access, a user will not be able to add remove recipients. This security option is available during configuration in the OpenForms Designer (OFD).

Email Template Editor – Reports sub-tab parameters

The Reports tab is composed of two (2) scroll-able grids that display the list of reports that have been configured with the email message template, Reports grid (top), and a lower Used In grid, that lists the locations where the template is used. These grids can be sorted in ascending or descending order by column heading.
When the email message is to be accompanied by a report, click to select the Reports tab. One or more reports can be added to the email message through the Reports grid.

Reports grid

Attach a Report to the Email Message

When configuring reports with the email template, some reports may require entry of variables that are required for the report to function. These variable can be set by writing an expression with the variable, and entering it in the Parameters Expression field in the form. See //Parameters Expression// field for details about entering expressions.
To attach a report…

  1. On the Reports tab, click [ + ].
  2. A blank field is inserted at the top of the grid. Note that when there is a pre-existing list, the new field will always be inserted at the top.
  3. Under the Report Name column, click in the field to display the combo box. Click to select one of the available reports.
  4. The column beside the Report Name is the Output column, click to display the combo-box for a list the output formats that the report will be sent in.
  5. Select an output format.
  6. Click Save on the main Email Template tab to save any changes.
NOTE: Multiple reports, in multiple formats, can be appended to the list. When specific reports are not available, ensure that you have access rights to them. The Output formats listed under the Output column are a function of either Crystal Reports. The report in the selected format will then be attached to the email message.

 

DEV NOTE: When configuring the Email action with reports that require user prompts, ensure that an expression has been configured to address them. If not these prompts will generate an error in Govern that will prevent the email from launching.

Deleting a Report from the List

To delete a report from the list…

  1. On the grid, click to select the report that you would like to remove.
  2. On the Reports tab, click [ – ].
  3. Click Save on the main Email Template tab to save any changes.

Used In grid

The collapsible Used In grid will list all locations that the currently selected email template has been used in.

NOTE: The Used In grid can be collapsed or expanded to conserve screen space.

Configuring an Email Action

When email templates have been defined they can be configured as an Action both at the Step level, and at the Activity level. The same parameters that appear in the template are present in the action, i.e. Delay and Override options.

To configure a Step Action…

In the Govern New Administration (GNA)…

  1. Open the GNA Workflow Department form.
  2. Select the Types tab.
  3. Choose a type that will be configured with an action.
  4. Click Steps on the Types tab.
  5. Select the activity step that requires the action.
  6. Click [ + ] to add the action.
  7. In the Add a new action modal window, configure the action.

When the activity step is initialized, the action will be performed based upon the step configuration.

To configure an Activity Action…

In the Govern New Administration (GNA)…

  1. Open the GNA Workflow Department form.
  2. Select the Activities tab.
  3. Locate an existing activity, or create a new one.
  4. On the right hand side (RHS) click [ + ] on the Actions tab to create a new action.
  5. Configure the form as a standard action; at the Action option, select the Send eMail action.
  6. Choose one of the existing templates.
  7. Save the configuration.

The action will be performed based upon the trigger that was configured for it, e.g. Initiation, or one of the Completion statuses.

Configuration of the Action Button

OpenForms Designer (OFD)

An Email Template can be configured as a standard Action Button, i.e. useable in most modules, and can be launched from a form tab in the profile. Configuration is through the OFD.

NOTE: The Email Action button cannot be added to the tab of a custom entity.

For configuration instructions for the action button, refer to Workflow Management Action – Generate Email on the Wiki.

Presentation in Govern

Action Button

When configured as an action button in Govern, the Send Email button is presented in the tab, e.g. Building Permit profile. When it is launched, it will display the Send Email window. Users are able to edit email messages based upon the permissions that were we configured, e.g. Delay Delivery, overrides for the To, Subject, and Body. Under the Attachments tab, you will see any associated reports that were configured to be sent with the email message, and the size. Once the email has been reviewed, the user is able to send or cancel the message.

Activity Step Action

The behavior in Govern for the Activity Step action is the same as when the email message is launched from an action button. When an action step to generate an email message is encountered, the Send Email window is displayed for the user. Users will be able to edit email messages based upon the permissions that were we configured, e.g. Delay Delivery, overrides for the To, Subject, and Body. Under the Attachments tab, you will see any associated reports that were configured to be sent with the email message, and the size. Once the email has been reviewed, the user is able to send or cancel the message.

Documentation

Click below to access or download documentation for this editor.
103-ed-017_GNA_Email_Template_Editor.pdf

Click below to access or download documentation for the Linked Names option.
103-ed-019_Email_Template_Editor-Send_to_Internal_User_option.pdf

NOTE: At a later point, both of the documents located above will be combined.

See Also

 

 

103-ED-017

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

 

GNA – Mobile Configuration Editor

Mobile Configuration Editor

Overview

The Mobile Configuration editor allows administrators of the mGovern Mobile Solution to control aspects of the subset database that is generated for their mobile deployment. The Initialize Mobile Database process is used to create a subset of the main source database. Copies of system resources, i.e. reports, tables, views, and so on are also copied. In addition, general and selected module parameters and tables for given years are created. This process is executed at the initial setup of the Mobile device, or when changes occur in the source database. The Mobile Configuration Editor offers an interface for administrators to manage the tables, views, and functions that are transferred during the initialization process, or the refresh/update process.

Functionality

The Mobile Configuration editor is the user interface for the The Database Objects Exclusion, and the Add and Update User Tables features. This point and click interface simplifies the manual inclusion and exclusion process. For this interface, the following tables were implemented:

  • SY_MOBILE_DB_OBJ_EXCLUSION – This table will contain all object names that should be excluded during the GNA Initialize Mobile Database process.
  • SY_MOBILE_TABLE
  • SY_MOBILE_COLUMN

For more information on manually excluding objects, or adding and updating user table, see the following:

 

User Interface (UI)

The Mobile Configuration User Interface is a grid that allows for the selective exclusion of required database objects in the Mobile deployment database. The grid of the UI displays all system Tables, Views, and Functions. Each Table/View/Function is displayed as a line item in the grid. The database objects that are available for selection are accessed by selecting either the Table, Views, or Functions tab.

Mobile Configuration – Command Buttons

Save – After make selections, click Save to save you changes.
Cancel – Click Cancel [x] to cancel any changes made to the line items, i.e. objects in the grid.

Mobile Configuration grid – Column Headings

Each Table/View/Function is displayed as a line item in the grid.
Name – This column displays the system name of the Table/View/Function.
System – A checkbox is displayed in this column which corresponds to each Table/View/Function.

NOTE: Check boxes under the System column cannot be selected, if not previously selected, or deselected, if previously selected. These are System objects that are not accessible to users.

Exclude from Initialize Mobile Database

In the column heading there is a check box that will allow the selection of all objects in the grid. When the check box beside the line item under this column is selected, the database object on the line will be excluded from the Initialize Mobile Database process.
After selecting or deselecting the database objects, Tables/Views/Functions, required, click Save on the Mobile Configuration tab.

See Also

Initialize Mobile Database
Govern Mobile Technology

Govern Administrator (GNA) System Product Map

 

 

103-ed-020

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

GNA – Data Mapping Editor

Data Mapping Editor

Overview

When an external application, e.g. a GIS application, is required to communicate with the Govern system, it will need to understand how data is stored within the system. Govern’s Web service methods accept requests, to Retrieve, Update, or Delete data.
The Data Mapping Editor allows users to map specific tables and columns within the Govern database to unique Data Element Names. When the application makes a request from Govern, the data element names must be included in the methods that are sent to the Web services.
There are specific rules that are required when making a request to the Web Service, e.g. the Data Element Name of the data map must exist, or the parcel ID requested must exist in the database, etc. Refer to the MS Govern Property Control System Service API guide for the list of methods and file structure details.
There are three (3) tables in the Property Control section that can currently be updated, (Table: PC_AREA, PC_PARCEL, and PC_LEGAL_INFO).

To access the Data Mapping Editor…

  1. In GNA select Setups/Editors > Editors > Data Mapping Editor…

Read More...

Data Mapping Editor buttons

New – To create a new data mapping record click New.
Cancel – Use Cancel to cancel the creation of an new entry. The Cancel button replaces the New button a save of the entry is made.
Save – Click Save to save a new record or any changes to an existing record. New records will appear under the List of Data Mappings column on the left hand side of the editor.
Delete – After selecting an existing mapping record from the List of Data Mappings list on the left hand column, click Delete to delete the record.

Data Mapping Editor parameters

Choosing Data Element Names – The names that are used for Data Elements must ensure that no Special Characters or Reserved Keywords are used. Refer to Govern Keywords for a list of keywords that should not be used.

Oracle Users and Data Element Names

Due to the case sensitivity of table names, a convention of all Uppercase or all Lowercase names should be decided upon. Do not use any Oracle Keywords for Data Element Names.

Data Element Name

Specify a Data Element Name for the mapping record. This is a unique name that must be included in the request from the external application to the Web service.

NOTE: This field has a maximum of 15 characters; no special characters or spaces are allowed.

Enter a descriptive name for the mapping record that will be used in the following parameters:

English Short Description – Enter a short description for the mapping record. This is useful for fast data entry and look-ups if space is limited on the forms.
English Long Description – Enter a long description for the mapping record. This will be displayed for look-ups on forms and is normally used for reporting.

Second Language Fields

When there is a 2nd language, or multiple languages, ensure that these description fields are also completed; i.e. French Short Description, and French Long Description.
Table Name – From the drop down menu, select the name of the Govern table that the data will be mapped to. Available tables are:

  • PC_LEGAL_INFO
  • PC_AREA
  • PC_PARCEL

Column Name – The table columns that are listed are filtered according to the table that is selected in the Table Name parameter.

Creating a Data Map record

To create a data map record, use a Data Element Name that will be acceptable to the requesting external application. This name will be used in the method that will be sent to the Web service.

  1. On the GNA ribbon, select Editors (tab) > Data Mapping Editor…
  2. Click New in the Data Mapping Editor.
  3. Locate the parameter called Data Element Name; enter the Data Element Name.
  4. If not expanded click the expansion arrow (A) to display the additional parameters in the form; complete the parameters.
  5. Select a table from the Table Name drop down menu.
  6. Choose a column name within the table that was selected.
  7. Click Save to save the mapping record to database.

When the external application makes a request to the web service, if the Data Element Name is in the method, the data will be retrieved, updated or deleted from the Govern database.
Testing a Web Service Request

As an example, we want to make a request that will obtain the tax map and the zoning information of the following Parcel ID’s, 16800, 16804, and 16807. This can be done in three (3) steps.

STEP 1 – Create the data mapping records

It is necessary to create the data mapping records for the elements that will be called in the method structure. For our example we will be using the pcTaxMap and areaZoning elements.

  1. On the GNA ribbon, select Editors (tab) > Data Mapping Editor…
  2. Click New, to create a new Data Mapping Record.
  3. Enter a Data Element Name of pcTaxMap.
  4. Click to expand the fields and enter an English Short and Long Description; enter PC Tax Map as a description.
  5. The tax map information will be coming from is the PC_AREA table in the ZONING column; select PC_PARCEL for the Table Name, and TAX_MAP for the Column Name.
  6. Click Save to save your mapping record.

Repeat the above steps to create the areaZoning data element. Use PC Area Zone as the description. The Table Name and Column Name are PC_AREA and ZONING

STEP 2 – Create the XML request structure

Refer to the Service Contract section of the MS Govern Property Control System Service API guide; this will provide you with the expected structure of the MSGovern_GetElementValue function. From the guide we obtain the following information:

Function MSGovern_GetElementValue (
ByVal strXmlElement As String ) As String
The retrieve elements must in structure of xml:
<?xml version=”1.0″ encoding=”utf-8″?>
<getElementValue>
<ParcelIds>
<ParcelId value=”16800″/>
<ParcelId value=”16807″/>
<ParcelId value=”23452″/>
</ParcelIds>
<ElementItems>
<ElementItem name=”areaZoning”/>
<ElementItem name=” areaSchDist “/>
</ElementItems>
</getElementValue>

For our example we will use the following…

<?xml version=”1.0″ encoding=”utf-8″?>
<getElementValue>
<ParcelIds>
<ParcelId value=”16800″/>
<ParcelId value=”16804″/>
<ParcelId value=”16807″/>
</ParcelIds>
<ElementItems>
<ElementItem name=”pcTaxMap”/>
<ElementItem name=”areaZoning”/>
</ElementItems>
</getElementValue>

The Parcel ID’s that we are requesting are specified within the <ParcelIds> tags. our Element Items are specified within the <ElementItems> tags. Note that the names are identical to what was specified in GNA in STEP 1 above.

NOTE: Verify that the XML structure is identical to specifications in the MS Govern Property Control System Service API document.

Always ensure that the Element Item name is identical to the one created in GNA.

STEP 3 – Validate the XML request with the Test Client

Locate the WcfTestClient.exe application that is included with the WCF PC Web Services package. This program is usually located in a folder called Test Application. Refer to the MS Govern Property Control Service Setup and Configuration guide for details about using the test application.

  1. Start the test application; add the WCF Service.
  2. On the left hand side, under the list of available methods in the service, locate the MSGovern_GetElementValue() method.
  3. Double click on the method to load it in the Test Client.
NOTE: A limitation of the supplied test client is that Return characters and Line feeds are not recognized. These characters must be manually removed in the editor.

As an example, the following formatting will become a single line when the returns and line feeds are removed.

<?xml version=”1.0″ encoding=”utf-8″?>
<getElementValue>
<ParcelIds>
<ParcelId value=”16800″/>
<ParcelId value=”16804″/>
<ParcelId value=”16807″/>
</ParcelIds>
<ElementItems>
<ElementItem name=”pcTaxMap”/>
<ElementItem name=”areaZoning”/>
</ElementItems>
</getElementValue>

becomes…

<?xml version=”1.0″ encoding=”utf-8″?><getElementValue><ParcelIds><ParcelId value=”16800″/><ParcelId value=”16804″/><ParcelId value=”16807″/></ParcelIds><ElementItems><ElementItem name=”pcTaxMap”/><ElementItem name=”areaZoning”/></ElementItems></getElementValue>

The above is only a charateristic of this test client; other clients may differ in behavior.

4. Copy the single line version of your XML code and paste it into the Value field in the Test Client.
5. Click Invoke; any errors will be displayed in a dialog box.
6. When the action is successful, a response is displayed in the Response pane of the Test Client.

Viewing the Results

In the Test Client, the request and response parameters can be displayed in two (2) modes, Formatted, and XML. You can switch between the two views with a click on the corresponding tabs along the bottom of the Request pane. When you are in XML mode results from the successful requests to the Service can be observed.

 

 

103-ED-011

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...