100-encryption

Encryption Methodology

Version 6.0/ Version 6.1

Overview

A new standard encryption method was implemented in OpenForms 6.1.
For compatibility purposes, changes were made in the Business Entity Designer in order to select which encryption mode to use.
A Correction Script is provided to convert the data.

Encryption Mode

Business Entity Designer Attribute Properties

The options include:

Legacy3

Compatible with Govern for Windows

Legacy5

Compatible with Govern for Windows

TripleDES

New Encryption mode available for OpenForms GA 1609 in version 6.0+

None

No Encryption – System Default

Configuration

The setup is made by attribute in the Business Entity Designer (BED).
The following are the standard OpenForms business entity attributes encrypted:

ACH Information by Name Entity

NA_ACHINFO

BANK_ACCOUNT_NO
BANK_TRANSIT_NO

Miscellaneous Correction Script
A Miscellaneous Correction Script is provided when executing the GNA – Utility Verify Database.
Upon execution, a warning message will be displayed.
When double-clicking the message, the warning along with an hyperlink to execute the Miscellaneous Script will be presented.
Should be run with care!
See also:

Troubleshooting

The User Password located in the USER MANAGEMENT users is encrypted.
Table USR_USERFILE

Please note that the User Password is not used in Govern OpenForms 6.1 except in certain circumstances:

Administrator Login Action Button (To Be Validated)
Deployment of Type GOVERN instead of MSAD (Validate: do we encrypt in 6.1 – was encrypted in Security Manager 6.0 and less?)

If the new encryption mode is used, and the circumstances can be met, it is recommended to open and make a modification to the users in order to RE-SAVE the records with the new encryption mode.

100-encryption

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

100-install-SMTP4Dev

Test SMTP Server Installation

Overview

For testing purposes, you can install SMTP4Dev, a dummy Simple Mail Transport Protocol (SMTP) server that sits in the system tray and does not deliver the received messages. This Open Source Software is distributed by Code Plex.
To download and get more information, access the Code Plex website smtp4dev.codeplex.com

Downloading

You can download the SMTP4Dev server from Code Plex (Open Source Distributor)
www.smtp4dev.codeplex.com

Harris Govern Employees, can copy from the Shared Program Folder
FSERVERsharedPGSMTP4Dev

Alternatively, when testing on the Harris Govern server, you can use the Harris e-mail Server.
Contact Govern Support for the SMTP server information account information.

Installation and Setup

Read More...Read Less...

Once downloaded and installed (double click on the documented downloaded), you will see an email icon in the system tray or on your desktop.
RIGHT-CLICK on the icon, and select OPTION in the menu
On the Server Tab, you need to setup:

Port Number

Default is 25 but it can be changed if already used.

Listen Interface

Select 0.0.0.0 for all or 127.0.0.1 for local

The same information needs to be setup in Govern Administrator, Parameters, General Settings Editor, Filter = General, Section Name = SMTP

FOR DETAIL INFORMATION and print screens, see SMTP4Dev Setup Presentation

Page	Date Edited
No Links

OpenForms Reference – What’s New!

Version 6.0

Overview

This table contains changes made to supported OpenForms Reference items between major releases. Table is entered by date, newest items first.
Click here to return to the OpenForms Reference main page.

Date yyyy/mm/dd…..	Version . .[6.0.0000]. .	Element …. (Form, Business Entity, Query, etc.) ………….	……Description……..



2014-08-25	6.0.1408	Business Entity Expression X	Expression was changed to

Return to OpenForms Reference

100-ofr-new

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

100-Installation-FromScratch-WM

Govern Installation from Scratch – Workflow Management

Version 6.1 (In Development)

Overview

This section covers the steps and the best practices when installing Workflow Management 6.1 from scratch.
For upgrades or updates see 100-Upgrade where you will find tools, tips and training material to help with the upgrade.
Click on Installation 100-Install to return to the main Installation page.

Note to Govern Employees : See Test Case 100-Install from Scratch Workflow Management (20238)

Step by Step

The following steps need to be accomplished to install and configure Workflow Management.

1- Create Empty Database

Create new db, deploy and initialize database (run Verify Database twice)

2-Create Departments

In GNA Parameters, Department Maintenance, create 2 new departments with a multimedia-code:
- d1: Dept 01 by PID (A/R….)
  - Sub-System Allowed (Land Management, Tax Title, Miscellaneous Billing…)
  - Multimedia Code (d1-Memo) – Not shared with other departments (i.e. Information Private to Department)
