Once the data are imported, typically from a comma separated value ( csv) file, it simply provides an interface so that we can ask questions using Structured Query Language (SQL). It has none of the overly-complex wrappings of MS Access or LibreOffice Base and doesn’t need a server like MySQL or Oracle. These can also be read by other software e.g. Firefox) use to store your bookmarks and history. It uses an SQLite database, which is what many browsers (e.g. This post aims to show how using a real database makes this easier. They are convenient places to enter and store data, but not to get it out again. Even so, spreadsheets are commonly used as such. The name in brackets is important for selection in next file. Here I have two set up - is for SqLite2 DB’s and is for SqLite3 DB’s. The odbcinst.ini file contains the information for the actual drivers: The are just text type files so if they don’t exist already they are easy to create. The are two files needed in /etc folder - ‘odbc.ini’ & ‘odbcinst.ini’.
Have not been able to find a JDBC driver which works for me so all is based upon ODBC for the connection. Haven’t used in quite a while so again tested how to set up again today. Regardless, here is a set up I use on Xubuntu 16.04 (last test was with LO 5.4.x but others used). Additionally, most other report generators I have used are Java based. I can get SqLite to work on Base with tables & forms but not Report Builder unless Java JRE (or even OpenJDK) is installed. If one of your conditions is NOT to use Java at all, then I cannot think of a way to generate this report. Has anybody solved this problem in a simple way? (by simple, I mean I don’t want to compile from source)Īll suggestions are welcome, including pointing me to packaged stand-alone report generator (important word here is “packaged”). In the end, I don(t know if this is a Fedora issue, an SQLite one, A LO one or some other. I also searched through LO extensions but it appears there’s nothing related to SQLite connector. However, for various reasons, I don’t want to install Java on my machine (anyway not knowing if I would succeed). Under “connector” jODBC, I can select any file, thus making SQLite DBs visible. ODBC Data Source: SQLite3 (but same behaviour wit SQLite – for SQLite v2)Īuthentication: none (as there is none in SQLite)įile selection dialog opens but only choice is ODF data base which will not display SQLite DB files. In order to connect to the database, I installed packages unixODBC and sqliteODBC, but when configuring access to said base with Base wizard: I want to generate summary report from an existing active SQLite DB. I searched through this site and googled without finding the appropriate fix. This is a duplicate/refresh of this old question because its answer is not satisfactory or outdated.
Config: LO 5.3.7.2, Linux 4.13, Fedora 26 (I have another “experimental” config under Fedora 27, but problem is the same)
0 kommentar(er)
