iMONDisplayPlugin Release

[kindt nick]

Started working from Monday again.

uploaded update 6. Watch out, there is a huge change in Keynames. I changed these because, for me, it was not easy to read anymore.

Currently implemented :
- Retain Data
- Message with or without time on idle
- EPG information, as a test for the subtitle you've asked (only implemented in extra keys)

If subtitle is not working, could you send me some sources of other plugins that can do that?

Also cleaning up the code and adjusting the iMON VFD section.

Also looking into the FFDSHOW API, to get the current codec used, for LCD

grtz,
Nick

[pBS]

subtitle not working for me, i can get you some db queries to get all the info, but you'll have to get basic sqlite3 queries going yourself..
i was using the .dll and it's pretty simple, but there should be a npvr helper api for the db access i think..
i'm not aware of any plugins except maybe tvlistings that use it in npvr...

i still have to test more thoroughly on my dev setup, but one thing i noticed is that one winxp, it still looks for the xml setting file in c:\users\... instead of c:\documents and settings\etc.. checked and appdir is set in registry..
i have next rec, filename->proper title/subtitle/desc, livetv channel, and in-progress recording queries..

[kindt nick]

I know, for now the .xml is a fixed path, I will change it.

So what text is written into the EPGSource & EPGMapping key?
I'm guessing that I'll have to retrieve extra information manually via the EPGSource key.

Nick

[dazzyb2k3]

This is developing really nicely. I'll try and get round to testing the new version in the next couple of days

[pBS]

the epg source is XMLTV and epgmapping is

Code:

<epg>
  <source>XMLTV</source>
  <file>\\PVR2\gbpvr\epg\mceloc.xml</file>
  <mapping_id>8.KUHT.1</mapping_id>
  <mapping_name>8 KUHT</mapping_name>
</epg>

for livetv...nothing for either when playing files..

for livetv i would get channel, then determine current time and look up in epg[db] whats on that channel at that time and get title,subtitle and desc....
for files of any kind, get file's case insensitive name only and search db for match and get info, or if no match, show filename...[audio same]

for npvr he changed existing recordings to have epg info in their scheduled_recordings event_details entry, in xml...so you'd have to look in there instead of epg for file info..you'll have to parse the xml to separate the info...
only for livetv look in db epg...
you could also just parse the file:metadata.xml attached to each file, but fat32 users wouldn't work..[only ntfs] and sometimes it doesn't get created if stopped prematurely..

oh and don't forget to take the "R" off of next and others so it only gets attached to in-progress recordings..[to tell them apart]

i've adjusted key names and have new setup instructs...
once everything's working i'll zip up a complete working setup with plugins and all,ready to go...

oh and you have a small typo in settings.xml time="H:MM tt"
i keep having to adjust it..

oh and make a subroutine to convert the 24hr times to 12hr+am/pm as that is much easier for users to read..

[pBS]