- d2: Dept 02 By Name
  - Sub-System Allowed (Land Management 2)
  - Multimedia Code (pdf) and Multimedia Code (Stored in Database

3-Set A/R Sub-System Configuration for Workflow

in GNA Application Configuration, select A/R General Parameters and click on Land Management in Related Sub-System Parameters
Select Link A/R to Names option

TIP: Configuring the Workflow
– When saving the Kind and Category parameters, the save applies to the Kind dependencies (Categories and their added fields).

4-Configure Workflow Kind & Categories

in GNA, Application Configuration, select Workflow Management, Kind & Categories

100-Installation-FromScratch-WM

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

100-Queries-(Advanced SQL Queries)

Advanced SQL Queries

The prior sections contained general rules that are to be followed when creating SQL queries. The following are specific examples of issues with advanced queries, and how they may be resolved.

A. Double Brackets Workaround

Database entries in Govern can have three (3) states, TRUE, FALSE, and NULL. The NULL is placed in a field as a placeholder when no data is entered. TRUE is equal to a value of -1, FALSE is equal to zero (0), and the NULL should equate with zero (0).

A NULL value is treated differently from other values due to its special nature. NULL and 0 cannot be compared because they are not equivalent.
The following example demonstrates how the NULL can be handled when it is encountered in the database.

In the following query…

Read More...Read Less...

Query Fragment

SELECT PC_PARCEL.P_ID, PC_PARCEL.TAX_MAP, PC_ADDRESS.FORMATED_ADDRESS, PC_PARCEL.EFFECTIVE_YEAR, PC_PARCEL.INACTIVE_YEAR

FROM PC_PARCEL left outer join PC_ADDRESS on PC_PARCEL.P_ID=PC_ADDRESS.P_ID AND PC_ADDRESS.LOC_SEQ=0

WHERE (PC_ADDRESS.CIVIC IS NULL OR (PC_ADDRESS.CIVIC>=@pcfhouseno_0 AND PC_ADDRESS.CIVIC<=@pcthouseno_1))
AND (ISNULL(PC_ADDRESS.STREET,”) = ISNULL(@pcstreetname_2PC_ADDRESS.STREET,”))
AND (ISNULL(PC_ADDRESS.SUFFIX,”) = ISNULL(@pcstreettype_0PC_ADDRESS.SUFFIX,”))

In the above query, the SQL ISNULL() function is used, so that when searching specified columns in the table, should a NULL character be encountered, the ISNULL() function will equate it with zero (0). In the above example a modification in the form of double square brackets “[[ ]]”, have been added to the query. This modification has been made for the DAB. When When the DAB encounters double-brackets it will immediately use the data type of the TABLE.COLUMN combination that are within the brackets to declare the leftmost variable that is outside of the brackets, in our case the ISNULL.

B. NULL Characters Alternate Method

As stated in the previous example, the database entry can have three (3) states, TRUE, FALSE, or NULL. A check box in a user interface can have two (2) states, TRUE (-1), or FALSE (0). We would need to code our query to equate a NULL with a zero (0). The following example demonstrates an alternate method of handling the NULL character.

Query Fragment

AND(PC_PARCEL.NON_PARCEL_FLAG=@pcnonparcel_0 OR ( 0=@pcnonparcel_0 AND PC_PARCEL.NON_PARCEL_FLAG IS NULL))

The above statement is written to handle the NULL by equating NON_PARCEL_FLAG with NULL.

The above example statement can also be recreated with the double brackets method. The statement would be as follows:

AND (PC_PARCEL.NON_PARCEL_FLAG=@pcnonparcel_0PC_PARCEL.NON_PARCEL_FLAG,”)

C. Linking Interface Selections

We would like to present the user with a search option that will include inactive parcels. Unfortunately in the database there is no field in the database that will tell you that a parcel is inactive. To be able to link something that does not exist in the database to something that does, and get a TRUE or FALSE value that we can then manipulate.

The PC Inactive Parcel field does not exist in the database but we want the user to use the check box, it will have to be linked to one that is of the same type. i.e. integer, float, text, small int, etc.

Create a dummy condition

This is a condition that will always return a value of TRUE, this also declares a variable based upon a column.

AND (PC_PARCEL.NON_PARCEL_FLAG=@pcinactiveparce_0 OR 1=1)

To declare the pcInactiveParcel object, we will link it to a field that is of the same type as that required by the checkbox, i.e PC_NON_PARCEL_FLAG. The DAB will now be able declare pcInactiveParcel as valid.

The conditions are now set for the two states of the checkbox option…

AND (( 0=@pcinactiveparce_0 AND PC_PARCEL.EFFECTIVE_YEAR<= year id AND

PC_PARCEL.INACTIVE_YEAR > year id )

OR (-1 = @pcinactiveparce_0 ))

If the Include Inactive Parcel option is not checked, i.e. FALSE (0), or Include Inactive Parcel is checked, TRUE(-1).

Following the above steps, we are able to declare a variable based upon a column. Based upon the fact that the variable does not exist, the Data Access Block (DAB) is being directed not to look directly at the column, but rather it is being told what to expect.

Best Practices for SQL Queries

Specify Table and Field Names

When creating SQL queries, it is good practice to specify both the table and the field names in your WHERE query statement.

EXAMPLE 1

The Original query below would function in Govern for Windows, but would result in an error in Govern.NET. In order for it to function
in Govern.NET it is necessary to include the table name in the WHERE statement. This was done in the Corrected example by using a “.” as a
separator.

Read More...Read Less...

Original

select count(*)
from pm_lk_permit_name,na_company_info
where key_id = permit id
and pm_lk_permit_name.na_id = na_company_info.na_id
and link_type = ‘contr’
and cont_type = ‘SI’
and (in_exp_date < current date or in_exp_date is null)

Corrected

select count(*)
from pm_lk_permit_name,na_company_info
where pm_lk_permit_name.key_id = permit id
and pm_lk_permit_name.na_id = na_company_info.na_id
and pm_lk_permit_name.link_type = ‘contr’
and na_company_info .cont_type = ‘SI’
and (na_company_info.in_exp_date < current date or
na_company_info.in_exp_date is null)

Specifying the table name in the WHERE statement is a good practice to follow when building SQL queries.

EXAMPLE 2

Another example of a query is the following. This is a SELECT query for PRIMARY_LAND

Original
SELECT DISTINCT
I.PRIMARY_LAND
FROM
PC_LEGAL_INFO I LEFT JOIN
PC_AREA A ON A.P_ID = I.P_ID
WHERE
I.P_ID = Parcel ID AND
I.YEAR_ID = Year ID AND
A.FROZEN_ID = Frozen IDCorrected
SELECT PC_LEGAL_INFO.PRIMARY_LAND FROM PC_LEGAL_INFO WHERE
PC_LEGAL_INFO.P_ID = Parcel ID AND PC_LEGAL_INFO.YEAR_ID =
Year ID AND PC_LEGAL_INFO.FROZEN_ID = Frozen ID

Results in the Treeview

Controlling the appearance of Results in the Treeview

One feature of the Govern.NET application is the users ability to control the appearance of results in the Treeview. This feature will appeal to users that perform queries that require that they display a Tax Map as opposed to a Parcel.

FOR EXAMPLE:

In the following query, the Tax Map Number (‘TAX_MAP’) is being replaced with the Roll Number (‘ROLL NO’).

SAMPLE LISTING:

Name: ParcelDesc001
SELECT
CASE
WHEN A.NON_PARCEL_FLAG = -1 AND NON_PARCEL_ID > 0 THEN ‘PREMISE ID: ‘ ||
CAST(A.NON_PARCEL_ID AS VARCHAR(30)) || ‘ ‘ || B.CURRENT_TENANT
WHEN A.NON_PARCEL_FLAG = -1 AND NON_PARCEL_ID IS NULL THEN ‘P ID: ‘ || CAST(A.P_ID
AS VARCHAR(30))
ELSE ‘ROLL NO: ‘ || A.TAX_MAP
END
FROM PC_PARCEL A LEFT JOIN V_PC_OCCUPANT_CURRENT_TENANT B ON A.P_ID = B.P_ID
WHERE A.P_ID = 261362 AND ROWNUM = 1

When the above sample code is incorporated in the query, results with Tax Map numbers will be displayed with the Roll Number.

Standard Batch Process – Report Scheduler

General

The Report Scheduler is used to schedule a report that is not associated with a batch process but needs to be run on a regular basis. You may, for example, want to run a report every night that does not require any data from a batch process.

Process description: Report Scheduler
Process name: co_NoProcess

Specification

Prerequisites

Batch Process Definition is created and linked to profile
SSRS or Crystal Report is configured
The same report can be used in multiple batch process definitions

Configuration

Create a batch definition process and select report to be executed

- When you add the report to the batch process definition, you need to define or update the Export Format Type
- PDF, CSV, RPT, etc.
Add newly created batch process definition to profile

Tools and Tips

Before getting started

Take down the report code as it will need to be specified (report selection window does not show description)

Troubleshooting

Execute the report stand-alone before setting it up with a batch process definition

100-bp-ScheduleReport

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

Encryption Methodology

Overview

Encryption Mode

Configuration

ACH Information by Name Entity

Troubleshooting

Test SMTP Server Installation

Overview

Downloading

Installation and Setup

Port Number

Listen Interface

See Also

OpenForms Reference – What’s New!

Overview

Govern Installation from Scratch – Workflow Management

Overview

Step by Step

1- Create Empty Database

2-Create Departments

3-Set A/R Sub-System Configuration for Workflow

4-Configure Workflow Kind & Categories

Advanced SQL Queries

A. Double Brackets Workaround

Query Fragment

B. NULL Characters Alternate Method

Query Fragment

C. Linking Interface Selections

Create a dummy condition

Related Topics

Best Practices for SQL Queries

Specify Table and Field Names

EXAMPLE 1

EXAMPLE 2

Results in the Treeview

Controlling the appearance of Results in the Treeview

FOR EXAMPLE:

SAMPLE LISTING:

Related Topics

Standard Batch Process – Report Scheduler

General

Specification

Configuration

Tools and Tips

Troubleshooting