Manual Input Table+

Overview

When to use it

Use this symbol when you need to:

• Review recorded values of several data sources in one table.
• Correct a recorded value or fill a gap at an existing timestamp.
• Add a row of values at a chosen time.
• Paste or import a block of timestamped values from a spreadsheet.
• Warn operators, or stop them, when a value is outside its limits.

Choose Manual Data Entry+ to type one new value per data source, with a prefilled user name and an ad-hoc trend, without showing the history. Choose Quick Input+ to write a value immediately, without a Save step.

Before you begin

• Use writable PI Points or AF attributes, and make sure the operators have write permission for them.
• Turn compression off on every PI Point you edit here. With compression on, the PI System can discard a manually entered value that falls inside the compression deviation.
• Set Step to On for numeric PI Points. With Step off, the PI System interpolates between stored values, and trend and table symbols show misleading values between your entries.
• Set the display time range to the period you want to review. The table loads the recorded values of that range.

Add and set up the symbol

1. Select Manual Input Table+ in the PI Vision symbol gallery, and drag the PI Points or attributes onto the display. Each data source becomes one column.
2. Set the display time range to the period to review. Every distinct timestamp in that range becomes one row, and a data source without a value at that time leaves its cell empty.
3. Right-click the symbol and select Configure Table....
4. Under Editing, check Existing Data Rule (1). Under Data Retrieval, keep Start- and Endtimes (2) at Display time range.
5. Close the configuration pane.
6. Click an empty cell, for example the Fan running cell of a row, and select a value. The cell shows the value (1) and Save (2) turns active.

Important: Nothing is written until you select Save. Save writes the staged cells to the PI Data Archive and then reloads the table.

Common tasks

Add a row at a chosen time

Use this to record a reading that you took earlier, or a set of values for one moment. A new row starts with the time that Default Time sets, and you can change it.

1. Select Add Row (1). A new row appears at the bottom of the table.
2. Click the Time cell (2) and type the time of the reading, for example 10/08/2026 10:00:00 AM.
3. Enter or select the values in the other cells (3, 4). Leave a cell empty to skip that data source.
4. Select Save (5).

A digital or Boolean cell offers a list of its states, so operators cannot type an invalid state. Closing the list without a choice leaves the cell unchanged.

Default Time sets the time of a new row. The default * is the moment of saving. Allow Adding New Rows under Editing shows or hides Add Row.

Correct a recorded value

Use this to fix a value that was entered wrongly. Editing a cell at an existing timestamp replaces the value at that timestamp.

1. Click the cell (1) of the value, and type the corrected value or select another state. Press Enter.
2. Check the Time (2) of the row. The value is written at that time.
3. To take the change back before saving, select Undo (3).
4. Select Save (4).

Existing Data Rule under Editing decides what Save does when a value already exists at the timestamp. Replace Existing overwrites it, Add as Duplicate keeps both values, and Protect Existing cancels the save and lists the existing values.

Important: Editing a saved value changes history. Follow your site's correction and audit procedure.

Check entries against limits

Use this to catch typing mistakes in numeric values. The check runs when the operator leaves the cell and again at Save.

1. Right-click the symbol and select Configure Table....
2. Under Columns, select the data source and select Validate Input (1).
3. Set Limits (2) to Custom and enter Max (3) and Min, or set it to Database to use the limits the data source reports.
4. To block out-of-range values instead of only warning, select Prevent Entry Outside Limits (4).
5. Optionally, enter a Message (5) with guidance for the operator.

Without Prevent Entry Outside Limits, a value outside the limits opens a Limit Warning. The operator can select Cancel to take the value back, or Continue to keep it.

With Prevent Entry Outside Limits, the dialog is titled Invalid Value and offers only Cancel. The value is not accepted.

Pasted and imported values get no dialog per value. At Save, the symbol checks every value it writes: a value outside a hard limit blocks the whole save with an error message, and values outside soft limits are listed in one Limit Warning that the operator confirms.

Delete a row of recorded values

Use this to remove the values of a timestamp from the archive, for example a row that was entered by mistake.

1. Select the check box (1) of each row to delete.
2. Select Delete Rows (2), the trash icon.
3. Check that the rows are gone from the table.
4. Select Save.

Deleting only stages the change. The rows leave the table and Save (1) becomes active, but the archive keeps the values until you save. Undo (2) cancels the staged delete.

To delete the value of one data source only, including a system state such as Shutdown, clear its cell and select Save. With Existing Data Rule set to Protect Existing, the symbol asks you to confirm the removal first.

Important: Save removes the values of every data source in the deleted row at that timestamp. A row older than the Max Age cannot be deleted.

Paste or import values from a spreadsheet

Use this when the readings are in a spreadsheet or a CSV file. Pasting or importing adds rows to the table. Nothing is written until you select Save.

1. Prepare the data without a header row. Use one column for Time, followed by one column for each data source, in the order of the data source list in the configuration pane. A hidden data source still takes a column: leave it empty.
2. In the spreadsheet, select the cells and copy them (Ctrl+C).
3. Select Paste Data from Clipboard (1) in the toolbar. To use a CSV file instead, select Import CSV.
4. Check the new rows (2).
5. Select Save (3).

For example, the display above has the data sources Fan running, Control mode, three hidden data sources, Air velocity and Next inspection. The first pasted row is 10/08/2026 10:00:00 AM, True, Auto, three empty cells, 44, and one empty cell.

A CSV file needs the same columns. Its first line is a header and is skipped while Skip First Row is on. Separate the values with a comma, or with a semicolon where your regional settings use a decimal comma. A value that contains the separator goes in double quotes. If the source has no time column, turn on Skip Time Column under Editing: every row then gets the Default Time. The browser may ask for permission to read the clipboard.

Use the symbol

• Type, then save. Typing, pasting, importing, adding a row and deleting a row only stage a change. Save, or Ctrl+S in the table, is available as soon as one change is staged.
• Save writes to the PI Data Archive, and the table reloads. You cannot undo a saved change from the symbol.
• Undo and Redo step through the staged changes. Reload reads the archive again.
• While you hold unsaved edits, the table does not reload by itself. Leaving the display with unsaved edits shows a warning.
• A row older than the Max Age of Limit Changes is read-only, and Save refuses changes to it.
• The table loads at most Max. Events values per data source. Shorten the range if it has more.

Configure the symbol

Right-click the symbol and select Configure Table.... The pane has the sections General (the groups Table, Header, Time and Editing), Columns, Editing, Data Retrieval, Toolbar, Style, Export Data and Numbers.

General: Table

General: Header

General: Time

General: Editing

Columns

Select a data source in the list, then set it.

The point attributes button beside the list shows the PI Point attributes of the selected data source. Multi-state colors come from Add Multi-State... on the right-click menu. They color the cells by the limits of the data source.

Editing

Data Retrieval

Toolbar

Style, export, and numbers

Troubleshooting and limitations

Limitation: Editing or deleting a saved value is a historical change. Follow your site's correction and audit procedure.