Skin Spider : Auto-Tagging Downloaded Videos

Posted November 9, 2006 at 9:40 AM by Ben Nadel

Tags: ColdFusion, Skin Spider

To learn all about Skin Spider, click here.

To view the most updated application, click here.

To view the current code base, click here.

This is a small update but one that is very good for the usability of the system. I have added the ability to auto-tag videos as they are being downloaded. This removes a lot of manual work that the user would have to do in order to categorize the downloaded videos.

In order to accomplish this, I only had to make a few small changes. First, I updated the XML database schema in the ColdFusion configuration bean, Config.cfc. I added the column "keywords" to the tag.xml data file configuration. This column will hold the keywords that are used to auto tag videos.

Then, I updated the edit_tag.cfm ColdFusion template. I merely added a new form field and the code that commits it to the database. That took about 2 minutes. The form field is an (X)HTML TextArea. It is designed such that each keyword is on a single line. This allows the user to enter multiple keywords per line as a phrase. I thought about using quotes to denote phrases, but that just increases the complexity of what we are doing in a highly unnecessary way. Doing it this way allows us to use the ascii characters 13 and 10 to be used at list delimiters that naturally break up the keywords whether they are a single word or a group of words.

Then, the final step was to update the spider_video.cfm ColdFusion template. Again, this was a fairly easy task. I get the gallery name of the video that is currently being spidered. If you can remember, I pass in a gallery ID to the spider_video.cfm page to help the template figure out which video to spider. Anyway, I get the gallery name based on that passed in ID. Then, once I have downloaded the video, I loop over every keyword and match it against the title using a FindNoCase(). For any keyword that matches the gallery title, I automatically tag that video with the current tag.

It's nice. I think this very small update will make a big difference in the user's experience of the application.

What I have noticed as I test this feature is that many of galleries have really poor titles. This will lead to bad auto-tagging. I think that as I get more into it, I will have to figure out more ways to gather information about the video and gallery. Perhaps the meta descriptions and keywords, although, I am not sure the this type of web page uses those effectively either. We shall see. Baby steps to the ultimate application.



Reader Comments

Mar 1, 2007 at 11:34 PM // reply »
1 Comments

none


Post A Comment

Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Please review the following issues:

Author Name:


Author Email:

Author Website:

Comment:

Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>







  • Help Wanted - Find Your Next ColdFusion Job
Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
May 25, 2013 at 10:08 AM
Using "//" And ".//" Expressions In XPath XML Search Directives In ColdFusion
@Ben, my question is that i want the current node with its tag and its parent node. i just want only that data. So, give me the solution for that. and remember solution is working on " xpath 1.0 ... read »
May 25, 2013 at 10:01 AM
Using "//" And ".//" Expressions In XPath XML Search Directives In ColdFusion
hey ben, i want get my current node tag and also want the root node tag withing. So, how can i fix it.. ! ... read »
May 24, 2013 at 5:39 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
@Adam Oops! My mistake! I hadn't gotten that far in my testing - I'm still baby stepping my way through the process. ... read »
May 24, 2013 at 5:13 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
Hi Jason, Thanks for checking up on that, but I still stand firm on my position. :) There are actually two listLast()'s in use, and you're right that the one using a space as a delimiter is fine. ... read »
May 24, 2013 at 4:45 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
@Ben I have been lurking your site for quite some time, and haven't stepped up to comment until today. Thanks for all the great info - keep it up! @Adam I believe you are mistaken... as the commen ... read »
May 24, 2013 at 11:21 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@WebManWalking, Ha ha, let's us never speak of justifying "##" notation again :P ... read »
May 24, 2013 at 11:18 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Ben, Ah, so it was indeed how I vaguely remembered it to be: A direct assignment value = users.id[ i ] causes value to retain the sticky datatype of the query column. Although unnecessary in ... read »
May 24, 2013 at 9:11 AM
Preventing Links In Standalone iPhone Applications From Opening In Mobile Safari
@Brandon, Hi, No, I haven't been able to do that. I have just kept it as it is. ... read »
InVision App - Prototyping Made Beautiful With Prototyping Tools