It seems that ParaLED uses software that only works with parallel ports that are part of the motherboard. Unfortunately, my computer did not come with any serial or parallel port built into the motherboard. I had to add a PCI card that provides one parallel and two serial ports.
ParaLED, or more specifically, the combination of ParaLED and Inpout32.dll do not work with this type of parallel port, even if I change the port address. Has anyone come up with a solution to this problem?
Any SQL gurus out there? I need a bit of help please in completing an SQL query to retrieve the next pending & in-progress recordings from the new schema in the NPVR.db3 database.
Using GBPVRWAKE, postprocessing.bat & parallelprocessing.bat I pipe these into a text file so I can use LCDSmartie to display them on my iMON VFD. This means theat I can easily see if anything is recording or about to record and for example I don't then put the PC into standby if there is. Also when the PC is in standby it displays the time the PC will wake for its next recording. With GBPVR this function was provided by the GBPVRCli program (provided as part of the SlimmGBPVR utility); the auther has confirmed this is not planned to be updated for NPVR.
I've got this far modifying SQL that I've plagiarised from the forum (thanks pBS) which runs via the SQLITE3 command line utility .
Code:
REM pending 3 recordings
"sqlite3.exe" -separator " -- " "npvr.db3" "SELECT name from SCHEDULED_RECORDING where status = '0' order by start_time limit 3;" > "C:\Users\Public\NPVR\EXTRAS\PendName.txt"
"sqlite3.exe" -separator " -- " "npvr.db3" "SELECT strftime('%%d-%%m %%H:%%M',start_time) from SCHEDULED_RECORDING where status = '0' order by start_time limit 3;" > "C:\Users\Public\NPVR\EXTRAS\PendTime.txt"
Rem IN-PROGRESS recordings (for upto three tuners)
"sqlite3.exe" -separator " -- " "npvr.db3" "SELECT name from SCHEDULED_RECORDING where status = '1' order by start_time limit 3;" > "C:\Users\Public\NPVR\EXTRAS\ProgName.txt"
"sqlite3.exe" -separator " -- " "npvr.db3" "SELECT strftime('%%H:%%M',end_time) from SCHEDULED_RECORDING where status = '1' order by start_time limit 3;" > "C:\Users\Public\NPVR\EXTRAS\ProgTime.txt"
REM next pending recording for USBPORT file for display during standby
"sqlite3.exe" -separator " -- " "npvr.db3" "SELECT name from SCHEDULED_RECORDING where status = '0' order by start_time limit 1;" > "C:\UTILS\LCDsmartie\USBPortExit.txt"
"sqlite3.exe" -separator " -- " "npvr.db3" "SELECT strftime('%%d-%%m %%H:%%M',start_time) from SCHEDULED_RECORDING where status = '0' order by start_time limit 1;" >> "C:\UTILS\LCDsmartie\USBPortExit.txt"
What I need a bit of help with please is:
1. The times returned for start/end time are an hour early. I assume this is as actual time (in UK) is currently BST but it is reporting GMT (or UMT).
2. I can get 'name', 'start_time' & 'end_time' but 'subtitle' is now only kept within an XML subfields structure in the 'event_details' field shown below. I can't see an easy way to get at just this.
Code:
<Event>
<OID>752285</OID>
<Title>Match of the Day</Title>
<SubTitle>World Cup 2010</SubTitle>
<Description>Colin Murray presents highlights of the day's three group matches, with all the reaction from England's clash with Algeria in Cape Town. The day's other Group C game sees the USA take on Slovenia in Johannesburg, while Germany meet Serbia in Group D.</Description>
<ChannelOID>6864</ChannelOID>
<StartTime>2010-06-18T21:00:00.0000000</StartTime>
<EndTime>2010-06-18T21:30:00.0000000</EndTime>
</Event>
It's seems NPVR 1.15 is all about changes, I am looking at a name change for MusicLibrary4 simply because the Default skin won't allow a name this long. Sub's Music Library is now just Music so MusicLibrary is an option but it might be confusing.
Since I've started testing out the recordings I have noticed the recording menu itself has slowed right down. As of tonight, I am also getting a database locked error. Logs attached.
Only other dabbling I have been doing is to set up a postprocessing batch file to transcode to MP4.
When playing DVD videos that I've copied to my video library folder, the video plays fine, but it shows the closed caption/subitle. I can't get rid of it.
These are DVD's that I copied the main movie files using a DVD copy program.
When I watch live tv on an analog channel, there is a slight stutter. If I pause and play just for a partial second to build a buffer, then the stutter goes away. Is there a preplay delay type setting I can access? I did not see it in the config file.
Im having issues with DVB EPG updates .. Im getting multiple entries for individual programs, that overlap - A LOT. So for example, I might get Ch 7 with a show running 1900 -2030. Then another entry in the guide with the same show running 1935 - 2030.. and so on.. The problem gets worse with the days updating.. Its affecting most, but not all channels, and only DVB EPG data. Any ideas? The aesthetics are horrific , sub would cry..
XMLTV updates (fm oztivo) are working fine - and Ive swung most channels back to this now for reliability, but I do like the seemingly more comprehensive data fm the stations.
Im in Adelaide, South Australia BTW.
