• Fixed a bug that would not allow user to add first video to an empty database.

• Fixed a bug that opened a redundant window when submitting changes to an idea in AMV Notepad.

MINOR/INVISIBLE CHANGES

• Updated layout of the home window. Video entry without checks button is now more prominent to account for the fact that this is probably what most people would want to use.

• Updated layout of search results. Previously, clicking on the video title in search results would pull up the video’s profile; now, the leftmost ‘Edit’ column provides this functionality. Additionally, a ‘Watch’ column has been added that can be clicked to open the locally-stored video (if it’s been specified), and the ‘Go to URL’ column will open the video’s URL if present.

• Updated search results so that a two-level sort is in place by default: first alphabetically by editor, second alphabetically by video title (previously, videos were displayed alphabetically by editor, but then multiple videos by the same editor were arranged in the order in which they were entered into the database).

• Removed ‘Download and Sync Master’ button in Database Management options as that function no longer works (also I doubt anyone ever used it).

• Previously, if you tried to enter a video with checks and you focused out of the min or sec boxes in video length, they would autofill with zeros and you could get into a loop where you were unable to move to any other entry boxes until a positive number was put in one of those two boxes. This was an intended “feature” to ensure that the video’s duration was correct, however it was an annoying method of doing so. Now, that loop will not occur and AMV Tracker will simply check when you press the “Submit” button to ensure that at least one of these fields has a positive nonzero number in them, and if not it will not let you submit the video to the database until this is corrected.

• “?” button on home window (that previously would pull up a set of tutorial screens that explained how AMV Tracker worked) now instead pulls up the “Using AMV Tracker” page on the AMV Tracker website.

• Added placeholder text for comments and contest search boxes in Custom Search window.

• Added clear buttons for “URL…” and “Local file…” search options in Custom Search window.

• On Quick Graphs, duration and Star Rating x-axis labels updated to better show range that is being counted.

• Made check for existing video on the video entry screen case-insensitive.

• Streamlined some things in the code to make AMV Tracker a bit faster in various places.

• Process for creating VidIDs (unique video identifiers invisible to the user) has been improved.

• Updated various text entry boxes throughout AMV Tracker to automatically have a cursor in them when the window they are in is opened.

• Minor text changes on some of the pop-up tooltips, including removing all mention of the Genome Project throughout AMV Tracker.

• README.txt added to folder that is created on user’s desktop when user selects ‘Yes’ on the update window.

FEATURES ADDED

• Pseudonym entry has been updated — a couple things will happen now on each new video you enter: (1) AMV Tracker will search through your database to determine if other entries already have one or more pseudonyms associated with the given editor username; if so, the new entry will be updated on the backend to have these, even if you forget to input them; (2) if you enter a new pseudonym for a given editor, all of that editor’s entries will be retroactively updated to have that pseudonym associated with the editor name.

• When editing the pseudonym field in a video entry already in your database, all videos with the same Editor Username will be updated to whatever you submit, allowing you to mass delete/update the pseudonym field for all of an editor’s videos.

• Date Entered field added to the database. AMV Tracker will now automatically record the date you enter a new video into the database. This field will show up on searches (all the way to the right, it’s the last field in the search results) and at the bottom of video profiles as a non-editable field.

• Database Management: “Rename” function added, which allows you to rename your current working database.

• Database Management: “Copy” function added, which allows you to copy the current working database to a new file.

• MAL search added on video profile. For videos already entered into your database, there is a new button at the top of the window which allows you to pull up a search for any of the anime listed on the video profile page on MyAnimeList (button is disabled if the ‘More than four’ anime checkbox is checked).

• AMV Notepad: A tool for organizing your AMV ideas, allowing you to specify potential songs, anime, conceptual ideas and other notes for AMVs you might want to create in the future. Additionally, it allows you to assign different priority levels to your ideas, set deadlines, and track the progress of these projects as you edit them.

