Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

proposed update for drawing schedule extraction format #1

Open
vdubya opened this issue Jul 16, 2019 · 0 comments
Open

proposed update for drawing schedule extraction format #1

vdubya opened this issue Jul 16, 2019 · 0 comments
Labels
enhancement New feature or request

Comments

@vdubya
Copy link
Owner

vdubya commented Jul 16, 2019

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.
@vdubya vdubya added the enhancement New feature or request label Jul 27, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant