AF Table+

AF Table+ is a custom symbol for PI Vision that lets you display and manage AF Tables directly in PI Vision. It supports tables linked to SQL databases, files, and more, allowing you to add, edit, save, and delete data with ease. This symbol brings database functionality straight to your dashboard.

Features

• Show SQL Tables: Display data from SQL databases like Microsoft SQL and MySQL directly in PI Vision.
• Multistate Support: Apply value ranges and limit colors for numeric data, and define colors for strings and booleans.
• Filter Data:
  • Define column-specific filters in the header.
  • Set advanced SQL filters to control displayed data.
  • Filter data based on the display time range.
• Manipulate Data:
  • Add or edit data in static AF Tables.
  • Delete data in bulk for easier management.
• Download Data:
  • Export data in Excel, PDF, CSV, or JSON formats.
  • Download data directly in your browser.
• Bulk Import:
  • Upload CSV files directly.
  • Copy/paste data to and from Excel sheets.

Benefits

AF Table+ simplifies data management in PI Vision, enabling teams to work more efficiently and make better decisions with direct access to database tables.

• Streamline Data Access: View and interact with SQL database tables without leaving PI Vision.
• Save Time: Quickly filter, edit, and update data directly on the dashboard.
• Enhance Collaboration: Share real-time table views and updates across teams.
• Improve Reporting: Export data in multiple formats for compliance and analysis.

Example Use Cases

• Production Tracking: Display and update production records stored in SQL databases, ensuring accurate and up-to-date information is accessible to everyone.
• Manual Data Entry: Allow operators to enter or adjust data manually, directly within PI Vision, saving time and reducing errors.
• Performance Monitoring: Use multistate formatting to highlight outliers or underperforming areas, enabling quicker responses.

Screenshots

Show SQL Table

Display tables from databases like Microsoft SQL and MySQL directly in PI Vision.

Multistate Support

Apply colors to numeric ranges, strings, and booleans for better visualization.

Filter Data

Use advanced filters to show only the most relevant data.

Add or Edit Data

Modify table data directly within PI Vision for quick updates.

Delete Data

Bulk delete data to keep tables clean and organized.

Download Data

Export tables in multiple formats like Excel, PDF, and CSV.

Bulk Import

Upload CSV files or copy/paste data from Excel sheets.

Demo