Govern – API and Services

Govern API & Services

Overview

Standard API Web Services

Govern’s standard API Web Services provide a communication and data exchange protocol to Govern Applications:

These services are distributed with a program called Mock-Up, to help the programmer test and make sure the correct information is received from the services.

Other Govern Web Services

Web services are used in OpenForms for:

Specification

In general:

  • Windows Communication Foundation (WCF) is an API in the .NET Framework.
  • Govern PC Web Services supports JavaScript Object Notation (JSON) serialization format to WCF.
  • Minimum System Requirements for IIS Servers and .NET Framework
  • IIS Server must be configured for each deployment (production, training, staging, tests…)
  • Govern Services are stand-alone programs that need to be installed separately.
  • API services downloads are zip files and a zip converter is required to install.
NOTE: Although the WCF PC Web Services supports (JSON), Harris Govern does not provide technical developer support for this type of implementation.

Configuration

In the Windows setup screen “Turn Windows features on or off”, accessible from the Control Panel, there are some IIS options to activate:

1. NET Framework WCF Services HTTP Activation

IIS WCF Services HTTP Activation.png

2. Internet Information Services (IIS)

IIS Config 1.png

IIS Config 3.png

3. Next, run the Govern WcfServices exe:
X:Install Package6.1WCF Services Setup

MS Govern WCF Services Setup.png

MS Govern WCF Services Installation.png

4. The IIS Application is installed and can be browsed:

IIS Browse.png

When clicking Browse, the service web page is open at the address:
https://localhost/GovernWcfServices_CMSDEMO_CAMA_60_2ZR8CZ1_SQL/

Click on the service name PropertyControlService.svc, you go to the service page. Copy-paste the link
https://localhost/GovernWcfServices_CMSDEMO_CAMA_60_2ZR8CZ1_SQL/PropertyControlService.svc

IIS Service Hyperlink.png

inside the WCF Test Client, located at: C:Program Files (x86) Microsoft Visual Studio 14.0/Common 7/IDE/WcfTestClient.exe:

WCF Test Client.png

You can then test any method from the service contract by clicking on it and set its parameters up.

Download and Install

As of 6.0, Deploy-EZ, can be used to download the standard Govern API WCF bundle (PC&GIS, AR&CC) and the Govern Scheduler Service.

  • Download Binaries for the required release (4.7, 5.1, 6.0., 6.1…)
  • Install for each Deployment (Production, Test, Train, Stage…)

For Govern e-Government or other Custom Services

  • Contact Harris Govern for FTP download information

For Harris Govern Employees, packages are located in GOVERN’s DEPLOYMENT SERVER, in the INSTALL folder by version.

What’s New

  • [6.0] New Govern Batch Scheduler Service (403) installation and automatic Service stop and restart for updates.
  • [6.0] The PC/GIS (401) and AR/CC (402) web services installation package have been bundled together.
  • [6.0] The installation pack can be downloaded via DeployEZ.

PC & GIS Web Service (401)

This service is used to load or create information in property control. It also establishes communication between Govern and a GIS system.
Click here for more information.

A/R & CC Web Service (402)

This service is used when cash is collected via a third party software.
Click here for more information.

Batch Scheduler Services (403)

Govern OpenForms Scheduler uses the following services:

  • Batch Scheduling
  • Batch Execution (Windows Services)

Click here for more information.

 

 

400-api

 

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

Roll Forward – Fields Exclusion

Fields Exclusion

Overview

By default, when you perform a roll forward or run a batch program that copies data to the following year, all database fields from the following list of tables are copied.
Using the Fields Exclusion form, you can select the fields to exclude from the Copy to Next Year and Roll Forward processes. You can exclude the same of different fields. The lists are independent.

For details, see Fields Exclusion.

Version

The Fields Exclusion form is available in Govern OpenForms v6.1 and above.

Excluding Fields

To exclude database fields from the Roll Forward and Copy to Year processes:

  1. Launch GNA.
  2. Select Application Configurations > Fields Exclusion.
  3. Click the Add icon to select a field.This adds a row to the grid.
  4. Select the table, containing the field, from the drop-down list in the Table Name field.
  5. Select the field that you want to exclude from the corresponding drop-down in the Column Name field
  6. Select the Roll Forward checkbox to exclude the selected field from the Roll Forward process.
  7. Select the Copy to Next Year checkbox to exclude the selected field from the batch processes that copy data to the following year.
  8. Repeat steps 3 to 7 to add more fields.
  9. Click Save.

Batch Processes

Batch processes that copy data to the following year include:

  • Compute Levies and Exemptions
  • Mass Appraisal Values Computation

