How To Create A Music Review Site ADDING VIDEO FIELDS -- Review Foundry Tutorial 07

Adjust Text:  a a a a

« Review Foundry User Manual   |   Tutorial Table Of Contents   |   Obtain Review Foundry » ADDING VIDEO FIELDS Just Like Audio Fields... Video Fields Video Title Fields Video Artist Fields Video Album Fields Video Running Time Fields Video Image Fields Video Description Fields Adding Video Fields In Bulk Summary ADDING VIDEO FIELDS Just Like Audio Fields... Assumimg that you paid attention to the previous section: ADDING AUDIO FIELDS you will have no difficulty guessing how video columns are represented in Review Foundry. Rather than discuss them in detail we will simply present the column definitions--which are virtually identical to their audio file column counterparts. The main difference is that the primary video column has a Form Type of PUBLIC_VIDEO rather than PUBLIC_AUDIO (no surprise there). Just as in the audio file case, we are supposing that Mike will be adding three optional video file columns (plus the auxiliary columns to hold title, running time, and so on). Here are the column definitions for the first video file column and its auxiliary fields (see the previous section if you need clarification on any of them): Video Fields When a video file column is added (another file upload column) it will be used to store the content of a video file. The properties of this column are that: The field will offer an upload manager to allow file uploads on pages dedicated to adding/editing records in the Item table. The field will allow any visitor to the site to stream (i.e. play) or download the video file by clicking either on an icon representing the file, or the filename itself. The field will store and report the size of the video file and its MIME type. As was the case for audio columns, video columns (and any of the auxiliary video columns also discussed below) can be added in bulk. See the section at the bottom of the page which discusses bulk column additions. VIDEO Column Properties Column Name   Column Type   INT Column Size/Precision   Column Values   Attributes   UNSIGNED Not Null   Yes No Extra   An AUTO INCREMENT column already exists Column Position   11: AFTER audio_03_description Default   Search Weight     AUDIO Form Properties Form Display   Form Type   PUBLIC_VIDEO Form Size/Length   Form Values   Form Regex   Hide on Add/Modify Forms   Yes   No Note that the column is an UNSIGNED (i.e. non-negative) INTEGER and NOT a URL. The uploaded video file is represented in the record as a numeric value which is converted into a download URL when a link needs to be generated and placed on the page. The column has its Not Null attribute set to No, as every other video-related column shall--all video tracks are considered optional in our example. The column has been named video_01. Additional audio track columns would be named video_02 and video_03 in our example. Video Title Fields (Recommended) Just like the audio title column: VIDEO TITLE Column Properties Column Name   Column Type   VARCHAR Column Size/Precision   Column Values   Attributes                     Not Null   Yes No Extra   An AUTO INCREMENT column already exists Column Position   11: AFTER video_01 Default   Search Weight     VIDEO TITLE Form Properties Form Display   Form Type   TEXT Form Size/Length   Form Values   Form Regex   Hide on Add/Modify Forms   Yes   No Video Artist Fields (Optional) Just like the audio artist column: VIDEO ARTIST Column Properties Column Name   Column Type   VARCHAR Column Size/Precision   Column Values   Attributes                     Not Null   Yes No Extra   An AUTO INCREMENT column already exists Column Position   11: AFTER video_01_title Default   Search Weight     VIDEO ARTIST Form Properties Form Display   Form Type   TEXT Form Size/Length   Form Values   Form Regex   Hide on Add/Modify Forms   Yes   No Video Album Fields (Optional) For the sake of uniformity the field equivalent to the album field in the audio column case is also called album for the video column case (as opposed to, say, disk): VIDEO ALBUM Column Properties Column Name   Column Type   VARCHAR Column Size/Precision   Column Values   Attributes                     Not Null   Yes No Extra   An AUTO INCREMENT column already exists Column Position   11: AFTER video_01_artist Default   Search Weight     VIDEO ALBUM Form Properties Form Display   Form Type   TEXT Form Size/Length   Form Values   Form Regex   Hide on Add/Modify Forms   Yes   No Video Running Time Fields (Recommended) Just like the equivalent audio column running time field: VIDEO RUNNING TIME Column Properties Column Name   Column Type   TIME Column Size/Precision   Column Values   Attributes                     Not Null   Yes No Extra   An AUTO INCREMENT column already exists Column Position   11: AFTER video_01_album Default   Search Weight     VIDEO RUNNING TIME Form Properties Form Display   Form Type   DATE_SELECTABLE Form Size/Length   Form Values   Form Regex   Hide on Add/Modify Forms   Yes   No Video Image Fields (Recommended) Just like the equivalent audio cover art column: COVER ART Column Properties Column Name   Column Type   INT Column Size/Precision   Column Values   Attributes   UNSIGNED Not Null   Yes No Extra   An AUTO INCREMENT column already exists Column Position   11: AFTER video_01_duration Default   Search Weight     COVER ART Form Properties Form Display   Form Type   PUBLIC_IMAGE Form Size/Length   Form Values   Form Regex   Hide on Add/Modify Forms   Yes   No Video Description Fields (Recommended) Just like the equivalent audio description field: VIDEO DESCRIPTION Column Properties Column Name   Column Type   VARCHAR Column Size/Precision   Column Values   Attributes   Not Null   Yes No Extra   An AUTO INCREMENT column already exists Column Position   11: AFTER video_01_visual Default   Search Weight     VIDEO DESCRIPTION Form Properties Form Display   Form Type   TEXTAREA Form Size/Length   Form Values   Form Regex   Hide on Add/Modify Forms   Yes   No Adding Video Fields In Bulk Adding video columns in bulk is done in exactly the same way that it is handled for bulk audio column addition. See the section on Adding Audio Fields In Bulk. Summary The video files which are represented by the columns defined above can be presented with either the Wimpy AV Player or the Wimpy WASP (Wimpy Av Single Play) Player. Or, they can simply be represented as links to downloadable files. However, using, for example, the Wimpy WASP Player to present the information provides for a lot more in the way of user-friendly options. In the next section we will see what the possibilities are for Wimpy Player integrations. Next Section: THE WIMPY PLAYERS « Table of Contents Copyright © 2004 Random Mouse Software. All Rights Reserved.