[NMJ v1] NMJToolbox - A Windows editor for the NMJ (Updated 15/10/2012 v1.0.4.6)

[Rom]

I have written a tool (Windows only) to allow you to update and edit the NMJ without any knowledge of the database or how the NMJ works. You need a built NMJ database to use this tool! If you have built a DB from YAMJ using ToNMJDB you can use that. Updating or replacing an image is as easy as dragging a .jpg onto a box - the NMJToolbox will save the image at the optimum size and update the database for you.

You may edit the DB whilst still on your (mapped) network drive or you can copy the folder locally, update it and copy it back when done.

Please note: This is beta software and though it has been tested by a number of the NMT beta team members neither I nor Syabas or anyone else will take any responsibility for any loss or damage to you, your machine or your data caused by using this software. If in doubt, make a backup of your database. Downloading this software means you agree to this and take the responsibility.

There is nothing to install. Simply extract the exe & dlls to a folder of your choice and run the exe.
Download all 3 files if you have not used before otherwise you do not need to re-download the SQLite or MediaInfo packages, just the exe (NMJToolboxvx.x.x.x.rar). Replace the exe you have with the latest one here.

NMJToolbox V1.0.4.6 - 15th October 2012

MediaInfo DLL <--You must extract & place this dll in your NMJToolbox.exe folder

SQLite DLL<--You must extract & place this dll in your NMJToolbox.exe folder

NMJToolbox User Guide v1.0.1.0


Some of the features:

• Ability to browse the database in sections (Video & Music).
• Highlight a DB line and it shows the coverart
• Drag new covers over the old which it resizes to the optimum size and updates the jukebox with the new image.
• Edit various DB entry details including title, plot, video info etc
• Delete Video entries
• Button to open the NMT forum in your browser (for lazy people)
  And more...
  

You need .NET 2.0 framework installed. (very basic) instructions:-

Browse (with the '...' button) to your nmj_database/media.db file. The default video data will be loaded and presented.
Click on any line in the recordset and 3 images will be displayed (thumbnail, poster & wallpaper).
To change any of the images simply drag the image you want and drop it on the image/section to replace.
If there was no previous image then the image will be saved with the original image name and the database will be updated.
If there was originally an image, the original image will be overwritten.

All images dropped can be resized to the relevant size for the section. The slider in the middle indicates the quality of the resizing function (default is 85%).

If you have any issues then post in here and I will try to sort them in a future release.

Constrictive comments welcome

Code:

1.0.4.6 - 15/10/2012
Fixed
When updating a movie's details from The Movie DB (on an existing movie), the genre list is now cleared (ie does not create duplicates) and re-populated.
Genre list box is refreshed when updating from ThemovieDB.


1.0.4.5 - 16/8/2012
Automatic grabbing & saving of genres from TheMovieDB when adding a new film.

1.0.4.4 - 16/5/2012
Added 'Scan Missing' report to search for files in media path but not in the database

1.0.4.3 - 8/5/2012
Added Exception handling when retrieving invalid data from MediaInfo
Added default handling when media runtime throws invalid format errors.
Added setting episode names in the DB from TheTVDB when adding new TV episodes

1.0.4.2 - 13/02/12

Fixed SQL error introduced in the last release when doing a bulk TMDB update.

1.0.4.1 - 12/02/12

Added facility to query TheTVDB by IMDB 'tt' ID
Fixed when querying TheTVDB the text 'Season X' is not stripped out so no results are returned.
Fixed 'bulk update from TheMovieDB' from clearing out details on TV shows.
Added querying TheTVDB with the tt ID for getting images to avoid multiple selection popup.

1.0.4.0 - 5/2/12
Added updating of information for TV shows from TheTVDB.  This is done at SEASON level, all linked episodes will be updated.
Added facility to get images from TheTVDB
Fixed spelling mistake
Corrected the poor quality of images downloaded from TMDB
Added further DB checking to prevent trying to open NMJv2 databases.

IMPORTANT NOTE: To bring it into line with NMJToolbox2 the SQLite DDL now uses the updated version.  You will need to re-download the SQLite dll to use this version.

1.0.3.8 – 17/9/2011

Added/Changed
Speed up processing of adding/deleting cast members
Removed ' - ' from episode Titles
Removed leading spaces from Series titles.
Edit Video - Update Cast now refreshes the cast list when complete.

Fixed
Fixed error when adding a cast/director with ' in the name.
Fixed error in some circumstances where starting the application causes an exception.
Fixed not updating Cast list in the SHOW record when editing cast.

1.0.3.7 – 16/9/2011

