Allow editing of IMDB etc without using NFO files

[GoogleCodeExporter]

ie edit database directly.

Original issue reported on code.google.com by lordylo...@gmail.com on 28 Jul 2009 at 2:55

[GoogleCodeExporter]

Original comment by lordylo...@gmail.com on 28 Jul 2009 at 2:56

• Added labels: Component-UI

[GoogleCodeExporter]

I was just about to post a question asking how to do this. I assume that if 
there is
a Change Request (CR) for this item, then it must not be a current function. 
There
are a number of reasons why someone might want to do this, so I'll post some 
feedback
in case this might help with the direction of development:

(1) TV Episodes - Bad Formatting
Against the recommendations in the comment of the catalog configuration file, I
rename my TV show files. I categorize my TV shows in the following format so 
they are
easy to read and look nice from the standard PCH interface:
/share/TV/Show Title/Season #/S##E## - Title.ext
/share/TV/Entourage/Season 1/S06E06 - Murphys Lie.mkv

While oversight does seem to pick these up most of the time, certain shows 
don't pull
in a proper title. For example, The Tudors episode titles are typically just 
"Episode
3". When the system tries to catalog these files, it typically gets them wrong. 
For
the time being, I have simply removed them from the index, but at some point 
I'd like
to add them in. There are probably other options here - such as improving the 
catalog
feature to use the folder names in determining how to index the content, but if 
I
could manually edit these items within the database it would simplify things 
for me.

(2) Non Movie / TV shows
I sometimes download video clips and short films which apparently don't get
categorized properly. For example, there is a group from Saturday Night Light 
(SNL)
called The Lonely Island which makes comedy sketches. Their files did get 
indexed by
oversight, but they all got added to the root of oversight which was somewhat 
messy.
Again, I simply removed these files from Oversight for the time being, but if I 
had
the option I would have cataloged the 10 or so Lonely Island sketches together 
under
one "Lonely Island" poster/season and manually added the titles for each item.

(3) Correction of Incorrect Tags
Sometimes items simply get cataloged with odd formatting / spelling or other 
minor
discrepancies. It would be nice to be able to clean these things up.
Ex:
Big Brother Us > Big Brother US
Final Fantasy Advent Children > No Poster and named odd within database
Iron Man > missing poster

Original comment by lyon.jos...@gmail.com on 19 Aug 2009 at 2:18

[GoogleCodeExporter]

I have installed oversight "r667-testing" and I love it, BUT it would be boomed 
to
heaven if there could be "somekind" of editor, to do corrections in the 
database. I
store all of my DVDs on a NAS and the correct hitrate is around 80%. So if I
could manually edit these items within the database it would simplify things 
not only
for me but anyone else. As I follow the DVD structure I'm using the "VIDEO_TS"
folders, but I cannot change the poster/cover.  

Original comment by ewe...@gmx.de on 10 Jan 2010 at 5:04

[GoogleCodeExporter]

As this issue is not progessing I created a simple editor.
Can be regarded as a beta version. Use it at your own risk.

Requirements:
- Windows / .NET Framework 2 (sorry :)
- Oversight r952 (with separate catalog.sh and catalog.awk files)

How to use:
- Rename .exec to .exe
- Create a backup of your /share/Apps/oversight directory (except /db and 
/tmp). It
might come handy if something goes very wrong.
- Start JukeboxNFOverifier.exe, press Autodetect
- If Popcorn Samba share cannot be found enter it manually, e.g. 
\\pch-a110\share
- Background scan of share starts now; wait for "Oversight editor" tab to appear
- Click on it. Wait until the grid populates (it can take some time).

Now you are ready to edit. You can edit all shown cells, except ID. 
Plot editing is not working yet.

Add/Rem Genre and Paste cells explained in popup hint.
You can also copy the currently selected cell value to the one below it by 
pressing
Alt+Down arrow.

If Oversight starts indexing all unsaved changes will be lost, and the editor 
tab
will display indexing progress instead of the editor. After indexing has 
stopped, it
will revert to editor mode.

