Asset inspection exchange

You can export and import asset inspections so they can be completed in an external CCTV system.

The inspection exchange functionality is currently supported for these asset types:

  • Sewer main
  • Sidewalk
  • Street segment

The inspections are exported from Infor Public Sector to a Microsoft Access database (.accdb or .mdb), from where they can be imported into the CCTV system. After the inspections are completed in the CCTV system they are sent back to Microsoft Access and then imported into Infor Public Sector. You can also import inspection images from the CCTV system.

Although the import process usually is based on a previous export, you can also import new inspections that were created outside of Infor Public Sector.

Inspection export is based on group inspections in Infor Public Sector, so you must either create a group of new inspections or add existing inspections to a group inspection.

In addition to the inspections belonging to the selected group, the export includes associated observations, supporting code definitions, and employee records. Employees are selected for export based on their job classifications, so only designated inspectors are included.

The inspection exchange functionality uses the Infor Public Sector Batch Manager. You do not need to set up a task in the Batch Manager, because there are separate forms in Infor Public Sector to initiate the export and import processes, but the Batch Manager must be installed and running.

In an on-premises environment, you must first install the Microsoft Access ACE driver on the application server.

See Installing the Microsoft Access ACE driver.