MA – BP Close Year (Finalize Assessment Role)

Mass Appraisal Batch Process – Close Year (Finalize Assessment Role)

Overview

This batch process will set the HISTORY ONLY flag in MA MASTER for all records or based on the selected Name Record Set.
Once this flag is set, any changes made to mass appraisal data will trigger an Audit Record of -1 Certified Appraisal to be created.

The batch process name is MA_CLOSE_YEAR
Description: Finalize Assessment Role

 

 

101-ma-bp-003

 

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

MA – Sales Data Computation Batch Process

Mass Appraisal Sales Data Computation Batch Process

[Under Review]

Overview

The Mass Appraisal Sales Data Computation batch process is used to recompute the sales data with the parameters from a different year. Typically, this is used to compare sales when rates changes. For example, you can compute the sales data from five years ago with the parameters for the current year.

The computation is run on all sales records that fall within the range of dates and meet the following criteria:

  • All parcels
  • Combination of a jurisdiction and a neighborhood
  • A Saved Dataset

Prerequisites

Computation by Neighborhood

Neighborhoods are filtered by jurisdiction. In order to run the batch process by neighborhood, you need to set up the Mass Appraisal User Validation Table by Jurisidction.
To set up the Neighborhood table by jurisdiction.

  1. Launch GNA.
  2. Select Editors > User Validation Table Editor > Mass Appraisal.
  3. Select NBHD – Neighborhood.
  4. Select By Jurisdiction.

 

Running a Batch Process on a Saved Dataset

If you want to run a batch process on a group of parcels, such as parcels within a certain area or tax jurisdiction, you need to create and save a dataset. You can also use an existing dataset. In Govern, a dataset is a saved group of property records:
To create a new dataset:

  1. Launch Govern.
  2. Perform a search and load the parcel records that you want to include in the dataset to the treeview.
  3. Select the View menu.
  4. Enter a name for the dataset in the text box in the Data Sources section of the View menu.
  5. Click Save Dataset.

For further details on creating Datasets, refer to the Govern General Information documentation.

Notes

This batch process must be run synchronously.
Asynchronous processing cannot be applied to this batch process.
To verify the transaction type:

  1. Launch GNA.
  2. Open the Batch Process Editor.
  3. Select the Transaction tab.
  4. Select Synch under Transaction Type.
  5. Click Save.

If the transaction type is set to Asynch, it is changed automatically when the batch process is run.

Accessing the Sales Data Computation Batch Process

To access the Mass Appraisal Sales Data Computation batch process in Govern:

  1. Launch Govern.
  2. Select a Profile that contains the Mass Appraisal Sales Data Computation batch process.
  3. Select Mass Appraisal Sales Computation*.

*The name of the process can vary according to the setup in GNA

Sales Data Computation Parameters

Sales Date
Do one of the following:

  • Select a range of dates for the batch process using the calendars in the From and To fields.
  • Select Use Parameter from Year and enter the year.

The parcels from all records that fall within the range and meet the other selected criteria will be recomputed.

Parcels to Compute
Select one of the following options under Parcels to Compute:

  • All

Select All to run the computation on all sales records that meet the criteria for the sales date and qualification type.

  • Jurisdiction / Neighorhood

The Neighborhood is optional. However, if you want to run the process on a specific neighborhood, you must select the Jurisdiction first.
Jurisdiction
Select a Jurisdiction to run the sales data computation on a specific jurisdiction.
Neighborhood
In order to select a neighborhood, you must select a Jurisdiction first. Select the Jurisdiction. Then, select the neighborhood from the Neighborhood drop-down list.

  • Tax Map Number

Enter a range of tax map numbers in the From and To parameters under Tax Map Number.

Optional
Sale Qualification
Select one or more sales types :

  • Not qualified
  • Qualified
  • Unverified sale

Removing a Sale Qualification
Deslect a sale type to remove it.
Reports
Select the Reports tab to add any required reports to the batch process. If the batch process is scheduled, the reports can be viewed in the Govern Schedule after the process runs.

Process

Running the Process
Do one of the following:
Click the Start arrow to run the process..
Click Schedule to create a schedule to run the process at a later date or on a regular basis. Refer to the Govern Batch Processing documentation for details on scheduling batch processes.
Processing
If the batch process is run in Govern, the status can be viewed by selecting the Processing tab.

