All of Lucity's web applications now require .NET Framework 4.8
Web
General Web Changes
Lucity Web application has been updated with modern material design. This provides a cleaner interface and increased application speed.
Login
Dashboard
Module
Form
A side effect of this is that the color scheme can no longer be modified.
If Lucity Web is using an NPR (Non-production/Test) License, it will display a message at the top of the application. This will help make test systems more identifiable even though the colors cannot be changed.
The upgrade process is improved so that users generally do not need to clear browser caches after applying upgrades or service packs.
Font scaling now works across most of the web application for scaling up and down fonts, including forms.
During the upgrade all users' fonts sizes are reset to 14. This font is slightly larger than the previous default Lucity font and may, in some cases, require that fields on forms be shifted to the right to prevent overlap.
Increases the vertical spacing between fields on all existing forms by 10% to make the new field display more readable. This pulls the field caption down away from the field immediately above.
All forms are automatically adjusted, and all template forms we provide with the Lucity 2019r2 release have also been adjusted to increase spacing.
If you have custom forms that have been exported to XML, you may want to re-export your forms from the upgraded Lucity forms so that your forms also have increased vertical spacing.
Lucity emails now have a more subdued header and footer.
Dashboard
Dashboard reorder - Temporarily remove the drag and drop function (the ability to drag tabs, plug-ins and frames around in design mode). This will be added again later. In the meantime, you can manually change the order using the Sequence in... field when editing the dashboard object.
Dashboard/Webmap Split-screen - Adds the ability to display your default web map side by side with the dashboard.
You can select items on the dashboard and have their location show in the map.
The system will remember whether the map was open last time or not.
All web map tools are available in dashboard/web map split screen.
Module Tools
Relationship Tool
Shows the relationship to the Building module for the following modules:
Water Storage Facilities > Building
Water Vaults and Structures > Building
Water Supply Sources > Building
Raw Water Storage Facilities > Building
Raw Water Supply Sources > Building
Raw Water Vaults > Building
Recycled Water Storage Facilities > Building
Recycled Water Supply Sources > Building
Recycled Water Vaults > Building
Shows the relationship from the Building module to the following modules:
Building > Water Storage Facilities
Building > Water Vaults and Structures
Building > Water Supply Sources
Building > Raw Water Storage Facilities
Building > Raw Water Supply Sources
Building > Raw Water Vaults
Building > Recycled Water Storage Facilities
Building > Recycled Water Supply Sources
Building > Recycled Water Vaults
Shows the relationship to the Pavement module for the following modules:
Rehab per Pavement/Classifications > Pavement Rehab Techniques
Rehab per Pavement/Classifications > Pavement Standards
Pavement Rehab Techniques > Rehab per Pavement/Classifications
Pavement Standards > Rehab Per Pavement > Classifications
Pavement Modeling Results Segments > Super Segments
Models > Modeling Year End Summary Results
Models > Pavement Budgets
Models > Pavement Miscellaneous Costs
Models > Pavement Modeling Results Segments
Models > Pavement Modeling Results Subsegments
Models > Planning Table Supersegment
Planning Table Supersegment > Pavement Models
Planning Table Supersegment > Super Segments
Pavement Budgets > Pavement Models
Year-End Results (Modeling Year End Summary Results > Pavement Models
Shows the relationship to the Water Loss module for the following modules:
Water Hydrant Flow Tests > Water Loss
Water Storage Facility Inspections > Water Loss
Water Supply Source Inspections > Water Loss
Water Main breaks > Water Loss
Work Water Loss > Water Loss
Water Flushing History via Additional Flushing Dates > Water Loss
Water Flushing History via Flushing Hydrants > Water Loss
Direct Hydrant Flushing > Water Loss
Shows the relationship from the Water Loss module for the following modules:
Water Loss > Water Hydrant Flow Tests
Water Loss > Water Storage Facility Inspections
Water Loss > Water Supply Source Inspections
Water Loss > Water Main breaks
Water Loss > Work Water Loss
Water Loss > Water Flushing History Additional Flushing Dates
Water Loss > Water Flushing History Hydrants
Water Loss > Direct Hydrant Flushing
All asset modules now show a relationship to the Project module.
Web Map
General
Upgraded the Web Map to use Esri Javascript 4.11.
Dashboard/Web Map Split Screen
The Lucity Web Map can now be displayed in split screen with the Dashboard. This enables users to interact with their web map and the dashboard at the same time.
Items selected on the dashboard can be displayed on the web map.
The application will remember the layout and reopen the application to have the same dashboard/web map layout.
The split screen map includes all of the web map tools.
Find Address tool
The Esri World Geocoding Service is no longer included in the Lucity Web system by default. Only geocoders configured in the Lucity Administration tool will be listed.
Editing Tools
Adds GIS Editing Tools back to Lucity Web. This enables users to add and edit features directly in the Lucity Web Map.
Module Enhancements
Important: Lucity desktop is no longer being updated with new enhancements. All of these module changes are in Lucity Web.
General Inventory Module Changes
All asset modules now show a relationship to the Project module.
All asset modules that store X/Y information can now store Z coordinates.
General
Easements - Adds fields for storing the Street addresses.
Plant/Equipment
Equipment Inventory
Equipment ID - Increased to hold 25 characters.
Roof Rec # - New field to link equipment to a record in Facility Roof Inventory.
Environmental Compliance
Storm BMP
Site Contacts - Adds more Custom fields
Storm BMP Site
Conversations - Adds Custom tab with additional Picklist, Date, Numeric, Free form text fields. None of the user custom fields are designed to transfer data from Storm BMP Conversations to Requests or Work Orders.
Facilities
Building Inventory - Adds the ability to display the following child grids.
Facility Rooms - Displays rooms linked to the Building record.
Facility Furnishings - Displays rooms linked to the Building record.
Facility Permits - Displays rooms linked to the Building record.
Facility Doors - Displays rooms linked to the Building record.
Facility Utilities - Displays rooms linked to the Building record.
Facility Building Assessment Library - User defined fields 1 – 15 in Facility Building Assessment Library were previously incorrectly shared to Facility Building Inventory. The picklists are now correctly shared with the Facility Building Assessment module instead. Your picklists and button captions will be lost for these fields in Facility Building Assessment Library, Facility Building Assessments, and Facility Building Inventory.
Note: Please contact Lucity Support if you need help preparing for these changes.
Fleet
Fleet Inspections - Adds more Custom fields.
System Configuration
Notification Setup
Notification Report - Adds a new field to define a report that will be attached to the email notification. When the notification is sent, the report is run against the current record and attached as a PDF to the notification. This also allows reports to be sent to a printer via email.
Sewer
Sewer Pipes - Adds more Custom fields.
Storm
Storm Conduit - Adds more custom fields.
Transportation
ITS Communications
Action History Grid > Change Services Toolkit - Adds the IP Address field to the dialog.
Water
Water Pipes - Adds more custom fields.
Water Main Breaks - Adds more custom fields.
Recycled Water Main Breaks - Adds more custom fields.
Raw Water Main Breaks - Adds more custom fields.
Field Changes
Material picklist
Raw Water and Recycled Water Main Breaks now use the picklist currently shared by the three Water Pipe modules.
Picklist values for the Material fields in Raw Water and Recycled Water Main Breaks will be lost during the upgrade.
Surface picklist
Raw Water and Recycled Water Main Breaks now use the picklist currently shared by the three Water Pipe modules.
Picklist values for the Surface fields in Raw Water and Recycled Water Main Breaks will be lost during the upgrade.
Pressure Zone
Raw Water Main Breaks, Raw Water Pipes and other Raw Water assets now share the same Pressure Zone pick list.
Recycled Water Main Breaks, Recycled Water Pipes and other Recycled Water assets now share the same Pressure Zone pick list.
Picklist values in the Pressure Zone fields, for all affected modules, will be lost during the upgrade.
System
Water Main Breaks, Water Pipes and other Distribution Water assets now share the same System pick list.
Raw Water Main Breaks, Raw Water Pipes and other Raw Water assets now share the same System pick list.
Recycled Water Main Breaks, Recycled Water Pipes and other Recycled Water assets now share the same System pick list.
Picklist values in the System fields, for all affected modules, will be lost during the upgrade.
Note: Please contact Lucity Support if you need help preparing for these changes.
Warehouse Inventory
Warehouse
Account # - New field that identifies the financial account assigned to the warehouse.
Parts Inventory
Create Purchase Order | Selected Record(s) - New toolkit to create a purchase order to reorder parts that are below their reorder point.
Create Purchase Order toolkit - Updated to honor whether the Auto Generate PO Numbers work option is enabled. If this option is disabled users may manually populate a PO Number or leave the field blank for the system to automatically populate with the Purchase Order > Rec #.
Change Cost Method - New toolkit to provide better tracking and accountability when changing a part record's cost method. The Cost Method field can no longer be changed through the Parts form and must be changed through this toolkit. After this toolkit completes, the cost method will be changed for the part. A new part transaction record is also created that tracks the cost method change.
Parts Vendors- Adds a child module for tracking additional contacts.
Transactions
Asset Alt ID - Adds the employee ID/asset ID for Parts Issued transactions.
Asset Description - Adds a new description field for Parts Issued transactions.
Part Purchase Orders
Status Codes - Standardized the list of Status Codes. Most important is that a Status Code of 1 now means New Purchase Order. This is hard coded and cannot be edited. In prior versions, Status Code of 1 meant Received and was editable. Any existing purchase order records with a status code of "1" will retain their old type value until changed by the user. We suggest proactively updating your purchase order records with a code of 1 to a new code. Important information about preparing for this change.
Work
General Work Improvements
Block categories which have sub-categories - New work option which prevents users from selecting a Category in the Category Tree that has sub-categories. This helps by making sure that users do not select categories that were just added for organizational purposes.
Default Transaction Account Number from To Warehouse in Warehouse Transfer Tools - New work option which, when enabled, causes the Account Number field in Part Transfer toolkit dialogs will default with the destination warehouse's Account Number. Toolkits affected:
Warehouse Inventory > Warehouse to Warehouse Parts Transfer toolkit
Warehouse Inventory > Warehouse Location > Transfer Parts to Different Location toolkit
Parts Inventory > Inventory > Transfer Parts to Different Location toolkit
Type portion of the Employee, Equipment, Material, Contractor, and Fluid ID fields now support 100 characters wherever they are available.
Employee Cert/Classes
Certifications > Employees grid- Adds more Custom fields.
Material Requisition
Account # - New field that identifies the financial account paying for the parts on the requisition.
Project # - New field that identifies the project account that is tied to the material requisition.
Create Purchase Order | Selected Recordtoolkit - Updated to honor whether the Auto Generate PO Numbers work option is enabled. If this option is disabled users may manually populate a PO Number or leave the field blank for the system to automatically populate with the Purchase Order > Rec #.
PM/Templates
PM/Template field - Now supports 25 characters wherever the field is located.
Tasks grid > Material Kits - New grid allows you to add Material Kits to the PM > Task record. This enable you to add groups of materials that are often used together and add estimates for how they are used.
Project Management
Project Contracts - Adds more custom date and time fields.
Work Flow Setup/Work Administration
Material Kit Setup - New module that enables you to group materials (including materials linked to Parts) into a kit so that the kit can be used on a Work Order or PM.
Let's you define a list of materials and units needed for a specific job.
Note: If any of your users are still using Lucity Desktop to create Work Orders we recommend that you do not use Material Kits as it may cause data problems.
Task Setup
Material Kits - New child grid allows you to specify material kits for a specific task. You can define estimated units for the material kits. These material kits will be brought into the Work Order with the Task.
System Assembly Component - No longer requires that all fields (System, Assembly and Component) need to be populated.
Work Orders
Adds more Custom number fields.
Assets
ViewMain Breaks for Asset | Selected Record - New toolkit that opens Water Main Break records associated with the selected Work Order Asset, eliminating the need to open the Water Main Breaks module.
Water Meter and AMR Toolkits - Adds a time field to these toolkits Ex. Completion Time, Effective Time, Installation Time.
Tasks
Material Kits - New child grid to show Material Kits used on the task.
Populate Dates and Units | Selected Record(s) - New toolkit allows you to enter the dates the Material Kit and the materials within it were used. The toolkit also allows you to define the Material Kit units used. This will automatically update the units in the material resources tied to the Material Kit.
Split Kit | Selected Records - New toolkit that allows you to separate the material resources from their material kit. This allows you to delete individual material resources, or change the units on individual material resources, that were brought into the work order from a material kit.
Note: If any of your users are still using Lucity Desktop to create Work Orders we recommend that you do not use Material Kits as it may cause data problems.
Tasks > Material Resources
Add Part Warranty to Vehicle - Toolkit no longer requires the resource to have an End Date specified or warranty information to be defined in the Material Setup record.
Work Requests
Adds more WO Custom fields. These are fields that are shared between Work Orders and Requests and transfer the data from the Request to the Work Order.
GIS
Geocoding Changes
Usage of the Esri World Geocoding Service will require utilization of service credits in the following situations:
Geocoded addresses processed by the Lucity Spatial Indexer
Reverse geocoded spatial relates processed by Lucity GIS Scheduled Tasks.
GIS Tasks
Work Requests Tasks
Now has the ability to import comments. Records from the feature class comment grid are inserted into the comment grid for the given Lucity record.
When syncing requests from Lucity to GIS the system now supports using translating picklist options in Lucity to the correct domain options in GIS using the GIS Code field in the Domain Configuration tool.
ArcGIS Pro
Requires Arc Pro 2.4
Find Feature - New tool to quickly find an asset in the map based on the Common ID.
Filter Viewer - New tool to select features in the map based on a filter saved in the related Lucity module.
Works for Inventory and Inspection modules, as well as for Requests, Work Orders, and PMs.
The results are selected and zoomed to in the map.
Subset Manager - New tool to load, create and edit Lucity subsets in the active ArcGIS Pro map.
Relates - Adds option to attach all selected records (assets, xy, address locations) in the map to a Work Order or PM.
Process Log - Most recent entries are displayed at top and include timestamp.
Both Dark and Light themes are now fully supported.
Lucity Admin > GIS Services
New option to specify credentials to geocoding services (for secured or fee-based services).
Lucity Web > Admin Portal > GIS Scheduled Tasks
Will now only load up the amount of records specified with the Max Tasks To Load system setting. This improves performance.
A new option has been added to purge all log entries.
Security Changes
GIS Setup - New permission added for use in a future release
REST API
Third Party Authentication
Adds the ability for third-party developers to use OAuth to log into our Rest API using a JWT token.
Note: A guide will be coming out soon for how to use this new REST API functionality. We will continue to support the older basic authentication at this time as well.
Coordinate Properties
Renamed the following coordinate properties
Tablename
Fieldname
Fieldname
Property Name
New Name
CMFibCbl
CMFCABLE
FA_X2
EndXCoordinate
EndingXCoordinate
CMFibCbl
CMFCABLE
FA_Y2
EndYCoordinate
EndingXCoordinate
CMFibCbl
CMFCABLE
FA_X
StartXCoordinate
BeginningXCoordinate
CMFibCbl
CMFCABLE
FA_Y
StartYCoordinate
BeginningYCoordinate
CMFibCct
CMFCIRC
FR_X2
XCoordinateEnd
EndingXCoordinate
CMFibCct
CMFCIRC
FR_X
XcoordinateStart
BeginningXCoordinate
CMFibCct
CMFCIRC
FR_Y2
YCoordinateEnd
EndingYCoordinate
CMFibCct
CMFCIRC
FR_Y
YcoordinateStart
BeginningYCoordinate
CMFibCon
CMCONDUIT
FO_X2
XCoordinateEnd
EndingXCoordinate
CMFibCon
CMCONDUIT
FO_X
XCoordinateStart
BeginningXCoordinate
CMFibCon
CMCONDUIT
FO_Y2
YCoordinateEnd
EndingYCoordinate
CMFibCon
CMCONDUIT
FO_Y
YCoordinateStart
BeginningYCoordinate
CMFibFbr
CMFIBER
FI_X2
XCoordinateEnd
EndingXCoordinate
CMFibFbr
CMFIBER
FI_X
XCoordinateStart
BeginningXCoordinate
CMFibFbr
CMFIBER
FI_Y2
YCoordinateEnd
EndingYCoordinate
CMFibFbr
CMFIBER
FI_Y
YCoordinateStart
BeginningYCoordinate
CMFibTrn
CMTRENCH
FT_X2
XCoordinateEnd
EndingXCoordinate
CMFibTrn
CMTRENCH
FT_X
XCoordinateStart
BeginningXCoordinate
CMFibTrn
CMTRENCH
FT_Y2
YCoordinateEnd
EndingYCoordinate
CMFibTrn
CMTRENCH
FT_Y
YCoordinateStart
BeginningYCoordinate
ELAGuy
ELAGUY
AG_X1
XCoordinateBeginning
BeginningXCoordinate
ELAGuy
ELAGUY
AG_X2
XCoordinateEnding
EndingXCoordinate
ELAGuy
ELAGUY
AG_Y1
YCoordinateBeginning
BeginningYCoordinate
ELAGuy
ELAGUY
AG_Y2
YCoordinateEnding
EndingYCoordinate
ELBBar
ELBBAR
BB_X1
XCoordinate1
BeginningXCoordinate
ELBBar
ELBBAR
BB_X2
XCoordinate2
EndingXCoordinate
ELBBar
ELBBAR
BB_Y1
YCoordinate1
BeginningYCoordinate
ELBBar
ELBBAR
BB_Y2
YCoordinate2
EndingYCoordinate
ELCCbl
ELCCBL
CA_X1
XCoordinate1
BeginningXCoordinate
ELCCbl
ELCCBL
CA_X2
XCoordinate2
EndingXCoordinate
ELCCbl
ELCCBL
CA_Y1
YCoordinate1
BeginningYCoordinate
ELCCbl
ELCCBL
CA_Y2
YCoordinate2
EndingYCoordinate
ELCirct
ELCIRCT
CC_X1
XCoordinate1
BeginningXCoordinate
ELCirct
ELCIRCT
CC_X2
XCoordinate2
EndingXCoordinate
ELCirct
ELCIRCT
CC_Y1
YCoordinate1
BeginningYCoordinate
ELCirct
ELCIRCT
CC_Y2
YCoordinate2
EndingYCoordinate
ELCond
ELCOND
CD_X1
XCoordinate1
BeginningXCoordinate
ELCond
ELCOND
CD_X2
XCoordinate2
EndingXCoordinate
ELCond
ELCOND
CD_Y1
YCoordinate1
BeginningYCoordinate
ELCond
ELCOND
CD_Y2
YCoordinate2
EndingYCoordinate
ELPOLS
ELPOLS
PO_X1
XCoordinate1
BeginningXCoordinate
ELPOLS
ELPOLS
PO_X2
XCoordinate2
EndingXCoordinate
ELPOLS
ELPOLS
PO_Y1
YCoordinate1
BeginningYCoordinate
ELPOLS
ELPOLS
PO_Y2
YCoordinate2
EndingYCoordinate
ELPshB
ELPSHB
PB_X1
XCoordinate1
BeginningXCoordinate
ELPshB
ELPSHB
PB_X2
XCoordinate2
EndingXCoordinate
ELPshB
ELPSHB
PB_Y1
YCoordinate1
BeginningYCoordinate
ELPshB
ELPSHB
PB_Y2
YCoordinate2
EndingYCoordinate
ELPULS
ELPULS
PU_X1
XCoordinate1
BeginningXCoordinate
ELPULS
ELPULS
PU_X2
XCoordinate2
EndingXCoordinate
ELPULS
ELPULS
PU_Y1
YCoordinate1
BeginningYCoordinate
ELPULS
ELPULS
PU_Y2
YCoordinate2
EndingYCoordinate
ELSGuy
ELSGUY
SG_X1
XCoordinate1
BeginningXCoordinate
ELSGuy
ELSGUY
SG_X2
XCoordinate2
EndingXCoordinate
ELSGuy
ELSGUY
SG_Y1
YCoordinate1
BeginningYCoordinate
ELSGuy
ELSGUY
SG_Y2
YCoordinate2
EndingYCoordinate
ELSOLS
ELSOLS
SO_X1
XCoordinate1
BeginningXCoordinate
ELSOLS
ELSOLS
SO_X2
XCoordinate2
EndingXCoordinate
ELSOLS
ELSOLS
SO_Y1
YCoordinate1
BeginningYCoordinate
ELSOLS
ELSOLS
SO_Y2
YCoordinate2
EndingYCoordinate
ELSULS
ELSULS
SU_X1
XCoordinate1
BeginningXCoordinate
ELSULS
ELSULS
SU_X2
XCoordinate2
EndingXCoordinate
ELSULS
ELSULS
SU_Y1
YCoordinate1
BeginningYCoordinate
ELSULS
ELSULS
SU_Y2
YCoordinate2
EndingYCoordinate
PKDock
PKDOCK
DR_X2
XCoordinateEnd
EndingXCoordinate
PKDock
PKDOCK
DR_X
XCoordinateStart
BeginningXCoordinate
PKDock
PKDOCK
DR_Y2
YCoordinateEnd
EndingYCoordinate
PKDock
PKDOCK
DR_Y
YCoordinateStart
BeginningYCoordinate
PKPthInv
PKPATH
PH_STARTX
StartingXCoordinate
BeginningXCoordinate
PKPthInv
PKPATH
PH_STARTY
StartingYCoordinate
BeginningXCoordinate
SMWeir
SMWEIR
WE_X1
XCoordinate1
BeginningXCoordinate
SMWeir
SMWEIR
WE_X2
XCoordinate2
EndingXCoordinate
SMWeir
SMWEIR
WE_Y1
YCoordinate1
BeginningYCoordinate
SMWeir
SMWEIR
WE_Y2
YCoordinate2
EndingYCoordinate
STAccdnt
STACDATA
AC_XC
AccidentXCoordinate
XCoordinate
STAccdnt
STACDATA
AC_YC
AccidentYCoordinate
YCoordinate
STBriInv
STBRINV
BV_X2
EndXCoordinate
EndingXCoordinate
STBriInv
STBRINV
BV_Y2
EndYCoordinate
EndingXCoordinate
STBriInv
STBRINV
BV_X1
StartXCoordinate
BeginningXCoordinate
STBriInv
STBRINV
BV_Y1
StartYCoordinate
BeginningYCoordinate
STMstArm
STMARM
MA_X1
StartXCoordinate
BeginningXCoordinate
STMstArm
STMARM
MA_Y1
StartYCoordinate
BeginningYCoordinate
WKProjCE
WKPROJCE
XE_X_COORD
LocationXCoordinate
XCoordinate
WKProjCE
WKPROJCE
XE_Y_COORD
LocationYCoordinate
YCoordinate
WTARoad
WTAROAD
NR_X1
X1Coordinate
BeginningXCoordinate
WTARoad
WTAROAD
NR_X2
X2Coordinate
EndingXCoordinate
WTARoad
WTAROAD
NR_Y1
Y1Coordinate
BeginningYCoordinate
WTARoad
WTAROAD
NR_Y2
Y2Coordinate
EndingYCoordinate
WKROUTN
WKROUTN
LocationXCoord
XCoordinate
WKRTLOC
WKRTLOC
LocationXCoord
XCoordinate
WKROUTN
WKROTUIN
LocationYCoord
YCoordinate
WKRTLOC
WKRTLOC
LocationYCoord
YCoordinate
CMADDR
AD_Z
Elevation
ZCoordinate
Mobile Server
Improves authentication methods. This requires the following new apps to be downloaded:
Lucity Mobile Android (2.7 Build 29)
Lucity Mobile iOS (2.2)
Lucity Mobile Warehouse (2.3)
Report Server
Report Server architecture is now only accessed by Lucity Mobile Server, Lucity Services or Lucity Web. Users' individual browsers no longer need to be able to talk directly to the Lucity Report Server.