Table Viewer

Icon:

---

Introduction

This command is used for bulk editing and analysis of attributes across multiple points or strings. It enables sorting, filtering, and mass-editing of attributes in a tabular format.

All COGO Points and Survey Strings with a Data Table assigned can be viewed and edited from this form.  Objects are sorted by Data Table assigned.

When selecting data for editing, any data managed by a Field Validation (list) will show a picklist dropdown to select allowable values.

Data cells that fails field validation (allowable list) checks will highlight in the table for correction.

About Attribute Data, Data Tables and Schemas

Additional (Attribute) data can be attached to COGO Points and Survey Strings through the creation of a Project Database. 

The Project Database enables the addition of Data Tables to points and strings.  Data Tables contain fields of data and are contained in a Schema. 

The Schema Editor can be used to create saved collections of Data Tables that can be copied into a local drawing (the Project Database).  To append attribute data to points and strings, users must run the Setup Project Database command.

Details

Upon selecting the command the following form is displayed:

Export Menu	CAD Table Adds a CAD table in the current drawing, applying the current Table Style for display output Excel Spreadsheet Set a location and name for output of an Excel spreadsheet of the table displayed.  The spreadsheet will open in Excel (or equivalent). CSV File Creates a comma separated (.csv) file of the table displayed.
Object	Allows to choose between Cogo Point or Survey String data.
Table	Selects the attribute Data Table to view or edit.  Picklist of all Data Table included in the Project Database.
Filter	Filters data by applying conditional logic to field values. The filter uses a selected column, comparison operator (e.g. =), and value to isolate relevant records. Supports schema-based fields
	Filter Column Lets the user select which attribute field to apply the filter on    Filter Operator (=) Defines the comparison logic (currently supports equality)    Filter Value The specific value to match against the selected column
Only Show Invalid	Toggle on to limit the displayed records to only those that fail validation checks
Override Selected	Opens a dialog where you can enter a value to apply to all selected cells in a column
[Point/String List]	Lists all COGO Points or Survey Strings that have the selected Table assigned. Objects are identified by the Point Number (or String Number). Objects are listed one per row. All attribute (field) data columns will be listed, as per the Data Table.  Individual cells contain data for each field assigned to each object.
Refresh Table	Reloads the data and re-applies filters or sorting