Roll Forward

The Roll Forward process is launched from the Govern Tax and Mass Appraisal forms.

Available Tables for Fields Exclusion

Aircraft Excise Tax

  • AC_ASSESSMENT
  • AC_ASSESSMENT_DET
  • AC_EXEMPTIONS
  • AC_LEVY_MASTER
  • AC_LK_LEVY_EXEMPT

Boat Excise Tax

  • BT_ASSESSMENT
  • BT_EXEMPTIONS
  • BT_LEVY_MASTER
  • BT_LK_LEVY_EXEMPT

Mass Appraisal Buildings

  • MA_BLDG_AREA_YEAR
  • MA_BLDG_DRAWING
  • MA_BLDG_INFO
  • MA_BUILDINGS
  • MA_BUILDINGS_2

Mass Appraisal Income

  • MA_INC_INFO
  • MA_INC_SIMULATION
  • MA_INCOME
  • MA_INCOME_DETAIL

Mass Appraisal Land

  • MA_LAND
  • MA_LD_INFO

Mass Appraisal Linking

  • MA_LINKS_PERCENT
  • MA_LK_INC_FIELD

Mass Appraisal Tables (General)

  • MA_MASTER
  • MA_MISC_STRUCTURES
  • MA_MRA
  • MA_OVERRIDE
  • MA_SITE
  • MA_VALUES_TABLE

Motor Vehicle Excise Tax

  • MV_ASSESSMENT
  • MV_EXEMPTIONS
  • MV_LEVY_MASTER
  • MV_LK_LEVY_EXEMPT

Property Control

  • PC_AREA
  • PC_LEGAL_INFO

Personal Property Tax

  • PP_ASSESSMENT
  • PP_ASSESSMENT_DET
  • PP_EXEMPTIONS
  • PP_LEVY_MASTER
  • PP_LK_LEVY_EXEMPT

Real Property Tax

  • TX_EXEMPTIONS
  • TX_LEVY_MASTER
  • TX_LK_LEVY_EXEMPT
  • TX_RE_ASSESSMENT

 

 

103-std-parm-RollFwdExcl

 

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

AR / CC – API Web service

Accounts Receivable (A/R) & Cash Collection (CC) API WEB Service

Overview

The Govern Payment Notification Web Service service is mainly used when cash is collected via a 3rd party software.

Installation and Setup

In Deploy-EZ:

  • Download the Binaries for the required release (4.7, 5.1, 6.0., 6.1…)
  • Deploy and Install the Govern WCF Service (Standard bundle with PC&GIS, AR&CC) for each deployment

For more information, see Download and Install on Govern API and Services main page.

What’s New!

AR Web Service for Key Bank (TM)

Key Bank’s web-based CSR Application (Payment Center) is used to process credit card transactions from cashiering stations. Govern provides a Payment Notification Web Service that can be utilized by Key Bank’s payment processing applications; Govern is used for Cash/Check transactions. In order to accommodate this process, a new method (AR_ExecutePaymentKeyBank) was added to the Govern A/R Web Service to support the Key Bank payment notification. This method uses key-value pairs as input parameters. For method details, refer to the updated Govern Accounts Receivable and Cash Collection API Web Service document. See Documentation section below.

Documentation

 

 

402-arccservice

 

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

Central Notes Feature

Central (Centralized) Notes

Overview

Central Notes are designed to allow users to enter and store notes in a centralized storage location. When used, Central Notes enables users to maintain, and review, any notes that are entered when an action is performed, or when a modification is made.

User prompts for a central note entry can be made to occur at the entity level, or at the field level of a profile. This means that a user can be prompted to make an entry when they either access and make a change anywhere in the profile, or in a specific parameter in the profile. These settings are made by an administrator in the Business Entity Designer (BED) release 5.1 or greater. in addition Central Notes can be applied on a dataset basis, i.e. all records of a search result could have a note applied to them collectively.

NOTE: Central Notes that are applied as a dataset are permanent, Notes applied to a dataset cannot be removed.

 

101-std-fea-009-(uiTN)-[v6.0].png
Centralized Notes Pane & Viewer

As an example, in the Parcel Linking profile if a new parcel link is created, or a modification is made to an existing Start Date or End Date, justification may be required for the action. This layer of security can be provided with the Central Notes System. When enabled, the user will not be able to complete the action unless an entry has been made in the Central Notes form. When entered and saved, the record of the username, change, and details is saved.
When a centralized note is entered, an optional flag can be assigned to it. A note can be entered with three (3) statuses. These statuses can be used as part of a search criteria. (Table: PC_CENTRAL_NOTES).