Added/Changed
Put the 'Compact DB' button back on utilities and removed auto compact on close (may avoid some errors some users are getting).

Adding episodes/TV series will complete the Episode number automatically (if media name in the format <series name> SXXEXX <Episode title>.xxx)

Adding episodes/TV series will complete the Series name automatically (if media name in the format <series name> SXXEXX <Episode title>.xxx)

Adding episodes/TV series will complete the Episode name automatically (if media name in the format <series name> SXXEXX <Episode title>.xxx), if no <Episode title> specified then a default episode name of 'Episode xx' will be added.

Fixed
Select all in the integrity check screen really does select all now ;)
GDI+ error in certain circumstances when selecting No to open last DB

1.0.3.6 – 4/9/2011

Added
Fix to remove duplicate '_OTHERS' indices, simply rebuild your indices and it will clean automatically.
Changed 'Article' matching in title indexing so that it is not language specific eg if you are german it removed 'Das' from the index but not 'The'. It will now remove all articles when indexing no matter what language. (user request).
Added Genre Filter option 'No Genre' to allow showing of only entries that do not currently have a genre. (User request)
Integrity check for missing TITLE_TYPE records. (Fix for Congo81)
Integrity check to remove orphaned VIDEO_ATTR records.
Added facility to add/edit/delete cast and directors on the Video Edit screen.

Fixed
No longer creates an '_OTHERS' index when one already exists whilst rebuilding Video indices.
(should have) fixed GDI+ error when exiting if 'no' to 'Open previous DB' selected then closing the app immediately (I say should as I could not re-produce this error but I know what may be causing it).
After editing a video entry, the datagrid was not updating it's display.
Progress bar on main screen now anchored correctly.

1.0.3.5 – 14/8/2011

Added/Changed:
Settings for positioning of splitter panes saved.

1.0.3.4 – 14/8/2011

Added/Changed:
Check box when adding a new video, if checked when you click OK the program automatically opens the 'Cover art edit' window.

When adding a new video, if you select a media file before adding a title on the left, the program automatically enters the media file name as the title.

Fixed:
When adding a new video and clicking OK, the newly added video is selected automatically in the datagrid.  Did not previously select if you replied Yes to the 'open previously opened database'

1.0.3.3 – 9/7/2011

Added/Changed:
Asks user if they want to re-open the last DB opened (rather than doing it automatically)

Fixed:
Unable to add music when there is no music already in the database (user was not able to select a Genre - now adds 'Default' if no Genre available/selected)


1.0.3.2 – 30/3/2011

Added/Changed:
Saved 'New image location' setting
Delete multiple music tracks at once in 'Modify Tracks' screen
last DB opened is saved in settings
Last DB opened is automatically opened when starting the application
Allow select & move up/down of multiple selected tracks in Modify tracks
Image Quality setting saved in parameters
Add renumber tracks button
Last Media/Audio path remembered when adding an episode/track
Added Splitter Bar to enable independant resizing of datagrid/tab controls.
Main Window size and position saved.

Fixed:
Nothing of note to fix ;)

1.0.3.1 – 27/2/2011

Added/Changed:
Restricted adding artwork from a folder that would also be the destination (used to cause GDI error)

Fixed:
Artist/Genre does not update if no previous record in DB.
Adding new album and manually changing the artists causes various errors on update.

1.0.3.0 - 26/02/11

Added/Changed:
Leaving the 'Modify Episode' screen takes you back to the record that was selected previously.
Added reading of FLAC/ID3 v1 & 2 Tags for Audio (no ogg files so not tested)
Added Delete Album to music
Added Modify Tracks to music
Added New Album function
Added jumping to selected track/album when changing between music tabs
Added Re-Index All for Music
Compact Database option removed - NMJToolbox does this automatically now when leaving the application
Added NMJToolbox web URL to title bar
Option to override default 'MPEG Audio' text for audio type to 'MP3' - this option is saved in parameters.
Changed 'Artist' label on Album & Track tabs to 'Album Artist' & 'Track Artist' for clarity.
Changed 'Title' label on Album & Track tabs to 'Album Title' & 'Track Title' for clarity.
Enter now selects 'OK' on the edit episode/track number dialog box in new/Modify functions.


Fixed:
Current Album Genre not displayed.
Move Episodes up/down in modify episodes does not move episode# or 'in DB'
Current Music (Track) genre not displayed
Removed un-needed text box on album tab that shows the album genre
Connection Closed error message when updating track details.
Windows exception when clicking New Video then cancelling out of the window.
Display issue leaves old posters in the picture control when changing tabs and the destination has no image path(s).

1.0.2.10 - 18/02/11

