The Export Reserved I/O status to Excel... command reads all IOSparesDb.ModuleIO channel 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 channel that has a reservation record, regardless of its current status, making it suitable for project progress reviews and handover documentation.
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 Export Reserved I/O status to Excel button is grayed out until a hardware community has been loaded. This is because the plant unit scope (Workbook A) requires the list of controller IDs from the active community to filter correctly.
Workbook A - Plant Unit
Contains one row per channel record that belongs to a controller in the currently loaded hardware community. 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 channel record across all controllers in IOSparesDb, regardless of which community is loaded. Use this workbook for plant-wide spare inventory audits and management reporting.
Columns
Both workbooks contain identical columns:
#
Column
Description
1
EntityName
The Experion parameter tag assigned to this channel.
2
DESC
The description of the channel parameter.
3
C300
The parent controller tag (e.g. C300_01).
4
IOLINK
The I/O Link identifier.
5
IOPTYPE
The hardware type of the IOP module.
6
IOREDOPT
The redundancy option configured for the module.
7
IOMNUM
The module slot number within the rack.
8
CHANNUM
The channel number within the module.
9
AssignedTo
The CM block or control module the channel is assigned to, if any.
10
TemplateName
The Control Architect template name of the assigned block.
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 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.
