Help




- Windows:

  • Option 1 - Using the NON Install ZIP File
    1. Install Sun's Java Runtime Environment
    2. Download the latest version of MeD's Movie Manager Non Install ZIP File
    3. Extract the .zip contents to a directory of your choice and double click the file MovieManager.jar or MovieManager.exe

  • Option 2 - Using the EXE Install File
    1. Install Sun's Java Runtime Environment
    2. Download the latest version of MeD's Movie Manager Exe Install File
    3. Double click the .exe installer and follow the installation instructions
    4. To start the movie manager simply double click the MovieManager.jar or MovieManager.exe located in the install directory, or any of the shortcuts (Desktop/Quick launch).

- Linux / Unix:



- Mac OS X:

  • Using the NON Install ZIP File
    1. Download the latest version of the MeD's Movie Manager Non Install ZIP File
    2. Extract the .zip contents to a new directory of your choice
    3. To start the movie manager simply double click the MovieManager.jar located in the install directory, or any of the shortcuts. Alternatively run java -jar MovieManager.jar in a terminal.

The first thing you need to do is create a new database.
This is done by going to the top menu and choosing File->New Database. You can choose between HSQL, MS Access and MySQL database.
If you don't have a clue...go with MS Access or HSQL database, they'll both do the job.


  • MS Access is Microsoft's database system which runs on Windows only.
    It's slightly slower than HSQL with a big movie list.

  • HSQLDB is a Java based database system which runs on any platform supporting Java.

  • MySQL is a database system which can be used over a network. A host-machine must be running the MySQL server to be able to connect. If you want you can run the server on your local machine and connect with your IP (127.0.0.1), though you'll need to have a user with sufficient privileges to be able to connect.

The search field is located right below the movie list (Here is an image that will help you spot it!).
Entering a search term and hitting return will activate the search.

Presuming the Search Options are set to default values:
The term  Silence  will give you all movies with 'Silence' in the title.
The term  Silence of  will give all the movies where the title contains 'Silence' and 'of'.

The expression  James Bond  will be translated into  James AND Bond  which means JamesleyBond would make a hit.
To be sure only the exact phrase is searched for, use quotes like this:  "James Bond" 

To search for any movie title containing a quote (' " ') (typically series) you will need to write three quotes. This is because a single quote will be intepreted as the start of a quoted string.

Using boolean operator (AND, OR, XOR and NOT)
If you'd like to search for all the movies that contain 'Silence' and 'lambs' you simply write  Silence AND Lambs 
If you'd like to search for all the movies that contain 'Silence' or 'Lambs' you simply write  Silence OR Lambs 
If you'd like to search for all the movies that contain 'Silence' and 'Lambs' or 'Hannibal' you simply write Silence AND Lambs OR Hannibal
To avoid ambiguous expressions you should use parentheses like this  (Silence AND Lambs) OR Hannibal , as  Silence AND (Lambs OR Hannibal)  will be interpreted differently

XOR means 'exclusive OR', and will not allow for both expressions to occur. So  Silence XOR Lambs   will give all movies containing one of the expressions, but not both. XOR is not supported in HSQLDB.

The NOT operator enables excluding values, so  NOT Silence OR Bond  will give the movies with either (not 'Silence') or ('Bond').

Advanced search:
It is possible to search through any info field by using a special syntax which is as follows:
Starting and ending of a special search is denoted by the curly braces (brackets) which are '{' and '}'. Usually they don't have their own key so you'll probably need to invoke the CTRL or ALT or SHIFT key(s) together with the brace key ('[' and ']').
The inside of the expression (between the two braces) has two parts:
The first part denotes the field that will be searched through, and the second part denotes the search expression. The two parts are separated by a colon ' : '.

Example:
The query  {"Additional Info","Subtitles":english}  will give all movies with english subtitles. Here the exact name of the table and column is important.
To make this simpler you can give each column an alias in the advanced search options. So if the Subtitles column is given the alias 'subs', one can write the following:  {subs:english} 
Searching for all James Bond movies with english subtitles (with the Filter Category set to 'Movie Title') will look like this :  James Bond AND {subs:english} 

To get all the movies with french subtitles as well, write:  James Bond AND {subs:english OR french} 

By these rules very complex expressions can be formed.
Example:
Following aliases declared:
"Additional Info" Subitles : subs
"Additional Info" "Video Codec" : codec
"General Info" Language : lang

 {subs:NOT ""} AND {codec:xvid OR (divx AND (5 OR 6))} AND {lang:english OR french OR japanese } 

This expression has three parts:

First part ( {subs:NOT ""} ) - All entries with a non-empty subtitles field.

Second part ( {codec:xvid OR (divx AND (5 OR 6))} ) - All entries where the Video Codec contains either (xvid) or (divx together with either 5 or 6).

Third part ( {lang:english OR french OR japanese} ) - All entries where the Language contains either english, french or japanese.

As the three parts are separated by the AND operator, all the three expressions must be true for the entry to be returned.


Click the 'Database' menu and then the 'Additional Info Fields' item. A window will open giving you the add / remove functions.
Note that removing a specific additional info field will apply to all movies in the current open database.