Locating the Central Notes pane

The Central Notes can be found by default as an Auto-Hide tab located on the left hand side of the Govern user interface. To display the note field, hover your pointer over the tab to display it. Refer to Auto-Hide Panes (std-fea-001).

Read More...

Enabling Central Notes

Creating an Entity Level Centralized Note requirement

At the entity level, when an entity is made or modified, the user will be required to enter a centralized note entry.

To set up an Entity level Central Notes entry request, you will need to make changes using the Business Entity Designer (BED) release 5.1 or greater. Refer to the BED release 5.1 guide for details about modifying Business Entities (BE’s)

  1. In the BED, under the Model Explorer pane, click on the Business Entity that will require a Centralized Note entry; for our example we will use Parcel Linking.
  2. Under the Properties pane on the right hand side under 1 – Basic Data Settings, set the Note is required on creation flag to True.
  3. Set the Note is required on modification flag to True.
  4. Click Save.

When the flags are set at this level, i.e. the Entity level, a Centralized Note entry will be required to create a new parcel link entry.
Creating an Attribute Level Centralized Note requirement
At the Attribute level, in order to enter a note, or when a modification is made to an attribute, i.e. field, a note entry will also be required to be made.
To set an attribute level Centralized Note entry request…

  1. In the BED release 5.1, under the Model Explorer pane, click on the Business Entity that will require a Centralized Note entry; for our example we will use Parcel Linking.
  2. In the central area under the List of Attributes pane, select an attribute that you want the user to be prompted with a Centralized Note entry request; for our example select the END_DATE attribute.
  3. On the right hand side, locate the Central Notes property, set both the Allow Notes, and the Note is required on modification flags to True.
  4. Repeat the above steps 2 and 3 for the FROM_DATE attribute.

About Entity / Attribute Level Centralized Note requests

Users that are enabling Central Notes for Entities and Attributes should note that the request for a Centralized Note entry by the system are separate. This means that if the flags are set at both the Entity and Attribute level, a separate prompt for a Centralized Note entry will be issued by the system.

Central Notes pane

The Central Notes pane is used to enter and display the notes that are related to the selected parcel. These tabs are used to enter and view the Central Notes, as well as controlling what notes are displayed after a search, through a series of user selectable filter fields.

Notes Viewer form

With a click on the Notes Viewer button in the Central Notes pane, the Notes Viewer form is displayed. This form contains two (2) tabs, one for defining your search parameters, and the other for displaying the search results.

NOTE: by default when the Notes Viewer button is clicked, the Notes Viewer form is displayed with the Notes Viewer Search Results tab.

Notes Viewer Search Criteria tab

In the Notes Viewer Search Criteria tab, you are able to search the Govern system for existing notes. The results of the query are filtered based upon your search parameters.

Central Notes Management tab

Notes Viewer Search Criteria tab – Command Button
Retrieve Notes:
Click Retrieve Notes to perform a search of the Centralized Note based upon the Filter options selected.

Notes Viewer Search Criteria tab – Parameters

The following is a description of the parameters that are found under the Notes Viewer Search Criteria tab.

Filters group

Dataset Filter group

Selections in the Dataset Filter group will restrict the display of notes to those within the current dataset.
All: Click All to display all notes in the current dataset.

Current Parcel: Select this option to display notes that are restricted to the current parcel.

Current Name: When Current Name is selected, only the Central Notes that were created on records that are linked to the current name account.

Author Filter group

All Authors: Select this filter option to display notes from all authors under the Author list. (TABLE: USR_USERFILE)

My Notes Only: When selected, this option will display only notes made by the current logged in user.

From Author: Click to select the From Author option; this will display the notes entered by the author that is selected from the drop down menu.

NOTE: The drop down menu list will not be active unless the option is selected. When this option is selected, but no author is selected, a warning will be displayed requesting that an author be selected from the list.

Subject Filter group

Entity Name: Click to select an Entity Name from the drop down list; the notes that are displayed are the ones that are related to the Entity.

Control / Attribute: Select the Control / Attribute option to filter for the Control or Attribute that is associated with the selected control or attribute

Table Name: Click to activate and filter Central Notes that are associated with the selected table name.

Column Name: After selecting a Table Name, you can further filter down and display Central Notes associated to a selected column name.
Date Filter group

Fiscal Year From / Fiscal Year To: Enter the Fiscal Year range of interest in the From and To fields.

Entry Date From / Entry Date To: Enter the date range of the Central Notes that you would like to view.

General Filter group