• Massive update to the Statistics module. Many new functions added. It is recommended that you read the walkthrough for a detailed rundown of what everything does.
  • “Addl. stats” added under “Quick” heading. This shows a number of interesting statistics, and also provides a matrix that allows you to choose specific elements from within your database and see measurements and averages based on them.
  • “Drill down by tag” added under “Quick” heading. This allows you to choose three separate tags (from either Genre, General Tags, or FX Tags). The first tag chosen will show the count of videos containing that tag as well as the average My Rating, Star Rating, and duration for those videos. When you add a second tag, you will see those same metrics updated for videos containing BOTH selected tags, as well as the difference. Selecting a third tag displays those metrics again for all three selected tags.
  • “Count By…” graphs added. The button pressed becomes the x-axis, and then you can choose a second element and drill-down data point to count by. For example, if you press the ‘Year’ button, and then select General Tag ‘adrenaline’ on the next window, you will be presented with a graph that counts the number of videos in the database which have the ‘adrenaline’ tag by year.
  • “Averages” graphs added. You can now view the average video duration, My Rating, and Star Rating based on any element you add.
  • “Heatmaps” added. These allow you to select two different elements as axes, and then choose either “Count of videos”, “My Rating average”, or “Star Rating average” to see a heatmap of that metric.

BUG FIXES

• “Check for Update” and general update notification functions work again.

• Fixed a bug that allowed user to copy a video from one database to another, even if that video already existed in the destination DB.

• Fixed a bug that allowed user to create a sub-database with the name “Main database”.

• Fixed a bug that allowed the user to input the same anime more than once on a single entry.

• Fixed a bug that would not display editor profile if that editor had one or more videos with an unknown release date.

• Fixed a bug that was displaying the incorrect editor username on editor profile.

• Fixed a bug that allowed user to rename Custom Lists to a name more than 25 characters long.

• Fixed a bug that was not carrying over the Sequence field properly when merging databases.

• Clicking the “Sequence” header in the search results window will now sort results based on numeric rank, rather than lexically.

• Sequence was not updating correctly for videos entered into sub-databases. This issue has been resolved.

• Sequence was not updating correctly when a video was copied from one database to another. This issue has been resolved.

• Fixed a bug in the “Quick Graphs” for Star Rating that was causing the x-axis values to display too many digits after the decimal point.

MINOR/INVISIBLE CHANGES

• Cleaned up some duplicate/misspelled anime listings in the Genome Project database that ships with AMV Tracker.

FEATURES ADDED

• “Sequence” now added as an additional (non-searchable) field. Each video entered into the database will have a sequence number added, one higher than the last video entered. Thus, this will essentially track the order in which you enter videos into the database so that if, for example, you wanted to rewatch a great video you entered relatively recently that you can’t remember any details for, you can sort your search results by Sequence in descending order to see which videos were recently entered.

• You can now select which sub-database you’d like to see information for on the Quick Stats window.

• “Quick Graphs” added to the Statistics window — you can now select a sub-database and the elements you’d like to measure and see a graph showing the count of videos with/for those elements.

BUG FIXES

• Main database was not an option when using the “Copy to Sub-DB” function on video profiles. Updated this so videos can now be copied from existing sub-DBs to the main database.

• Fixed a bug that allowed user to create a new database with the same name as an existing database.

• When using the “Make spreadsheet compatible” function, if the user chose a non-AMVT spreadsheet, AMV Tracker would show an error message alerting the user that no action could be taken, and then immediately after would show the user another message stating the spreadsheet had been updated. In these cases AMV Tracker did not actually do anything, so I stopped that second message from being displayed in these circumstances.

• When clicking “Yes” on the dialogue that opens to alert the user to the fact that a new version of AMVT is available, AMV Tracker will now copy the files that contain Custom List information in addition to the user’s spreadsheets.
  PLEASE NOTE: To preserve your Custom Lists when upgrading from any version before v1.2.0a, please copy the “cust_list_names.p” and “cust_lists.p” files in your old AMV Tracker folder to the new AMV Tracker folder.

