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

Revision history [back]

click to hide/show revision 1
initial version

How to connect a database to E+ using BCVTB in each timestep

I am trying to receive data from a database (PostgreSQL)( each row in each time step) and send it to Eplus model. I am using SQLStatement in BCVTB to retrieve data. However it brings the entire 8760 row in each time step. Any suggestion how can I get the first row of data in first time step, the second row in the second time step and the same for other rows?image description

The picture shows how data converted from string to Array of doubles but still time step is the main problem.

How to connect a database to E+ using BCVTB in each timestep

I am trying to receive data from a database (PostgreSQL)( each row in each time step) and send it to Eplus model. I am using SQLStatement in BCVTB to retrieve data. However it brings the entire 8760 row in each time step. Any suggestion how can I get the first row of data in first time step, the second row in the second time step and the same for other rows?image description

The picture shows how data converted from string to Array of doubles but still time step is the main problem.