Error in reading sql output

sql-file
energyplus
retag add tags

E+ provides the results in .sql format for SQLite 3 database. But when I try to launch this sql to get a real database in .sqlite format it returns me a syntax error. Just opening works fine, but I need to process data further, so I'd like to have a real database... What may be the problem?

990

Dinosaver

asked 2016-05-27 10:17:40 -0500

4.4k

__AmirRoth__

updated 2017-05-08 18:21:42 -0500

edit flag offensive 0 remove flag close merge delete

Comments

I think we need some more information, here. Could you share your command statements and any standard or error messages returned?

rpg777 (2016-05-27 16:53:23 -0500) edit

I use DB Browser for SQLite (the same with some others). The message is "Error in statement #1: near "SQLite": syntax error

Dinosaver (2016-05-28 10:20:39 -0500) edit

Hmmm, can you put a copy of the DB on Dropbox or similar, and provide a download link?

rpg777 (2016-06-01 09:49:02 -0500) edit

link text

Dinosaver (2016-06-03 13:15:42 -0500) edit

This file opens fine in OpenStudio's ResultsViewer app, and SQLite Browser.

rpg777 (2016-06-03 16:29:42 -0500) edit

add a comment see more comments

2 Answers

Sort by

oldest

newest

most voted

The eplustbl.sql file is a SQLite database. It is not a SQL command file. So you should open it in DB browser and then do queries using your own SQL command.

1.2k

Yi Zhang

answered 2016-06-04 04:13:10 -0500

edit flag offensive 0 remove flag delete link

Comments

Ok, I got it. I just open it in DB Browser, dump to and .sql and then import that dump into an empty database with .db extension. Now it works. Thx everyone.

Dinosaver (2016-06-10 09:30:02 -0500) edit

add a comment see more comments

Sorry, I misunderstood your question initially. Just putting your conundrum into the Googleizer, I found a few UOIs (urls of interest) that may help, here, here, and here. YMMV.