Topic: Cinematic Collection Viewer

[Tom]

I thought I'd make a thread for my tool "Cinematic Collection Viewer" for those who are not visiting the other forum but have questions (I know I lack help documentation. It is one of those things that I always had planned to do but never came around to it).

You can find the tool on my website.

What is it for?
This is a database front end (with an Access database behind it) for managing your collections. Initially solely for movie collections, I also use it for my Manga collection). Originally thought as an extension to the DVD Profiler database it can also be used on its own.

Here some of the key features:

• Import DVD Profiler XML
• TV Episode Handling
• SQL Queries (Exchanging, discussing and asking for help for SQL queries is very welcome in this thread]
• Awards display
• Export as HTML. Example see my Online-Collection
• Headshots support
• Online source for TV episode data, awards, SQL queries and more

History:
The CCViewer first came about during the time, that DVD Profiler 2.5 was in development hell. During that time it was promised, that DVD Profiler will have episode handling in the future. So I started a project asking the community to start collecting episode based cast and crew data for when the time comes. To put this data into use before that time, I created a "TV Cast & Crew Viewer". I then started to put features into it, which I missed in DVD Profiler (cross-linking, headshots, SQL, awards, episode assign to profiles, HTML export (replacing Doug's DVDProfiler Companion which did not work with Profiler 3, different collection types other than Owned/Ordered/Wishlist, additional information like IMDb links, Wikipedia links, reviews). Some of those features are still not supported in Profiler (or not to my satisfaction). I soon renamed the tool to "Cast & Crew Viewer".
Later on I was not satisfied with this name anymore, because it was not solely a cast and crew viewer anymore. So I went on search for a new name. Because this tool was mainly known as "Tom's Viewer" in the community and I always liked to appreviate it with CCV or CCViewer, I wanted to retain those letters. Madacid (my faithful beta tester) had proposed "Cinematic Collection Viewer" and this name stuck.

[Tom]

I have a new beta version in development planned for release when DVD Profiler 3.6 has gone final. It is stable and is a release candidate. If anone is interested to check it out, just ask me

[Najemikon]

Tom, I must apologise, I had no idea your viewer could do proper SQL queries. I must give this a try. 

[richierich]

Tom, I must apologise, I had no idea your viewer could do proper SQL queries. I must give this a try. 

me 2

will be checking out the new beta when 3.6 is officially released

[Antares]

I can't get this program to work. When I start it up I get this...




It says it's loading, but nothing happens.

What am I doing wrong?

[RossRoy]

Just click the "New" button to create a database, and then click OK and you're good to go.

You'll have to import the XML from DVD Profiler, then you could update some data (awards, etc.)

[Tom]

I will rename the dialog to "Select database" for the next version. I think that would be less confusing.

[Tom]

New version: v2.3

As DVD Profiler 3.6 seems to be in Beta forever, I will release a new version of CCViewer now. I hope Ken doesn't change the XML for the final release.

New: Profiler 3.6 support
New: Optionally include awards data and/or additional infos in Profiler export
New: Detailed progress information
New: Person crosslinking in HTML Output
New: Special handling to deal with custom/other roles with category prefix (CastCrewEdit2)
New: Adjust common names in award data via "Edit Crosslinks" window
New: "credit only" flag for cast
New: Re-arranging crewmapping via drag & drop
New: Show datatypes of non-string fields in table list in SQL Queries window
New: Import IMDb data "AKA names" into crosslink table (i.e import all IMDb Common Names with all variations). For local use only.
New: Added variable CCV_ProgramPathHeadshots to CCV_HEADER_VARS
New: Added bool variable CCV_ExportedHTML to CCV_HEADER_VARS
New: Move Crew Type in Crew Mapping editor via context menu
New: Included list of past changes (Changelog.txt)
New: IsActive flag for Users
New: Single profile export for Viewer Collection file export
New: Headshot Wizard -> "Copy Where None Exists": Copies all headshots from source to headshot folder, for persons where previously no headshot was available at all
New: Filter file list in "Manage Headshots" dialog
New: Export StoreIt text file (iPhone App), DB template is included (Beta)
New: Events in CCV_HEADER_VARS
New: Cast and crew in CCV_HEADER_VARS
New: Variable CCV_IsEpisode in CCV_HEADER_VARS
New: Blu-ray region icons for Deviant skin
New: Add URL links for episodes
New: SVN Audit Trail
New: Easter egg
Fix: Awards in CCV_Header_Vars
Fix: Airdate in Episodes skin tag
Fix: Restrict string length for award nominees
Fix: Proper indentation episode cast node in Viewer export
Fix: Loading of boolean default settings
Fix: Headshot Tool "Remove Trailing Spaces". Fixed handling of alternate headshots.
Fix: Handle if XML are input which miss tags which are usually not optional
Fix: Handle apostrophe in URL of headshots in HTML export
Fix: Crash when entering BY > 32768
Fix: Command line "CloseViewer"
Fix: Cancel of user input in SQL queries will also cancel SQL query
Fix: Display the correct movie year in award editor
Fix: Loading the correct collection type content after start-up
Fix: Crash when entering apostrophe in IMDb link dialog
Fix: Handle local separator in HEADER_VARS in Aspect Ratio
Change: BirthYear is considered in award search.
Change: Ordering of events and awards in CCVExport
Change: Improved AddAlias function
Change: Better handling of SongTitles/EpisodeTitles which include colon
Change: Ask before saving changes to crew mapping
Change: Added MetaInfo table which will include DVDProfiler information not used in CCV but needed to have all information for DVDProfiler export
Change: Settings for translation now saved in database
Change: Tracing of translatable strings now done in table Translation
Change: Adjustment in movie award search. If MovieYear unequal to award year is given, only comparison of movie year with the profile's production year is used. No range check of production year with award year is done.

[Tom]

New version: v2.4

New: Handling of uncredited crew in Profiler XML Import/Export (appendix "(uncredited)" in Profiler's custom crew role is converted to uncredited flag in CCV)
New: Syntax highlighting in Skin editor on loading of skin (though no dynamic highlighting as of yet)
Change: Improvement of profile editing
Change: Adjustment of group divider handling to be similar to DVD Profiler (i.e. only one additional level)
Change: Map audio channels on Profiler Import/Export
     Dolby Surround  <-> 2.0 Surround
     2-Channel Stereo <-> 2.0 Stereo

[Tom]

Version 2.5
Change: Special handling of group dividers to be able to see role names of group members in appearances search
Fix: Minor tweak in profile editing combobox
Fix: Export IsRegular with Viewer Collection File and TV Series export


I am releasing this now, even though I haven't changed much. But the first change I think is an important one because of the ever-increasing use of group dividers. You'll need to reimport the Profiler XML file to have the full effect.

[Tom]

New Version: v2.6
New: Added filter support in "Export HTML"
New: Optionally export all infos in TV Series export
New: Enhanced TV Series import to import all infos
New: Import optional additional infos from Profiler XML generated by CCViewer
Change: Reworked buttons update in "Edit Awards" window
Change: Only copy visible columns on copying a list to clipboard
Change: Wrapping for awards in Deviant Skin
Fix: Overflow error in BrowseFolder dialog
Fix: Handle invalid Review values in Profile Information window

[Tom]

I need beta testers:
I have added a new field called "CustomTitle". You can enter now a custom title for each profile. E.g. it can be used to enter the English title for an Asian movie of your German DVD profile. It includes new skin tag CUSTOM_TITLE and option View->Use custom title
This change is affect a lot of parts throughout the program, so I would appreciate some beta testers before I release a new version.
If you are interested, please download
this zip file and replace the CCViewer.exe in your installation with the included new exe file. Please report any issues you have to me. Thanks!

Other changes in this beta version:
New: New setting for including profiles of certain collection types in Owned tab
Change: SetAutoAlias function updated to current Invelos common name filter
Change: Use title if original title is empty on import of IMDb Data
Fix: Crash at loading HTML Export form

[addicted2dvd]

Hey Tom... think I may have goofed up. I went to get Episode Data... and clicked ok... and suddenly realized that I was downloading also for shows I don't have. So I clicked the X in the top corner to stop it. And when I went to do it again to check off the series I actually have... it don't bring up the box and just freezes. Ideas?

[addicted2dvd]

Took several tries... but finally got it going again.

[Tom]

Hey Tom... think I may have goofed up. I went to get Episode Data... and clicked ok... and suddenly realized that I was downloading also for shows I don't have. So I clicked the X in the top corner to stop it. And when I went to do it again to check off the series I actually have... it don't bring up the box and just freezes. Ideas?

Probably it was still trying to finish up the last action it was doing. If you press the X, it will get a cancel signal and it will stop at the instances were I put possible stops. Probably it was still finishing downloading the data of one of the series.