MA – M&S Valuation Setting Editor (103-ed-025)

Valuation Setting Editor (Marshall & Swift MVP Interface)

Available in release 6.1.2211 – (In Development)

Overview

Marshall & Swift (M&S) is a cost-based appraisal methodology intended to value buildings and non-buildings improvements using the reconstruction cost method. It comes with two different valuation approaches, one for residential properties and one for commercial ones. This appraisal method is rarely used to produce final values but often used to provide a comparison point with other value types such as comparable sales or market values (MRA). The Marshall & Swift Valuation Platform Online (MSVPO) integrates with Computer Assisted Mass Appraisal (CAMA) systems via web services hosted by CoreLogic®.

Purpose

In Govern for Windows, M&S was offered as a special set of configurations within the Building Structural Element (BSE) function. An interface was developed to periodically load M&S valuation tables within the Govern BSE tables from the M&S database tables.

A different approach has been taken with OpenForms v6.1. In OpenForms, a new M&S API was developed to support the MSVPO interface for both residential and commercial valuations.

M&S In Govern

New admin parameters have been created as well as new database table structures that are specific to M&S. An internal API or data exchange tool will be needed for each Harris Govern product line to read/write the data from/to our product specific format (either in the legacy improvement tables or in new ones).

With the implementation of the new MSVPO API, a conversion tool has been created to convert the legacy M&S data into the new format.

The CoreLogic MSVPO API has been developed by CoreLogic as a public facing Web Service. This MSVPO service has been leveraged for Govern development.

The system defaults are by year and valuation types. As the M&S tables determine the type of computation, residential or commercial, the interface offers two entries, one for the Residential valuation method and one for the Commercial valuation method.

Valuation Settings Editor User Interface (UI)

The Valuation Setting Editor interface is located in the Govern New Administration (GNA)

To access the UI in GNA…

  1. On the GNA ribbon click Editors (tab) > Valuation Settings Editor
  2. The Valuation Settings editor will be displayed.

<–>

Valuation Settings Editor Setup Parameters

Valuation Settings Form – tab buttons

New – Click New to create a new Valuation Setting record.

Save – After completing the required parameters, click Save to save your Valuation Settings.

Delete – Click Delete to delete the currently selected valuation settings record

Refresh – To update the settings in the form with those of the M&S Valuation tables, click Refresh.

Valuation Settings Form – parameters

Description – Enter a descriptive name for the new valuation settings record.

Commercial / Residential – These options refer to the valuation method; select which type of table will be obtained from the M&S tables, e.g., Commercial or Residential.

Years – This column lists the valuation type and corresponding year that are available.

Year – This field that will indicate the year of the currently selected record.

Residence Type – This optional parameter is a drop-down menu that displays the residence types available in the Marshall & Swift (M&S) tables.

NOTE: This parameter is disabled when the valuation method selected is Commercial.

Default Style – When a Residence Type is selected, all possible styles will be displayed.

NOTE: This parameter is disabled when the valuation method selected is Commercial.

Valuation Date – All valid valuation dates will be displayed in this drop-down menu

Base Date – Select a Base Date from the date picker; this is a value that is less than or equal to the Valuation Date. The default is the Valuation Date.

Multipliers (group)

The local multiplier adjusts the calculated costs to the location of the building. Commercial Estimator automatically uses a local multiplier based on the ZIP or Postal Code entered on the General Information screen.

Local Multiplier – Enter a value to set the Local Multiplier; this parameter accepts values between 0.10 and 3.00.

Local Multiplier Adjustment Percentage – The Local Multiplier Adjustment is used to increase or decrease costs for unusual situations, such as remote locations, resort locations, shortages, surpluses, and so on. Enter a positive or negative percentage to increase or decrease the local multiplier. Accepted values are -50.00 to 200.00

Regional Multiplier – Accepted values for this parameter are 0.10 to 3.00.

NOTE: This parameter is disabled when the valuation method selected is Commercial or when the Regional Multiplier parameter is not set.

Manufactured Home Mult. Type (group)

Manufactured homes are residential structures built on steel undercarriages with necessary wheel assemblies to transport them to permanent or semi-permanent sites.

Use Regional Multiplier / Use Local Multiplier – Select either Use Regional Multiplier or Use Local Multiplier.

