1. Installation
o Install the plugin msi from here
2.1 PVD setup
o from the file menu, select connect to server
2.2 PvdImport setup
o In Media Center, goto "Services & plugins" and select PvdImport
o The lowermost area in the plugin window shows status texts
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at PvdImport.MainInterface.buttonSaveConfiguration_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(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.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
PvdImport
Assembly Version: 1.0.3405.42397
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Media%20Center%2013/Plugins/PvdImport/PvdImport.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
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.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
DataConfig
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Media%20Center%2013/Plugins/PvdImport/DataConfig.DLL
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
NamedPipe
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Media%20Center%2013/Plugins/PvdImport/NamedPipe.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
gyc8vepr
Assembly Version: 1.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
3whkwwr-
Assembly Version: 1.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Interop.MediaCenter
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Media%20Center%2013/Plugins/PvdImport/Interop.MediaCenter.DLL
----------------------------------------
FirebirdSql.Data.FirebirdClient
Assembly Version: 2.0.1.0
Win32 Version: 2.0.1.0
CodeBase: file:///C:/Program%20Files/Media%20Center%2013/Plugins/PvdImport/FirebirdSql.Data.FirebirdClient.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Media Center; Version: 13.0.152; Types: 16383
0020009: 5236: General: CMCResourceHelper::GetIsModalPopupShowing: Menu showing
0022472: 5236: General: CMCResourceHelper::GetIsModalPopupShowing: Menu showing
0034369: 5236: General: CMCResourceHelper::GetIsModalPopupShowing: Main window disabled
0034439: 5236: General: RunProgram: Start
0034479: 5236: General: RunProgram: Filename: C:\Documents and Settings\Rick\Application Data\J River\Media Center 13\Log.txt / Parameters:
0034579: 5236: General: RunProgram: Performing ShellExecute...
0034750: 5236: General: RunProgram: Running process...
0034810: 5236: General: RunProgram: Finish (371 ms)
0046296: 5236: Podcast: CPodcastScheduler::Update: Start
0046336: 5236: Podcast: CPodcastScheduler::Update: Processing completed work threads
0046527: 5236: Podcast: CPodcastScheduler::Update: Purging files
0046587: 5236: Podcast: CPodcastScheduler::Update: Scheduling downloads
0046687: 5236: Podcast: CPodcastScheduler::ScheduleDownload: Start
0046727: 5236: Podcast: CPodcastScheduler::ScheduleDownload: No work found
0046767: 5236: Podcast: CPodcastScheduler::ScheduleDownload: Finish (80 ms)
0046787: 5236: Podcast: CPodcastScheduler::Update: Finish (491 ms)
0052345: 5236: General: CMCResourceHelper::GetIsModalPopupShowing: Main window disabled
0053677: 5236: General: CMCResourceHelper::GetIsModalPopupShowing: Main window disabled
0069690: 5668: General: TopLevelExceptionFilter: Unhandled exception -- program crashing
0069770: 5668: General: TopLevelExceptionFilter: Message: 0, wParam: 0, lParam: 0, Window class: Okay, now I give up. ;)
Warning!! Failed to find Pvd database (C:\Documents and Settings\Harald\My Documents\Personal Video Database\movies.pvd)
Plugin Initiated OKFailed to open database (when retrieving filenames);I/O error for file CreateFile (open) "C:\Documents and Settings\Harald\My Documents\Personal Video Database\movies.pvd"
Error while trying to open file
Failed to open database (when retrieving filenames);I/O error for file CreateFile (open) "C:\Documents and Settings\Harald\My Documents\Personal Video Database\movies.pvd"
Error while trying to open file
I think we have a winner!
I'll keep fiddling.Great, I'll try and fix those issues with the paths later on today.
I wonder what happened with yours, Rick? Weird.
Rick.ca, do you see the "send to external" item?
Which OS are you guys on?
...my lack of patience is the problem.
Media Center; Version: 13.0.152; Types: 16383
0013780: 924: General: CMCResourceHelper::GetIsModalPopupShowing: Menu showing
0013900: 924: General: RunProgram: Start
0013960: 924: General: RunProgram: Filename: C:\Program Files\Media Center 13\Plugins\PvdImport\PvdImportContextMenu.exe / Parameters: "L:\Oscars\Babette's Feast (1987) 7.7.avi"
0014000: 924: General: RunProgram: Performing ShellExecute...
0014140: 924: General: RunProgram: Running process...
0014271: 924: General: RunProgram: Finish (371 ms)
0014391: 924: Reader: CLocalReader::OpenInternal: Opening: C:\Documents and Settings\Rick\Application Data\J River\Media Center 13\Library\links.xml
0014551: 924: Reader: CLocalReader::Close: Closing: C:\Documents and Settings\Rick\Application Data\J River\Media Center 13\Library\links.xml
0014601: 924: Database: CMJSearchHelper::GetResults: Search: [media type]=audio; Elapsed ms: 0.428
0014771: 924: Database: CMJSearchHelper::GetResults: Search: [Media Type]=[Audio],[Video]; Elapsed ms: 0.489
0014861: 924: Database: CMJSearchHelper::GetResults: Search: [Media Type]=[Audio]; Elapsed ms: 0.427
0014922: 924: Database: CMJSearchHelper::GetResults: Search: [Media Type]=[Video]; Elapsed ms: 0.429
0014972: 924: Database: CMJSearchHelper::GetResults: Search: ; Elapsed ms: 0.198
0020760: 924: Reader: CLocalReader::OpenInternal: Opening: C:\Documents and Settings\Rick\Application Data\J River\Media Center 13\Library\links.xml
0020810: 924: Reader: CLocalReader::Close: Closing: C:\Documents and Settings\Rick\Application Data\J River\Media Center 13\Library\links.xml
0020830: 924: Database: CMJSearchHelper::GetResults: Search: [media type]=audio; Elapsed ms: 0.463
0020870: 924: Database: CMJSearchHelper::GetResults: Search: [Media Type]=[Audio],[Video]; Elapsed ms: 0.520
0020890: 924: Database: CMJSearchHelper::GetResults: Search: [Media Type]=[Audio]; Elapsed ms: 0.462
0020910: 924: Database: CMJSearchHelper::GetResults: Search: [Media Type]=[Video]; Elapsed ms: 0.463
0020930: 924: Database: CMJSearchHelper::GetResults: Search: ; Elapsed ms: 0.249
0021000: 924: General: CMainUIWnd::Resize: Start
0021080: 924: General: CMainUIWnd::Resize: Finish (80 ms)
0000151: 4196: Reader: CLocalReader::OpenInternal: Opening: C:\Program Files\Media Center 13\Data\Languages\English (Canadian)\Language.txt
0000221: 4196: Reader: CLocalReader::Close: Closing: C:\Program Files\Media Center 13\Data\Languages\English (Canadian)\Language.txt
That was it. It takes more than 10 seconds to query a record in my full database. Hitting "Test" while that's in process causes MC toStrange, PVD doesn't respond that slowly? What about the other client you installed? I've got maybe 500 files in my collection and one query takes approximately .3 seconds.
Strange, PVD doesn't respond that slowly? What about the other client you installed? I've got maybe 500 files in my collection and one query takes approximately .3 seconds.
I've fixed up some minor issues with the file paths in the new version
Strange, PVD doesn't respond that slowly? What about the other client you installed? I've got maybe 500 files in my collection and one query takes approximately .3 seconds.
I've fixed up some minor issues with the file paths in the new version.
Yes, that was just a lapse of reason.
There is one significant change in the wrong direction—the field configuration can no longer be saved. The button remains as "Load fields," no matter what changes have been made. Now I really hate the "one-button-does-all" idea. ;)
Is it really necessary the previous version be uninstalled before installing a new version. It would be so much faster just to overwrite. In any case, something should be done to preserve the user's existing configuration files, or users should be advised to not use the default files for custom configurations (which, surely, most will be).I agree with you here.
Failed to open database (when retrieving filenames);I/O error for file CreateFile (open) "C:\Documents and Settings\Harald\My Documents\Personal Video Database\movies.pvd"Hey Peter, thanks for joining in!
Failed to open database (when retrieving filenames);I/O error for file CreateFile (open) "D:\Tools\Personal Video Database\Ramus Test Install\Test Library\Ramus Test Library.PVD"
Error while trying to open fileNo luck for me with using a custom database file:Code: [Select]Failed to open database (when retrieving filenames);I/O error for file CreateFile (open) "D:\Tools\Personal Video Database\Ramus Test Install\Test Library\Ramus Test Library.PVD"
Error while trying to open file
The Load/Save & Set Database buttons all seem to work as expected now though. Exiting MC and loading a saved config file loads all the relevant paths again which is nice.Good.
Can you ckeck if this file is locked by PVD maybe? Try closing down PVD and hit "test" again; you might still be using PVD through the embedded client (which locks down the database).
I'm at work now and I don't have my code at hand, but I'm pretty sure that PvdImport fails in *opening* the file (I.e. PvdImport finds the file).
There is a problem in beta4 of PVD which I've experienced, so for now, I cannot run PVD simultaneously with PvdImport (or Firebird Maestro).
Good.
Was just posting :) Yes, I tried again after closing PVD and the sql results were populated. I noticed that "Test" actually updates the fields in MC as well - this was not expected.Good point, we might turn off update when "test" is pushed. Did you make a backup of your library, btw. :)
Update of fields via Send To -> PVDImport is also working fine, just as before.
I know we're probably not at graphical interface level of design yet, but the mouseover popups of fields/column headers from within the plugin view (in Media Center) are unreadable. I'm using the default (Noire) skin.I know, and I've tried googling this but to no avail..
I can start testing out custom fields and a larger library now.Yes. Check-> On. Rick.ca desperately wants this :) For me it's not an issue. You can just deselect the option.
Two questions though... how does the numbered list column work? The checkbox turns it on? Is this an optional solution for preserving artists etc as numbered lists. I'll have to consider this. As you you guys might be aware, MC only alphabetises the field if it is manually edited, so provided you don't touch the entries once they're in MC, it may not be necessary. It's an interesting idea though...
I'll have to examine the language in the PVDexpression part of the plugin a bit more closely. What would the general template for a custom field be?
Hey Peter, thanks for joining in!
Yes, this particular issue disappeared in the noise. I'll fix it in the next update.
Sorry could someone explain what this plugin is for?
:)
I found one issue. If a movie filename and or path contains a special character like ' or " (umlaut) then the data will not be imported from pvd.Yes, I saw that. It's noted.
peter
I'd like to see if a clean install manages to find all te files. Especially the default PVD database location found under my documents.
Ok :)Great!
Yes it did find:
C:\Users\Peter\Documents\Personal Video Database\movies.pvd
That one exists, but I actually use:
C:\Users\Peter\Documents\VIDEO DB.PVD
Using set I select it and it then works ok.
peter
Great!
Indeed.
I changed in the plugin settings mc [Original Title] to mc [Name] for the title import and that worked as expected :) Maybe I will try to change it to add the pvd translated title when it exist as well...but my sql is very rusty ;) Anyway after you got the special characters thingy fixed I am all set. In the meantime I'll have some "fun" entering all my movies into pvd ;)
peter
There is a problem in beta4 of PVD which I've experienced, so for now, I cannot run PVD simultaneously with PvdImport (or Firebird Maestro).
[DataBase]
FileName=rix:C:\Data\PVD\MY MOVIES BETA 5.PVD
Mode=0
RecentFiles=..\..\Data\PVD\Dummy.PVD|rix:C:\Data\PVD\TEST.PVD
Network=1
RecentTypes=0;1;Don't push test button until sql results are ready, the application will hang
If a movie filename and or path contains a special character like ' or " (umlaut) then the data will not be imported from pvd.
Yes. Check-> On. Rick.ca desperately wants this. For me it's not an issue. You can just deselect the option.
Select PEOPLE."name" || ' - ' || CAREER."role"
From PEOPLE Inner join CAREER on (CAREER."pid" = PEOPLE."pid")
Where CAREER."ctype" = 0 And CAREER."mid" = @idWhat would the general template for a custom field be?
Select CUSTOM_VALUES_LONGSTR."value"
From MOVIES
Inner join CUSTOM_VALUES_LONGSTR on MOVIES."mid" = CUSTOM_VALUES_LONGSTR."mid"
Inner join CUSTOM_FIELDS_MOVIES on CUSTOM_FIELDS_MOVIES."cmfid" = CUSTOM_VALUES_LONGSTR."cmfid"
Where MOVIES."mid"=@id and CUSTOM_FIELDS_MOVIES."dispname" = 'Review'I suggest you download Firebird Maestro and experiment if you would like some other fields populated, etc.
Select EPISODES."season"
From MOVIES Inner join EPISODES on MOVIES."epid" = EPISODES."epid"
Where MOVIES."mid"=@idSelect EPISODES."epnum"
From MOVIES Inner join EPISODES on MOVIES."epid" = EPISODES."epid"
Where MOVIES."mid"=@idAny ideas how to get this working with ripped dvd's? With mc you cant just point pvd to the .ifo file in the VIDEO_TS folder because mc creates its unique filename in the filename field (ie .dvd;1)
I like where this is going.
Trying to update too many movies at once overwhelmed my machine. It seems MC dutifully executes all the Sendto commands at once, and each one is a separate process. I find I can do 100 at a time, but over 150 is likely to cause out of memory errors, and then (especially with a few hundred processes running) everything goes to hell.
PvdImportContextMenu.exe - Application Error
Application has generated an exception that could not be handled.
Process ID=0x1cd8 (7384), Thread ID=0x1b50 (6992).
---------------------------
C:\Program Files\Media Center 13\Plugins\PvdImport\\PvdImportContextMenu.exe
Attempt to access invalid address.
---------------------------
PvdImportContextMenu.exe - Application Error
---------------------------
Application has generated an exception that could not be handled.
Process ID=0xc20 (3104), Thread ID=0xcbc (3260).
---------------------------
PvdImportContextMenu.exe - .NET Framework Initialization Error
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll could not be loadedI haven't been able to figure out is how to get the series title to go with each episode.
Select MOVIES1."title"
From MOVIES
Inner Join EPISODES On MOVIES."epid" = EPISODES."epid"
Inner Join MOVIES MOVIES1 On EPISODES."mid" = MOVIES1."mid"
Where MOVIES."mid"=@id
I don't do DVD, so I can only ask a dumb question... What would MC do if you changed the .ifo to .dvd;1 and associated that extension with MC? I expect it would not recognize it as a valid file type. But if by some miracle it does otherwise, then PVD won't object to .dvd;1 being set as a video file type. Otherwise, all I can say is "uh-oh." :-\
Nope, I also tried to set the file name in PVD to end with .dvd;1 but that did not work.
If this is the bug I reported, it shouldn't be stopping you from running PVD and PvdImport simultaneously. If PVD is "stuck" running Firebird Embedded, edit your pvdconfig.ini so the server connection will be used. Mine looks like this:Code: [Select][DataBase]
FileName=rix:C:\Data\PVD\MY MOVIES BETA 5.PVD
Mode=0
RecentFiles=..\..\Data\PVD\Dummy.PVD|rix:C:\Data\PVD\TEST.PVD
Network=1
RecentTypes=0;1;
I'll try with smaller batches of files and see if I can narrow down common elements to reproduce the errors. Maybe fields which are empty in PVD? Has anyone else seen this?
Just an aside... is there (or will there be) any way to simply 'disable' import of a field into MC without actually deleting it from the plugin menu?
This will definitely be a problem. MC handles DVDs quite differently, in that the "Filename" field in MC is more of a instruction of where to find the video files rather than the physical location of the file.
I also would like to have mc and pvd open at once but I can't seem to find pvdconfig.ini...what am I missing?
The configuration file is saved in the application data directory. In XP that's C:\Documents and Settings\%USERNAME%\Application Data\Personal Video Database\. In Vista, I believe it's: C:\Users\%USERNAME%\AppData\Personal Video Database\. If you can't find the application data folder, it's probably because it's hidden.
It seems to be the same problem I encountered—the system is overwhelmed with 500 instances of the program being launched at once.
Strangely enough, I don't get an exception for that many files.
The interprocess communication between the plugin and PvdImportContextMenu.exe is really a pain.
Thanks!...it now asks for a username and password...I did try my windows user password, the default firebird password and I created a user in pvd but none of them worked...any suggestions what it is looking for?
What is asking for a username and password? Could this be a Vista thing—because you are changing a configuration in a protected folder? What happens if you copy the configuration file to the installation directory, and then run PVD with the -portable switch (that forces it to use the configuration file located there)?
Pvd is asking for a username and password when I change the ini to connect to the database using the network method.
Select
USERS."name",
PERMISSIONS."password"
From
USERS Inner Join
PERMISSIONS On USERS."uid" = PERMISSIONS."uid"Did any of you guys test the new coverart functionality and ignore fields of 1.0.5?
2. Coverart > filepath\folder.jpg did not work. I'll try it again tomorrow.
Which value in the filename tag do you see?
o Cover art Functionality
New Ignore field: Selected fields items will not be updated
Fixed by removing plugin skinning: Critical parts of the plugin are not visible in the ThunderStorm or Blue Steel skins.
Known Issues 1.0.6:
o Plugin doesn't handle DVDs (.ifo, .vob, etc.)
Any ideas how to get this working with ripped dvd's? With mc you cant just point pvd to the .ifo file in the VIDEO_TS folder because mc creates its unique filename in the filename field (ie .dvd;1) Actually I would prefer if I could just use .ifo with mc, but I have not seen an option in mc to do just that.Does PVD know how to import dvd (ts, ifo, vob)? I've tried but PVD seems to ignore the folder...
peter
Has anyone tried my suggestion of putting them in a playlist? (I'd try it myself, but I don't do DVD's.)
Does PVD know how to import dvd (ts, ifo, vob)? I've tried but PVD seems to ignore the folder...
Does PVD know how to import dvd (ts, ifo, vob)? I've tried but PVD seems to ignore the folder...
oops, should have been, "what's the value of [Image File]", sorry...
What do you mean by putting them in a playlist, Rick?
I only have 2 DVDs in my MC library - I copy from MC into an excel spreadsheet and import them into MC that way. At least this way both MC and PVD refer to the DVD movie in the same way.
I point PVD to the .ifo file. If you could match it with the pseudo filename in mc then we could make the match.
Also, there must be a reason why the DVD;1 scheme is used—I have no idea what adverse consequences there might be in not complying with it. :-\
ted between pipe symbols "|" in PVD.
But as I wrote above, PVD does't import my .ifo (or whatever) files.
You will end up with something like this for file path in pvd:Thanks, that's just what I needed. I'll see what I can do wrt. special handling of DVDs...
Actually when I use set in the plugin settings to point to the ifo file and then use test it will show the correct sqlresults. The only problem it does not match with mc's filename. Maybe you could try to make it so that if the file has an ifo extension then try a match with mc's ,dvd;1 extension.Yes, something in that direction.
Yes, something in that direction.
What does "I point PVD to the .ifo file" mean? can you import single files? I haven' found that feature yet.
3. The Plugin can be modified to match PVD's IFO's to MC's DVD;1's.Exactly.
Issues:How is it not working? I believe that there is no "rule" in MC on how this relation ship should work for this coverart selection. Currently, I generate the jpg name with the [name] tag of the file. Are you saying MC doesn't display cover art? Is the [image file] tag correct?
Assign coverart isn't working for me - Does the name of the image file have to match that of the video file? I store my coverart in the same folder as the video file, and set the plugin to "InTheSameFolderAsTheFile". There is only one video file and one image file per folder. The name of the image file does not always match the name of the video file (this might be the problem?). One example is
- Video: F:\Film\A Beautiful Mind\A.Beautiful.Mind.2001.DVDRip.x264.AC3.mkv
- Image: F:\Film\A Beautiful Mind\A Beautiful Mind.jpeg
The columns are too narrow to see the column header, so the user might not know what the checkboxes are for...Yes, I still haven't figured out how to fix the tooltip for each column. It's a space saving issue...
The plugin is still updating MC fields in test modeWell, updating the fields is currently part of the test. Maybe some tick box to deselect update?
Suggestions:Could you do me a favor and start a new suggestions thread?
1.0.7
-----
o Fixed: Plugin doesn't handle DVDs (.ifo, .vob, etc.)
o Fixed: folder.jpg for cover art doesn't work properly.
o Fixed: If a movie filename and or path contains a special character like ' or " (umlaut) then the data will not be imported from pvd.
I haven't been able to test DVD handling properly since PVD is acting up on me (I cannot import new files). But the fix in this release handles the notorious .dvd;1 (mc) vs. .ifo (PVD). So if your file is called .ifo in PVD, it should work (?).
Please test for special characters. There are a lot of levels in the plugin where this can go wrong, so I'd apprerciate feedback!
1. Dvd import. I just tried a batch of 50 and 100% success!You're welcome. Thanks for testing!
2. Special characters. Reimported the movies that failed before...all ok now!
3. Folder.jpg also worked!
Big thanks for your hard work! :)
peter
There are a lot of levels in the plugin where this can go wrong, so I'd appreciate feedback!
I haven't been able to test DVD handling properly...
Could you do me a favor and start a new suggestions thread?
How is it not working? I believe that there is no "rule" in MC on how this relation ship should work for this coverart selection. Currently, I generate the jpg name with the [name] tag of the file. Are you saying MC doesn't display cover art? Is the [image file] tag correct?
o Fixed: Plugin doesn't handle DVDs (.ifo, .vob, etc.)
o Fixed: If a movie filename and or path contains a special character like ' or " (umlaut) then the data will not be imported from pvd.
Could you do me a favor and start a new suggestions thread?
2. Data conversion features (e.g., converting dates and ratings so they can be put in MC standard fields).
100 files ~ 30s
This would be nice. How does PVD store date data?
=If(IsEqual(Math(4-IsEmpty([Rating.IMDb],1)-IsEmpty([Rating.Other],1)-IsEmpty([Rating.User],1)-IsEmpty([Rating.AllMovie],1)),0),0, Math(Math(If(IsEmpty([Rating.IMDb]),0,Field(Rating.IMDb)) + If(IsEmpty([Rating.Other]),0,Field(Rating.Other)) + If(IsEmpty([Rating.User]),0,Field(Rating.User)*2) + If(IsEmpty([Rating.AllMovie]),0,Field(Rating.AllMovie))) // Math(5-IsEmpty([Rating.IMDb],1)-IsEmpty([Rating.Other],1)-IsEmpty([Rating.User],1)*2-IsEmpty([Rating.AllMovie],1))*.5+.5))
does having the month and day really make that much difference?
Rick, your super composite rating field scares me. Just a little bit.
No. For the release date, I'm happy with just the year. But there's date acquired, updated (i.e., meta data downloaded), viewed, modified (i.e., PVD record changed). If it's not possible to create a custom date field, I don't think there's any choice but to use strings. It would be nice to be able to put it in the YYYY-MM-DD format, however—to eliminate the need for expressions.
I have to do something while waiting for imports to finish. Besides, it anyone asks, "Why does that get four stars?" I have a geeky answer for them. 8)
I'm sure that you could produce an MC style date where the number of seconds (and fractions) are output from SQL.
[...] Without documentation, I haven't a clue how to create a stored procedure or even how to use format() (which might be useful for a variety of things).
I still don't see much point in this if the only date field available to us in MC is Date. Am I missing something?
Select PEOPLE."name" || '\' || CAREER."role"
From PEOPLE Inner join CAREER on (CAREER."pid" = PEOPLE."pid")
Where CAREER."ctype" = 0 And CAREER."mid" = @idSelect CUSTOM_VALUES_LONGSTR."value"
From MOVIES
Inner join CUSTOM_VALUES_LONGSTR on MOVIES."mid" = CUSTOM_VALUES_LONGSTR."mid"
Inner join CUSTOM_FIELDS_MOVIES on CUSTOM_FIELDS_MOVIES."cmfid" = CUSTOM_VALUES_LONGSTR."cmfid"
Where MOVIES."mid"=@id and CUSTOM_FIELDS_MOVIES."dispname" = 'Review'Code: [Select]Select PEOPLE."name" || '\' || CAREER."role"
From PEOPLE Inner join CAREER on (CAREER."pid" = PEOPLE."pid")
Where CAREER."ctype" = 0 And CAREER."mid" = @id
This one gives you nested panes with actors and roles! So you can expand an actor within a pane in MC and see the different roles they've played underneath :)Code: [Select]Select CUSTOM_VALUES_LONGSTR."value"
From MOVIES
Inner join CUSTOM_VALUES_LONGSTR on MOVIES."mid" = CUSTOM_VALUES_LONGSTR."mid"
Inner join CUSTOM_FIELDS_MOVIES on CUSTOM_FIELDS_MOVIES."cmfid" = CUSTOM_VALUES_LONGSTR."cmfid"
Where MOVIES."mid"=@id and CUSTOM_FIELDS_MOVIES."dispname" = 'Review'
Thanks for that one Rick.
So guys, any chance of a quick rundown on where to start with Firebird Maestro with the PVD database? I don't even know how to get it to read the database!
I have a bunch of custom short text fields I'd like to try out with the plugin...
Raldo, is there anything else specific you'd like us to test out?
I.e. I'm giving up on mass updates via "Send to", hoping that JRiver will expose parts of the menu system to plugins...
aTagger (a plugin no longer in circulation) updated music files by downloading information from AMG and directly updating MC fields. While the first part is obviously different in PVDImport, maybe we can learn something from how it updated the files in MC? The plugin allowed the user to specify a playlist (or playing now) and updated any files in that playlist - all the user had to do was execute the plugin from the actual plugin page (progress & status was shown here too). It worked really well... there was no "Send To" component to it at all...
If you could emulated this, all the user would need to do would be to drag all their movie files into a playlist (or even create a smartlist).
This one gives you nested panes with actors and roles!
I'd use some other client/tool than Maestro. My trial ended yesterday, so I'll find some other free tool. I think there was some discussion on this in the PVD forums.
I'm testing a mass import feature, done from the plugin as you're describing in your post.
1.0.8 feature: Mass import, uses MC expressions. See User manual for details.
Improved: Thread handling when importing many files.
New user here and need some help.
1. Clicking on "Connect to Server" in PVD opens a dialog box requesting a Password and User name. I tried "sysdba" and "masterkey," but these did not work. (I got these from the Firebird Quick users guide.) Since I cannot get beyond this point, I doubt if I am connected. But, I do get this at the bottom of the Pvdimport plugin:
o feature: Mass import, uses MC expressions. See User manual for details.
o feature: Write only empty fields
o Improved: Thread handling when importing many files.
o Feature: Progress bar and current import status text
I haven't had the resource issues Rick mentioned above, but I don't really have a slower machine to test it on either
This seems to be a problem with PVD, but that is as far as my troubleshooting skills can take me.Ok, it seems as if you have managed to get PVD up and running in "embedded Firebird mode".
o Press "set file"
and select one of your video files that you know exists in the PVD database.
o Press "test" (Warning: pressing "Test will update your library too)
o The fields in the "SqlResult" should now be populated by data.
I assume this is the "Set" button, and when I click on it, an "Open" window appears showing my
Movies.PVD database file. When I select the file and click on open, nothing appears to happen.
Should a list of the files in my Movies.PVD appear from which I can select the appropiate file?
The "SqlResults are shown ony when I use the "Send To" method.
the "Year" and "IMDB Rating" fields are not being populated.
Finally, This is a supurb tool and will save me much time. Thanks for all the hours you have
spent in it's development. First, MC, then PVD, and now PVDIMPORT. How can it get any better
The "SqlResults are shown ony when I use the "Send To" method.
1.0.10: Fixed: Test filename would occasionally be truncated so that no data was imported
1.0.9: feature: Mass import Stop Button
feature: Removed Indexing of lists.
Feature: Software User Manual (SUM) is now included in the installation.
Fixed: Tooltip for field configuration headers doesn't show properly. You can deselect tooltips with a checkbox
Fixed: User information (lower window) is not updated properly during import.
But there does seem to be a problem. The plugin makes the server behave as if it has a memory leak. It adds about 2,000 K "Private bytes" as each item is processed, and releases none—not as it is running, or after it has finished. The memory allocated is only released after MC is closed—so it seems clear the plugin is at fault. As it happened, the test batch was not big enough for me to see what might have happened if there were no more memory to be allocated.
I see no change in this behaviour. Any idea what's wrong?
There's no such feature in either PVD or MC. Will users understand what it's for? ;D
Maybe the button should be labelled "Help."
Fixed: Runtime information in lower Listbox. Added some logging information.
Fixed: There is a memory leak in the Firebird server.
Perfect! ...except it reports "Sucess!" when I'm looking for "Success!" ;):)
Suggestions:
- Include a date/time stamp on each entry...
- ...and I wonder if there should be an option for the recording of a date/time stamp in a custom field (e.g., if the user creates, say, a PvdImport.Updated field, the plugin will record it).
- Add results to "log.txt" in PvdImport directory.
The plug seems about ready for prime time. Have you thought about how to "release" it? Or what more we need to do before it's ready? I imagine new users are going to demand help with the SQL statements. Maybe we should work on the default PvdImportFieldConfig.xml so it includes sample (i.e., Ignore="true") queries for each type of custom field, handling of dates and ratings, and various options (e.g., saving actors/roles as a nested field).
I think the best thing to do is, as you suggest, to gather up some examples of fields, and include them in the default config file. Tag those examples as Ignore.
<?xml version="1.0" encoding="utf-8"?>
<Organizer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<!--Version: rick.ca 2009-05-21-->
<!--______________-->
<!--IDENTIFICATION-->
<ConfigItem McField="Name" PvdExpression="Select MOVIES."title" 
From MOVIES 
Where MOVIES."mid"=@id" />
<ConfigItem Ignore="true" McField="Original Title" PvdExpression="Select MOVIES."origtitle" 
From MOVIES 
Where MOVIES."mid"=@id" />
<ConfigItem McField="Year." Type="Integer" PvdExpression="Select MOVIES."year" 
From MOVIES
 Where MOVIES."mid"=@id"></ConfigItem>
<ConfigItem McField="Series" PvdExpression="Select MOVIES1."title"
From MOVIES 
Inner Join EPISODES On MOVIES."epid" = EPISODES."epid" 
Inner Join MOVIES MOVIES1 On EPISODES."mid" = MOVIES1."mid"
Where MOVIES."mid"=@id">
<!--Get series name for episode record-->
</ConfigItem>
<ConfigItem McField="Season" PvdExpression="Select EPISODES."season"
From MOVIES Inner join EPISODES on MOVIES."epid" = EPISODES."epid"
Where MOVIES."mid"=@id">
<!--Replacing SQL that returns index rather than number-->
</ConfigItem>
<ConfigItem McField="Episode" PvdExpression="Select EPISODES."epnum"
From MOVIES Inner join EPISODES on MOVIES."epid" = EPISODES."epid"
Where MOVIES."mid"=@id">
<!--Replacing SQL that returns index rather than number-->
</ConfigItem>
<!--______________-->
<!--CLASSIFICATION-->
<ConfigItem Ignore="true" McField="Type." Type="CUSTOM String/List" PvdExpression="Select CUSTOM_VALUES_SHORTSTR."value"
From MOVIES 
Inner Join CUSTOM_VALUES_SHORTSTR On MOVIES."mid" = CUSTOM_VALUES_SHORTSTR."mid"
Inner Join CUSTOM_FIELDS_MOVIES On CUSTOM_VALUES_SHORTSTR."cmfid" =
 CUSTOM_FIELDS_MOVIES."cmfid"
Where MOVIES."mid" =@id and CUSTOM_FIELDS_MOVIES."dispname" = 'Work type'">
<!--Illustration of custom SHORT TEXT, SELECT or MULTISELECT LIST field (field is referenced by "dispname")-->
</ConfigItem>
<ConfigItem McField="Genre." Type="List" Sep="; " PvdExpression="Select GENRES."value" from GENRES 
Inner join MOVIEGENRES on (GENRES."gid" = "MOVIEGENRES"."gid") 
Where MOVIEGENRES."mid" = @id">
<!--Replacing standard string field with list-->
</ConfigItem>
<ConfigItem Ignore="true" McField="Moods." Type="CUSTOM String/List" Sep="; " PvdExpression="Select CUSTOM_VALUES_SHORTSTR."value"
From MOVIES inner join CUSTOM_VALUES_SHORTSTR On MOVIES."mid" = CUSTOM_VALUES_SHORTSTR."mid" inner join CUSTOM_FIELDS_MOVIES on CUSTOM_VALUES_SHORTSTR."cmfid" = CUSTOM_FIELDS_MOVIES."cmfid"
Where MOVIES."mid" =@id and CUSTOM_FIELDS_MOVIES."dispname" = 'Moods'">
<!--Illustration of custom MULTISELECT LIST field (field is referenced by "dispname")-->
</ConfigItem>
<ConfigItem McField="Keywords" Type="List" Sep="; " PvdExpression="Select TAGS."value" from TAGS 
Inner join MOVIETAGS on (TAGS."tid" = "MOVIETAGS"."tid") 
Where MOVIETAGS."mid" = @id" />
<ConfigItem McField="Country" Type="List" Sep="; " PvdExpression="Select COUNTRIES."value" from COUNTRIES 
Inner join MOVIECOUNTRIES on (COUNTRIES."cid" = "MOVIECOUNTRIES"."cid")
Where MOVIECOUNTRIES."mid" = @id" />
<ConfigItem McField="Studios" Type="List" Sep=";" PvdExpression="Select STUDIOS."value"
From STUDIOS inner join MOVIESTUDIOS on MOVIESTUDIOS."sid" = STUDIOS."sid" inner join
 MOVIES on MOVIES."mid" = MOVIESTUDIOS."mid"
Where MOVIES."mid" =@id" />
<!--_______-->
<!--CREDITS-->
<ConfigItem McField="Producer" Type="List" Sep="; " PvdExpression="Select PEOPLE."name" from PEOPLE 
Inner join CAREER on (PEOPLE."pid" = "CAREER"."pid")
Where CAREER."mid" = @id AND CAREER."ctype" = 4" />
<ConfigItem McField="Screenwriter" Type="List" Sep="; " PvdExpression="Select PEOPLE."name" from PEOPLE 
Inner join CAREER on (PEOPLE."pid" = "CAREER"."pid")
Where CAREER."mid" = @id AND CAREER."ctype" = 2" />
<ConfigItem McField="Director" Type="List" Sep="; " PvdExpression="Select PEOPLE."name" from PEOPLE 
Inner join CAREER on (PEOPLE."pid" = "CAREER"."pid")
Where CAREER."mid" = @id AND CAREER."ctype" = 1" />
<ConfigItem McField="Actors" Type="List" Sep=";" PvdExpression="Select PEOPLE."name" 
From PEOPLE inner join CAREER on (PEOPLE."pid" = "CAREER"."pid")
Where CAREER."mid" = @id and CAREER."ctype" = 0"></ConfigItem>
<ConfigItem Ignore="true" McField="Actors" Type="List" Sep=";" PvdExpression="Select PEOPLE."name" || '\' || CAREER."role"
From PEOPLE Inner join CAREER on (CAREER."pid" = PEOPLE."pid")
Where CAREER."ctype" = 0 And CAREER."mid" = @id">
<!--Use nested list-->
</ConfigItem>
<ConfigItem McField="Composer." Type="List" Sep="; " PvdExpression="Select PEOPLE."name" from PEOPLE 
Inner join CAREER on (PEOPLE."pid" = "CAREER"."pid")
Where CAREER."mid" = @id AND CAREER."ctype" = 3">
<!--Use list field (as for other people) instead of standard string field-->
</ConfigItem>
<!--___________-->
<!--DESCRIPTION-->
<ConfigItem McField="Tag Line" PvdExpression="Select MOVIES."tagline" 
From MOVIES 
Where MOVIES."mid"=@id" />
<ConfigItem McField="Description" PvdExpression="Select MOVIES."description" 
From MOVIES 
Where MOVIES."mid"=@id" />
<ConfigItem Ignore="true" McField="Review." Type="CUSTOM Memo" PvdExpression="Select CUSTOM_VALUES_LONGSTR."value"
From MOVIES
Inner join CUSTOM_VALUES_LONGSTR on MOVIES."mid" = CUSTOM_VALUES_LONGSTR."mid" 
Inner join CUSTOM_FIELDS_MOVIES on CUSTOM_FIELDS_MOVIES."cmfid" = CUSTOM_VALUES_LONGSTR."cmfid"
Where MOVIES."mid"=@id and CUSTOM_FIELDS_MOVIES."dispname" = 'Review'">
<!--Illustration of custom MEMO field-->
</ConfigItem>
<!--______-->
<!--RATING-->
<ConfigItem McField="MPAA Rating" PvdExpression="Select MOVIES."mpaa" 
From MOVIES 
Where MOVIES."mid"=@id" />
<ConfigItem McField="Rating.IMDb" Type="Decimal" PvdExpression="Select MOVIES."imdbrating" 
From MOVIES 
Where MOVIES."mid"=@id">
<!--Use in expression (column or field) to display as rating stars-->
</ConfigItem>
<ConfigItem Ignore="true" McField="Rating.AllMovie" Type="CUSTOM Real number (Decimal)" PvdExpression="Select CUSTOM_VALUES_REAL."value"
From MOVIES 
Inner Join CUSTOM_VALUES_REAL On MOVIES."mid" = CUSTOM_VALUES_REAL."mid" 
Inner Join CUSTOM_FIELDS_MOVIES On CUSTOM_VALUES_REAL."cmfid" = CUSTOM_FIELDS_MOVIES."cmfid"
Where MOVIES."mid" =@id and CUSTOM_FIELDS_MOVIES."dispname" = 'AllMovie rating'">
<!--Illustration of custom rating (and any other custom REAL NUMBER) field-->
</ConfigItem>
<ConfigItem Ignore="true" McField="Rating.Other" Type="Decimal" PvdExpression="Select MOVIES."orating" 
From MOVIES 
Where MOVIES."mid"=@id" />
<ConfigItem Ignore="true" McField="Rating.User" Type="Decimal" PvdExpression="Select MOVIES."rating" 
From MOVIES 
Where MOVIES."mid"=@id" />
<!--__________-->
<!--STATISTICS-->
<ConfigItem Ignore="true" McField="Budget." Type="Integer" PvdExpression="Select MOVIES."budget" 
From MOVIES 
Where MOVIES."mid"=@id" />
<ConfigItem Ignore="true" McField="Box office." Type="Integer" PvdExpression="Select MOVIES."money" 
From MOVIES 
Where MOVIES."mid"=@id" />
<ConfigItem Ignore="true" McField="Viewed." Type="Date string" PvdExpression="Select MOVIES."viewdate" 
From MOVIES 
Where MOVIES."mid"=@id">
<!--Use expression to convert format to YYYY-MM-DD for correct sorting-->
</ConfigItem>
<!--_________________-->
<!--MEDIA INFORMATION-->
<ConfigItem Ignore="true" McField="Duration." Type="CUSTOM Number (Integer)" PvdExpression="Select CUSTOM_VALUES_INT."value"
From MOVIES 
Inner Join CUSTOM_VALUES_INT On MOVIES."mid" = CUSTOM_VALUES_INT."mid" 
Inner Join CUSTOM_FIELDS_MOVIES On CUSTOM_VALUES_INT."cmfid" = CUSTOM_FIELDS_MOVIES."cmfid"
Where MOVIES."mid" =@id and CUSTOM_FIELDS_MOVIES."dispname" = 'OrigDuration'">
<!--Illustration of custom NUMBER field;
Standard field not used because it's formated HH:MM:SS and can't be edited-->
</ConfigItem>
<ConfigItem Ignore="true" McField="MediaInfo.Video" Type="CUSTOM String" PvdExpression="Select VCODECS."value" || ', ' || MOVIES."resolution" || ', ' ||
 MOVIES."videobitrate" || ' Kbps'
From MOVIES inner join VCODECS on VCODECS."vcid" = MOVIES."videocodec"
Where MOVIES."mid"=@id">
<!--Illustration of custom string CONCATENATION-->
</ConfigItem>
<ConfigItem Ignore="true" McField="MediaInfo.Audio" Type="CUSTOM String" PvdExpression="Select ACODECS."value" || ', ' || AUDIO."bitrate" || ' Kbps'
From MOVIES inner join AUDIO On MOVIES."mid" = AUDIO."mid" inner join ACODECS on ACODECS."acid" = AUDIO."acid"
Where MOVIES."mid"=@id"></ConfigItem>
</Organizer>Maybe you and Darichman could cooperate on this?
I included most of the standard fields included in PVD, illustrations of each of the four different types of custom fields, and a few tricks. Note that I always use a "." in my custom field names—to make them distinct from MC standard fields. So "Name" is the MC standard field Name, while "Year." is a custom field.That dot is actually a pretty good idea. It avoids fields being grabbed by MC - also it's easier to see which fields "belong to you".
I changed the default MC user field names so that the "." is in the beginning of the field name, sorry about that, Rick.ca!
o Changed: Several new fields/rows and corresponding sql+description, thanks to Chris.ca
It seems the posted version is still 1.0.11. :(Sometimes, you're really fast :) . You must have downloaded it between me posting on the forum and uploading to the site...
Who is Chris.ca? ;)
Sometimes, you're really fast Smiley . You must have downloaded it between me posting on the forum and uploading to the site...
I know i said "no more features" but the Description field seemed neccessary...
| McField | Description | ||
| .Genre | McField: User (List) | ||
| .Rating IMDb | McField: User (Decimal) | ||
| .Budget | McField: User (Integer) |
I think it's important to avoid the MC default Year field. Unless I've managed to get myself (and/or my MC configuration) confused, this is the display name for the Date (year) field—a calculated field based on the file date modified. So whatever is put in the Year McField will be overwritten by the year according to the date modified file stamp.Yeah, I realized this after I'd uploaded the file.
I've also put together a rather colourful (and sortable) excel document which shows which fields are matched to what.
Select LANGUAGES."value"
From MOVIES inner join LANGUAGES On MOVIES."origlang" = LANGUAGES."lid"
Where MOVIES."mid" =@idJust a heads up, the plugin doesn't work with MC14...
Are you sure Year "is not automatically modified from the file timestamp if you manually put another value in there"? I haven't actually tested it, but my concern is MC may "detect external changes" (or whatever) and update the field based on a new Date Modified.
It may seem unlikely a media file would change, but maybe the effect would be the same even if the file was just moved.
Production Credits consists of HTML links—have you found a way to use this in MC?
How do you use your "Links" fields in MC—particularly URL, which typically contains more than one URL?
How do you use your "Genre / Genre 1 / AMG Genres" fiield?
It's not clear to me what you think should be included in the default field configuration. I believe we need to be careful not to overwhelm the new user (to PVD, as well as the plugin) by including too many queries they are unlikely to use.
Did I read something about a new import facility? If so, will this have any impact on the plugin, or user's perception of it's usefulness?
Select CUSTOM_VALUES_SHORTSTR."value"
From MOVIES inner join CUSTOM_VALUES_SHORTSTR On MOVIES."mid" = CUSTOM_VALUES_SHORTSTR."mid" inner join CUSTOM_FIELDS_MOVIES on CUSTOM_VALUES_SHORTSTR."cmfid" = CUSTOM_FIELDS_MOVIES."cmfid"
Where MOVIES."mid" =@id and CUSTOM_FIELDS_MOVIES."dispname" = 'Moods'
Auto-import etc will not change the [Date] fields once you've put a value in there...
If a file is moved or renamed, MC loses it's connection to the file.
I have detailed my Type and Genre system elsewhere...
I also think it's worthwhile including a second config file in the installation folder with an exhaustive list of fields which users can select from.
EDIT Again: I changed the relevant custom fields to Select List, but I'm still seeing this.
Have I stumbled across a problem here, or am I just missing something obvious?
I think we both got it wrong. :o
You convinced me I should be able to use the standard Year field. But when I tried, I found it could not be overwritten. I think it's just a pseudo field that reflects the year of Date. It could be updated by importing a Date, but we don't have the proper date value. It seems importing is different than manually entering something—that will, as you say, will be stored in the database and not changed by anything else.
Select MOVIES."year"
From MOVIES
Where MOVIES."mid"=@idLet's not forget there's probably still some room for including some optional queries in the default configuration—not for additional fields, but for different ways of handling the information (e.g., the nested Actor\Roles field). I've figured out a way of handling series that works for me, but I realize people are going to want to do that different ways. Maybe we can provide more tools to help make that easier.
Select PEOPLE."name" || '\' || 'Director'
From PEOPLE Inner join CAREER on (CAREER."pid" = PEOPLE."pid")
Where CAREER."ctype" = 1 And CAREER."mid" = @idSelect PEOPLE."name" || '\' || 'Producer'
From PEOPLE Inner join CAREER on (CAREER."pid" = PEOPLE."pid")
Where CAREER."ctype" = 4 And CAREER."mid" = @idA Select List is a field where you select one item from a list—the result is a string. What you want is a Multiselect List—the PVD equivalent of MC's semicolon-delimited list. For example, I save Moods in a Multiselect List and the query works fine—the items are semicolon delimited.
Set McField to: Date (Year) (NOT Year)
is there any way to link the output of the query so we get: [SQL Result A];[SQL Result B] ?
You could do an MC ListCombine of the separate results, but I haven't yet come across a way to combine separate queries into one. That would be less "messy," and would have a more general application—for combining anything that doesn't really need to be in separate fields.
We seem to be on the same page with a lot of things ;) I did consider this - in my experience with the listcombine feature, it can really slow down large views. If we put nesting in the mix as well... We can only try it out I guess.
I wonder if there's another way to get an output of: Directorname\Director;Producername\Producer;Actorname\Role etc etc
Select PEOPLE."name" || '\' || CAREER."ctype" || '\' || CAREER."role"
From PEOPLE inner join CAREER on (CAREER."pid" = PEOPLE."pid") inner join MOVIES on CAREER."mid" = MOVIES."mid"
Where CAREER."mid" =@idGuys, in case you'll worry later, where did the camel's back break, I believe it's my duty to point that that time is _now_, when you started using random inner joins between fields to make the plugin output data in a custom way. :)
What's the conclusion on the Year field?!
If yes, do you guys think a "bloated" config file is ok for initial release?
I do not think mine should be the default configuration. I think we should have a default which contains only the default fields which PVD can grab (ie without any customisation). As you say, exemplary custom field queries could be included at the bottom of the plugin page, ignored by default. This should be the default config file used by PVDImport on a new install.
When you initially import a video, this field is populated by mc based on the filename. I usually clean up this field and I've seen that an import from PVD can sometimes have weird effects. for example, if PVD doesn't reckognize the video, you may get any kind of result back. Then it's hard to figure out which file you're dealing with after an import from PVD.
Also, PVD swaps the location of articles ("The", etc) to the end of the name.
Darichman, did you test those extra amg fields in the attachment of your previous post?
If yes, do you guys think a "bloated" config file is ok for initial release?
I think we should have a default which contains only the default fields which PVD can grab (ie without any customisation). As you say, exemplary custom field queries could be included at the bottom of the plugin page, ignored by default. This should be the default config file used by PVDImport on a new install.
Do you think the MC Name field should be omitted from the config file?
I suppose it could go into a custom Title. field—but not because there is any good reason why Name should be something different than Title. I don't agree with the premise the Title in PVD is likely to be incorrect, while Name in MC is correct. If the title in PVD is not exactly what it should be, it can only be because PVD is not correctly configured or updated—user error. But using a separate field and comparing the two might be a helpful way to detect errors. The method of correcting any error, however, would be to fix it in PVD, and then re-import.
I did suggest maybe putting an expanded (IMDb +AMG) one in the plugin folder as well, as an option if the user requires it... I've attached my updated one below.
We can't expect everyone to know the inns and outs of PVD the first time they use it, can we?
What about resolving it as follows: Put "Ignore" on Name and a warning in the field Description?
I still can't get original language to work
Btw, how does 1.0.12 look, did you guys find any snags
Edit: Oops. Now I see—it only works in a some cases. Back to the drawing board.
Select LANGUAGES."value"
From MOVIES inner join LANGUAGES on MOVIES."origlang" = LANGUAGES."lid"
Where MOVIES."mid" =@idI wonder if there's another way to get an output of: Directorname\Director;Producername\Producer;Actorname\Role etc
Any comments on the field config file?
Select PEOPLE."name" || '\Actor\' || MOVIES."title" || ': ' || CAREER."role"
From MOVIES inner join CAREER on MOVIES."mid" = CAREER."mid" inner join PEOPLE on PEOPLE."pid" = CAREER."pid"
Where CAREER."ctype" = 0 and MOVIES."mid" = @id
Union
Select PEOPLE."name" || '\Director'
From MOVIES inner join CAREER on MOVIES."mid" = CAREER."mid" inner join PEOPLE on PEOPLE."pid" = CAREER."pid"
Where CAREER."ctype" = 1 and MOVIES."mid" = @id
Union
Select PEOPLE."name" || '\Screenwriter'
From MOVIES inner join CAREER on MOVIES."mid" = CAREER."mid" inner join PEOPLE on PEOPLE."pid" = CAREER."pid"
Where CAREER."ctype" = 2 and MOVIES."mid" = @id
Union
Select PEOPLE."name" || '\Composer'
From MOVIES inner join CAREER on MOVIES."mid" = CAREER."mid" inner join PEOPLE on PEOPLE."pid" = CAREER."pid"
Where CAREER."ctype" = 3 and MOVIES."mid" = @id
Union
Select PEOPLE."name" || '\Producer'
From MOVIES inner join CAREER on MOVIES."mid" = CAREER."mid" inner join PEOPLE on PEOPLE."pid" = CAREER."pid"
Where CAREER."ctype" = 4 and MOVIES."mid" = @id
o Feature: New checkbox "Ignore". When selected all fields marked Ignore are displayed, otherwise, none marked ignore are displayed.
o Changed: Updated field configuration to contain Darichman's suggestions too.
| Data Type | PVD Field Type | MC Field Type | |
| SHORTSTR | Short text, Select or Multiselect list | String, List | |
| LONGSTR | Memo | String | |
| INT | Number | Integer | |
| REAL | Real number, Rating | Decimal, Rating |
What about resolving it as follows: Put "Ignore" on Name and a warning in the field Description?
I think the default field configuration should be as follows:
Ok, can we agree on this version of the config file?
I've only did a quick comparison between darichman's proposal and this one, and decided to trust you reflected his changes appropriately.Well, the file seems to converge towards something now anyways :)
Select MOVIES1."title"
From MOVIES inner join EPISODES on MOVIES."epid" = EPISODES."epid" inner join MOVIES MOVIES1 on EPISODES."mid" = MOVIES1."mid"
Where MOVIES."mid"=@idWhat is the expected behaviour for "Series"?
Select MOVIES1."title"
From MOVIES inner join EPISODES on MOVIES."epid" = EPISODES."epid" inner join MOVIES MOVIES1 on EPISODES."mid" = MOVIES1."mid"
Where MOVIES."mid"=@idWhat puzzles me, is this looks the same as the query you've posted.
Can you post a note when you've tested "Series"? I think we can call the package sort of healthy then...
Are we ready to push this out the door?
Rick - I don't use series, so maybe I hadn't set something up right when I was testing it? Who knows. I'll trust your judgement :D
I have also installed 0.9.9.7 and done mass imports + "Send to" . It seems as if this version of PVD works just fine. Another plus is that there is a proper installer associated with the release.
So where do I post the released version? in the "Media Center 13" forum?
This is good enough to ask for donations. ;D
Looking foward to future developments.
It would be nice if JRiver had a currency format option for related fields.There are some formatting options in Firebird SQL.