Custom Export Events

The Custom Export functionality allows you to choose a subset of event data and export that to an Excel file.

You can perform custom export by choosing Custom Export from the toolbar on the INSPECTION screen.

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 Events for more information on importing data from Excel.

Perform Custom Export

  1. On the INSPECTION screen, choose Custom Export from the toolbar.

    Result

    The Event Export Wizard opens.

  2. Specify the name of the file and the location where you want it to be saved to. NEXUS proposes a default path and name, which you can overwrite as required.

  3. Click Next.

  4. In the next dialog, specify the export options:

    Field

    Description

    Columns

    Select one of the following options:

    • All columns - includes all the relevant columns in the exported file.

    • All visible columns - columns that have the Visible Grid or Visible Form options ticked will be exported. Workflow rules affecting field visibility will not be run.

    • User selected - you can select which columns to include in the export. A subsequent dialog will be shown later select those columns.

    Asset Location

    Select one of the following options:

    • Single column - the location of the assets will be included in a single column, each node separated by “ / “ (note the space), for example, “Field / Asset / Elevation / Member / Anode”

    • Multiple columns - each node in the asset location hierarchy will have its own column in the exported file.

    Findings

    Select one of the following options:

    • Include - finding data will be included in the export, in which case they will get their own worksheet.

    • Exclude - finding data will not be included in the exported file.

    • Only export Findings - only finding data will be included in the exported file.

    Images

    Select whether you want to include the attached images in the exported file, and if so, how. 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.

    Calculated fields

    Indicate whether you want to include calculated fields in the export.

    Sub events

    Indicate whether you want to include sub-event data in the export. If you export sub-events, the event data will be repeated in several rows, one for each sub-event.

    Worksheets/One per event type

    When ticked, a separate worksheet will be created for each event type. If you untick this option, you will get one Excel worksheet with (potentially) many different event types mixed together.

    Worksheets/Hide Lookup Lists

    By default, extra worksheets are created for each lookup list used in the forms. You can choose to hide these worksheets.

    Date

    Specify the formatting of dates in the exported file.

    Time

    Specify the formatting of times in the exported file.

    Cell formatting

    If you select this option, some cell formatting options will be applied, for example, cells with invalid values will be shown in red, cells not relevant to this event form will be greyed out, and so on.

  5. Click Next.

  6. In the next dialog, choose the Asset View and select which subset of assets you want 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 selecting an asset at the top level will not automatically select all the child assets beneath it.

  7. Click Next.

  8. In the next dialog, select the workpacks that you want to include in the exported file.

  9. Click Next.

  10. In the next dialog, select the event types that you want to include in the exported file.

  11. Click Export.

Result

The system generates the Excel file to the location that you specified. If required, you can choose to open the document immediately.


Hint

  • The column order within the exported sheet is determined by the grid column order set within each form under Configuration ‣ Assets ‣ Information (see Configure Asset Information Groups).

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