NOTE: This parameter is disabled when the valuation method selected is Commercial.

Effective Age Adjustment Value – When entering an Effective Age Adjustment Value, accepted values are 020.

Rounding Value – Accepted Rounding Values are 01000000.

Architect Fee Percent – Valid values for the Architect Fee Percentage is 0.00100.00.

Depreciation Percent Adjustment Value – Refer to MPV Commercial 2.1.3 & 8.6.3 and MPV Residential 2.1.4 & 7.8.3 for more information.

US Localization Type (group)

Select one of the available three (3) options, 3-digit only, 5-digit only, or 5-digit or 3-digit.

Depreciation Percent Apply Flag – Select True or False ; See MPV Commercial 8.6.2 and MPV Residential 7.8.2 for details

Depreciation Maximum Percent – Refer to MPV Commercial 2.1.3, 8.6.3 & 8.6.4 and MPV Residential 2.1.4 & 7.8.4 for details.

Section Depreciation Maximum PercentSee MPV Commercial 2.1.3, 8.6.3 & 8.6.4 and MPV Residential 2.1.4 & 7.8.4 for details.

Zone Information Adjustment Override (group)

NOTE: The Zone Information Adjustment Override frame is only available when the valuation method selected is Residential.

Target Zip Code – Enter the zip code of the required area on the M&S table.

Energy Zone – Select an Energy Zone, e.g., Moderate.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Foundation Zone – Select a Foundation Zone.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Hillside Construction – Choose a value from the drop-down menu; e.g., Flat.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Seismic Zone – Choose a value from the drop-down menu.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Wall/Energy Zone – Select a Wall Energy Zone code; e.g., 2×4 Base Cost.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Wind Zone – Select a Wind Zone code.

NOTE: This parameter is enabled only if a Target Zip or Postal Code has been entered.

Documentation

When documentation is available click here to view it.

GNA Product Map

 

 

103-ED-025

 

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

Generic Import Editor (103-ed-024)

Generic Import Editor

Available in release 6.1.xxxx – (In Development)

Overview

The Generic Import Editor is a GNA Editor that will allow users to import

The function of the Generic Import Editor is as follows:

  • Allow import definitions to be stored in a configuration
  • Allow imports to be tracked and monitored from a single location.
  • Allow imports to be created faster with minimal coding required.
NOTE: This editor maintains records found in (Table: VT_USR_IMPORT_DEF).

Generic Import Editor Setup Parameters

T/C

 

GNA Product Map

 

 

103-ED-024

 

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 – Batch Process Definition Editor

Batch Process Definition Editor

Version 6.x | Version 5 and less

Overview

The GNA Batch Process Definitions editor is used to define how you want your batch processes to appear and run in Govern. This includes setting up your batch processes, configuring each process, associating one or multiple reports, and synchronizing the batch process definitions and adding permissions. When complete, the batch processes are displayed in Govern.
This procedure has two major steps:

  • Configuring Batch Process Definitions
  • Adding Batch Processes Definition to Govern.
  • Configuring Sequential Batch Processes (101-std-fea-046)
  • Configuring Sequential Batch Processes (101-std-fea-046)

 

Read More...

Configuration

Configuring Batch Process Definitions

Configuring Batch Process Definitions describes the following topics; locate the appropriate sections on this page:

  • User Interface
  • Defining a Batch Process
  • Defining the Transaction Type
  • Defining the Transaction Mode
  • Adding a Report
  • Deleting a Batch Process Definition

Batch Process Definition – User Interface

This section provides a tour of the Batch Process Definitions UI. The interface is comprised of a treeview (left hand side), the definition form (main central area), and a secondary window for creating the menus and submenus or categories.
To access the Batch Process Definitions form:

  1. Launch Govern New Administration (GNA).
  2. Select Batch Process > Definitions.

Once you create menus and define batch processes, the selected items are listed in a treeview on the left of the form. You can display or hide the treeview according to your preference.

About Batch Process Definitions

You can view, add, or modify a batch process definition, as described later in this section.
To display or hide the English and French long and short descriptions, click on the arrow beside the text box at the top of the form.

About the Menu Manager