Note Priority: When a priority has been assigned to a Centralized Note, use this option to filter the search results for a specific priority. If no priority is selected, the all notes will be specified.

Exclude Private Notes: Select this option to exclude all notes that have been assigned with the Private Notes option.

Searching for Central Notes

Users with access to Central Notes can perform a search on all notes entered in the system. The search can be by parcel, name, or by author, for a given entity or attribute.
To perform a search for Central Notes that have been entered in the system:

  1. Click to display the Central Notes auto-hide pane.
  2. Select the Notes Viewer Search Criteria tab.
  3. In the Filters group, select each criteria required from each of the filter groups.
  4. If required select a priority note from the General Filter group.
  5. Click Retrieve Notes.

Notes Viewer Search Results

The search results will be displayed under the Notes Viewer Search Results tab.

Notes Viewer Search Results

As indicated earlier, the Notes Viewer Search Results tab displays the results of search queries based upon selected filters. The columns displayed can be re-arranged with a drag and drop action.

Grouping by Columns

The Central Notes drag and drop feature also allows for grouping by column heading. The space above the columns titled Drag a column header here to group by that column is referred to as the Grouping Area (A). This space expands to accommodate column names as they are added.

For example, if we have the following columns headings…:

  • Priority
  • Private
  • Entry Date
  • Relates To
  • Note
  • Author Name

We may want to view the entered notes grouped according to the Priority (A).

To group according to the Priority:

  1. Click and drag the Priority column into the Grouping Area above the columns; when empty this area is marked”Drag a column header here to group by that column”. Drop the column heading on the Grouping Area.
  2. You will note that the data has now been grouped according to the Priority column. You will see a heading that indicates the column grouping, the item that it is being displayed under, and the total number of items under that grouping. Click on the “^” beside the column grouping (A) to expand or contract the content listed.

Multiple columns or attributes can be grouped by dragging and dropping them into the Grouping Area above the column headings. Additional columns will appear as subgroups within the original group.

The order of the groups and subgroups can be changed with a drag and drop procedure.

To re-arrange subgroups:

  1. Click and hold the pointer on the subgroup title.
  2. Drag the title to its new location, noting the insertion point between the subgroups. The insertion is indicated by a bright vertical bar.
  3. Release the mouse button to complete the insertion.

Removing Column Groupings

To remove column groupings from the Grouping Area:

  1. Click and drag the grouped or sub-grouped title to an area outside of the Grouping Area.
  2. When an ‘X’ appears, release the mouse button to drop the object. The grouping or sub-grouping will be removed.

Viewing Central Notes Search Results

After result have been generated, there are two (2) options available to view the results; export results to an Microsoft Excel spreadsheet, Print with a preview.

Notes Viewer Search Criteria tab – Command Button

Export to Excel: When Export to Excel is selected, the current search result grid will be exported as an Microsoft Excel spreadsheet.

NOTE: The Excel export will not be affected by the sort order or grouping; the columns are output in the default order of the system.

Print Preview: Click Print Preview to display a preview of the current search result grid.

Behavior of Central Notes when enabled in Govern

When Central Notes are enabled, fields that have the Central Notes enabled through the Business Entity Designer (BED) will have icons that flag the state of the field.

Central Notes Status Icons

Central Notes fields are indicated with Notepad icons that lets the user know their status. Red icons indicate that note entries are required, i.e. mandatory; Gold icons are an indication that note entries are optional:

Allowed: The yellow icon indicates that entry of notes is optional for the user.

Required: This indicates that any changes to the field involves a mandatory note entry

Exists and Allowed: The yellow icon and magnifying glass indicates that notes exist in the system, but they are optional for the user.

Required and Exists: The red icon and magnifying glass indicates that a notes exist, but mandatory entry is required for changes by the user.

How to make a Centralized Note entry

Users that are attempting to save a record when the field is set as Required will be presented with the following error window: To resolve this situation…
1.Click OK to acknowledge the notification.
2.Locate the Central Notes auto-hide tab; place your pointer over the tab to display it.
3.Click Add a New Note.

NOTE: When a new note is created, the date, time, and user log-in name is displayed for reference.

4.Click in the note field and enter your note

5.When complete, click Save.

As long as the Centralized Note is created and the reason for the creation or change, i.e. “justification” is entered, the system will them allow a save.

Creating a Centralized Note for a Dataset

WARNING: A Centralized Note that is applied to a dataset cannot be modified or deleted. Take care when making your entry

Creating a Centralized Note for a Dataset, i.e. a group of records that are the result of a query, hand picked records, or appended list, is a similar procedure to applying one to an individual record.

NOTE: In order to be able to click on the Central Notes button, you will need to open a Profile, then perform a search.

