Melting similar movie attributes (genres, countries,...)
Have you got, for example, multiple 'genres' definitions which are all similar and should be melted in only ONE definition ?
If you have 'Sci Fi' and 'Sci-Fi' Genres, you may want to have all movies concerned point to only ONE name and the one you choose ('Sci-Fi' for example).
Renaming 'Sci Fi' Genres definition in 'Sci-Fi' won't be forbidden by Movienizer but you still have two groups of movies (each one with genre named 'Sci-Fi') ...
This tool can do the melting job.
So, let's call a movie 'attribute' an info of a movie which refers to a definition list like 'Genre', 'Country', and so...
This Tool makes possible to switch a movie attribute name to another like switching the movies pointing to 'Sci Fi' Genre to now point to 'Sci-Fi' Genre instead of 'Sci Fi'.
This can be done for any attribute type (genre, country, custom fields, custom lists, etc...)
HOW TO USE attribMultiSwitch :
1) Make sure sqlPack is installed (sqlite.exe is present in 'sql' subfolder of Movienizer install dir)
To install sqlPack, see topic http://www.movienizer.com/forum/viewtopic.php?f=7&t=473
2) Unzip the attribMultiSwitch.zip file in Movienizer install dir : it will install files in 'sql' subfolder
3) Make sure Movienizer is NOT active (close it if it is)
4) Edit file sql/attribMultiSwitch.csv (using Excel or Notepad or ...) NB: example file is french oriented...
5) BEFORE ANY SQL REQUEST LAUNCH : BACKUP YOUR DATABASE !! (unwanted deletions and updates couldn't be rolled back !)
5) Run (Double-click) sql/attribMultiSwitch.bat
You may run it after each (significant or not) Database update (movie updates or adds)
6) Run Movienizer. All should be done as you defined in .csv file.
If it seems not, open sql/attribMultiSwitch.out to see if errors occured (name references not found in database or mistyped)
NB: Every attribute name (the old one AND the new one) must have been defined in definition list in Database.
You CAN'T CREATE a new name : only SWITCH from one name to another existing one.
If 'Great Britain' country isn't defined, switch 'G.-B.' to 'Great Britain' won't do anything.
You must first create 'Great Britain' country definition.
Thanks for reading till this point !...
Hope this will help (at least, it did for me...
Edit : Obsolete File removed. JeF's interface now has this feature integrated (see Database Toolbox page)