On Save all media files in index.db will be hashed quickly (not the whole 
files, only
some parts of them). (Hash info will be stored /share/Apps/oversight/jnv_store) 
If you move any of these indexed files to other directories, JukeboxNFOverifier 
will
try to repair the path of these "missing" files in index.db on next start, so
Oversight would not have to reindex those files again (and fill your beautified 
data
with uncomplete/bogus info).

I will monitor this issue for a couple of weeks.
Ideas/comments are welcome.

Original comment by a...@put2.net on 5 May 2010 at 7:01

Attachments:

• JukeboxNFOverifier.exec

[GoogleCodeExporter]

When running on Win7 x64, clicking on the Oversight editor window triggers an
Unhandled excetion ...

System.ArgumentOutOfRangeException: Index was out of range. Must be 
non-negative and
less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at JukeboxNFOverifier.OverSight.DiscoverWinLinuxPath()
   at JukeboxNFOverifier.OverSight.ReadDB()
   at JukeboxNFOverifier.Form1.tabControl1_SelectedIndexChanged(Object sender,
EventArgs e)
   at System.Windows.Forms.TabControl.OnSelectedIndexChanged(EventArgs e)
   at System.Windows.Forms.TabControl.WmSelChange()
   at System.Windows.Forms.TabControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr
wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
JukeboxNFOverifier
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/david/Desktop/JukeboxNFOverifier.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e
089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/Sy
stem.Drawing.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase:
file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.
Data.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System
.Xml.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Original comment by davidfga...@gmail.com on 8 May 2010 at 1:36

[GoogleCodeExporter]

Possible causes I see so far:
- No files in Oversight were indexed at all.
- All files are external (on NAS, etc) to the PCH (as I do not have NAS, I 
don't know
how they is mapped)

In any case, I improved the code to skip hashing (and therefore syncing) if it 
cannot
map files.

Also, it will display the error (and copy it to clipboard) with line numbers 
from now on.

If still there are problems please include:
- JukeboxNFOverifier.ini
- \share\Apps\oversight\index.db

Original comment by a...@put2.net on 9 May 2010 at 5:33

Attachments:

• JukeboxNFOverifier.exec

[GoogleCodeExporter]

So my desktop machine is mapped to the PCH via smb drive Q:.  The video files 
are on
a Windows Home Server, and mapped to a drive as well (drive V:).

I am attaching the files you requested.

D

Original comment by davidfga...@gmail.com on 9 May 2010 at 9:18

Attachments:

• JukeboxNFOverifier.ini
• index.db

[GoogleCodeExporter]

Sorry, I wont'be able to progress for a couple of days, as I have 
conjunctivitis.

Meanwhile please attach \Apps\oversight\conf\catalog.cfg, and tell me what is 
the
absolute path of the videos directory on the Popcorn.

I assume it is V:\videos on the PC. 

BTW the last attached version should work as an editor, it just need some extra 
time
to recognize nothing can be mapped before displaying the editor grid.

Original comment by a...@put2.net on 10 May 2010 at 1:26

[GoogleCodeExporter]

On the Popcorn:

Protocol: Samba
Ip/Hostname: 192.168.2.36
share folder: videos

Original comment by davidfga...@gmail.com on 10 May 2010 at 6:06

Attachments:

• catalog.cfg

[GoogleCodeExporter]

I have modified the logic of mapping the files between Windows and the Popcorn. 
Now
it will able to use more than one mapping (and stores them in the .ini file). 
If it encounters a file which has no mapping defined, it will ask you for its
location with a dialog. (Also, the .ini can be edited manually too, when
JukeboxNFOverifier is not running: [Mappings] section)

So I think it should work for you now.

I have also changed the background scan logic: it will skip scanning of folders 
named
mp3, Music, Photo, lost+found. (Case sensitive!)

Original comment by a...@put2.net on 23 May 2010 at 9:06

Attachments:

• JukeboxNFOverifier.exec

[GoogleCodeExporter]

Issue 607 has been merged into this issue.

Original comment by lordylo...@gmail.com on 22 May 2011 at 11:50

[GoogleCodeExporter]

Unfortunatly it seems like development of this databse editor has stopped.
Are you still here Arpa?

Original comment by hussey.m...@gmail.com on 12 May 2012 at 3:12

[GoogleCodeExporter]

Is there any progress?

Original comment by esch...@gmail.com on 29 Jul 2012 at 1:58