Using AMV Tracker

AMV Tracker was designed to be very self-explanatory, however I will post an overview of how the program functions here. Please note that if you ever don’t know what something means, it very likely has either a hover-over tooltip that will pop up, or (in the case of the Database Management functions) you can click a button to see what it will do, before it does anything.

Nevertheless, here’s a basic rundown:

When you start the program for the first time, you’ll need to select a spreadsheet for the program to work off of; you can start with either a blank spreadsheet, or one that comes pre-populated with all the videos I’ve entered into the Genome Project over the years. Choose one and the program will set that as the working database and then pull up the home window. From the home window, you’ll see five buttons in three main sections:

You add videos to your chosen database by clicking one of the two right-most buttons on the home window. The top one should be used if you care about the data being entered into the database being compliant with the Genome Project — that data entry window will check to make sure all data is entered, and entered correctly (as much as it can check that, anyway) before submitting the video to the database. The lower-right button (“Free Entry”), on the other hand, only requires that you enter the editor name and video title; all other fields are optional. Choose this one if you don’t care as much about your data contributing to the Genome Project. Once on the video entry screen, you enter data into each field as appropriate and click Submit — it’s as simple as that!

This allows the user to select a folder on his/her computer that contains any number of AMVs. AMV Tracker will then display a list of all the video files in that folder that have not already been added in the “Local file” field in a video entry, and the user can click on each video file in turn to pull up a data entry window which will automatically populate with that video file’s file location in the “Local file” field. The user can then add the video to the database as normal.

This option also has a feature that will check the filename against any videos already entered into the database. If it finds a match (it’s kind of finnicky, but if the username or video title is anywhere in the file name, it should pick up the corresponding database entry), you can click it to pull up the existing database entry, and the file path will be added to the corresponding field. You can then just click “Submit” to update the entry with the file path.

Once you have some videos entered into the database, you can search the database by clicking the big button on the left on the home window. You’ll be presented with three main sections:

Show All Entries
Quick Search options
Custom Search

If you want to see everything that you’ve entered into the database, click the first button; if you only need to search using a single criteria, one of the middle buttons may suit your needs; if you want to do something more detailed and narrow your search, choose Custom Search. Each piece of information entered into the Custom Search window will be searched for inclusively with any others, i.e. the search results will display videos meeting [Criteria 1] AND [Criteria 2] AND [Criteria 3] etc.

Once you’ve executed a search (and assuming that your search produces results), a table will pop up showing all videos that meet the search criteria. Each row is a video, and each column is a different piece of information about that video, as you entered it. If you need to edit anything about a video, add information, etc., click on the video’s title and a window will pop up pre-populated with all that video’s information. Click a check box to enable editing of a particular field, and click submit to update this entry with the changes. PLEASE NOTE: As long as at least one checkbox is checked, ALL changes made to the video will be submitted, regardless of whether or not the corresponding Edit checkbox is checked on a given line.

You also have the option to delete the video from the database from this window. Please recognize that this function is not reversible; you will need to re-enter the video altogether if you need to get it back.

Also from the search results window, you can click on any editor name to pop up a small “editor profile” of sorts, that displays some statistics on the data available for that editor. Finally, scroll all the way to the right on the search results to find the URL column; if there is a URL in the cell, you can click it to open the video’s page online (likely the video profile, or YouTube video page).

The final button on the home window is “Database Management”, which leads to a number of options for — you guessed it — managing the database(s). All of these buttons can be safely clicked to bring up a window describing what exactly they do, and you will have the opportunity to back out before they do anything, so feel free to check them all out. I won’t spend too much time on these here as a result, but there are two items of particular importance that I want to point out:

(1) Change working database > This is a very important option, as it allows you to choose which database is the one that new videos are entered into, and which you search through. You can select a different working database at any time. Most people will probably only work off of one or two at any given point, but please make sure you are aware which database you’re in before you enter anything. The current database name is prominently displayed on AMV Tracker’s home window at all times.

(2) Download and sync Master > If you care about the Genome Project, keep this button in mind. I will be periodically updating my copy of the Genome Project and putting it online. If you click this button, AMV Tracker will check to see if a new version of this “master” Genome Project database is available, and if so, will allow you to download it and merge it with your current working database. Please note — if there are duplicate entries between your working database and the Master (i.e. different My Ratings, tags, etc), your database’s entries will be preserved for those particular videos.