BUG FIXES

• Fixed a bug that caused Custom Lists to get scrambled when using the “Merge databases” or “Download and sync master” functions.

MINOR/INVISIBLE CHANGES

• Fixed wording on the last bullet point in the Custom Search help window to clarify that if a date search row is not entered with all fields populated, it will not be included as a search criteria.

• Fixed wording on pop-up tooltip for the Genome Project entry button on the home window to also indicate that “Star Rating” is not a required field for data entry.

• Made certain large windows within AMV Tracker resizable if the user’s screen resolution is lower than a certain threshold. This was done because there were a few windows (data entry, custom search, and others) which at full size have a large height that rendered AMV Tracker unusable on smaller screens (i.e. netbooks). All such windows are now resizable and scrollable in such cases.

• Made minor UI changes to some windows to complement the changes mentioned above.

• Certain windows will now close when new windows are opened, to keep from having too many windows open at once cluttering up the screen.

• “No effects” FX tag checkbox will now be checked if that tag was previously selected and the FX tag window is re-opened on data entry/video profile.

• Text label on home window indicating current working database will now auto-shorten the displayed database filename if it is too long, so that the home window does not stretch.

• When using the ‘Add From Folder’ function, AMV Tracker will now display only video files from the folder you choose, rather than all files. If no video files are found, AMV Tracker will show an error window.

