The Export Reserved I/O status to Excel... command reads the IOSparesDb.ModuleIO reservation records and writes them to two Excel workbooks - one scoped to the current plant unit and one covering the whole plant. The export captures every slot that has a reservation record, regardless of its current status, making it suitable for project progress reviews and handover documentation.
How to Export
1. Open the LCN Hardware View and click an xPM controller node in the diagram.
2. Click Export Reserved I/O status to Excel... in the Export ribbon group (key tip: EX).
3. A Save File dialog opens. Choose a base file path and name (without an extension).
4. The application appends _PlantUnit.xlsx and _WholePlant.xlsx automatically and writes both workbooks to the chosen folder.
5. A confirmation message is displayed when the export completes.
Note The plant unit scope (Workbook A) is based on the xPM controller currently selected in the LCN Hardware View diagram.
Workbook A - Plant Unit
Contains one row per slot record that belongs to the currently selected xPM controller. Use this workbook for project-specific reviews and to share with site engineers who are responsible for this plant unit.
Workbook B - Whole Plant
Contains one row per record across all controllers in IOSparesDb, regardless of which controller is selected. Use this workbook for plant-wide spare inventory audits and management reporting.
Columns
Both workbooks contain identical columns. For xPM records the values are as follows:
#
Column
Description
1
EntityName
The tag of the point assigned to this slot, if any.
2
DESC
The description of the assigned point.
3
C300
The controller. For xPM records this is the node type and number (e.g. HPM13).
4
IOLINK
For xPM records, the LCN/UCN network path (e.g. LCN01/UCN10).
5
IOPTYPE
The I/O type of the module (AI, AO, DI, or DO).
6
IOREDOPT
The redundancy option configured for the module.
7
IOMNUM
The I/O Module number (MODNUM).
8
CHANNUM
The slot number within the module (SLOTNUM).
9
AssignedTo
The point or module the slot is assigned to, if any.
10
TemplateName
For xPM records, XPM_IO: followed by the IOP card type (e.g. XPM_IO:HLAI).
The display name of the engineer who created the reservation.
15
Reserve Date (UTC)
Date and time the reservation was created or last modified, in UTC.
16
Undo Date (UTC)
The Undo by deadline date, in UTC. Blank if none was set.
17
Note
The free-text note from the reservation record.
Tip Run Rescan xPM I/O Assignments and Reconcile I/O Reservations before exporting to ensure all status values in the workbook reflect the current state of the hardware and any elapsed undo dates have been flagged as Stale.
