Data Export
Process Vision provides comprehensive historical data query and export capabilities. Open it by clicking "History Query" in the main menu.
Query Methods
Query by Date Range
- Set the "From" and "To" dates.
- Use the quick buttons: "Today", "This Week", "This Month".
- Optionally filter by a specific tag (e.g., Temperature.PV, Pressure.SV).
- Set the result limit (default: 1,000 records).
- Click "Query" to execute.
Query by Session
- Enter a session code in the "Session Code" field.
- Click "Search".
- The system will load the complete process data for that session.
- You can also select a previously recorded session from the dropdown.
Query Results
Results are displayed in a table with the following columns:
| Column | Description |
|---|---|
| Timestamp | Time of recording |
| Tag Code | Data tag (e.g., Temperature.PV) |
| Value | Recorded value |
| Quality | Data quality |
The bottom of the window shows query statistics: total records and query time.
Available Data Tags
| Tag Code | Description |
|---|---|
| Temperature.PV | Temperature process value |
| Temperature.SV | Temperature set value |
| Temperature.Output | Temperature output percentage |
| Pressure.PV | Pressure process value |
| Pressure.SV | Pressure set value |
| Pressure.Output | Pressure output percentage |
| Process.State | Process state |
| Process.Progress | Process progress |
Statistics
After running a query, the system calculates and displays statistics for the selected tag:
- Min: Minimum value
- Max: Maximum value
- Average: Mean value
- Standard Deviation: Statistical spread
- Count: Number of data points
Click "Refresh Statistics" to recalculate.
Chart View
- After running a query, click "View Chart" to open the chart window.
- The chart shows the time-series trend of query results.
- You can show or hide individual tag data lines.
- The chart header displays the data point count, start time, and end time.
Exporting Data
Export to CSV
- After running a query, click "Export CSV".
- Choose the save location and filename.
- The CSV file can be opened with Excel or other spreadsheet software.
Export to Excel
- After running a query, click "Export Excel".
- Choose the save location and filename.
- Exports as
.xlsxformat, directly openable in Excel.
Session Details
When viewing a specific session, the following information is available:
- Session code
- Recipe name used
- Operator name
- Start/End time
- Duration
- Final state
- Associated video file list
Clearing Filters
Click "Clear Filters" to reset all filter criteria to their default values.
Log Export
Click "Export Logs" in the left navigation panel of the main window to package diagnostic information into a ZIP file.
ZIP File Contents
| Folder | Contents |
|---|---|
logs/ | Application logs (Serilog, filename pattern processvision-*.log) |
logs/modbus/ | Modbus communication trace logs |
config/ | Configuration files (deviceconfig.json, appsettings.json) |
The exported file is named ProcessVision-Logs-{timestamp}.zip by default.
Use Cases
When a system issue occurs or technical support is needed, export the log ZIP and provide it to technical support staff for quick problem diagnosis.