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
InVision App - Prototyping Made Beautiful With Prototyping Tools Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
Feb 12, 2012 at 3:37 AM
Learning ColdFusion 8: CFImage Part III - Watermarks And Transparency
Hi Ben, Just to ask currently it is placed bottom right corner, if i need to replace the same rendered image on the bottom left side or in the bottom center, how that can be calculated. bottom ce ... read »
Feb 11, 2012 at 9:29 PM
Use jQuery's SlideDown() With Fixed-Width Elements To Prevent Jumping
I can't say how glad I am that I found your post. Thank you very much. ... read »
Feb 10, 2012 at 7:21 PM
jQuery AJAX Strips Script Tags And Inserts Them After Parent-Most Elements
Update! Instead of $(eval(options.insertAfter)).after(data['insertData']); I now use: var ajaxNode = document.createElement('span'); var parent = $(eval(options.insertAfter))[0].parentNode; ... read »
Feb 10, 2012 at 6:18 PM
jQuery AJAX Strips Script Tags And Inserts Them After Parent-Most Elements
encountered this same, what I consider, jQuery bug last week. I'm building a site in which I load some content via AJAX. This content contains Linkedin share button placeholders which Linkedin API ne ... read »
Feb 10, 2012 at 11:30 AM
Cross-Origin Resource Sharing (CORS) AJAX Requests Between jQuery And Node.js
After you understand the concepts here, this is an awesome cheatsheet for enabling CORS in just about anything http://enable-cors.org/ ... read »
JM
Feb 10, 2012 at 9:10 AM
My Safari Browser SQLite Database Hello World Example
@Amy, Here is a very good tutorial on how to use JOIN: http://www.sqltutorial.org/sqljoin-innerjoin.aspx ... read »
Feb 10, 2012 at 4:42 AM
Building A Twitter-Inspired RESTful API Architecture In ColdFusion
This is great, very useful Ben. I spotted a small typo in the api.cgm listing: <cfthrow type="Unauthroized" /> Cheers Stefan ... read »
Feb 9, 2012 at 10:35 PM
CFDirectory Filtering Uses Pipe Character For Multiple Filters (Thanks Steve Withington)
I was wondering if there would be a filter you could apply so that you got everything but what you included in the filter. As in show me all docs that are not a .pdf. ... read »