Data Tables

Located in the Settings menu, the Data Tables feature allows tabular data tables to be entered in Revit, essentially providing lookup tables that may be utilized by other eVolve functions. Tables can be created manually or imported from Excel.

Overview of the Data Tables window

Tool palette buttons
  • Edit Table - Opens a dialog to edit the in-focus table row.
    • NOTE: If the table is flagged as read-only or Data Tables is currently worksharing checked out to another user, the dialog will only have a Cancel button (which effectively makes the table read-only).
  • View Table Info - Displays basic data regarding the selected tables with respect to their size.
  • Export Tables - Allows for exporting selected entries to a file.
  • Import Tables - Allows for importing individual selected entries from a file which can be used to interchange data across projects.
    • Note that this differs from the “Export/Import” button at the bottom of the form which applies the entire data configuration (not just individual entries).
  • Clear Cache - Resets the internal cache which is used for optimization when fetching data tables. This will have a “passive” performance impact but is likely not noticeable to the user.
Data Navigator buttons
  • Add - used to add a new row to the grid.
  • Delete - used to delete selected row(s).
  • Duplicate - used to duplicate selected rows.
  • Export grid - exports the grid as currently displayed to Excel.
Grid Columns
  • Name - Must be unique and can only contain letters, numbers, and spaces.
  • Description - used to provide additional information about the Data Table.
  • Read Only - Specifies if the respective entry is intended to be unalterable. The user can change this without warning but this is intended to prevent inadvertent changes.
  • Last Updated - (read-only) Indicates the last time an entry within the respective data table was modified.

Via the toolbar, users can:

  • Edit Table - Opens a dialog where the focused table row can be edited.
    • If the table is flagged as read-only or Data Tables is currently work-sharing checked out to another user, the dialog will only have a Cancel button (which effectively makes the table read-only).
    • See below for additional details
  • View Table Info - Shows basic data regarding the selected tables with respect to thier size.
  • Export/Import Tables - Allows for exporting or importing individual selected entries to a file which can be used to interchange data across projects.
    • Note that this differs from the “Export/Import” button at the bottom of the form which applies the entire data configuration (not just individual entries).
  • Clear Cache - Resets the internal cache which is used for optimization when fetching data tables. This will have a “passive” performance impact but is likely not noticeable to the user.

The Edit Table grid

The Edit Table function allows users to enter data for existing tables.

Tool palette buttons
  • Add Column - Prompts the user for the column name (must be unique) and what type of data the column holds. This will add the column to the end of the table.
  • Remove Column - Removes the focused column from the table entirely.
  • View Column Info - Display technical data on each column.
  • Metadata - Allows for freeform data to be associated with the table. This does not impact the row/column data but is “attached” to the table and provided to any implementers to use how they see fit.
  • Import From Excel - Imports a table from Excel.
    • This action completely overwrites the current table’s columns and row data.
    • It is assumed column headers are on row 1 in Excel.
    • If column headers have duplicate names, only the first encountered in the Excel sheet is used (the other is ignored).
    • Columns created by the import can specify their data type by having the respective header column title in Excel end with one of the following (spacing is important). When provided, this indicator is removed and not used as part of the header text:
      • ,integer - Column data type should be an integer number.
      • ,decimal - Column data type should be a decimal number.
      • ,boolean - Column data type should be true/false.
      • ,text - Column data type should be text.
      • The default value if this is not provided is text.
      • It is expected that if the column defines the data type, then all cells in that column are of that type. If not then the respective cells are imported with a blank value.
    • Excel column header examples:
      • Value 1 = Header value is “Value 1” / Type is text.
      • Value 1,integer = Header value is “Value 1” / Type is integer.
      • Value 1,decimal,text = Header value is “Value 1,decimal” / Type is text.
Data Navigator buttons
  • Add - used to add a new row to the grid.
  • Delete - used to delete selected row(s).
  • Duplicate - used to duplicate selected rows.
  • Export grid - exports the grid as currently displayed to Excel.
  • BulkUpdate - Allows users to update values for selected entries.

Relevant Articles

Using grids in the eVolve software

Data Navigator

Save Grid States

Searching in grids - using the Find feature


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)