Simply write a MS Access/HSQL compatible SQL query and add it to the folder 'Queries' of a specific database.
You can write the text file with a text editor (like notepad and emacs), and save the file with extension '.qry'.
The file format is:

Query Name (first line)
SQL Query (next lines)

After this you only need to click the 'Database' menu and then the 'Queries' item and the query you created will appear in the 'Execute' list.

A query that will give you the title of all the movies with Sean Connery in the cast would look like this:

My Sean Connery search
select "Title"
from "General Info"
where "General Info"."Cast" like '%Sean Connery%'

  • Explanation:
    1. The first line is the title which will appear in the 'Execute' list.
    2. The second line is what info will appear on each of the movies that match the query.
    3. The third line specifies which Table the columns in the select statement can be found.
    4. The last line tells which Table and column it should search through (the like statement).
    5. The two % characters says that there can be any character before and after the Sean Connery string.
    6. So if you left out the '%' characters, there would be a hit on movies where the cast only contains the phrase 'Sean Connery'.

A query that will give you the title, subtitles and video codec, where the video codec contains 'xvid', would look like this:

Search Video Codec
Select "General Info"."Title", "Additional Info"."Subtitles", "Additional Info"."Video Codec"
from "General Info" inner join "Additional Info" on "General Info".id="Additional Info".id
where ("Additional Info"."Video Codec" like '%xvid%')
order by "General Info"."Title";

The 'like' statement with MS Access is case insensitive, but with HSQL it's not,
so to make the search case insensitive with HSQL you need to add 'upper' to the 'like' statement like this:

where (upper("Additional Info"."Video Codec") like '%xvid%')

Here is a query that will give you the title, date, rating, language, and video codec.
In addition, only movies that are not seen, and where the language exists but is not english, will match.

Search Multi
select "General Info"."Title", "General Info"."Date", "General Info"."Rating", "General Info"."Language", "Additional Info"."Video Codec"
from "General Info" inner join "Additional Info" on "General Info".id="Additional Info".id
where (("General Info"."Seen" = 0) and (("General Info"."Language"<>'') and ("General Info"."Language" not like '%English%')))
order by "General Info"."Title";


  • This is what you need to do:

In the MySQl command client, write the following:

mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'password';
mysql> CREATE DATABASE database_name; (schema)
mysql> GRANT ALL ON database_name.* TO 'username'@'%' IDENTIFIED BY 'password';

Now you should be able to connect to the database.

If you want a guest account for others to use externaly e.g. from the Internet you do the following:

mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'password';
mysql> GRANT SELECT ON database_name.* TO guest@'%' IDENTIFIED BY 'guest_password';

Using the guest account you're now able to connect and view the movie list, but not able to change anything in the database.

Remember that to be able to connect from an external IP, you'll have to make sure that the port which the MySQL server is listening on is open in your router.


Windows:
Default player:
You may choose to use the system default program assosiated with the file extension of the video files. It is however not possible to pass more than one file to the program, so if there are multiple video files registered, only the first one will be sent to the program.

Custom player:
In the preferences, supply the full path to your desired media player in the "Player location" field.

GNU/Linux:
Full player path:
You can use the full path to the media player, or, if the player is located in the PATH, just provide the command, e.g vlc.

Gnome-open: (For those using GNOME)
Using  gnome-open  in the "Player location" will work, but if you have multiple media files registered for a movie, only the first file will be passed to the player. If the player doesn't automatically play the next (e.q CD2) it will not play.

Mac - OS X:
Full player path:
You can provide the full path to the player in the "Player location" field. Full path to .app e.g. /Applications/VLC.app will not do. It must be directly to the exectuable located inside .app directory.

open
Using the command open, you can use a player (Application Bundle) located in the Applications folder. Example settings:
Player location: open 
Command line argument:  -a VLC  or  -a "Quicktime Player" 


Note: The duplicates function is not available for MS Access database.

Finding duplicates in v2.8.2 (or later):
The duplicates function was introduced in v2.8.2 and is quite simple to use:

Simply write  DUPLICATES  in the search filter and press enter. This will find all movies that have the same title and same release date.
If you only want to search for the movies that have the same title, use  DUPLICATES title 
If you want to find the movies with the same IMDb id use the following:  DUPLICATES imdb 

Note: "DUPLICATES" must be in capital letters.


The config file used to be written to the install directory in the directory "config" like this:
Windows:C:\Program Files\MeDs-Movie-Manager\config\Config.ini
Linux:/home/username/MeDs-Movie-Manager/config/Config.ini
On OSX, the config was written to home/Library/Application Support/MovieManager/Config.ini This behaviour made it possible to place the install directory on a USB stick and start the movie manager with the same configurations independant of which OS it was running on.

In version 2.8.1 this was changed for Windows Vista and Windows 7 because these OSes only allow write access to the program files directory for administrators. Vista:C:Users\username\AppData\Roaming\MovieManager\Config.ini

This behaviour can however be overwritten by creating a new (empty) file with the name "uselocalconfig" and place it in the config directory of the install directory of the movie manager.


You should visit the Project Forum