To create a Centralized Note that will apply to a dataset…

  1. Perform a search; the resulting records will be the dataset.
  2. Load the dataset into the Dataset Treeview.
  3. If not selected, click the Home tab in the Govern Ribbon.
  4. In the Flags group, click to select Central Notes.
  5. In the Central Notes form, enter your notes that will apply to the dataset (1).
  6. Select a Priority status, and select the Private option if the note is to be set as private (2).
  7. Click Save (3) to create the note or Cancel (4) to stop the creation process.

Central Notes for Datasets are saved in the same table as the individual record notes, (Table: PC_CENTRALIZED_NOTES), the exception here is that these notes are permanent, i.e. they cannot be deleted.

Modifying a Centralized Note

Once a Centralized Note has been created, the author or creator of the note can modify their entry. In addition, with the correct security flags set in the Govern Security Manager (GSM), an author can modify all Centralized Note entries.

To modify a Centralized Note…

1.Display the Centralized Note pane.

2.Select the note and effect any required change.

To enable a Centralized Note author to be able to edit all notes…

1.In the GSM, ensure that the permissions flag for Update (U) has been set; refer to the Working with Central Notes section of the GSM 5.1 user guide.

NOTE: If the update flag has not been set, the author will only be able to change the notes that they created, and no others. Refer to the GSM release 5.1 for details on Working with Central Notes.

 

What’s New

[v6.0.1404]
  • The search panel is now dockable. Users can keep this window open while performing other tasks. Very handy for users with dual screens.
  • Collective notes can be recorded by dataset (permanent)
[v5.1]
  • Note Priorities
  • Private notes are used to flag notes that should not appear on the web

Specification

Product feature specification [v6.0] for centralized notes:
General

  • Recorded at the business entity level or at the field/attribute level
  • Recorded for the active parcel, name, building… or for the entire dataset or recordset results (permanent)
  • Metadata recorded along with the note (i.e. the author, date, dept. fiscal year, entity name, attribute/field name… is saved along with the note)
  • Additional security level based on authorship (my notes, other people notes)
  • Allowed or Required (on creation or on modification) Business Entity notes
  • Allowed or Required notes on Attributes
  • Priority status (3)
  • Private notes

User Interface

  • Auto-hide and dockable Note Pane synchronized with active form and ids
  • Notes are saved with the form
  • Centralized Notes Viewer with Search & Results (sort, group, print and export to xls)
  • Search Criteria:
    • Dataset: All, Current Dataset, Current Parcel
    • Author: All, Mine, Specific Author
    • Subject: Entity name, Attribute name, Table name, Column name
    • Date: Fiscal Year From and To, Entry Date From and To
    • General: Priority, Exclude or Include Private Notes
  • Visual representation (cues) of the note state on the form (required & missing, required and available … )
  • Notes can be deleted

Business Rules

  • Required Note Option to enable an additional layer of security to prevent a user from completing an action unless a note is created
  • Is dirty property is set to true on the form when a note is created or modified

Examples

  1. in a profile with Parcel Linking, if a new parcel link is created, or a modification is made to an existing Start Date or End Date, justification (note entry) may be required to complete the action (save or modify).

Setup (BED)

Setup in the Business Entities Designer as true or false properties for the Business Entity or for an Attribute (field).

Business Entity

  • A note is required on creation
  • A note is required on modification

Attribute

  • Allow notes
  • A note is required on modification

Security

In Govern Security Manager (GSM), there are 2 items that can be secured for notes; Entry & Viewer.
In addition, a distinction is made for Centralized Notes Entry between My Notes (notes entered by the user) and Other people’s Notes.

Expand ApplicationsGovernMenuViewViewCentral Notes to get the following:
Central Notes (change to Centralized Notes)

  • Central Notes Entry
    • My notes
    • Other notes
  • Central Notes viewer

For more information, see 102-Govern Security Manager (GSM) OpenForms System Suite

Technical Info

Tables

PC_CENTRAL_NOTES
PC_LK_CENTRAL_NOTES

[v6.0] New Govern Standard Attribute PC_CENTRAL_NOTES REQUIRED

Best Practices

  • Do not overuse (it is human nature to overdo it); this can be overwhelming when reviewing the information.
  • If Required Notes are not set properly, they can be a burden for users with data entry functions.

 

 

101-std-fea-009

 

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

eGov – Upgrade Web User Interface

Upgrade of the eGovernment – Public Self Service Portal

Overview

