Question-and-Answer Resource for the Building Energy Modeling Community
 | 1 | initial version |
You may want to look at this post on Getting CSV From SQL. If you do want to automate this through a measure we have an example measure that exports schedules to a csv file. While this specific example exports input data from the OSM, you can use the same approach for tabular or time series sql data. You will have to learn how to do the sql queries to find the data you are looking for. A reporting measure can also inject variable requests ahead of the run if you need it.
| | 2 | No.2 Revision |
You may want to look at this post on Getting CSV From SQL. If you do want to automate this through a measure we have an example measure that exports schedules to a csv file. , and there's an answer here which explains its use. While this specific example exports input data from the OSM, you can use the same approach for tabular or time series sql data. You will have to learn how to do the sql queries to find the data you are looking for. A reporting measure can also inject variable requests ahead of the run if you need it.