See Also

Mass Appraisal Batch Computation

101-ma-bp-005

 

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

MA – Generate Pending Audit Batch Process

Mass Appraisal Generate Pending Audit Batch Process

Overview

The Mass Appraisal Audit Pending batch process automatically generates new MA Audit Information records in Govern OpenForms. While these records can be created manually, running the batch process can save time and increase the accuracy of the records

Records can be created for a:

  • Saved dataset
  • Jurisdiction and neighborhood
  • Range of tax map numbers

The MA Audit Pending batch process updates the following fields on the MA Audit Information form. Once the batch process is complete:

  • The Status field is set to Pending.
  • The Frozen ID is set to 0.

The following fields are updated as selected on the batch process form.

  • Audit Reason Code: This is a required field.
  • Appraiser
  • Entry Date: This is a required field.
  • Entry Code
  • Activity Code: This is a required field.
  • Source Code

You can select parcels from the batch process by jurisdiction or neighborhood within a range of tax map numbers, or in a saved dataset. Alternatively, you can crate audit records for all parcels. The fiscal year is required.

The Mass Appraisal Audit Pending batch process generates Audit Information user records in Govern OpenForms. The Status field is set to Pending once the process is run. These records can be modified or deleted, as any other record.

Documentation

To read this information in pdf format, click on the following link:

BatchAuditPending.pdf

Prerequisites

The following tables are required for the Mass Appraisal Audit Pending batch process:

  • MA_APPRAISERS: This table lists the appraisers that can be selected for the audit.
  • NA_NAMES: This table lists all the name and address accounts in the deployment.
  • VT_USER.MAENTRY: This table lists the entry code that can be associated with an audit.
  • VT_USER.MAINFSRC: This table lists the source codes associated with the Mass Appraisal audit.
  • VT_USER.MAACTV: This table lists the activity codes associated with the audit.
  • VT_USER.MA_AUDIT_REASON: This table lists the reasons for conducting the audit.

If you are running the process on a saved dataset, one must be created.

Related Forms

The Mass Appraisal Audit Information form is updated by the Mass Appraisal Audit Pending batch process. The Mass Appraisal Audit Finalized batch process can be run to create finalized MA Audit Information records from pending ones.

MA Audit Information User Form

The following new fields are now included in the MA Audit Information form. These are required for the MA Audit Pending and MA Audit Finalized batch processes.

  • Status: The Status field is automatically set to Pending when you run the MA Audit Pending batch process. In this state the form can be modified or even deleted. An appraiser can update the status field to Finalized. The MA Audit Finalized batch process selects the Finalized flag. At this point, the record can no longer be modified.
  • Audit Reason Code: The Audit Reason Code contains user defined values from the VT_USER.MA_AUDIT_REASON table. When you run the MA Audit Pending batch process, you must select a reason code. This can be modified after the process is complete.

For details, see Mass Appraisal Audit Information.

Related Batch Processes

The MA Audit Finalized Batch Process is similar to the MA Audit Pending batch process. It generates finalized Mass Appraisal Audit Information records for existing MA Audit Information records with the Status set to Finalized. The MA Audit Finalized batch process selects the Finalized option and updates the Entry Code as set on the batch process. The finalized Audit Information records cannot be deleted, except by a user with authorized permissions.
For details, see Mass Appraisal Audit Finalized.

Business Rules for the MA Audit Pending Batch Process

The MA Audit Pending batch process creates new MA Audit Information records for all Mass Appraisal records that:

  • Match the Selection Criteria
  • Do not have a current MA Audit Information recording with Frozen ID 0
  • Are in the Fiscal Year selected

Creating Mass Appraisal Audits

You can use the Mass Appraisal Pending and Mass Appraisal Finalized batch processes, as follows, in order to facilitate the Mass Appraisal audit procedure. None of these steps are required.

Step 1
Receive the requirement to create a number of Mass Appraisal Audit Information records on parcels within any of the following:
  • A Saved Dataset
  • A Jurisdiction and Neighborhood
  • A Range of Tax Map Numbers