Added/Changed:
Switching between Video & Episode auto jumps to related records (is selecting a video line & clicking episode will automatically select the realted episode for the video that was previously selected)
Added a hard coded fix where 'The Watchmen' returns no cast due to TheMovieDB having (incorrectly) the film listed twice.
Added une, les, le, la, el, un, una, ein, das, der to the 'remove article' option when adding search titles (depending on the language settings selected).
Set 'Disable Resize' to default to unchecked (this is the recommended option to try to avoid the playback problems some experience)
Honour the 'Disable Resize' checkbox when getting images from TMDB (it never used to resize).
Added save settings for the state of: Disable resize, Keep aspect, use image name and overwrite images.

Fixed:
When modifying a video, clicking OK twice causes an error.
When modifying a video on returning to the main screen the old details are still visible (does not refresh)
Article not removed when modifying a video.
Adding a new episode to an existing show does not update the #episodes on the show record.
Rating & FPS on the Episode tab is an integer (worked around Syabas' DB design flaw)
Rating on the Video tab is an integer (worked around Syabas' DB design flaw)
Modify Episodes (adding to existing), IMDB TTID and file size not added.

1.0.2.9 - 23/01/11

Added/Changed:
Initial startup centred to screen
Check box to select/unselect all images on the TMDB images screen.
Changed MediaInfo source from Library to Format (Library is not always populated)
Defaulted text in the open file dialog to 'media.db'
Save the last language/region setting in a local properties file.

Fixed:
Adding an ISO causes a windows error.
Error generated when selecting 'MediaInfo' on Edit Episode under certain circumstances.
Catch invalid response received from TheMovieDB with certain language settings.


1.0.2.7 - 20/01/11

Added/Changed:
Added splash screen to conform to TheMovieDB API terms & conditions
Improved speed of cast processing.
Added progress bar for TMDB update in Edit Video screen.

Fixed:
When using TMDB button on Edit screen, the cast list is not added to the Video tab entry.


1.0.2.6 - 18/01/11

Added/Changed:
When Modifying a media file the media info details of the first media file is copied into the SHOW record.
Added retrieving cast from TMDB when adding a new Show.
Added retrieving cast from TMDB when the TMDB button is clicked on the Edit Video screen.
Automatic DB backup on start (will create/replace media.db.NMJBKUP in the nmj_database folder).
Add Synopsis to VIDEO (Episode) when adding a SHOW via 'New'

Fixed:
In Edit when using the MediaInfo button on a media file without any subtitles a windows error is generated.
Delete does not remove synopsis for SHOW record.
Create Time wrong format when adding a new show.

1.0.2.5 - 15/01/11

Added/Changed:
Images for wallpaper retrieved from TheMovieDB are auto resized to 1280x720.
Posters/thumbnails are downloaded at the 'mid' setting from theMovieDB.
Repositioned Wallpaper image count label
Add Subtitle DB updates using Mediainfo.
Added check to ensure that the required DLLs are found in the NMJToolbox.exe directory.

Fixed:
If first video file in the DB is a folder structure the Actual NMT Drive parameter is not set automatically.
Episode count on SHOW table being updated unncessarily.
Windows error given when selecting TMDB Images button and the 'Actual NMT Path' is not set.
Adding a new media file that has '[]' in the file name causes a windows error.

1.0.2.4 - 11/01/11

Added/Changed:
Certificate retrieved from TheMovieDB in Edit Show (Note, non US ratings may cause issues with NMJ).
If a movie has more than one media file, NMJT sets the type to '1' automatically in Add/New.
Updated Video type drop down lists to include Movie (multiple Parts).
Browse images directly from TheMovieDB within the NMJToolbox and add to the database.

Fixed:
Changing a title in show now places the title in the correct index.
Fixed error generated in some circumstances where there was an apostrophe in Title when adding a new title.
Rating being retrieved from TheMovieDB as an integer in Edit.


1.0.2.3 - 03/01/11

Added/Changed:
Nothing

Fixed:
Add/Modify when the media file has an apostrophe in it's name it caused an SQL error.
Titles in Add/Modify not being made DB safe.


1.0.2.2 - 02/01/11

Added/Changed:
Defaulted Add/Modify genre to Action.
Defaulted Add/Modify Title to Unknown if not already set.
Defaulted Add/Modify Type to Movie.

Fixed:
SHOW (Video tab) does not get deleted if there are no Episode records.
Adding an entry for a BDMV folder structure caused a windows error.


1.0.2.1 - 01/01/11
Added/Changed:
Added status bar messages and progress bar whilst adding/updating a show/episode.
Check for video already in the database.
Editing Episode number in New/Modify auto selects the text.
Added bulk re-index option on the utilities screen.

Fixed:
Ordering the data grid by DETAIL_POSTER caused a windows error.
(Hopefully) fixed the occasional path error when adding a new media file.
Error generated when video being added is already in the database.
Added a check that the title field is completed when adding a TV show.
Adding a new TV series or changing the episode number in 'Modify' does not update the episode number in the DB.
Child windows were not centred to parent window.
When indexing a title that starts with an apostrophe, the title was indexed under 'Other'.


1.0.2.0 - 31/12/10

Added/Changed:
Added MediaInfo facility
Added 'Modify Episode' and 'New' functions to edit media entries

Fixed:
Dropping an image with an apostrophe in the name causes an SQL error.
When adding a completely new genre, the available genres dropdown list is not updated with the new genre.

Other notes:
[b]NOTE: You MUST have the MediaInfo.dll in the same folder as the NMJToolbox.exe file[/b]
A number of other fixes have been added but I lost my changelog due to Windows update rebooting my computer and I can't remember everything I fixed :)


1.0.1.3 - 04/12/2010

Added/Changed:
(main screen) Ability to filter Video & Episode views by Genre.
(utility tab) Ability to mass add & remove genres on episodes.
(main screen) Double Clicking a row whilst in Video or Episode view opens the edit window.
(utility tab) Added a bulk 'scraping' facility from TheMovieDB (also allows to change the language of your entries)
(utility tab) Added a 'compact database' function.
(edit video) Added facility to update a single movie details from TheMovieDB.

Fixed:
Progress bar positioning.
Check for the path to the DB contains 'nmj_database' (If not previously gave windows error).
Images not being displayed if nmj_database folder is in a sub folder containing the phrase 'nmj_database' and the the image is stored inside the nmj_database/media' folder.
Added TheMovieDB lookup functionality. - gives the ability to change films into languages other than English.
Error generated if 'Refresh' is clicked whilst on the Utilities tab.
Error generated when moving from one DB to another DB when the new DB path does not contain 'nmj_database'.
Error generated when dropping an image with an apostrophe in the image name.


1.0.1.2 - 28/11/2010

Added/Changed:
Re-written image naming routines for dropped images (again).
Image clean up routine (with progress bar).
Donate button.

Fixed:
Moving from a video (or episode) with a synopsis to one without a synopsis in the DB did not update the video synopsis in the display.
Unable to add synopsis if a record does not already exist.
Images placed in the wrong folder or overwriting when it should not.

1.0.1.1 - 26/11/2010
Quick fix:
Corrected tab order on Edit Video
Fixed system error when trying to play a video that is inaccessible.

1.0.1.0 - 26/11/2010

Added/Changed:
Option to disable image resizing
Button to allow playback of video media via default playback application.
Video Genre(s) shown.
Ability to add/delete genres.
Removed 'Enter' taken as 'OK' on Edit episode as it interferes with clicking on the new 'Genre' combo box.
Added '<ALT>O' as the keyboard shortcut for OK on Edit Episode & Video.
Added '<ALT>C' (as well as <Esc>) as the keyboard shortcut for Cancel on Edit Episode & Video.
Database version checker (warns the user if the DB being opened is out of date and likely to cause problems).
Re-written image naming routines for dropped images.

Fixed:
Clicking 'X' in the Video Edit screen sometimes caused a database lock error.


1.0.0.12 - 23/11/2010

Added:
Edit Video & Episode - Escape key now enabled to cancel the edit.
Edit Video & Episode - Enter key now enabled to OK the edit.

Fixed:
Edit Video or Episode when the IMDB 'tt' ID is blank no longer causes an update error.
Tab order on Edit dialog boxes corrected.

V1.0.0.11 - 23/11/2010

Added:
Ability to resize window.
IMDB ID, Season and Episode numbers added to edit episode screen.
IMDB ID added to edit Video screen
Warning if user tries to use a UNC path
Parsing '<' and '>' search to HTML safe codes.
Artist, Genre & Track number to edit fields on Music Track.
Artist and Genre on Album edit tab (also corrects an error in the DB where multiple artist records are attached to an album).
Changing an artist automatically creates a new artist record if not already in the DB.
Artist changing gives a dropdown list of all currently registered artists in the DB.
Count of media being viewed in the status bar.
Updating Artist on a multiple artist album normalizes the data and warns the user before comitting.
Check & warning if the track number is already being used when changing the track number of an album track.
Keyboard shortcuts added to most buttons.
Pressing 'Enter' in the serch box automatically searches forward.
Column select facility to search on.
A User Guide!!

Fixed:
Improved detection of clicking on a data grid row.
Fixed details not changing when using the up/down arrow keys to navigate the data grid.
Corrected the order of columns to match database.
Fixed more fields to be DB 'safe' (apostrophes etc).

Removed:
Consolidate album art function (redundant).

v1.0.0.10 - 10/11/2010
Fixed:
Errors generated in music Album edit when date > 31/12/9998
Errors generated in all date fields when date < 01/01/1700

V1.0.0.9 - 10/11/2010
Added:
Ability to edit SHOW plots (previously only VIDEO - 'episode' plots).  The NMJ currently only shows the SHOW plot so you would have not seen a difference in the NMJ screen previously.

[mapleleafs89]

Neato, Im sure it will come in very handy for many.

Thanks!

[Specter]

This is a great tool to replace wallpaper and posters on the fly. Great with searching the database too.

Anyway that the window can be resized? It sucks having to be stuck in a 800 x 600 resolution when i have a 1920 x1080 monitor, im scrolling up down left right just to get a good view of the database list.

[Rom]

(11-10-2010 04:20 AM)Specter Wrote:  This is a great tool to replace wallpaper and posters on the fly. Great with searching the database too.

Anyway that the window can be resized? It sucks having to be stuck in a 800 x 600 resolution when i have a 1920 x1080 monitor, im scrolling up down left right just to get a good view of the database list.

I have thought about this and wondered what to do with the tab control and the image controls and frankly I was lazy and took the easy way out. I developed it on my netbook (only a 10" screen) so I kept it to the size I could see the whole app in my window .

However, I will look at re-enabling the window resize and sort that out for you no problem Specter.

[Bazrah]

Hey Rom, thanks for this!!

Can I change anything else apart from the images- plot, genres etc?

EDIT- Ignore me, I just reread the first post!!

[nicob]

Rom, looks great...

please consider FTP support in future release as I would like not to run samba when not needed. The less services, the better...

[TheBigAristotle]

Just a question: where does NMJ put the databases by default?

[halfelite]

(11-10-2010 11:03 AM)TheBigAristotle Wrote:  Just a question: where does NMJ put the databases by default?

The root of the device its scanning. so if you scan the local drive in root you will have a folder called nmj_database. if its a share the root folder will have nmj_database which holds the db and all pictures it gets from imdb.

[Rom]

(11-10-2010 10:58 AM)nicob Wrote:  Rom, looks great...

please consider FTP support in future release as I would like not to run samba when not needed. The less services, the better...

Unfortunately it has to use samba as it not only saves images to your network shares (which could be FTP'd potentially) it also updates the database via SQL which cannot be done over FTP.

If you don't want to use samba you can copy the DB over locally via FTP and edit it on your local machine. However, you will not be able to use the function to save images to your media folders as it needs access to them. You would have to keep images in the nmj_database/media folder.

[Bazrah]

@Rom - got this up and working after converting my YAMJ setup. All good!

The only thing is I can't see where to edit the plot or genres. Have I missed something?

Thanks!

[Rom]

(11-10-2010 12:18 PM)Bazrah Wrote:  @Rom - got this up and working after converting my YAMJ setup. All good!

The only thing is I can't see where to edit the plot or genres. Have I missed something?

Thanks!

The plot is edited on the 'Episode' tab. A film will have 1 VIDEO entry and 1 EPISODE entry. However, a TV series will have one VIDEO entry but multiple EPISODE entries. This allows you to edit the plot for each episode (though currently it is the same plot for every episode in a series in the NMJ). I put it on the Episode in case the devs change it to enable multiple plots per TV series.

As to Genre, there is not edit for that at the moment as I will have to generate a list of valid genres. Can be an option to put on my 'to do' list.

[coolstream]

Excellent stuff. I have been screaming out for something like this from the first beta.

Can't wait to try it. BTW, I also echo the request to have access to a larger screen size

[Rom]

Out less than a day and already an update!

Thanks to Xorron for spotting this.

Added ability to update the plot on the SHOW (previously only VIDEO plot was editable). The NMJ currently does not use VIDEO plots, only SHOW plots so you would have seen no change in the plot text on your TV if you edit on the 'Episode' tab. The new plot box is on the 'Video' tab.

[doliha]

Thanks for NMJToolbox.
Please can you see what happend with link of V. 1.0.0.9, the .rar contains the V. 1.0.0.8.

[Rom]

(11-10-2010 07:14 PM)doliha Wrote:  Thanks for NMJToolbox.
Please can you see what happend with link of V. 1.0.0.9, the .rar contains the V. 1.0.0.8.

I have just downloaded it and the link is correct. It may have been cached. Try re-downloading again.