The Menu Manager form is used for creating the menus and submenus for organizing your batch process definitions in Govern.NET.
To access the Menu Manager

  1. Launch Govern New Administration (GNA).
  2. Select Batch Process > Definitions.
  3. Click the ellipsis button beside the Category text box.

If categories are already created, they are listed on the left. You can expand a category to view secondary levels if they exist. The name of selected menu is displayed on the right. You can expand the name to view the English and French short and long descriptions.

Defining a Batch Process

Use the following process to name the definition and to associate it with a Govern Batch process.

NOTE: You need to define the processes under the category to which they are assigned and will appear in Govern.

To define a Batch Process:

  1. Select the category where you are defining the process as described under Selecting a Category for the Batch Process. The batch processes already defined for the category are displayed in the treeview on the left.
  2. Click the New button.
  3. Enter a code for the new batch process definition. This is a required field.
  4. Select a Govern batch process from the Process drop-down list. This is a required field.
  5. Enter a name for the record in the text box at the top right. This is automatically added to the English Long Description field.
  6. Click the button to the left of the text box where you entered the name. This expands a menu with additional descriptions.
  7. Add an English Short Description and French Short and Long Description as required. These fields are optional.
  8. Click the Save button to add the category to the menu.
    If you click the New button without saving your modifications, a confirmation message appears:

Defining the Transaction Type
The Govern batch processes can be run synchronously or asynchronously. If they are run synchronously, they are run on the same server. If run asynchronously they are run on multiple servers at the same time.
Select Synch or Asynch as required. For processes with multiple transactions, it is recommended to use asynchronous processing as this spreads the load over multiple servers and makes for faster processing time.
Pool #: For Asynchronous processes only, enter the maximum number of transactions to be handled by the client servers at any one time.
This works as follows: If you are running asynchronous batch processing, there is one master server that manages all the transactions and is responsible for sending them to the client servers. The value In the Pool # field indicates the maximum number of transactions to send out by the master server at any one time.
Scenario: Running a Batch Process Asynchronously
The following scenario illustrates how asynchronous batch processing works.
The parameters are as follows:

  • Master server: one
  • Client servers: five
  • Transactions: 50,000
  • Pool #: 50

The master server sends out the first 50 transactions to the client servers. Each server is responsible for ten transactions. As soon as a server completes one transaction, the master server sends it another. This continues until all transactions have been processed. However, there are never more than 50 transactions being handled by the client servers at any given time.

Defining the Transaction Mode

Select one of the following transaction modes for the process.

  • Break If One Transaction Failed: the process terminates when the transaction fails.
  • Roll Back If One Transaction Failed: the process terminates when a transaction fails and all the transactions that were completed are cancelled. Computations are returned to the starting point.
  • Continue If One Transaction Failed: Continue to run the process even if a transaction fails.

Adding a Report

Use the following procedure to associate one or more reports with the selected batch process.
To add a report: to the batch process:

  1. Launch the Batch Process Definitions form.
  2. Select the category for the process as described under Selecting a Category for the Batch Process.
  3. Select the batch process from the treeview on the left.
  4. Click Add Reports.
  5. Select one or more reports from the Choose the Reports menu.
    TIP: You can select multiple reports using the left mouse button.
  6. Click Select Reports.

The selected reports are displayed in the List of Reports text box. The parameters for the report are displayed in the Report Parameters list box.
The List of Parameters text box displays the parameters that can be included in the report and that can be used to build an external report; for example, these could include Date To and Date From fields. The purpose is to give you the exact reference and wording of these fields.

Deleting a Batch Process Definition

To delete a batch process:

  1. Launch the Batch Process Definitions form.
  2. Select the category for the process as described under Selecting a Category for the Batch Process.
  3. Select the batch process from the treeview on the left.
  4. Click the Delete button.

Adding Batch Processes Definition to Govern

When you have defined your batch processes, you need to add them to Govern.NET. In order to do this, you need to launch the Govern Security Manager and synchronize your new processes between GNA and Govern. Then, you need to assign access permissions.

Synchronizing Batch Process Definitions

When you have synchronized your new batch process definitions, they appear on the Govern.NET menu.
To synchronize the new batch processes:

  1. Launch the MSGovern Security Manager (GSM).
  2. Select your database connection key.
  3. Right-click on Applications and select Synchronize menu from the dropdown list. A confirmation message appears.
  4. Click Yes on the confirmation message.