Step 2
Run the Mass Appraisal Audit Pending batch process in order to create Mass Appraisal Audit Information records.:
Result
The MA Audit Pending batch process updates the following fields on the MA Audit Information form:
Status: Sets the Status field to Pending.
Frozen ID: Sets the Frozen ID to 0. This indicates that the record is current and modifications can be made.
It updates the following fields on the user form as selected on the batch process form.
  • Entry Date
  • Appraiser
  • Entry Code
  • Source Code
  • Activity Code
  • Audit Reason Code
The record can be modified or deleted at this point.
Step 3
Perform audits on the parcels, update the Audit Information records, and set the Status field to Finalized.
Step 4
Run the MA Audit Finalized batch process in order to create a number of Mass Appraisal Audit Information records for parcels within any of the following:
Result
The MA Audit Finalized batch process updates the following fields on the MA Audit Information form:
  • Status: Sets the Status field to Finalized.
  • Value Finalized: Selects the Value Finalized check box.
  • Frozen ID: The Frozen ID is set to a value starting with -2. This is updated for each audit performed/
Updates the following field as selected on the batch process form.
Entry Code
The record is frozen and cannot be modified, unless the user is granted the required access permissions. Typically, only supervisors have access to modify frozen records.

Defining the MA Audit Pending Batch Process

There are no special requirements for the MA Audit Pending batch process. It is set up as any other batch process in Govern OpenForms. You can create as many MA Audit Pending batch processes as required.

To configure the batch process:

  1. Launch GNA.
  2. Select Editors > Batch Process Definition Editor.
  3. Select 101-ma-bp-007 – MA – Audit Pending.
  4. Enter a Code, Short, and Long Description in order to uniquely identify the batch process.
  5. Select the Transaction tab.
    The Transaction Type and Transaction Mode can be set to any value, depending on how you want to run the batch process. Refer to the Govern Batch Scheduler guide for details.
  6. Complete the other parameters as required by your organization.
  7. Click Save.

Adding the MA Audit Pending Batch Process to a Profile

In order to use the batch process in Govern OpenForms, you must add it to at least one Profile. You can add it to multiple Profiles.

To add the batch process to a Profile:

  1. Launch GNA.
  2. Select Editors > Profile Editor.
  3. Select the Profile that you want to use.
  4. Select the Links tab.
  5. Click Add in the Batch Process section to add open a secondary window.
  6. Select the batch process.
  7. Click Save.

Running the MA Audit Pending Batch Process

To run the batch process:
Open the Batch Program:

  1. Launch Govern.
  2. Open a Profile that contains the MA Audit Pending batch process.
  3. Open the Batch Processing Explorer.
  4. Select the Mass Appraisal Audit Pending batch process.

Complete the Parameters:

  1. Complete the Selection Criteria as follows.In the Parcels to Compute, do one of the following:
    Select All to create Pending Audit records for all parcels with Aduit records that do not have a do not have a status..
    Select Saved Dataset and select a saved dataset from the drop-down list.
  2. Select Jurisdiction and select a jurisdiction and neighborhood from the drop-down list.
  3. Select Tax Map Number and enter a range of tax map numbers.
  4. Enter the year you are associating with the Audit records in the Year parameter.
  5. Click on the calendar icon and select the date of the audit.
  6. Select the Appraiser who is responsible for the audit from the Appraiser drop-down list.
  7. Select the entry code from the drop-down list (Table: VT_USR. MAENTRY).
  8. Select the source code from the drop-down list (Table: VT_USR. MAINFSRC).
  9. Select the activity code from the drop-down list (Table: VT_USER. MAACTV).
  10. Select the reason for the audit from the Audit Reason drop-down list (Table: VT_USR.MA_AUDIT_REASON).

Run the Program

  1. Do one of the following:
    Click Run to run the batch process immediately.
    Click Schedule to run the batch process at a later time.

Viewing the MA Audit Log Files

The following information is logged and appears on the Processing tab of the MA Audit Information batch process in Govern. If you are scheduling the process to run at a later time, the information can be viewed on the Log Files in the Govern Schedule

