SQL-ish


#1

We have seen Excel in and out scripts to alter data in our revit model.

The thought of adding a SQL-ish workflow to alter data, has that been put to the test in Dynamo, thus skipping the Excel step?

 

Marcel


#2

Let me elaborate.

The Replace node lets me change a value in a text field. In SQL i can change all kind of fields in a SQLdatabase. I know there are fields in the Revit database that won’t allow me those changes, I have some experience with the Revit DBLink and Ideate BIMLink, and thus i know that there are possibilities to change fields other than text fields. If i can make changes based on a condition of another field (value) that would be nice. I see many similarities between Dynamo and SQL, for instance, a node that gives me the category Doors can be stated in SQL by the SELECT DOORS command in the Revit database, etc. Would this all work if i load a SQL.dll in Dynamo?

Thanks in advance,

Marcel

PS,

English is not my native language, i hope i get points for giving it a try.


#3

I would checkout slingshot for Dynamo by case inc on the package manager. It’s an sql library, I’m not sure if it supports sql or sqlite.