New version of Video Archive plug-in released

[cubsfan]

Would it be possible to add the ability to see what file is currently being transcoded and the percent complete to the panel on the main menu? I believe Sub has implemented this in the standard panel.

[Jeff]

If there is an API function for this, then yes. The video archive panel now accepts "panel widgets" so someone can create this as a plug-in to the plug-in if they'd like using the panel API in commongbpvrutilities.dll. I don't do any transcoding so I'd have no way to test it (and not too much interest at the moment therefore in writting it either).

Jeff

[Jeff]

It does this at launch because it is building up the cahced list of directories. It should stop using CPU after a bit. I find it takes about 10 seconds on my machine, but your milage may vary. If you go to the memory tab and tell it to not load all directories and files on startup this time should be greatly reduced. To reduce the momory usage, set it to cache fewer directories. I have almost 1 GB of recordings and I find performance okay.

Jeff

[Ambro]

Good stuff Jeff,

Any comments on how to disable the feature where it downloads images - I'm not a big fan of auto d/l images, especially when they're wrong 30% of the time.

[Jeff]

There is no option to turn that off at the moment. I'll add it to the next version.

If you could send me a list of things it got wrong that would be great. I can work to improe the lookup. Right now it works well on the shows I record because I've tesed and turned to make sure it worked wit them.

Jeff

[LilY0da]

Hey Jeff, any finds on that weird lockup I had with specific skins when going back to the main page?

[cubsfan]

Jeff and others, below is the code we used in the web admin tool for displaying the transcode percent complete. I'm not sure how to make the pluging widgets for VA so if someone is familiar with that and would like to do that that would be great.

string GetCurrentTranscode(OleDbConnection aConnection)
{
// create the command object and store the sql query
string SQLstr = "SELECT t.percentage, r.filename FROM TRANSCODE_QUEUE t, " +
"RECORDING_SCHEDULE r WHERE (r.oid = t.scheduled_recording_oid) " +
"AND (t.status = 1)";
OleDbCommand aCommand = new OleDbCommand(SQLstr, aConnection);

//create the datareader object to connect to table
OleDbDataReader aReader = aCommand.ExecuteReader();

string labelText = string.Empty;
while(aReader.Read())
{
int percentage = aReader.GetInt32(0);
string filename = aReader.GetString(1);

if (percentage > 100)
percentage = 100;

filename = Path.GetFileNameWithoutExtension(filename);

if (labelText.Length > 0)
labelText = labelText + "<br/>";

labelText = labelText + filename + " : " + percentage + "% Complete";
}

//close the reader
aReader.Close();

if (labelText.Length > 0)
return labelText;
return "There are currently no files being transcoded";
}

[Ambro]

There is no option to turn that off at the moment. I'll add it to the next version.

If you could send me a list of things it got wrong that would be great. I can work to improe the lookup. Right now it works well on the shows I record because I've tesed and turned to make sure it worked wit them.

Jeff

Thanks - From memory here in Aust. I'm getting incorrect images for programs such as 'The Glass House', 'Catalyst' & another one I can't recall ....:confused: . I wouldn't worry about correcting them for me as I'll tick the box marked ' Turn off auto image downloads ' when it's released

(thanks for doing this too!)

Cheers

[cubsfan]

Thanks - From memory here in Aust. I'm getting incorrect images for programs such as 'The Glass House', 'Catalyst' & another one I can't recall ....:confused: . I wouldn't worry about correcting them for me as I'll tick the box marked ' Turn off auto image downloads ' when it's released

(thanks for doing this too!)

Cheers

On a side note you can download the image that is right manually and put it in the folder for that show and name it folder.jpg

[Jeff]

On a side note you can download the image that is right manually and put it in the folder for that show and name it folder.jpg

Yes. The plug-in will look t see if a folder.png, folder.gif, or folder.jpg are present and, if so, use that.

Note that in the new vrsion I have also changed the lookup order. First the plug-in will look to see if there is an image for the file in its database, next it will look for an image (.png, .gif, or .jpg) for the file in the file's folder, and if all else fails it will look for a folder image. It used to do the first two steps in the opposite order. Hopefully looking in the database first will improve performance, although it also means that if the database has a "wrong" image in it you will need to correct it. Before I release this version, I will add code so that the plug-in autoamticallly imports new images into the database when image files are copied into the directory.

Jeff