Parameter: ReasonCode = The Reason Code selected for the batch Process.
Parameter: BatchProcessType = The name of the batch process.
Parameter: Appraiser = The name of the appraiser who is responsible for the audit.
Parameter: EntryDate = The date of the audit.
Parameter: EntryCode = The entry code selected for the Audit.
Parameter: Activity = The activity code selected for the audit.
Parameter: SourceCode = The source code selected for the audit.
Parameter: ValueFinalized = Displays True or False according to whether the Value Finalized option is selected or deslected.
Parameter: YearId = The year the audit occurred.
Parameter: IsAllParcels = Displays True or False according to whether All is selected.
Parameter: CanChooseJurisdictionNeighborhood = Displays True or False according to whether the Jurisdiction option is selected.
Parameter: Jurisdiction = Displays the code for the jurisdiction.
Parameter: Neighborhood = Displays the code for the jurisdiction and neighborhood.
Parameter: CanChooseTaxMapRange = Displays True or False according to whether the Tax Map Number options is selected.
Parameter: TaxMapStart Displays the starting tax map number in the range.
Parameter: TaxMapEnd: Displays the ending tax map number in the range.
Parameter: CanChooseSavedDatasets = Displays True or False according to whether the saved dataset option is selected.
Parameter: SavedDataset Displays the name of the Saved Dataset.
Parameter: AuditBatchID = Displays the Batch ID associated with the audit.
Parameter: MaxNumberProcess = Displays the maximum number of records processed.
Parameter: RunBatchAsync = Displays True or False according to whether the transaction type of the batch process is Synchronous or Asynchronous
Information: Parameter: TransactionMode = Displays the transaction type, such as ContinueIfOneTransactionFail
Parameter: BatchId = Displays the batch ID.

Viewing the Updated Record in Govern

Once the batch process is run, a new audit record is created with the status set to Pending for all parcel records that meet with the criteria.
To view the updated records.

  1. Launch Govern.
  2. Open a Profile that contains the MA Audit Information form.
  3. Perform a search to retrieve the required records.
  4. Select a record.
  5. Open the MA Audit Information form.
  6. Scroll to the required record.

 

 

101-ma-bp-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...

 

MA – BP Generate Audit Finalized

Mass Appraisal Generate Audit Finalized Batch Process

Release 6.1

Overview

The Mass Appraisal Audit Finalized batch process sets all Mass Appraisal Audit Information that meet the following criteria to Finalized:
The Status field of the Audit Records is set to Finalized.

The parcels are in the dataset, jurisdiction, neighborhood, or range of tax map numbers selected.

NOTE: Once records are finalized, they can no longer be modified, except with required permissions in alternate security.

Documentation

To view this information in pdf format, click on the following link:

BatchAuditFinalized.pdf

Business Rules for Finalized Records

When the Value Finalized option is selected on the MA – Audit Information form, a frozen record is automatically created. The first time the record is frozen, it is assigned Frozen ID -2. The next time, it is assigned Frozen ID -3, and so on.

Users can view frozen records by selecting the applicable year and Frozen ID in the History Panel, provided they have the required access permissions. Records from all Mass Appraisal forms can be viewed.

Access rights are required for viewing and modifying frozen records. These are defined in the OFD by selecting the Alternate type and then setting rights for the required Profile, Roles and users.

Related Information

Refer to the Govern OpenForms Designer (OFD) documentation for details.
Refer to the Mass Appraisal General Information documentation for further details on frozen records.

Prerequisites

Required Tables

The following tables are required for the Mass Appraisal Audit Pending batch process:

  • MA_APPRAISERS: This table lists the appraisers that can be selected for the audit.
  • NA_NAMES: This table lists all the name and address accounts in the deployment.
  • PC_PARCEL: This tables lists all the parcels in the deployment.
  • VT_USER.MAENTRY: This table lists the entry code that can be associated with an audit.
  • VT_USER.MA_AUDIT_REASON: This table lists the reasons for conducting the audit.
  • VT_USER.MA_AUDIT_STATUS: This table lists the Pending and Finalized status codes that are required for the audit.

Required Records

Ensure that the Mass Appraisal Audit Information records are up to date.
If you are running the process on a saved dataset, one must be created.

Related Batch Processes

The Mass Appraisal Audit Pending Batch Process is similar to the Audit Finalized batch process. It generates Mass Appraisal Audit Information records and sets the Status to Pending. These records can be modified or deleted. The finalized Audit Information records cannot be deleted, except by a user with authorized permissions.

