Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question
1

Export SQL to CSV files OpenStudio Radiance

asked 2016-06-15 16:39:25 -0500

adityord gravatar image

updated 2016-10-18 14:34:33 -0500

I am currently do simulation using OpenStudio Radiance and would like to know how I can export full EnergyPlus simulation results to a .csv file through OpenStudio? If it's not possible, what program i can use to transform eplusout.sql to the .csv file? . . .

Based on this thread Exporting full (component-level) simulation results to CSV from OpenStudio

Once the OS has been ran, you can turn the eplusout.eso file which contains the hourly results into a .csv by using the ReadVarsEAO.exe program that comes with E+ located here : C:\EnergyPlusV8-3-0\PostProcess

I usually copy the eplusout.eso file into a empty folder and then also copy in the ReadVarsEAO.exe. Simply double click the ReadVarsEAO.exe file and it will create a file called eplusout.csv.

image description

in my Energyplus Folder there is no ReadVarsEAO.exe. files, so what should i do next? thankyou

edit retag flag offensive close merge delete

Comments

ReadVarsESO.exe should be located in the PostProcess directory, which is a subdirectory/folder of your EnergyPlus-[version] directory, which is a subdir of the sharedresources subdirectory of your OpenStudio[version] directory.

rpg777 gravatar imagerpg777 ( 2016-06-15 17:10:27 -0500 )edit

sure, i have to search in the PostProcess and also share folder, but still there is no .exe file name ReadVarsEAO.exe. i use the OpenStudio 1.11.5 Version.

adityord gravatar imageadityord ( 2016-06-15 22:34:27 -0500 )edit

2 Answers

Sort by ยป oldest newest most voted
1

answered 2016-06-16 05:28:47 -0500

Dinosaver gravatar image

If you want to export E+ variables in CSV format you can either apply a measure from BCL (haven't tried it but still) or edit and run the exported out.idf file with option to export variables data to CSV file - this works well. If you want to export Radiance daylight simulation results, then you need to deal with .sql file it provides. Use one of SQLIte database browsers (like this) find a table with daylight results (either maps or for sensors) and export it as a CSV file. Be aware that natively SQLite keeps data as lists of values, not separating them through columns as we used to see in CSV files. You probably will need to format data either before or after the export.

edit flag offensive delete link more

Comments

yess so i do the export using SQLite database browser. And now i had to learn more about this software. is it possible that we know what the units of data, in CSV files? because the result only number without the unit measure.

adityord gravatar imageadityord ( 2016-06-19 11:27:05 -0500 )edit

Depends on what you export. E+ native CSV contains names of variables in the first row, but not their units, this you should know from E+ documentation. If you export CSV from SQL you can export ReportDataDictionary table as a separate CSV, there you see the units. Anyway if you want to receive a beautifully arranged report to present it on a meeting or whatever, you will definitely need some manual work :)

Dinosaver gravatar imageDinosaver ( 2016-06-20 03:21:30 -0500 )edit
1

answered 2016-06-16 02:53:58 -0500

updated 2016-06-16 03:06:40 -0500

Clearly that was an honest typo from @TaylorRoberts on the inital question (I just corrected it)...

ReadVarsESO.exe is the name of the program you're looking for. It's an .eso file, makes sense no?

Also see this question Exporting results data from Openstudio and do a query on the BCL

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

 



Question Tools

1 follower

Stats

Asked: 2016-06-15 16:39:25 -0500

Seen: 154 times

Last updated: Jun 16 '16