one nice thing about my separate app was i could continue to update next/inprogress recordings while program was closed...
but i guess that's impossible without an app running all the time..
hmm,i wonder if there's a sqlite3 plugin for smartie? lol
[wouldn't be hard to make]
i might be able to use cmd line ver sqlite3.exe to get it done.....

haha, found it, done it.....next rec info straight from database!
http://forums.lcdsmartie.org/viewtopic.p...ite#p14413
problem with plugin is it uses .ini and only 1 query...but can select field in smartie...
i'll see if he can't add more queries in the same .ini but for persistent Next: info one is all we need..
here's my query for next rec info: save as sqlitedb.ini in smartie plugins dir
smartie line: $Dll(sqlitedb,1,,)

Code:

[config]
refresh=5000
dbpath=c:\Users\Public\NPVR\npvr.db3
query=SELECT 'Next:' || strftime('%H:%M',start_time), ' [' || name, '] ' FROM scheduled_recording WHERE status = 0  order by start_time limit 1
separator=
endrow=

which gives: Next:15:30 [NFL Football]
and it will update even when npvr is closed

guess this means you don't need to worry about nextrec and persistent info...

p.s. i'll see if i can't work out a way to have current recordings added too...

[pBS]

LOL, i found it! after some trial and error, i have succesfully found way to convert 24hr time format to 12hr and add pm/am to end in the sqlite query alone!

this won't run from cmdline cuz of all the |>< and other chars, but works in sqlite plugin and more importantly, smartie!
glad i figured this out cuz no other option using just smartie alone...
it's amazing what can be done with the queries themselves..formatting, alteration, etc also..but it gets complicated..lol

stick this in sqlitedb.ini query line:

Code:

SELECT 'Next-'||CASE WHEN strftime('%H',start_time,'localtime') > '12' THEN ((strftime('%H',start_time,'localtime') - 12)|| ':' ||strftime('%M',start_time,'localtime')|| 'pm') WHEN strftime('%H',start_time,'localtime') = '12' THEN '12'||(strftime(':%M',start_time,'localtime')|| 'pm') WHEN strftime('%H',start_time,'localtime') = '00' THEN '12'||(strftime(':%M',start_time,'localtime')|| 'am') ELSE (strftime('%H:%M',start_time,'localtime') || 'am')  END AS 'AmPmTime', ' ' ||name || ' ' FROM scheduled_recording WHERE status = 0  order by start_time limit 1

which shows: Next: 3:00pm NFL Football
but it's hard to read, so here tis with a bit of formatting:

Code:

SELECT 'Next-'||CASE
  WHEN strftime('%H',start_time,'localtime') > '12' THEN ((strftime('%H',start_time,'localtime') - 12)|| ':' ||strftime('%M',start_time,'localtime')|| 'pm')
  WHEN strftime('%H',start_time,'localtime') = '12' THEN '12'||(strftime(':%M',start_time,'localtime')|| 'pm')
  WHEN strftime('%H',start_time,'localtime') = '00' THEN '12'||(strftime(':%M',start_time,'localtime')|| 'am')
ELSE (strftime('%H:%M',start_time,'localtime') || 'am')  END AS 'AmPmTime',  ' ' ||name || ' '
  FROM scheduled_recording WHERE status = 0  order by start_time limit 1

Enjoy!!

found bug as time of 12:00pm [midnight] gives 00:00 time...easy fix...will post fix once it's confirmed..fixed!

plus found out times are not in localtime!! so Nick you'll have to adjust your times as well, add ,'localtime' to time queries for local adjusts
cuz i noticed both our next:times were off by 6 hrs here, so i adjusted my time queries and it came out right..

[kindt nick]

the epg source is XMLTV and epgmapping is

Code:

<epg>
  <source>XMLTV</source>
  <file>\\PVR2\gbpvr\epg\mceloc.xml</file>
  <mapping_id>8.KUHT.1</mapping_id>
  <mapping_name>8 KUHT</mapping_name>
</epg>

for livetv...nothing for either when playing files..

for livetv i would get channel, then determine current time and look up in epg[db] whats on that channel at that time and get title,subtitle and desc....
for files of any kind, get file's case insensitive name only and search db for match and get info, or if no match, show filename...[audio same]

for npvr he changed existing recordings to have epg info in their scheduled_recordings event_details entry, in xml...so you'd have to look in there instead of epg for file info..you'll have to parse the xml to separate the info...
only for livetv look in db epg...
you could also just parse the file:metadata.xml attached to each file, but fat32 users wouldn't work..[only ntfs] and sometimes it doesn't get created if stopped prematurely..

oh and don't forget to take the "R" off of next and others so it only gets attached to in-progress recordings..[to tell them apart]

i've adjusted key names and have new setup instructs...
once everything's working i'll zip up a complete working setup with plugins and all,ready to go...

oh and you have a small typo in settings.xml time="H:MM tt"
i keep having to adjust it..

oh and make a subroutine to convert the 24hr times to 12hr+am/pm as that is much easier for users to read..

Started to work again from last monday, and is crazy as hell.

Still,

For recordings, all the information is provided by nPVR (I think so), the channel, channelnumber, title, start & stophour, quality, etc.
For LiveTV I understand that the EPG is stored in a xml file. (pointing to "\\PVR2\gbpvr\epg\mceloc.xml")
Could you send me that file (a sample) so I know how to parse it?

Developing the adjusteble string.
Will do this first. This way, it will be able to create line 1 & 2 yourself. Same for VFD

The houreadjustment... Are you sure it's just +6hr and use localtime for everbody? could you test this by changing your region?


grtz
Nick

[pBS]

yea, it's localtime adjustment. as i see every time inside db for epg is utc...even existing recordings need the adjustment..

and the epg info is stored in db...but only for livetv...no need to parse xml file...just lookup in db with sqlite..
for existing recordings it's in db, but in each file's event_details field,stored in xml format..

for livetv details, lookup in db, and find what's on current channel at current time...always correct no matter source of epg..
for recordings details, also lookup in db, but search for the filename, and look in it's event_details for the entry it used to have in epg..
for music have to look in file's id3 tags..
for dvd's just query drive's volume label...or parent dir name if it's a path and not just a drive letter..[for dvd folders]

for recordings if npvr provides details that's cool, but only if it includes subtitle too..
i have ready-to-go db query strings already if you'd like...slight mods from previous versions..only single queries needed for each one..
[you'll have to handle music and dvd's tho..simple]
if you can get simple sqlite3 db queries working then just plug these queries in and you're good to go..
are you retrieving next info from api or db?

[pBS]

query to get what's on a channel number right now: [livetv]

Code:

SELECT e.title, e.subtitle, e.description FROM channel AS c inner join EPG_EVENT as e on c.oid = e.channel_oid where start_time < datetime('now') and end_time > datetime('now') and c.number = '{CH#}' ;

replace {CH#} with channel number only..

for videos:

Code:

SELECT EVENT_DETAILS FROM scheduled_recording where filename like '%{FILE}%'

replace {FILE} with file name only..[no ext, no path, keep % around it..%=wildcard]
which returns this:

Code:

<Event>
      <OID>357</OID>
      <Title>How I Met Your Mother *</Title>
      <SubTitle>Three Days of Snow</SubTitle>
      <Description>(2009-01-19) Lily and Marshall try to continue their airport reunion tradition; Barney and Ted offer to keep MacLaren&apos;s open during a blizzard so they can meet up with some college girls.</Description>
      <ChannelOID>6919</ChannelOID>
      <StartTime>2009-01-20T01:30:00.0000000Z</StartTime>
      <EndTime>2009-01-20T02:00:00.0000000Z</EndTime>
    </Event>

parse results as an xml file with epg details inside..[title,subtitle,description]

only reason i mention this is cuz npvr might not provide all info, this way you can get any info that's available...
people with 4 line displays could display title 1st line, subtitle 2nd, and have 2 lines for description...

hope that helps..