This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Importing SQLite files

Tags: None
(comma "," separated)
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS

Importing SQLite files

Wed Jan 01, 2014 2:17 pm
Hi, Posting a question from Jonathan, under his permission:

Jonathan Ryshpan, jonrysh@pacbell.net wrote:I am interested in trying out kexi to access a sqlite database which is continually being added to by my home weather station, which is accessible from the web at: http://oaklandweather.no-ip.org/index.html/ . I am quite ignorant about databases in general and almost totally ignorant about kexi, which does look as if it might do what I want, which is to calculate simple results (rainfall totals, etc) from the database. The actual sdb file is hidden in the server; but I can email you a short instance. I am quite familiar with software development; I worked on embedded systems of varying levels of complexity for about 20 years.

Kexi as available on my system (Fedora-19) won't import the database. On attempting to import it, kexi reports:

Code: Select all
Could not import database "/home/jonrysh/src/wview/archive/wview-archive.sdb". This type is not supported.

So it appears that the sqlite module for kexi is not included in the Fedora-19 distribution. How can I verify this? Are there any .so files whose presence or absence would indicate whether the sqlite driver is present?

The development page for this module, https://community.kde.org/Kexi/KexiDB/K ... ers/SQLite

is a little vague about what to do. I assume it gives build instructions for a source package, for my system this would most likely be calligra-2.7.4-1.fc19.src.rpm.

Is this correct? The instructions appear to be targeted towards building under Debian Linux. The RPM spec file has a quite different format. Do you have any hints about how to proceed?

Thanks for your help, and please excuse the length of this message.

Happy New Year & All the best - jon


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS

Re: Importing SQLite files

Wed Jan 01, 2014 2:43 pm
Hi Jonathan,
Thanks for contacting the Kexi community!
Currently Kexi does not open SQLite files "in place", it needs some metadata added (once) so it can see the tables. This metadata is created by Kexi itself, so it's missing in sqlite files created elsewhere. So you of course have the SQLite 3 driver in Kexi.

For the record, here is the SQLite file you have sent me (as you said elsewhere, it's public file): http://kexi-project.org/download/tests/ ... -31.sdb.xz (600KB compressed using xz).

I am interested in this use case. Before Kexi handles it out of the box (ie. imports SQLite tables or files) I'd like to provide a workaround. Stay tuned.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS

Re: Importing SQLite files  Topic is solved

Fri Jan 03, 2014 11:47 pm
Hello,
Just published a tutorial: Importing SQLite database into Kexi. Please do not hesitate to ask for clarifications or improvements.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
gbriggs
Registered Member
Posts
3
Karma
0

Re: Importing SQLite files

Tue Mar 07, 2017 5:27 pm
For what it's worth, I just posted a script that kinda-sorta does most of this, automatically: https://forum.kde.org/viewtopic.php?f=220&t=139243

Cheers
Gary


Bookmarks



Who is online

Registered users: Bing [Bot], gfielding, Google [Bot], markhm, sethaaaa, Sogou [Bot], Yahoo [Bot]