pontis 5.1 implementation tips - s powerbuilder, asa is no longer the ... pontis 5.1 xml registry...
TRANSCRIPT
General Guidance
• Read Pontis_Installation_Guide.chm
• Pontis 51 Technical Manual.pdf
• Pontis 5.1 User Manual.pdf
• Pontis 5.1 Release Notes.rtf
• Re-read Pontis_Installation_Guide.chm
Pontis Installation Guide
• Workstation vs. Enterprise
– Decisions of which direction, or both
• Review Requirements
– Hardware
– Software
– Database type
– Dependent upon previous decision
Server Hardware
• Machine Intel Pentium IV 3 GHz
• Memory 2 GBVideo
• 1024x768, 32 bit color
• Mouse Microsoft® or compatible
• Hard Disk120 GB +
• Disk Drives16X CD ROM ***
***NOTE: Pontis 5.1 support data is on DVD
Server Software
• OS – Server 2003 SP 2 with IIS 6.0
• Microsoft®.NET Framework 2.0 Service Pack 1
• Microsoft Data Access Components (MDAC) 2.8
• ODBC Connection to DB
• I.E. 6.0
• Adobe Acrobat Reader 5.x through 8.x (problems with 9.X)
Desktop/Laptop Hardware
• Machine Intel Pentium IV 3 GHz
• Memory 2 GBVideo
• 1024x768, 32 bit color
• Mouse Microsoft® or compatible
• Hard Disk120 GB +
• Disk Drives16X CD ROM ***
***NOTE: Pontis 5.1 support data is on DVD
Client Software
• Windows XP SP 2
• I.E. 6.0
• Adobe Acrobat Reader 5.x through 8.x
(problems with 9.X)
Workstation Software
• Windows XP SP 2
• Microsoft Data Access Components (MDAC) 2.8
• Microsoft®.NET Framework 2.0 Service Pack 1
• ODBC Connection to DB
• I.E. 6.0
• Adobe Acrobat Reader 5.x through 8.x (problems with 9.X)
Other Software
• Infomaker 11.2 Build 16971 for reports
(note 11.2 Build 8806 for Pontis 4.5)
• Crystal Reports Developer XI Release 2
(11.5.9.1076) for reports
• Ghostscript for PDF generation for
datawindows reports
• Visual Studio for development of agency
controls -- 2005 or 2005 Express with SP1
Databases
• Sybase ASA9.0.2.3274 (i.e., 9.0.2 with EBF 3274)
• Oracle10g R2 (10.2.0.1)
• Oracle Express (Oracle XE)10g R2 (10.2.0.1)
• Microsoft SQL Server 2005 with Service Pack 2
• Microsoft SQL Server Express 2005 with Service Pack 2
Databases
• Since Pontis 5.1 is no longer developed using
Sybase’s Powerbuilder, ASA is no longer the
“design” platform.
• Encourage use of SQL Server and Oracle
Pontis 4.4.X
• Migrate your data from any older version of
Pontis 4.X up to Pontis 5.1
– Can still work with Pontis 4.5
• Registering Pontis DB within Pontis
• User Synchronization
• Agency Customization
Post Install Process
• Decision between 3 “authentication”methods
– Specify Proxy User ID and Password
– Each Application User has a Matching DB User
– Use Windows Authentication
• All have advantages and disadvantages and
will depend upon your IT policies and
procedures
Registering Pontis DB
User Synchronization
• Need to synchronize the users with the
Pontis 5.1 xml registry
• Go to Admin Tab, User Synchronization
• Add all database users to the registry
• All users will have password by default
Agency Customization
• Pontis 5.1 Technical Manual – page 135 +
• Pontis 5.1 User Manual – page 271 +
• Pontis_Installation_Guide.chm
Agency Customization
• Setting Units of Measure for Display
• Localization / Flexible Relabeling
• Navigation and Field Level Security
• Layouts and Filters
• Bridge Detail Pane
• Agency Report Headers
• Agency Reports
Agency Customization, cont.
• Agency Pages
• PDI, export options
• Elements.prn
• Multimedia
• Other items
• Metric or US Customary Units
• Update PON_UNITS in COPTIONS table
– Via SQL statement or Admin within Pontis
– ENGLISH or METRIC
• Remember all data is stored in METRIC
regardless of which option chosen
Units of Measure for Display
• For now, two approaches
– XML Resource File Approach
– Navigation and Field Level Security (FLS)
Approach
Localization / Flexible Relabeling
• Navigation
– Can modify how the user navigates through the
screens
– Turn screens on or off
– Located in Admin Tab
Navigation/ Field Level Security
• Field Level Security
– Control which fields are visible, editable or
enabled
– Very fine grained control
– Also found in the Admin tab
Navigation/ Field Level Security
• Stored in database (pon_layouts table)
• Can be shared with all users
• Saves the SQL in database
• Point and Click building of SQL or
Advanced Users can write their own
advanced SQL Statements
• In Pontis 4.4, layouts could also “filter” – but
this is completely separate in Pontis 5.1
Layouts
Condition Summary Layout
• Example - Revise
– Bridge Id to Str No
– District to Region
– Drop Placecode
– Change length meters to feet
Condition Summary Layout
• Edit SQL
• Change Bridge_id to Str_No
• Change District to Region
• Delete pl.shortdesc as Place,
• floor(100*(b.length/0.3048))/100 as
Length_FT
• Stored in database (pon_filters table)
• Can be shared with all users
• Saves the SQL in database
• Point and Click building of SQL or
Advanced Users can write their own
advanced SQL Statements
Filters
Filters
• Filter those Structurally Deficient
• Add in the Where Clause
– AND inspevnt.nbi_rating = '1'
• Preview of Bridge/Inspection data
– Non-editable data – display only
– Customized by editing pon_attribute_display
– No Admin function to customize this currently
– Need to edit DB directly
– Pontis 5.1 Technical Manual – Page 142-142
• Currently does not work to add new tabs but can only edit descriptions of existing fields
Bridge Detail Pane
• Agency Name - The name of your agency
• Agency Office - The name of your office, or
any other level of your agency
• Agency Department - The name of your
department or group.
• Located in web.config
– Workstation – locally available
– Enterprise – your web admin can do this
Agency Report Headers
• <add key="[Site].Agency" value="SDDOT"/>
• <add key="[Site].Office" value="Bridge Design"/>
• <add key="[Site].Department" value="SDDOT"/>
Agency Report Headers
• Two approaches
– Infomaker
• Datawindow .NET
• Can migrate from 9 to 11 (sometimes works)
– Crystal Reports
• Preferred Method to be supported long term
Agency Reports
• Two approaches
– Agency (Basic)
• Point & Click in Admin
• “Easy” but many limitations
– Only user bridge and inspection tables
– Not user roadway or structure unit tables
– Agency (Advanced)
• Microsoft Visual Studio
• ASP.NET user controls
• Much more advanced
Agency Pages
• This is an afternoon class in and of itself
• A brief example of the Basic Form
– Pages 155-185 in Technical Manual
Agency Pages
• *.txt files replaced with database table driven
options
– PON_EXCHANGE_OPTION
– PON_EXCHANGE_OPTION_DETAIL
Import/Export Options
• PON_EXCHANGE_OPTION
– List of tables available for export/checkout
– Add any agency tables to this table
• PON_EXCHANGE_OPTION_DETAIL
– List of tables for each export/checkout option
– Need to customize for any agency tables
– Replaces the BRIDGES.TXT, INSPDATA.TXT,
ALL.TXT, NON_BRIG.TXT, SCENSUMM.TXT,
SCENDETL.TXT, and CUSTOM.TXT
Import/Export Options
• No longer used – database table driven from
PON_CTRL_ELEMENTS_PRN
• Any custom elements that were stored in
elements.prn need to be added to this table
• If still using Pontis 4.5, still need elements.prn for
that though – so you’ll need to keep them current in
both places
Elements.prn
• No longer uses this Nbiguide.txt when export NBI
files
• PON_CTRL_NBI_GUIDE
• Any changes you may have customized to your
nbiguide.txt file needs to be reflected in the records
of this table
• If you made no changes, then you should be ok
Nbiguide.txt
• MULTISERVER5 in COPTIONS table
– Created Virtual Directory on web server and pointed to
media folder and named it such to work in
COPTIONS.MULTISERVER5
• We’re having problems getting it to work correctly
but I think others have gotten it to work.
Multimedia
• Agency Logo on Header
• Web.config
<!--For Agency logo customization-->
<add key="[AgencyLogo].ImageUrl" value="~/images/agency_logo.jpg"/>
<add key="[AgencyLogo].Width" value="112"/>
<!--in pixel-->
<add key="[AgencyLogo].Height" value="46"/>
<!--in pixel-->
<add key="[AgencyLogo].SideBySide" value="TRUE"/>
Other customizations
User Groups
• Can assign users to a group, but only one
group
• Can associate a bridge-level access filter
with each group
– e.g. User in Group “Region 1” will only see
bridges in their respective Region
Questions/Problems
• https://pontis.bakerprojects.com/cont/index.html
• Review incidents already reported and possibly solved – no sense re-inventing solutions identified for others
• Report a new incident – provide as much detail as you can – only speeds up resolution
Summary
• Review Pontis User and Technical Manuals
for Pontis 5.1 specific information
• Review the Pontis_Installation_Guide.chm
Outstanding Issues
• SR Calculate Status – not updating
– Fixed in 5.1.0.1
• Bridge Detail Pane – customization not working
• User table records not being created (e.g. user bridge, user inspection, etc.
– fixed in Pontis 5.1.0.1
• Multimedia – not working correctly for us
Outstanding Problems
• Some PC’s – text unreadable – issues with
CSS?
– Try using Compatiblity View – fixes some
issues
– Pontis 5.1.0.1 hopefully will fix the rest
• IE 8 update (Pontis 5.1.0.1)
Important Enhancements
• Ability to link multiple documents at once
for multimedia (currently one at a time)
• There are actually over 50 enhancements
identified already in JIRA
Questions?
Todd Thompson, PE
SD DOT – Bridge Design
(605)773-3285