Video Archive Plug-in Update

[Jeff]

Posted at the wiki site.

* Made the list of file extensions that should be treated as video files a configurable option. By default the list, which is case insensitive, contains mpg, mpeg, and avi.

* Added current time to the display. You will need to update the Preview View skin.xml and List View skin.xml skin files.

* Doubled the size of ratings field in the database to 20 characters from 10. This will be upgraded automatically when you use the plug-in

* Moved the processing of the VA panel messages into the CommonGBPVRUtilties library. This means that other plug-ins could, if they wanted to, display messages in this panel. As an example, the message processing for the “Now playing” music function has been moved into its own mini panel widget. You now need to place the MusicVAPanelWidget.dll library into the plugin directory. The weather plug-in has also been updated to display the forecast for the current and next day.

* Bug fix: Fixed bug in importing tagline, director name, and wrote names that contain apostrophes (') from My Videos database

* Bug fix: Fixed bug that could audio tracks to continue to show in the panel even after they had finished playing

* Bug fix: DVD2MPEG standalone button will no longer display if there are no DVDPaths defined

* Bug fix: Fixed bug that would cause the video archiver panel to display the next message in the queue whenever the main screen was redrawn. When using in combination with the RSS news feed panel this would result in new messages being displayed every second. New messages are now displayed at the rate specified by the config settings.

[wattsy]

When playing music panels shows
TESTNow Playing:

[Jeff]

Ooops. You are right. Obviously that was in there for testing. I have posted a new update (Apr-13a-05VAPlugin.zip) to the wike site. Only the MusicVAPanelWidget.dll file has changed.

Jeff

[Jeff]

What do you mean exsactly by rebuilding GBPVR? I delete all the plug-in's settings from my config.xml directory and deleting the database from my archive directory to try running as a clean install. Everything work fine for me. Can you look in the jeff directory at you archiver-pc.log or archiver-mvp.log file and see what it says. The beginning should look something like this

4/13/2005 8:42:15 PM In ArchiveVideosTask constructor

4/13/2005 8:42:15 PM Found GBPVR DatabaseConnectionString Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Program Files\devnz\gbpvr\gbpvr.mdb";User Id=admin;Password=

4/13/2005 8:42:36 PM Archive DB not found; copying initial file from C:\Program Files\devnz\gbpvr\\Jeff\video archive.mdb to C:\Program Files\devnz\gbpvr\video archive.mdb

4/13/2005 8:42:36 PM ArchiveVideosTask constructor done

4/13/2005 8:42:36 PM Starting ShowList.FillDirList thread

4/13/2005 8:42:36 PM Starting DVDList.FillDirList thread

4/13/2005 8:42:36 PM ArchiveVideosTask init done

Jeff

[Jeff]

What about the Weather plug-in the numbers are all bunched up, but then again what font did you use? Also is there a Weather panel for the main menu, I didn't think there was?

I used Arial Narrow. Everything is skinable now so you can move things around on a field-by-field basis to un-bunch things to look good to you.

With respect to the panel, there is not a dedicated weather planel. Instead the weather plug-in will optionally post messages to the video archiver panel. The video archive panel cycles through all posted messages. So far it can display weather, current audio audio track, next pending recording, and free disk space warnings.

Jeff

[Spartan]

I am getting a problem with VA, and I don't think it is related to the latest version...

From the logfile (ArchiveDB-MVP.log):

4/14/2005 9:48:52 AM    Error saving record for CSI Miami_20050411_22002300.mpg

4/14/2005 9:48:52 AM    CommandText was UPDATE ArchiveTable Set Title='CSI: Miami', Description='When an IRS agent is killed trying to repossess a yacht, and another is shot to death soon afterward, the CSIs search for the perpetrators in a potential series of murders before tax day.', StartTime='10:00 PM', RecordDate='4/11/2005', ChannelName='3 WWMT', Viewed=1, UniqueID='EP5240610067', Genre='',Subtitle='Sex & Taxes',Runtime='60', Actors='',Rating='',Director='Scott Shiffman',InternetFetchCompleted=0, YearOfRelease = 'April 11, 2005', Tagline ='',	Writer ='EP5240610067', ViewerRating ='7.04 out of 10', Votes ='23' WHERE VideoFile='CSI Miami_20050411_22002300.mpg'

4/14/2005 9:48:52 AM    System.Data.OleDb.OleDbException: The field is too small to accept the amount of data you attempted to add.  Try inserting or pasting less data.
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at CommonGBPVRUtilities.ArchiveDB.AddOrUpdateRecordForFile(String filename, ArchiveRecord record)

Now, after playing around with access a little bit, I have determined that the problem lies in the "YearOfRelease" field and that the data April 11, 2005 is trying to get stuffed into it. (YearOfRelease is defined as a Text/4 field)

On a somewhat related note, I am trying to activate DVD to MPEG on my menu and I cannot get it to show up. I do have all of the necessary directories defined.

[Jeff]

I will up the yearOfRelease filed to 30. The upgrade will happen automatically as part of the next release.

With respect to the second issue, can you email me (or post) your config.xml file?

Jeff

[Spartan]

re-installed A/V and got the same error message:

Microsoft.NET Framework

"Exception: Could not find file: C:\Program Files\gbprvr\video archive.mdb"

I just check the current zip file and it's not in the root of gbpvr it's only in jeff directory. This could be because I've updated .NET, but now I'll have to move the mdb to the root of gbpvr for this to work. Just letting you know Jeff..

I thought that was intentional so that when you upgrade the plugin, it doesn't trash your database.

[Jeff]

You are correct. The plug-in does not require that the database be in the GBPVR root directory. It only needs to be there if that is the directory you are using to store the archive, in which case it should automatically be copied from the jeff directory if it is not found in the GBPVR root. I don't understand why Tipster is having the problem he is having.

[dneprrider]

You are correct. The plug-in does not require that the database be in the GBPVR root directory. It only needs to be there if that is the directory you are using to store the archive, in which case it should automatically be copied from the jeff directory if it is not found in the GBPVR root. I don't understand why Tipster is having the problem he is having.

Yesterday I downloaded the latest VA plugin. Never having installed it before. I opened the config app to check the setting and it gave me the same error:

"Exception: Could not find file: C:\Program Files\gbprvr\video archive.mdb"

Then all the pull down boxes in config were blanked out.

I closed the config app and restarted the computer. I tried the config app again and all was well.

Now when I try exiting GBPVR it hangs and won’t close. Have to CTRL ALT DELETE to bring up task manager then cancel to go back to the windows desktop.

Strange. Only change since yesterday is a new VA plugin installation.