as i need to simulate the energy use for the district, and i have seprated to few .gh files for simulation. Each file can simulate the result successfully. However, i would like to combine the whole district for analysis, i.e. how to call back all .sql files related to this district into one .gh file. Therefore, what is the fastest method to call back the .sql file so that the results can be analyzed by ladybug?
if you already run the simulations, you can just call the .sql file with a panel or a filepath and reimport it via the read result components under the tab 6::results.
You can find these under "C:Ladybug’NameofyoufSimuletion’…
Than you can deconstruct the data and add it up hourly, etc. - whatevery you like and recombine it with a suitable header, thus it can be used for graphs again.
however, there are about 100 .sql files. I need to type their path manually? Or there is a fast method to recall these 100 .sql files?
No you can autoomatically create the filepath either using python or simple grasshopper components. For example I have an automatic naming convention for the files and then I just add via “concentrate” the other parts to create the full filepath. Here is a snipped:
This is then used as an Input to the read results.
would you mind to show me the name of the grasshopper components which you have used in the above snap?
It is concentrate componet.
Would you also mind to upload the .gh file for me, as i dont know how to write a program
ReadResultsFromSQL.gh (46.1 KB)
Attached is my solution to this.
Recently I needed to re-read results from a Dragonfly/UrbanOpt simulation of a couple thousand buildings. I had to split those buildings into groups - roughly 100-200 buildings at a time - to reduce the size - and it still took 15-20 mins to read the results (when loading hourly results; daily or monthly results reporting would be much faster).
The file uses the export excel tool from TTToolbox and a custom C# component to split the resulting text into multi-line text (so you can copy & paste into column ‘A’ of Excel with building/zone names). I downloaded the C# component a while ago - it’s from another user on the LBT forum, but I couldn’t find the post to give them credit for it.
Hope this is helpful to you,