Permissions and Batch Processes

Use the following procedure to assign access permissions to the new batch process definitions. You can grant permissions by profiles and grant permissions to the Batch Process Editor application in Govern Administrator.

  1. Launch the MSGovern Security Manager (GSM).
  2. Select your database.
  3. Expand Applications > MSGovern.NET > Batch Process > Batch Process.
  4. Continue to expand the menus until you are the level where you want to grant permission.
  5. Right-click on the item that you want to secure.
  6. Define the permissions and exclusions as required and as described in the Govern Security Manager.

What’s New

 

Related Topics

Govern New Administration (GNA)
Batch Processing in OpenForms

 

 

103-ed-013

 

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 – Email Template Editor

Email Template Editor

Version 6.1 (1706)

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.

 

Read More...

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. In the GNA Email Template editor, there are sub tabs, one of which allows users to preconfigure their email messages. The Predefined 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. You are able to add recipients from the list of Govern Users or Govern Roles as they appear under the Predefined tab. An additional support function is that Email templates generated by the editor can be invoked through a Batch Process.

For more information, see:

Configuration

A recommended methodology for correct implementation is to take the following steps:

1. Design or Select an Email Template

Determine the format that your email message will take in the GNA Email Template Editor. In the Parameters Expression field, build the expression that will be used to extract the parameters needed for your email message. For example a message that is pertaining to overdue accounts might require some of the following pieces of information.
From and To fields for the email, account holder names and account numbers, dates, and so on.
Refer to the Email Template Editor Wiki page or user guide for details about using the editor.
When email templates are designed in the GNA Email Template Editor, expressions can be used to determine which fields are required to be populated in the template. Refer to the About Parameters Expression Field  section on this page.
As an example, an email message will be sent to all mailing addresses with a late filing. The information that is required will be retrieved by the Govern ID’s. Each record returned by the query will look through each column to see if it corresponds to a Govern ID; if this is the case, the Govern ID will be set. Then when the email is being sent via the template, the Govern ID will be passed to the template to be used directly within the email, or as a Parameter Expression that is passed to another query.
In our example, another query has been designed to extract information such as the naNameInfo, EMAIL, FULLNAME, ACCOUNT_NO, and so on.

Parameters Expression

As indicated earlier, build your query in the parameters expression, it is here that you will determine the required Govern ID’s.
For example…:
{
To = Query(‘naNameInfo’, ‘EMAIL’);
Name = Query(‘naNameInfo’, ‘FULLNAME’);
AccountNumber = Query(‘stAccountNo’, ‘ACCOUNT_NO’);
Category = Query(‘stCategoryCode’, ‘SHORT_DESC_EN’);
PeriodeCode = Query(‘stPeriodCode’, ‘SHORT_DESC_EN’);
PeriodeNumber = Query(‘stPeriodNumber’, ‘SHORT_DESC_EN’);
DueDate = Query(‘stDueDate’, ‘DUE_DATE’);
}
In the above expression, we need the NA_ID’s for name information, ST_ID’s for ST account information and due dates, and so on. Each required query must be created. Refer to the Appendix section below for a listing.

The SELECT query is now written to retrieve the Govern ID’s that are needed in the email template.

2. Design Your Query

The SELECT Query

It is within the SELECT query being used that the Govern ID’s are set.
Looking at the following query…:
SELECT top 100 f.st_acct_id,
f.na_id,
f.st_id
FROM st_filing_master f
INNER JOIN NA_NAMES n ON n.na_id=f.na_id
WHERE f.unfiled <> 0 AND
f.due_date < GETDATE() AND
(n.email IS NOT NULL AND n.EMAIL <> ‘ ‘)
ORDER BY f.st_acct_id, f.st_id;
The above query was designed in the Select Query Editor in GNA. It will list all filings that are late. An email will be sent to the NA_MAILING address. For this example, note that only the top 100 records are selected.

Appendix

List of Queries

The following queries were used as examples for demonstration purposes. They can used as a starting point and modified for other purposes.

— Query Expression:

{
To = Query(‘naNameInfo’, ‘EMAIL’);
Name = Query(‘naNameInfo’, ‘FULLNAME’);
AccountNumber = Query(‘stAccountNo’, ‘ACCOUNT_NO’);
Category = Query(‘stCategoryCode’, ‘SHORT_DESC_EN’);
PeriodeCode = Query(‘stPeriodCode’, ‘SHORT_DESC_EN’);
PeriodeNumber = Query(‘stPeriodNumber’, ‘SHORT_DESC_EN’);
DueDate = Query(‘stDueDate’, ‘DUE_DATE’);
}

— Email message

Dear @Name,
The following Account #@AccountNumber has registered a late payment for the @PeriodeCode period of @PeriodeNumber in the @Category.
The actual due date was @DueDate

— naNameInfo

SELECT EMAIL,
CASE
WHEN FORMAT_CODE=’c’ THEN COMPANY
ELSE FIRST_NAME || ‘ ‘ || LAST_NAME
END as FULLNAME
FROM NA_NAMES
WHERE NA_ID=@idna_id

— stAccountNo

SELECT ACCOUNT_NO
FROM ST_MASTER
WHERE ST_ACCT_ID=@idst_acct_id

— stCategoryCode

SELECT VT_USER.SHORT_DESC_EN
FROM ST_FILING_MASTER
INNER JOIN VT_USER ON VT_USER.YEAR_ID=ST_FILING_MASTER.YEAR_ID AND
VT_USER.DEPT=ST_FILING_MASTER.DEPT AND
VT_USER.CODE=ST_FILING_MASTER.CATEGORY_CODE
WHEREST_FILING_MASTER.ST_ID=@idst_idAND
VT_USER.TABLE_NAME=’ST_CATEG’

— stPeriodCode

SELECT (CASE WHEN ST_FILING_MASTER.PERIOD_CODE = ‘ST_INACTIVE_PER’ THEN ‘Inactive’ ELSE VT_USER.SHORT_DESC_EN END) AS SHORT_DESC_EN
FROM ST_FILING_MASTER
INNER JOIN VT_USER ON VT_USER.YEAR_ID=ST_FILING_MASTER.YEAR_ID AND
VT_USER.DEPT=ST_FILING_MASTER.DEPT AND
VT_USER.CODE=ST_FILING_MASTER.PERIOD_CODE
WHEREST_FILING_MASTER.ST_ID=@idst_idAND
VT_USER.TABLE_NAME=’ST_PER’

— stPeriodNumber

SELECT VT_USER.SHORT_DESC_EN
FROM ST_FILING_MASTER
INNER JOIN VT_USER ON VT_USER.YEAR_ID=ST_FILING_MASTER.YEAR_ID AND
VT_USER.DEPT=ST_FILING_MASTER.DEPT AND
VT_USER.CODE=(ST_FILING_MASTER.PERIOD_CODE + ‘_’ + CAST(ST_FILING_MASTER.PERIOD_NB AS VARCHAR))
WHEREST_FILING_MASTER.ST_ID=@idst_idAND
VT_USER.TABLE_NAME=’ST_PER_DETAIL’

— stDueDate

SELECT DUE_DATE
FROM ST_FILING_MASTER
WHERE st_id=@idst_id

Documentation

Click to view or download the current version of the user document:
103-ed-017_GNA_Email_Template_Editor.pdf

Related Topics

Email Notification
Email Notification Batch Process

 

 

 

103-ed-019

 

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

Bill Messages Editor

Bill Messages Editor

Available in release 6.1.1911

Overview

The Bill Messages Editor allows you to edit and manage Bill Messages. With this editor, you can add a message to your next billing run using form. This message is valid for one billing only. The message is defined by Message Type and by Subsystem. For example, you can define a message to be printed on duplicate bills created for Real Property Tax.

NOTE: This editor maintains records found in (Table: VT_USR_BILL_MESSAGES).

Bill Messages Editor Setup Parameters

Subsystem: Select a Sub-system (Land Management, Real Property Tax, Special Assessment, Utility Billing, and so on) from the drop-down list (Table: VT_SYSTEM.SUBSYS).

Message Type: Select a Message Type from the drop-down list (Table: VT_USER.MESSBILL).

: Click the ellipsis to add additional Message Types. Click to display the User Validation Table Editor.

Message on Bill: In this field, enter the message that is to appear on the bill.

 

GNA Product Map

 

 

103-ED-023

 

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