The Govern Public Web Portal is an e-Government services application that contains a set of modules which provide citizens and professionals public access via the Internet. Through the portal, users are able to apply, query, request and view information. This page is intended for administrators, and contains links to instructions of how to upgrade to the current version of the e-Government (eGov) – Public Self Service Portal (WebUserInterface) that is hosted on an IIS Server.

How to Obtain the Updated Package…

The new package can be downloaded through the Govern Deploy EZ deployment application. To download through Deploy EZ:

  1. Launch Deploy EZ.
  2. Select the Download binaries from the FTP site
  3. Click Next.
  4. In the Import Selection group, select the eGovern
    Package
    .
  5. Click Next.

The selected packages will be downloaded.

Copy Downloaded Files to IIS Server

Once the package has been downloaded, copy the package (WEBUserINTERFACE_6.1.XXX.XXXX.zip) from the folder \\kpb\installpoint\MSGovern.SRTClient61\Binaries\eGovern to the IIS Server.

If downloaded to the Govern install folder:

\\Install_Folder\Govern\Binaries\WEBUSERINTERFACE\6.1.XXXX.XXXX

  1. Copy the downloaded file to the IIS server.
  2. Extract the Zip file package WEBUserINTERFACE_6.1.XXXX.zip

Deploying the new version on the IIS Server

WARNING: Prior to performing any update ensure that a backup has been made of the folder that is being upgraded.

1. Stop the Application Pool

To deploy the new version on the IIS server…

  1. Open the IIS Manager console.
  2. Select the Application Pools.
  3. Locate the application pool of the website that is to be updated.
  4. Click Stop to stop the application pool.

2. Stop the website to upgrade

In the Sites section:

  1. Select the website to upgrade and in the Manage Website
  2. Click Stop to stop the website.

3. Verify your backup…

In the folder containing the site that is being hosted, make a backup of all files in the folder. This should be done prior to copying the new version. This procedure is done in case there are errors with the installation and a roll back is required.

4. Edit the “web.config” file

Perform the following steps to edit the web.config file.

  1. Rename the config to web.config.bkp, or the filename that is located in the V1 folder; this is the folder that the website is installed in.
  2. Copy and Replace all files located in the files from the package.

<appSettings>

<!– MSGovern configuration file–>

<add key=”MSGovern.GovernNetConfig” value=”D:\inetpub\salestaxtest.kpb.us\v1\GovernNetConfig.xml” />

<add key=”MSGovern.SynchFileAndFolders” value=”FALSE” />

<add key=”MSGovern.CopyFilesAndFoldersLocally” value=”FALSE” />

<add key=”GovernSoftware.WebSite_Id” value=”1″ />

<add key=”GovernSoftware.DefaultPage” value=”WEBPROFILE” />

<add key=”GovernSoftware.UploadDirectory” value=”D:\inetpub\salestaxtest.kpb.us\vl\Dummy\”  />

<add key=”GovernSoftware.UploadMaxFileSize” value=”5048576″ />

<add key=”GovernSoftware.Version_dnet” value=”3″ />

<add key=”GovernSoftware.DisplayBuildVersion”  value=”Off” />

<add key=”GovernSoftware.TraceArTransactionResponse” value=”Off” />

<add key=”GovernSoftware.WebReportDirectoryPath” value=”D:\inetpub\salestaxtest.kpb.us\v1\Dummy\” />

<add key=”GovernSoftware.WebReportWidth” value=”875″ />

<add key=”GovernSoftware.WebReportViewerHeight” value=”1200″ />

<add key=”GovernSoftware.WebReportViewerZoomFactor” value=”100″ />

<add key=”GovernSoftware.WebReportViewerw1dthLandscape” value=”l080″ />

<add key=”GovernSoftware.WebReportViewerHeightLandscape” value=”825″ />

<add key=”GovernSoftware.WebReportV1ewerZoomFactorLandscape” value=”l00″ />

<add key=”GovernSoftware.ShowHelpPath” value=”False” />

<add key=”GovernSoftware.DebugMode value=”True” />

<add key=”GovernSoftware.ReportDebugMode” value=”False”  />

<!– Temporary Setup- Must add in GNA –>

<!– <add  key=”GovernSoftware.GisServerName” value=”mtldev01″/> –>

<!– <add  key=”GovernSoftware.GisGeoDataBaseName” value=”Layers@Juneau”/> –>

<!– <add  key=”GovernSoftware.AutoLogin.Login” value=”+5fJF+/cy3RmUG6brJBK9b5i/a+ycLok”/> –>

<!– <add  key=”GovernSoftware.Autologin.Password” value=”47rYbcSyyx6t 1Kx6ZnEn6QwFeKG4tNoq”/> –>