Defining the MA Audit Information Form

The following new fields are now included in the MA Audit Information form. These are required for the MA Audit Finalized and MA Audit Pending batch processes.

Status
The Status field is automatically set to Pending when you run the MA Audit Pending batch process. In this state the form can be modified or even deleted. An appraiser can update the status field to Finalized. The MA Audit Finalized batch process selects the Finalized flag. At this point, the record can no longer be modified.
Audit Reason Code
The Audit Reason Code contains user defined values. When you run the MA Audit Pending batch process, you must select a reason code. This can be modified after the process is complete.

Creating Mass Appraisal Audits

You can use the Mass Appraisal Pending and Mass Appraisal Finalized batch processes, as follows, in order to facilitate the Mass Appraisal audit procedure.
Step 1
Receive the requirement to create a number of Mass Appraisal Audits.
Step 2
Run the Mass Appraisal Audit Pending batch process in order to create Mass Appraisal Audit Information records for parcels within any of the following:

  • A Saved Dataset
  • A Jurisdiction and Neighborhood
  • A Range of Tax Map Numbers

Result
The MA Audit Pending batch process updates the following fields on the MA Audit Information form:
Status: Sets the Status field to Pending.
Frozen ID: Sets the Frozen ID to 0. This indicates that the record is current and modifications can be made.
Sets the following fields as selected on the batch process form.

  • Entry Date
  • Appraiser
  • Entry Code
  • Source Code
  • Activity Code
  • Audit Reason Code

The record can be modified or deleted at this point.
Step 3
Perform audits on the parcels, update the Audit Information records, and set the Status field to Finalized.
Step 4
Run the MA Audit Finalized batch process in order to create a number of Mass Appraisal Audit Information records for parcels within any of the following:

  • A Saved Dataset
  • A Jurisdiction and Neighborhood
  • A Range of Tax Map Numbers

Result
The MA Audit Finalized batch process updates the following fields on the MA Audit Information form:
Status: Sets the Status field to Finalized.
Value Finalized: Selects the Value Finalized check box.
Frozen ID: The Frozen ID is set to a value starting with -2. This is updated for each audit performed/
Updates the following field as selected on the batch process form.
Entry Code
The record is frozen and cannot be modified, unless the user is granted the required access permissions. Typically, only supervisors have access to modify frozen records.

Defining the MA Audit Finalized Batch Process

There are no special requirements for the MA Audit Finalized batch process. It is set up as any other batch process in Govern OpenForms. You can create as many MA Audit Finalized batch processes as required.
To definethe batch process:

  1. Launch GNA.
  2. Select Editors > Batch Process Definition Editor.
  3. Select 101-ma-bp-008 > MA – Audit Finalized.
  4. Enter a Code, Short, and Long Description in order to uniquely identify the batch process.
  5. Select the Transaction tab.
  6. The Transaction Type and Transaction Mode can be set to any value, depending on how you want to run the batch process. Refer to the Govern Batch Scheduler guide for details.
  7. Complete the other parameters as required by your organization.
  8. Click Save.

Adding the MA Audit Finalized Batch Process to a Profile

In order to use the batch process in Govern OpenForms, you must add it to at least one Profile. You can add it to multiple Profiles.
To add the batch process to a Profile:

  1. Launch GNA.
  2. Select Editors > Profile Editor.
  3. Select the Profile that you want to use.
  4. Select the Links tab.
  5. Click Add in the Batch Process section to add open a secondary window.
  6. Select the batch process.
  7. Click Save.

Before Running the MA Audit Finalized Batch Process

Ensure that all MA Audit Information records are up to date in the dataset, jurisdiction and neighborhood, or range of tax map numbers that are selected.
To view the updated records.

  1. Launch Govern.
  2. Open a Profile that contains the MA Audit Information form.
  3. Perform a search to retrieve the required records.
  4. Select a record.
  5. Open the MA Audit Information form.
  6. Scroll to the required record.
  7. Ensure the following:
    The Status field is set to Finalized.
    The Finalized option is deselected.

The MA Audit Information record can still be modified at this point.

Running the MA Audit Finalized Batch Process

