Mass Maintenance

Create Custom Pages and Views

Before performing this task:

  1. Create a looped template and process in Integrate. Refer to BDC Script Template with Looping Enabled or GUI Script Template with Looping Enabled in Integrate for more information.
  2. Create all tt Tables and tx Views for the Integrate Process
  3. Create rt Tables from the tt Tables

Once all of the necessary tables and tx views are created, create the custom pages and views in Mass Maintenance outlined in the following sections. Create the views in the same database where the tt tables and tx views were created.

After creating custom pages and views, continue with Create a Template that Uses the Custom Pages in Mass Maintenance.

Create Data Entry Pages and Views

Create Data Entry pages for each of the tt tables and name these pages 'xxx' where 'xxx' describes the page activity.

NOTE: Most column properties do not need to be specified on these pages.

Add column properties to the page to hide the following columns: ID, LockReject, PostError, RejectedBy, RejectReason, PostMessage, Reject, RequestID, and ViewName.

Disable Severity and ValidationErrorMessage.

Create Horizontal views for each Data Entry page named web'xxx'Hor where xxx describes the page activity. Register each view to the corresponding Data Entry page.

NOTE: Page Table should have an ID column that is set as the PrimaryKey.

Create Approval Pages and Views

Create an Approval page for each Data Entry page. These pages will use the tt table used by the corresponding Data Entry page. Name these pages 'xxx - Review' where xxx describes the page activity.

Add column properties to the page to hide the following columns: ID, LockReject, PostError, RejectedBy, PostMessage, RequestID and ViewName.

Disable Severity and ValidationErrorMessage. Enable Reject and RejectReason.

Create Horizontal views for the Approval pages and name the views web'xxx'ApproveHor where xxx describes the page activity. Register each view to the corresponding Approval page.

NOTE: Page Table should have an ID column that is set as the PrimaryKey.

Create Archive Pages

Create Archive pages for each rt table and name these pages 'xxx - Archives' where xxx describes the page activity.

Add column properties to the page to hide ArchiveID, LockReject, Reject, RejectedBy, RejectReason, RequestID, and Severity.

Disable Connection and PostedOn.

Create Horizontal views for each of the Archive pages and name these views web'xxx'ArchiveHor where xxx describes the page activity. Register each view to the corresponding Archive page.

NOTE: Page Table should have ArchiveID column that is set as the PrimaryKey.