<add key=”GovernSoftware.cGovernWMUrl” value=”/st/account?suppressRedirect=true” />

</appSettings>

  • Open the config.bkp.
  1. Locate and copy the contents of the appSettings section to the new config file.

 

5. Restart the website…

The next step is to restart the website. In the IIS console…

  1. Open the Application Pools.
  2. In the Application Pool Tasks section, click Start to start the application pool of the site.
  3. In the IIS console open the Manage Website section and click Start to start the web site.
  1. At the bottom of the IIS Console, click the Content View tab at the bottom of the console to display the Content View in the console
  2. In the connections pane expand the sections to display the CommonPages
  3. Look in the CommonPages Content pane and locate aspx
  4. Click on aspx and select Browse under the Actions pane.

The default web browser will open to display the validator page; this will validate that the site is functional.

6. Validation of the installation

In the header of the validator page, the installed version of eGovern will be displayed. In addition, details of the website will also be displayed.

NOTE: The information in the Check Speed section can be ignored.

Documentation

Click here to view the content of this page as a document.

Related Topics

What’s New in the eGovern

Configuring the eGov

eGov Product Map

FAQ

 

 

201-all-egov-upgrade

 

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

Oracle Synonyms

Oracle Synonyms

Overview

Using Synonyms in Oracle (Best Practices)

An Oracle synonym basically allows you to create a pointer to an object. This object can exist in the same database, or in another database. Oracle synonyms are used because, by default, when you are logged into Oracle, it will look for all objects being queried within your schema, i.e. accounts.
A synonym allows a database administrator to define alternate names for existing database objects from other schemas.

Configurable Searches and External queries

With Govern Open Forms, you can build customized queries, open forms, Dynamic Searches, etc. based on data in different schemas and/or external databases.

Data in a different Schema but same Database Instance

When using a synonym to access data in a different schema but within the same database, it is recommended that you add the synonyms directly in the govern schema. For example, in a schema called MANTA, if you need to work with the tables, it is recommended that you create synonyms with a Govern prefix, in the Govern schema for the required tables.

 

Govern Schema MANTA Schema
Govern.PC_PARCEL
Govern.MA_MASTER Manta.External_table2
Govern.PC_ADDRESS Manta.External_table3
Manta.External_table4 (*Synonym)_ Manta.External_table4
Manta.External_table5 (*Synonym) Manta.External_table5
Manta.External_table6 (*Synonym) Manta.External_table6

 

NOTE: When creating synonyms, one limitation is that it is essential that the name used by the synonym is the same as that of the original.

Data in a different Database or Server

When using a synonym to access data in a different database or on a different server, there are two (2) methods that can be used.

Method 1

When the data is located in a different database, a connection key will need to be generated to access this database. To ensure success, you will need to be able to create stored procedures that will be used by Govern, within the database and schema. Note that this may not be the preferred methodology for System Administrators as this mixes different information within the same schema.
An alternative is to create a Govern schema within the other database, and use the synonyms to point to the desired tables. When this method is used, stored procedures will be created in the Govern Schema along with the synonyms. This is a recommended practice.

Method 2

This second method allows you to connect to an external database or server. Once a connection has been established, the synonym can be used in your current Govern database and schema.

Example of a database link

The following is an example of the commands that can be used to establish a database link.
CREATE DATABASE LINK manta.manta_server_name

CONNECT TO the manta database, IDENTIFIED BY manta_password

USING ‘manta_service_name’;

The above connects to the ‘manta’ database using the net service name ‘manta_service_name’, and is connected with a username of ‘manta’ and a password of ‘manta_password’.

With this, you can do a
SELECT * FROM upload_address@manta.manta_server_name

This will allow you to retrieve the rows from the upload_address table on the manta database residing on the manta_server_name Oracle server.

Creating the Synonym

You can also create a synonym in the following manner:

CREATE SYNONYM upload_address for upload_address@manta.manta_server_name
So that now you can do a SELECT * FROM upload_address.

Syntax

Create synonym [SYNONYM_NAME] for [SCHEMA].[TABLE_NAME] Example: CREATE synonym [UPDATE]

Using Synonym for table residing on same Server but different Schema