To run the batch process:

  1. Launch Govern.
  2. Open a Profile that contains the MA Audit Finalized batch process.
  3. Open the Batch Processing Explorer.
  4. Select the Mass Appraisal Audit Finalized batch process.
  5. Complete the Selection Criteria as follows.
    In the Parcels Selection section, do one of the following:
    Select All to create Pending Audit records for all parcels that do not have Audit records for the selected year.
    Select Saved Dataset and select a saved dataset from the drop-down list.
    Select Jurisdiction and select a jurisdiction and neighborhood from the drop-down lists.
    The jurisdictions and neighborhoods are year-based.
    Ensure that the correct year is entered in the Year field.
  6. Select Tax Map Number and enter a range of tax map numbers.
  7. Enter the year you are associating with the Audit records in the Year parameter.
  8. Select the entry code from the drop-down list (Table: VT_USR. MAENTRY).
  9. Click Save.

Viewing the MA Audit Finalized Log Files

The following information is logged and appears on the Processing tab of the MA Audit Finalized batch process in Govern. If you are scheduling the process to run at a later time, the information can be viewed on the Log Files of the Govern Scheduler.

Information: Starting Time: Displays the starting of the batch process
Parameter: UserId = Displays the name of the user who ran the process.
Parameter: BatchId = Displays the batch ID.
Information: Parameter: TransactionMode = Displays the transaction type, such as RollBackIfOneTransactionFails
Parameter: RunBatchAsync = Displays True or False according to whether the transaction type of the batch process is Synchronous or Asynchronous
Parameter: MaxNumberProcess = Displays the maximum number of records processed.
Parameter: AuditBatchID = Displays the Batch ID associated with the audit.
Parameter: SavedDataset Displays the name of the Saved Dataset.
Parameter: CanChooseSavedDatasets = Displays True or False according to whether the saved dataset option is selected.
Parameter: TaxMapStart Displays the starting tax map number in the range.
Parameter: TaxMapEnd: Displays the ending tax map number in the range.
Parameter: CanChooseTaxMapRange = Displays True or False according to whether the Tax Map Number options is selected.
Parameter: Jurisdiction = Displays the code for the jurisdiction.
Parameter: Neighborhood = Displays the code for the jurisdiction and neighborhood.
Parameter: CanChooseJurisdictionNeighborhood = Displays True or False according to whether the Jurisdiction option is selected.
Parameter: IsAllParcels = Displays True or False according to whether All is selected.
Parameter: YearId = The year the audit occurred.
Parameter: ValueFinalized = Displays True to indicate that the Value Finalized option is selected.
Parameter: EntryCode = The entry code selected for the Audit.
Parameter: EntryDate = The date of the audit.
Statistics: Total Records To Process = Displays the number of records in the batch.
Information: Statistics: Total Records Processed = Displays the total number of records processed.
Ending Time: Displays the time the batch process ended.

Viewing the Updated Record in Govern

Once the batch process is run, a new audit record is created with the status set to Pending for all parcel records that meet with the criteria.
To view the updated records.

  1. Launch Govern.
  2. Open a Profile that contains the MA Audit Information form.
  3. Perform a search to retrieve the required records.
  4. Select a record.
  5. Open the MA Audit Information form.
  6. Scroll to the required record.

 

 

101-ma-bp-008

 

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

Govern Scheduler Version 5

Overview

NOTE: The following page is intended for version 5 and lower of the Govern Scheduler Console (SC) application.

The Govern OpenForms product suite gives you a lot of flexibility for setting up and running batch processes. You can now:

  • Customize the list of batch processes that appear in Govern.
  • Add as many or as few batch processes as are required for your organization.
  • Set the transaction type and mode.
  • Add automatic e-mail messaging.
  • Add reports or attachment.
  • Define a network path or FTP site for saving or uploading the attachment.
  • Set up schedules to run processes at a later time or on a regular basis.
  • Apply security so that only authorized users can view certain batch processes.

With the Govern Scheduler, you can:

  • Monitor and track your Govern batch processes in one central location.
  • View the progress of batch processes as they run.
  • Modify or delete any scheduled process to which you have access permissions.
  • View logs and details on previously-run batch processes.
  • View reports generated from previously-run processes.
  • Monitor the Govern Scheduler Services

Installation

For details on installing the Govern Scheduler, see Installation.

Documentation

Govern Scheduler guide version 5.1

