Events Export

The INSPECTION ‣ Custom Export functionality gives the user the ability to choose a subset of event data to export to Excel.

The format in which the data is exported to Excel is the same format in which the data can be reimported (with some exceptions). See Import for more detail on importing data from Excel.

The Events Export Wizard

  1. Export Filename - Either use the default folder and filename that NEXUS IC proposes, or use the ellipsis button to navigate to an alternate Windows folder and edit the default filename.
  2. Export Options - Select options here.
    • If you set Columns to User Selected, you will be shown a page later in the wizard to select those columns. If you set it to All Visible Columns, columns that have Visible Grid or Visible Form ticked will be exported. Workflow rules affecting field visibility will not be run.
    • Asset Location can be shown in a Single Column, like “Field / Asset / Elevation / Member / Anode”, or as Multiple Columns, with one tree level per column.
    • Findings: You can Include findings in the export, in which case they will get their own worksheet, or Exclude them, or Only export Findings.
    • Images: You can Embed thumbnails at various resolutions, Embed full size images, Hyperlink to external images, or Do not export images. If an event has several images, you will get several sets of Multimedia columns, with images for an event shown horizontally within the event’s row.
    • You can choose to export or not export Calculated fields and Sub events. If you export subevents, the event data will be repeated in several rows, one for each subevent.
    • Under Worksheets if you untick One per event type, you will get one Excel worksheet with (potentially) many different event types mixed together.
    • Extra sheets are exported for each Lookup List used in the forms. You can choose to hide these.
    • You can control Formatting for Date and Time. You can also control Cell formatting — if you select this, cells with invalid values will be shown in red, cells not relevant to this asset information group or event form will be greyed out, etc.
  3. Asset Selection - Choose the Asset View and check which subset of assets to include in the export. Note: use the Select Children and Unselect Children toolbar buttons to include and exclude the visible and non-visible child assets. Simply checking an asset at the top level will not automatically check all the child assets beneath it.
  4. Workpacks - Choose which Workpacks to include in the exported document.
  5. Events - Choose which Event types to include in the exported document.

Hint

Column order within the exported sheet is determined by the grid column order set within each form in Configuration ‣ Assets ‣ Asset Information.

Hint

The exported Excel sheet will contain a Legend tab, which shows the meaning of various cell and row colours.