The following steps are for using a Synonym for a table that is on the same Server, but in a different Schema.

  1. Create a synonym for the MANTA.UPLOAD_PROPERTY table and name it GOVERN.UPLOAD_PROPERTY.
  2. Start the Business Entity Designer (BED)
  3. Create the UPLOAD_PROPERTY Business Entity (BE); create all required attributes and ensure that each attribute matches the MANTA.UPLOAD_PROPERTY table.
  4. Select the ParcelInfo Business Model (BM) and add the UPLOAD_PROPERTY business entity to it.
  5. Click on the ENTITIES (relationship) tab (A) and select PC_ParcelInformation as the parent entity and UPLOAD_PROPERTY as the child entity
  6. Under the same tab (A), define the relationship between the TAX_MAP_UFMT and ROLL_NUMBER attributes
  7. Start the Model Object Designer (MoD) and open the PC (Property Information) model.
  8. Expand the ParcelInfo item in the loaded Business Model section. You will now see the UPLOAD_PROPERTY Business Entity at the end of the list.
  9. Drag the UPLOAD_PROPERTY business entity to the property information model.
  10. Select the UPLOAD_PROPERTY cell to change it’s position.
  11. Change the Row sequence to 1 and cell sequence to 2.
    NOTE: You may also add action buttons to the UPLOAD_PROPERTY model to save/delete/etc…
  12. Click Save to save the model.
  13. Start the Govern Security Manager (GSM). Right click on Applications (A) and select Synchronize Profiles from the floating menu.
  14. Expand the applications node (A) and confirm that UPLOAD_PROPERTY is now present in the Property Control profile (B).
    NOTE: For details about the synchronization process, refer to the Govern Security Manager (GSM) release 5.0 for details.

Verification in Govern

After the synchronization process, the presence of the new tab can be verified in Govern.

  1. Start Govern and go to the Property Control profile.
  2. Open the Property Information openform.
  3. Search for and edit the Property Information for tax map number 13092095000. You will now have a tabbed document for the UPLOAD_PROPERTY business entity.
  4. Click on the UPLOAD_PROPERTY tab and the related data from the UPLOAD_PROPERTY business model will be displayed.

All editable fields can be edited and saved.

Using a Synonym for a Table residing on another Server and Schema

The following steps are for using a Synonym for a table that is on another Server with a different Schema.

  1. Create a database link to where the remote tables reside.
  2. Test and validate the new database link
    NOTE: The test must be successful.
  3. Export the DDL (save to worksheet) of the synonym UPLOAD_PROPERTY that we created earlier.
  4. Edit the DDL to add a reference to the database link to the server that we are linking to by specifying ‘@WPG11G’ as a suffix to the table name.
  5. Run a test query to verify that the link is working.

We are now querying (and joining), transparently, tables that reside on separate Oracle servers. If you run the MS Govern application, at this point, you will obtain identical results.

A Note about Security for Synonyms

In order for a synonym to function correctly, it is essential that the security be set to have access to the external tables that are pointed to by the synonym. For example to, to access a MANTA schema, you must have security access to the MANTA tables in question..

See Also

Oracle

 

 

381-Synonyms

 

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

Custom Entity – Standard Module Form Control

Standard Module Form Control – Multimedia Custom Entity

Version 6.1

Overview

This page is intended for system administrators, business analysts, or technical support for information on how to install and configure the form Custom Entity control for multimedia.
The purpose of this control is to provide management functionalities (add,delete, view) to an entity (parcel, name, st…) Multimedia Documents.
It can be used:

  • With an existing form for it’s Root Entity id documents
  • As a stand alone form for the profile Govern id
  • As a stand alone form that can be linked to for view queries link option

Form Custom Entity Name: MultimediaDocuments_Control

Configuration (Root entity)

To configure the controller with an existing form:

  • In OpenForms(TM) Designer, on the form where you want to add the multimedia, drag the Custom Entity object to the form header at the position where you want to create the new entity.
  • Then click on the new entity for tab to set the following properties.

Controller Properties

Element Property Setup
Misc. Action MultimediaDocuments_Control
Name n/a – Maintain by System
Parent Entity The form Root Entity (must be name or property base)
Name Maintain by System
Properties
Misc. SelectedMultimediaType Multimedia can be setup for different type of forms and entities.
—-Options include:
  • None
Use to be verified
  • Building
For documents linked to a building
  • Inspection
to be reviewed
  • Parcel
  • ParcelOnly
  • PersonalProperty
  • Name
  • NameOnly
  • SpecialAssessment
  • SplitMerge
Special
  • Sales
Used to display comparable sales pictures – need to verify
  • Bankruptcy
  • DelinquencyCollection
  • SRT
  • Activity
  • Workflow
Tab Sequence Tab Stop Sequence Number Standard OpenForms
Text
Misc En Enter the name that will be displayed for the form entity
i.e Multimedia

Configuration (Stand Alone)

The following is the configuration of the controller or custom control object properties.

 

 

101-std-install-multimediadocuments_control

 

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