@PLI team (SQLite)

[providers]

Hi,

I have some questions:

Is epg.db the database file for SQLite?

Under "Services" I find "channels", "providers" and "servicekey."
is this automatic createt by the image?

Under Enigmacache" I can also find start and stop times for different channels, but I can find any data about "program name" and "info bu program" where s thatstored?


Can you guys plz try to explain the database structure?
Is there anyway to import xmltv to this SQL database?



regards
/Providers

[d00z]

Is the epg.db file "plain" SQLite3 file and is there any program that can open it for study..

i have tried with sqlitebrowser but gets same result as provider...

--
d00z

[sat-turner]

Originally Posted by providers

Is epg.db the database file for SQLite?

Yes. Garnet works with SQLite version 3.3.5. So, you can open it with SQLite tools based on this version. On a 7020 you can use the sqlite3 client app.

Originally Posted by providers

Under "Services" I find "channels", "providers" and "servicekey." is this automatic createt by the image?

Yes it is created during when the database file is created. From then on services are added and removed when services are found or deleted in enigma. On pitfall: when you temporarily use the standard epg store, you may miss these events.

Originally Posted by providers

Under Enigmacache" I can also find start and stop times for different channels, but I can find any data about "program name" and "info bu program" where s thatstored?

There is a field eitData in the table epgcache. This contains binairy data that is in EIT format. This is not the easiest format to read, but this is what enigma can read directly.

Originally Posted by providers

Can you guys plz try to explain the database structure?
Is there anyway to import xmltv to this SQL database?

I have seen some 3rd party plugins and programs.

Best regards,
Sat-Turner

[sat-turner]

Originally Posted by d00z

Is the epg.db file "plain" SQLite3 file and is there any program that can open it for study..

Yes, this file is plain SQLite3 and open. If you have a 7020 you can examine the file with the sqlite3 client tool. If you use an external tool, be sure to use the right version. SQLite is pretty critical about the version.

Best regards,
Sat-Turner

[providers]

Is it possible that you could give me name on the some of the 3rd party plugins and programs, maybe upload them if you have them.

rgs.
Providers

[sat-turner]

Originally Posted by providers

Is it possible that you could give me name on the some of the 3rd party plugins and programs, maybe upload them if you have them.

You can download "Dreambox EPG config" via the software downloads in PLi. That one uses the SQLite store.

Cheers,
Sat-Turner

[redneck eyeball]

And with that plugin you will get a couple of scripts installed in /var/bin

Have a look a those scripts, that will tell you how to get the xmltv data into the epg store.

CU
Red

[d00z]

fixed it, a mod could delete this post..

--
d00z