PI Vision Custom Symbol
Bring Your SQL & AF Tables to Life in PI Vision
Unlock the data in your AF Tables. AF Table+ allows you to display, edit, filter, and manage data from SQL databases and other sources directly within your PI Vision dashboards.
The Bridge Between Your Data and Your Dashboards
Seamless Data Integration
- Display Any AF Table: Natively displays any AF Table, including those linked to SQL databases, files, and more.
- Bulk Data Import: Upload CSV files directly or copy and paste data from Excel to quickly populate your tables.
- Real-Time Connection: View live data from your SQL sources like Microsoft SQL and MySQL.
Powerful Data Management
- Add, Edit & Delete: Perform full CRUD operations (Create, Read, Update, Delete) on static AF Tables.
- Bulk Deletion: Quickly remove multiple rows at once for efficient table management.
- Advanced Filtering: Use column-specific filters or advanced SQL queries to precisely control the data you see.
Advanced Analysis & Reporting
- Multistate Support: Apply conditional formatting to highlight critical values, statuses, and outliers.
- One-Click Export: Download your table data in Excel, PDF, CSV, or JSON formats for reporting and offline analysis.
- Time Range Filtering: Automatically filter table data based on the PI Vision display's time range.
Integrate, Manage, and Visualize Your Relational Data
Managing Operator Logbooks
Create and manage digital logbooks for shifts, maintenance activities, or safety checks directly in PI Vision.
Integrating Lab (LIMS) Data
Display quality or sample data from your LIMS database alongside your real-time process data for full context.
Production & Asset Tracking
Display and update production targets, asset information, or maintenance records stored in external SQL databases.
Configuration & Limit Management
Manage and edit alarm limits, operational targets, or other configuration parameters stored in an AF Table.
Your Data, Your Way, in PI Vision
Display SQL & AF Tables
Display tables from databases like Microsoft SQL and MySQL directly in PI Vision.
Multistate Support
Apply colors to numeric ranges, strings, and booleans for instant visual insights.
Powerful Column Filtering
Use advanced, column-specific filters to show only the most relevant data.
Add or Edit Data
Modify table data directly within PI Vision for quick updates and manual entry.
Bulk Delete Data
Quickly select and delete multiple rows of data to keep tables clean and organized.
One-Click Data Export
Export tables in multiple formats like Excel, PDF, and CSV for reporting and analysis.
Bulk Import from Excel
Quickly populate tables by uploading CSV files or simply copying and pasting data from Excel.
See AF Table+ in Action
Questions?
Click the button below to get in contact, or simply email us at contact@software-athlete.com. We would love to help you.
