Making a My DVD Movies module with ListX

One of my hobbies is watching DVD movies at home and the collection of DVDs has grown over the years. Anyway I decided to make a module on our DotNetNUke website to display and search my DVD movies. I decided to use the ListX module from www.bi4ce.com and this is a description of what I did to make it work.

First of I already had a program on my home computer called "Movie Collector" from www.collectorz.com so I just exported the records from that to a text file. Then a straightforward import from the text file into SQLServer on our webserver. This resulted in a new Table in the database with all my DVDs (turned out to be 572).

Table:   [MyMovies]

Columns:
[Title], [Movie Release Year], [Running Time], [Genre], [Director], [Producer], [Writer], [Country], [Language], [Color], [IMDb Rating], [Plot], [Actor], [Front Cover] and [Back Cover]

Then I uploaded the Images to the webserver (20MB zip-file).

Next item was create a page in DNN, add the ListX module to the page and configure the ListX module from the "View Options" menu.

This is what I did in ListX to make the module:

General:

20 Records pr Page

Selected:
Show Records Per Page
Show Page Selection
Show Alphabetic Filter

Query:

SELECT [Title] as Title, [Movie Release Year] as Released, [Front Cover] as Cover, [Country] as Country, [Language] as Language, [Running Time] as Time,  [Genre] as Genre,
 [Director] as Director, [Producer] as Producer, [Writer] as Writer, [Actor] as Actor, [Plot] as Plot
FROM MyMovies
WHERE [FILTERTAG]

Filter:

Title like '[FILTER]%'

Search:

Search Option: Title
Field:         Title

Search Option: Actor
Field:         Actor

Format:

Group Header:

<table width=100% >
<tr bgcolor= #3586AE ><td>Movie</td><td align=right>Front Cover</td></tr>

Group Footer:

</table>

List Item:

<tr>
 <td valign=top ><table width=100% border=0><tr><td><b>[Title]</b></td><td align=right>[Released] / [Country] / [Language] / [Time]</td></tr></table>Director: [Director], Producer: [Producer]<br><br>[Plot]</td><td align=right ><img src="/Portals/1/Mymovies/[Cover]" height="140"></td></tr>

Alternating List Item:

<tr bgcolor=#c0c0c0 >
 <td valign=top ><table width=100% border=0><tr><td><b>[Title]</b></td><td align=right>[Released] / [Country] / [Language] / [Time]</td></tr></table>Director: [Director], Producer: [Producer]<br><br>[Plot]</td><td align=right ><img src="/Portals/1/Mymovies/[Cover]" height="140"></td></tr>

Saved the configuration and the result looks like this:

You can check out the module on My DVD Movies in the Timeout section of our website www.faktnet.com

Hope you enjoyed the article and check back later for upcoming how-to articles.