Technical Info

The Govern OpenForms System Requirements on this site 100-SystemReq apply to the Govern Scheduler.

Govern Batch Scheduler Technical Sheet and Installation [106-TechSheet]

Testing with SMTP4Dev

To test the e-mail notification, developers and BA’s may want to use SMTP4Dev. Download the Installer and set it up to launch automatically at login.

NOTE: Internal users can select the following link and obtain the installer on \\FSERVER\sharedPG\SMTP4Dev\

106-(tech)-SMTP Server for Testing Purpose (smtp4).docx
Details
Download
128 KB

Alternatively, you can use the Harris e-mail Server
mail.harriscomputer.com

https://206.191.12.18/

Related Links

Govern Product Suite

Internal Material

BSS Installation Material – PKO –

  • 106-Batch Services.pptx
  • Details (
    Download (537 KB)

 

 

106-all-sc-v5

 

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

 

 

 

Batch Scheduler Service Installation

Batch Scheduler Service Installation

Version 6.0 and 6.1

Overview

Step by step Govern Batch Scheduler Service installation procedure.

  • Before Getting Started (Requirements, Prerequesites)
  • Step by Step Installation

See What’s New in Govern Batch Scheduler
If you are installing the Batch Scheduler Service for OpenForms Version 5 and less, click here (106-all-SC-v5).

Before Getting Started

Validate Requirement

A dedicated server is strongly recommended. To maximize execution speed, the most important factors are:

  • Memory (Quantity and Type)
  • Network (Speed and Routing)

Govern System Requirements

Email Notification Server Information

SMTP Server Information

The batch scheduler generates email. To enable this option, you will need to supply SMTP server and account information for the organization.

  • Host Name
  • Port Number
  • Username & Password

SMTP4Dev Test Server setup (Optional)

  • For testing purposes, you can Install SMTP4Dev, a dummy SMTP server that sits in the system tray and does not deliver the received messages. This Open Source Software is distributed by Code Plex. For more information or to download, see smtp4dev.codeplex.com

Step by Step Installation

Step 1 – Deploy Binaries and Services

Refresh the source environment. The deployment/connection key for which we want to have a scheduler service.

  • Deploy the latest binaries, services and installation pack
    • Binaries
      • Resources
      • Custom Control
      • System Files
      • Govern Scheduler
    • Services
      • Govern Scheduler Service
      • Govern WCF Services
    • Install Pack
  • Run a Database Verification

Step 2 – Install / Verify Email setup

In Govern Administrator, in General Settings Editor (SY REGISTRY)

  • Select Registry Filter Section = General | Section Name = SMTP
    • Host:
    • Port: Any port that is not currently in used (ex:6666)
    • Connection User and Password
    • Default Sender Address
TESTERS: Click here to download and install a Test SMTP Server

 

Step 3 – Install the Batch Scheduler Service

On the server where you will be installing the Govern Scheduler application:
Execute (double-click) BatchSchedulerServiceSetup.exe located on the deployment server INSTALL > VERSION > Batch Scheduler Service Setup Folder

  • Supply the Deployment Configuration Path
    • GovernNetConfig.xml Path: Located in the source DEPLOYMENT Folder (Note: Use UNC path if typed in)
  • The following information will auto-fill
      • Base Installation Path:
      • Full Installation Path:
      • Deployment Name:
      • Connection Name:
      • Service Name: GovernSchedulerService_[Connection Key]
        • NOTE: Copy the name to notepad or word as the service name will be needed later during the installation
  • Enter the Failure Alert Configuration
    • Email Address: Provide one or more e-mail addresses in order to have key users receive e-mail alerts when a program failure occurs. The default message that you enter is sent
    • SMTP Server
    • Email Subject and Email Body
  • Click Start and once completed, you can exit.

Once completed, in Task Manager, Services, you should have the following service running

  • GovernSchedulerService_[Connection Key]

Step 4 – Configure Govern Scheduler in GNA

In Govern Administrator, in General Settings Editor (SY REGISTRY) – to be validated

  • Select Registry Filter Section = Batch Process | Section Name = Scheduler
    • Scheduler Service Port Number: Any port that is not currently in used (ex:6666)
    • Scheduler Service Machine Name:
    • Minimum Batch Process Interval for Update (minutes): Number of minutes needed for upgrade (will not auto-upgrade if a batch is schedule to be executed in X minutes) – usually 15 minutes
  • Select Registry Filter Section = Batch Process | Section Name = Batch Process
    • Worker Service Address – see roadmap

Step 5 – Launch Govern Scheduler

Double-click on the shortcut to install the Govern Scheduler

  • Verify there are no error messages and that the service is listed on the second tab

Step 6 – Test Service

In order to ensure the Batch Scheduler Service is installed properly:
Setup and execute the standard Batch Test Process

  • Setup the Batch Process Test Service GNA > Editors > Batch Process Definition
  • Setup Batch Definition
    • Email Notification: TIP: Use groups for email alerts
    • Report
    • Schedule: in 5 minutes
  • Setup Second Batch Definition
    • Schedule: in 15 minutes

 

Uninstalling the Govern Scheduler Service

In version 6.0, you need to run the Command Prompt CMD as ADMINISTRATOR to uninstall.

  • sc delete [service name]
    • NOTE: The service name listed may not be the actual service name, check in TASK MANAGER, SERVICES and right-click for PROPERTIES or to OPEN SERVICE to validate. The name listed there is the name to use in the command.
    • SERVICE NAME = GovernSchedulerService_DEPLOYMENT NAME
    • example: C:\Windows\System32> sc delete GovernSchedulerService_ARVADA_MTL-SQL2014

Troubleshooting

Verify that no other Service is running

  • Open Task Manager, Services and click on the name column to sort the services by name.
  • Check if any other services for GovernSchedulerService …

Verify that the Windows Service is running

  • Open Task Manager, Services and find the Service Name

Verify Services Tab in Scheduler

  • Verify Error Messages in Govern Schedule (History Log)

Firewall

  • If the server is protected by a firewall, verify that incoming traffic is allowed on the port you have configured in GNA

Path for Files

  • If you get an error during the batch execution for ‘Access to the Path is denied’ you need to make sure the folder has Read/Write access.

VERSION 5 Installation

For more detail information, see the following extract from the Govern Scheduler Guide [pdf] Getting Started and Installation – to be reviewed

See Also

 

 

106-install

 

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

202-all-mgovern

 mGovern – Your Mobile Solution

Overview

The mGovern Mobile Solution provides a secure, user-friendly interface for transferring property records from the office server to a mobile device. It also allows for updating records in the field over a wireless connection or when disconnected from the office server. Records are kept up to date and synchronized on both the Mobile device and the Office server.
For more information, see technical info or education plan.

Configuration

The mGovern solution offers easy, secure configuration and installation in any Govern environment .
To configure the mGovern mobile solution:

  • Create a database on each mobile device. The Govern structure is copied to these databases when the application is installed.
  • Create a temporary database on a server. This is used for the deployment and initialization only.
  • Deploy the mGovern solution using Deploy EZ as you would any application in the Govern Product Suite, version 5.1.
  • The Govern database is copied to the mGovern database during deployment.
  • The user transfers records directly from the source database on the office server to the mGovern database when required.

 

NOTE: To improve the user experience, special forms can be designed to better fit the mobile device display characteristics.

 

Read More...

 

User Interface

The Govern Mobile UI provides user forms with the same look-and-feel and features as the Govern for .NET application.
The following are available in the mobile application:

  • All the user forms available in Govern.NET
  • All the functionality available in Govern.NET
  • Same user form layout and icons
  • Same Govern Ribbon and Status Bar
  • Dataset TreeView, Forms and Reports Explorer
  • Predefined Searches

Process Schema

Click below to view/download the mGovern process flowchart.
mGovern 6.0_01.pdf

Documentation

Click below to view/download the mGovern Release 6.0 User Guide
202-all-mgovern[guide]-(6.0).pdf

Schema – Govern 6.0 Mobile Solution
Schema – mGovern 6.0 Process Flow

Technical

See [6.0] Mobile Technical Page

Education

Also available, Mobile 6.0 Hands-on Installation Course Education Agenda and Plan page.
Class 2-201.202-Mobile

See Also

Initialize Mobile Database
Govern Mobile Technology

Govern Administrator (GNA) System Wiki Map

 

 

202-all-mgovern

 

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