DWR Templates

1
DWR Templates

• SiteManager 3.1a-2
• Sheri Meyerhoff
• Indiana Department of Transportation
• September 8, 2003

2
DWR Templates

• Reasons INDOT uses DWR templates
• Reviewing sections of the DWR template
• Creating DWR templates in SiteManager
• Modifying DWR templates in PowerBuilder
• Reviewing and revising DWR templates
• Problems with DWR templates

3
Reasons INDOT uses DWR Templates

• Uniformity of computations throughout the state
  of Indiana
• Simplify record keeping for field employees
• Reduce human error
• Replace some of the paper forms currently used

4
Reviewing sections of the DWR template
Header Only
5
Reviewing sections of the DWR template
Header
Detail
6
Reviewing sections of the DWR template
Multiple pages can be used in the detail
7
Reviewing sections of the DWR template
Calculations can be created in the header portion
8
Reviewing sections of the DWR template
9
Creating DWR Templates in SiteManager
10
Creating DWR Templates in SiteManager
11
Modifying DWR templates in PowerBuilder
12
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• Drop-down lists
• Radio buttons
• Check boxes

13
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• No leading zeros

14
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• Grey out a field based on the result of a radio
  button
• Protect a field based on the result of a radio
  button

15
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• A length is calculated based on stationing

16
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• Calculate a text string in a computed field
  based on the results of a drop-down list

17
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• Use common widths on the entry and calculated
  fields to improve appearance

18
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• Create simple drawings to the template

19
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• Add lines and border to help organize the template

20
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• Make first 8 fields of each templates open for
  stationing

21
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• A general entry template is associated to each
  master item that has another template associated
  to it
• The first Remarks field is required

22
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

• Messages are visible when certain criteria are
  met

23
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

Force Account template
24
Modifying DWR templates in PowerBuilder

• Miscellaneous Modifications

Check list No Return Value
25
Reviewing DWR Templates

• Attaching a DWR Template to a master item in the
  Item DWR Template Association window

26
Reviewing DWR Templates

• Attaching a DWR Template to a project line item
  Contract Item DWR Template window

27
Reviewing DWR Templates

• Navigating through a DWR Work Items tab

28
Reviewing DWR Templates

• Viewing a list of DWR templates available to a
  project item

29
Reviewing DWR Templates

• Viewing a DWR Template

30
Revising DWR Templates

• Export template out of SiteManager
• Import template into PowerBuilder
• Make adjustments in PowerBuilder
• Export template out of PowerBuilder
• Import template into SiteManager
• Review template in a DWR
• Repeat process

31
Problems with DWR Templates

• Modifying a template after it has been used in a
  DWR
• Large templates error message
• Defaulting numeric field to zero, based on the
  result of an alphanumeric field

32
DWR Templates

• SiteManager 3.1a-2
• Sheri Meyerhoff
• Indiana Department of Transportation
• September 8, 2003