Skip to content

proposed update for drawing schedule extraction format #1

@vdubya

Description

@vdubya

Proposal for new schema to address some minor issues.

  1. camelCase
  2. Add columnID to preserve extracted column order.
  3. Add scheduleID as convenience to counting total number of schedules.
  4. Reorder to put schedule info up front and file at end. fileName and filePath are optional and do not need to be submitted so best at end.
  5. Renamed some fields for consistency

Data Extraction Schema (Proposed)

The following data is extracted in the following comma delimited format with quote wrapped strings, with one CSV row for each drawing schedule column:

"columnID","scheduleID","scheduleTitle","isOnSheet","columnHeaders","parameterName","isShared","sharedParameterGUID","columnValues","fileHashID","fileName","filePath"
  1. columnID: Sequential numeric column ID based on the order of schedule columns starting at 1 up to total number of columns extracted.
  2. scheduleID: Sequential numeric schedule ID starting at 1 up to total number of schedules extracted.
  3. scheduleTitle: Title of drawing schedule if displayed graphically on the sheet. This can be different than the name of the schedule used in the GUI.
  4. isOnSheet: True if the drawing schedule appears on a sheet, otherwise False.
  5. columnHeaders: Drawing schedule column headers. Headers with groupings are formatted with a "|" delimiter like: "Column Group Header Text|Column Header Text". Column headers and groupings are what are displayed graphically, and are not required to match the parameterName containing the data.
  6. parameterName: Name of the parameter that stores the data. The parameter name can be different than what ColumnHeaders displays on the sheet.
  7. isShared: True if the Parameter Name is stored with a parameter with a GUID (in Revit, a "Shared Parameter"), and False if not.
  8. sharedParameterGUID: GUID of the parameter (in Revit, the Shared Parameter GUID)
  9. columnValues: All values in the column separated by the delimiter "|". Delimiter only between values, not at beginning and end. An empty column results in "" not "||".
  10. fileHashID: SHA256 hash of file, used to uniquely ID each file independent of filename, timestamp, and path.
  11. fileName: File name without path.
  12. filePath: File name with full path.

Notes:

  1. fileName and filePath are extracted but optional for submission.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions