pyRevit icon indicating copy to clipboard operation
pyRevit copied to clipboard

Update an existing schedule from a modified CSV

Open theoryshaw opened this issue 2 years ago • 5 comments

Is your feature request related to a problem? Please describe. It seems, although i might be wrong, that there's no way to update a schedule from an external CSV that has been updated. If an external CSV is updated, you have to 'Create Schedule from CSV', and then delete the old one. So any formatting you did on the previous schedule is lost, and you have to recreate the formatting on the new schedule.

Describe the solution you'd like Just a simple way to import or link in updated data from an external CSV, without having to create a new schedule in revit.

theoryshaw avatar Jan 26 '23 17:01 theoryshaw

You are right, not with the actual tool. I use DiRoots Sheetlink to do such things. Another way would be to create a schedule template from the original and apply it to the newly created one.

Doing such a tool is no small task, I think, top of my head this implies:

  • grab the parameters
  • deal with their units
  • get the categories and elements they are applied to
  • extract all of that as a csv
  • import the csv
  • check the modified data against the actual schedule
  • deal with errors
  • set parameter values of elements
  • create new elements in Revit if new lines are created (doable for rooms and spaces, but unlikely friendly for other categories as they need a location...)

jmcouffin avatar Jan 28 '24 22:01 jmcouffin

If you would like to start, I could give a hand, but I think the SheetLink from DiRoots, being free, kind of kills it, unless it adds more water to the well than Sheetlink

jmcouffin avatar Jan 28 '24 22:01 jmcouffin