Question-and-Answer Resource for the Building Energy Modeling Community
 | 1 | initial version |
The complexity of doing so depends highly on what data you're trying to get (could be a simple SQL query or a complicated one).
It also depends which version of E+ you're using. I found out the hard way, when trying to write a Python script to collect information from the SQL file, that in E+ 8.2 update 1 there's a bug that tends to complicate things, the "VIEW" tables are somewhat broken, at least the TabularDataWithStrings (see my answer here).
Good news is that it was fixed in 8.3.
I kinda stopped there, thinking I'll get back to it once I fully move to 8.3 and once I need it, but I have the start of a Python script to load SQL data into a Pandas dataframe, if anyone is interested in collaborating on it, let me know. With the view tables being fixed, it should be pretty simple to make it work, I just didn't have that much time.
Otherwise, I don't know if you have an .eso file being generated as well, but Daren Thomas at ETH Zurich has created a utility called esoreader to load it into dictionaries. I haven't been able to make it work with v8.2 though, not sure why or if it's a version problem.
| | 2 | No.2 Revision |
The complexity of doing so extracting (useful) data from SQL file depends highly on what data you're trying to get (could :could be a simple SQL query or a complicated one).one, could require post-processing or not.
It also depends which version of E+ you're using. I found out the hard way, when trying to write a Python script to collect information from the SQL file, that in E+ 8.2 update 1 there's a bug that tends to complicate things, the "VIEW" tables are somewhat broken, at least the TabularDataWithStrings (see my answer here).
Good news is that it was fixed in 8.3.
I kinda stopped there, thinking I'll get back to it once I fully move to 8.3 and once I need it, but I have the start of a Python script to load SQL data into a Pandas dataframe, if anyone is interested in collaborating on it, let me know. With the view tables being fixed, it should be pretty simple to make it work, I just didn't have that much time.
Otherwise, I don't know if you have an .eso file being generated as well, but Daren Thomas at ETH Zurich has created a utility called esoreader to load it into dictionaries. I haven't been able to make it work with v8.2 though, not sure why or if it's a version problem.