• Updated search function so that searching by e.g. anime with the “Starts with” radio button checked will list videos that have that anime listed anywhere as one of the anime in the video. Previously, it would only work if the searched-for anime search term matched the first anime listed on an AMV’s video profile (i.e. searching for “Neon” would pull up videos that had the anime listed as “Neon Genesis Evangelion // Akira // FLCL”, but would not pull up videos that had the anime listed as “FLCL // Neon Genesis Evangelion // Akira”). Also works when searching for editors listed as the second entry in collaborations.

• Date Search option now has 2018 as the default year.

• Changed button spacing and ordering in “Database Management” window so that the button groupings make more sense.

• “Clear My Ratings” and “Clear database” functions updated to work with sub-databases (see “FEATURES ADDED”, below). User can specify which sub-DB(s) they want the selected function to act on. PLEASE NOTE: These functions now NO LONGER automatically create a backup of your database before executing. You must now manually create backups using the “Create backup of database” function before using these if you want to ensure a backup exists.

• Minor wording changes on some of the tag pop-up tooltips.

• Went through Genome Project database and did some pruning/streamlining on the anime column — ended up consolidating a lot of duplicate anime with different character cases, and fixed a few misspellings.

• README.txt updated for v1.2.0.

FEATURES ADDED

• “Statistics” button added on home window. This brings up another window which will allow access to a number of different ways to view database statistics (currently under construction, will be expanded in future updates).
  • “Quick stats” — Shows a bunch of generalized statistics for a kind of quick-and-dirty overview of basic metrics pulled from the database — total number of videos/editors, average rating scores, tag stats, etc. PLEASE NOTE: For the time being, Quick Stats are only available for the main database, not any sub-databases (see below).

• Sub-databases: Create new databases which reside alongside your main database but are separate from it. Can be used, for example, to track your own videos with which you may utilize different criteria for rating than other editors’, or to set aside videos to watch and rate later, etc.
  • Drop-down menus added throughout AMV Tracker to specify which sub-database to search through or add to at any given time.
  • Create and delete sub-databases via “Database Management” window.
  • Copy videos from one sub-database (or the main database) to another via “Copy to sub-DB” button on video profile window.
  • PLEASE NOTE: If you use the “Merge databases” function under Database Management, and the database you choose happens to have a sub-database with the same name as one of the sub-databases in the existing DB, AMV Tracker WILL NOT copy that sub-database to the existing database (i.e. the existing sub-DB will be preserved).

• Custom Lists: You can now further organize videos into “Custom Lists”, which are groupings of videos that you create. Add videos from the video’s profile page (“+” button on top of the window) or by clicking the “+” button on the “Custom Lists” window accessible from AMV Tracker’s home window, which allows you to perform a custom search to find videos to add (you must create a Custom List first using the “Create New List” button).
  • On viewing a Custom List from the “Custom Lists” window accessible on the home window, if a video has a local file path entered you can simply click that cell to start the video in your default video player.
  • PLEASE NOTE: Custom Lists are currently only able to be populated by videos in your main database. Videos that exist ONLY within any sub-databases are NOT able to be added to Custom Lists — you will need to copy these to your main database in order to add them to a Custom List.
  • PLEASE ALSO NOTE: Custom Lists are not tied to a specific database in that they will be listed regardless of which database is active (if you keep more than one), however the CONTENTS of each list are tied to the database in which they are created. It is recommended therefore to only keep a single database, or if you intend on creating multiple databases, label your Custom Lists in such a way that you know which Custom List is tied to which database.

• Tutorials: Accessible via clicking the ‘?’ button on the home window, you can now access a number of descriptive tutorial screenshots which help explain all the functions of AMV Tracker.

• New data entry box added: “Contests”. This is a separate, searchable field which you can use to log any contests a video was in (if known). Not a required field for Genome Project entry or Free Entry.
  • Searchable via Custom Search; will search for the particular phrase you enter and will look for that phrase anywhere in the Contest field (i.e. searching for ‘expo’ would find videos entered in Anime Expo, Japan Expo, etc.)

• “Make Compatible” function (accessible via “Database management”) updated for this new release. This function MUST be used on any pre-existing AMVT databases you want to carry over to the new version.

• Choosing a database when first starting up the program, or changing the working database afterwards, will automatically make the chosen spreadsheet compatible if it has not already been updated to work with the new version of AMV Tracker.

• In Custom Search, added ability to search for videos based on whether or not a URL has been added to the database.

• “Refresh” clickable text added to search options window. When videos are deleted from the database or copied to a sub-database, subsequent searches to the database will not reflect these changes until the user goes back to the home window and re-enters the search side of AMVT. Now, the Refresh text can be clicked to do that immediately.

• (Genome Project Entry ONLY) If video length entered is 2:30 or less, the “short” general tag will automatically be checked on pulling up the General Tags window. Similarly, if the length entered is 6:00 or longer, the “long” tag will automatically be checked.

BUG FIXES

• Fixed a bug that was preventing the “More than 2 editors” checkbox from performing as it should.

• On Custom Search, searching by song genre was returning any video that started with the song genre search term (i.e. searching for “Pop” returned videos with the song genre classified as “Pop”, “Pop rock”, “Pop punk”, etc). Fixed this so the song genre search will return only videos with exactly the song genre selected.

• Similarly, in a very edge case, searching for the “text” FX tag was also picking up videos that didn’t have that tag but did have “textures”. Fixed so tag searches only search for exact tag match.

• “Make Spreadsheet Compatible” function was not throwing up an error message when the selected spreadsheet was not AMV Tracker-compatible. Fixed this so that function will not work with non-AMVT spreadsheets.

• Fixed a bug that was preventing video profiles from displaying the fourth anime listed in a video if exactly four anime were entered on data entry.

• Searching Comments in Custom Search was not working as intended; fixed the search algorithm so multiple search terms could be entered (spearated by comma + space, as originally noted next to the search box) and AMV Tracker will return videos which have all listed search terms in the Comments section. NOTE: “Contests” search works the same way.

• There is an existing feature in AMV Tracker that checks to see if the video you are entering has already been put in the database previously. It asks you if you’d like to just edit the existing entry, and if you click “Yes” it will bring up that video’s profile page. However, at that point, whatever you do, when you exit that page AMV Tracker will close altogether. Fixed this so that the AMVT home window will remain open when you finish on the video profile page.

• Updated filename parsing on the “Add from folder” function. This function should now be much better at finding correct matches in the database than it was previously.

• Initial startup text has been updated to accommodate a new bug fix (see below).

FEATURES ADDED

• “Play random video” button added to Custom Search window. When clicked, this will execute a search based on the criteria entered, and will play a random video that meets those criteria. Search will always execute as if the “Local file exists in database” button is checked, even if it’s not.

• AMV Tracker will now automatically run a check when it starts to see if a newer version is available. If so, it will prompt the user and ask if s/he wants to download it now. If yes, the user will be taken to the download webpage, and a folder will be created on the user’s Desktop with all spreadsheets from the user’s existing amv_tracker folder copied there for convenience. If the user selects ‘No’, AMV Tracker will start as normal and the user will not be prompted again.

• Added “Check for Update” button on the home window. In the event that an update is available and the user decides not to download it at that moment, they can click this button to check again later.

• Added “Watch” button on data entry window (just like on the video edit window). This was mainly for my own convenience but other users may like it too — I found it useful for quickly starting up videos located with the “Add from folder” function that weren’t already in the database, so I could watch them and add them to the database then and there.

BUG FIXES

• Fixed bug that would not allow user to update the release date of a video that currently shows “Unknown release date” in the database.

• If the user changed the working database, and then selected the “Add from folder” option without closing out of the program and reopening it, any changes made (i.e. videos added to the database, “Local File” fields populated on existing entries) were being put into the previously selected working database. Fixed this bug so that the user will now be acting on the currently selected database.

• Fixed a bug that prevented AMV Tracker from opening if the user had deleted, moved, or renamed the working database. This was previously fixed by the user manually deleting “working_ss.p”, however now the program will just prompt the user as it normally does when s/he starts the program for the first time.

• Fixed an “intentional bug” that caused the program to run in an infinite loop on startup if the user decided not to choose a spreadsheet. User now has the option to click “Ok” or “Cancel”; if “Cancel” is selected or user presses the “X” button in the upper-right, program will simply close.

• “Merge database” function was not working properly since v1.1.0. Any merged databases would potentially have the “Pseudonym” and “Local file” fields switched between video entries. Fixed this bug so that this function can be safely used.

MINOR/INVISIBLE CHANGES

• AMV Tracker will now remember window position on exiting and reopening. PLEASE NOTE: All window positions are now based off of the home window’s position (i.e. they will open in the vicinity of where the last instance of the home window is/was).

• Fixed minor bug that allowed user to create a new database without a file name (i.e. file would have been called ‘.xls’).

• Changed “Editor name” to “Editor username” throughout program to mitigate confusion (some people were stating they thought that this field was asking for the editor’s actual name).

• Clarified what is meant by “pseudonyms” on the data entry window.

• Changed wording on some of the pop-up tooltips to be more concise, and hopefully clearer to non-native English speakers.

FEATURES ADDED

• “Local file” field added on video entry/edit window. This is for the user to specify the video file location if it exists on his/her hard drive.

• Added new data entry button — “Add from folder”. This will allow 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 to the database, 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.

• Added Custom Search function “Local file…” which allows the user to specify whether they want the search to include or exclude videos which have local file paths specified in the database.

• “Go” button added by the URL field in a video’s edit window; user can click this button to pull up the video’s profile page online (assuming a URL has been entered).

• “Watch” button added by the Local File field on the video’s edit page. If the user has specified a file location for a video, they can click this button to start up the video in the user’s default video player.

• Added “Copy video” button on video edit window, which allows the user to copy the video from the current database to another of the user’s choice.

• Created “Make spreadsheet compatible” button under Database Management functions. NOTE: This will ONLY work to update spreadsheets that were already compatible under AMV Tracker v1.0.0.

• Added two search buttons on each editor’s “profile page” — one for YouTube, one for a-m-v.org. These will pull up searches on the respective websites for all of the selected editor’s videos.

• Similarly, added same buttons on each video’s edit window, but tweaked slightly to search for the specific video, rather than all of the editor’s work.