Author |
Message |
Registered: May 12, 2007 | Posts: 29 |
| Posted: | | | | Any sub directory from this path is what I am looking for... <Field Name="Filename">\\TOWER\MY HD Movies\" |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting ellisr63: Quote: Any sub directory from this path is what I am looking for... <Field Name="Filename">\\TOWER\MY HD Movies\" Ok, great: Here is the script I had already modified in anticipation of that answer: <job id="JRiver2CSV.wsf"> <script language="VBScript"> Dim filename If WScript.Arguments.Unnamed.Count > 0 Then filename = WScript.Arguments.Unnamed.Item(0) Else filename = "JRiverXML.txt" End If Dim infso, outfso, inf, outf, str, outstr, tmpstr Const ForReading = 1 Const ForWriting = 2 Set infso = CreateObject("Scripting.FileSystemObject") Set outfso = CreateObject("Scripting.FileSystemObject") If infso.FileExists(filename) Then Set inf = infso.OpenTextFile(filename, ForReading) Set outf = outfso.CreateTextFile("JRiverMovies.CSV", True) outf.writeline """title"",""location"",""notes""" outstr = "" Do While Not inf.AtEndOfStream str = inf.ReadLine If InStr (str,"<Field Name=""Filename"">") Then tmpstr = Replace(str, "<Field Name=""Filename"">", "") tmpstr = Replace(tmpstr, "</Field>", "") If InStr (tmpstr,"HD Movies")Then outstr = """[filepath]"+tmpstr+"[/filepath]""" Else outstr = "" End If End If If InStr (str, "<Field Name=""Name"">") Then If outstr <> "" Then tmpstr = Replace(str, "<Field Name=""Name"">", "") tmpstr = Replace(tmpstr, "</Field>", "") outstr = """"+tmpstr+""""+ ",file,"+outstr outf.writeline outstr outstr = "" End If End If Loop inf.Close outf.Close End If </script> </job> | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | I ran the new script on the file you sent me, and got 337 entries. I hope that sounds about (or better, exactly) right.
By the way, did you try the LoadDVD part - playing the media? | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
|
Registered: May 12, 2007 | Posts: 29 |
| Posted: | | | | 337 is the same as I got... I wonder if I have added more movies since the JRiver file was made. I will have to check in JRiver and make a new XML file and rerun the script. I haven't tried the Load DVD part. I will try it too. |
|
Registered: May 12, 2007 | Posts: 29 |
| Posted: | | | | How do I setup LoadDVD to the path of the movies? When I open LoadDVD all I see is changer info which I no longer have. |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting ellisr63: Quote: How do I setup LoadDVD to the path of the movies? When I open LoadDVD all I see is changer info which I no longer have. I don't mean to be rude, but you do have the habit of making me repeat stuff that I already posted - sometimes more than once. Here is where I described that and asked that you try the sample file I provided - I thought you had done that. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
|
Registered: May 12, 2007 | Posts: 29 |
| Posted: | | | | I appreciate all your help to get this working... I am retired and sometimes I miss the simple little details.
When I select play it opens up XBMC and plays the movie, even though there is no path listed in the notes area. Is this the way it should be? |
|
Registered: May 12, 2007 | Posts: 29 |
| Posted: | | | | "Now, to get all the cover art, and all the movie data, you will need to "Change UPC" manually and the data will be downloaded from the Invelos web site. Alternatively, you can figure it out ahead of time and add the field "Profile ID" into the CSV and put the Invelos ID there, or you could use "UPC" and put any valid UPC for a DVD that has the correct movie info for you. So, you either do the work up front and bulk load, or do a simple bulk load and update the UPCs later as you have time- your choice."
Is there any way to retrieve more info from the JRiver feed without manually inputting the UPC code for each movie? I know that all the info other than the UPC code is there allready.
tia, Ron |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting ellisr63: Quote: "Now, to get all the cover art, and all the movie data, you will need to "Change UPC" manually and the data will be downloaded from the Invelos web site. Alternatively, you can figure it out ahead of time and add the field "Profile ID" into the CSV and put the Invelos ID there, or you could use "UPC" and put any valid UPC for a DVD that has the correct movie info for you. So, you either do the work up front and bulk load, or do a simple bulk load and update the UPCs later as you have time- your choice."
Is there any way to retrieve more info from the JRiver feed without manually inputting the UPC code for each movie? I know that all the info other than the UPC code is there allready.
tia, Ron Seems like we are going in circles. You can learn VBScript and modify my script if you like. I think I have done what I promised. Good luck. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. |
|
Registered: May 12, 2007 | Posts: 29 |
| Posted: | | | | You have done what you promised... What I was wondering if it is possible to copy a few lines and change the info to add more to be scraped out of the JRiver file.
tia, Ron |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting ellisr63: Quote: You have done what you promised... What I was wondering if it is possible to copy a few lines and change the info to add more to be scraped out of the JRiver file.
tia, Ron Well of course it is. I even asked you maybe three times what other data you wanted - personal data - there is no need to scrape movie data, as that will come from Invelos. You never told me. Now you "want it all" - doesn't make sense. And you mentioned before that when you clicked the play icon, the media played. That means the Location and Notes were set up properly. I do not believe you that Notes was blank. I am talking about the official Notes field in the Personal Info section (your screen shot does not include the Notes field - it was hidden - you can see the hidden Notes tab in the upper pane in your screen shot) Again, best of luck to you. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
|
Registered: May 12, 2007 | Posts: 29 |
| Posted: | | | | Thanks for the help... I was more concerned at the time with even getting it to work at all, and figured it would be better to get it working with just a few fields first before trying to get all the info from JRiver. Thanks again for your assistance. |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Quoting ellisr63: Quote: Thanks for the help... I was more concerned at the time with even getting it to work at all, and figured it would be better to get it working with just a few fields first before trying to get all the info from JRiver.
Thanks again for your assistance. Not true. We agreed you didn't need that data because it would come from Invelos. You are trying to avoid the work of putting in the UPCs, and you can't - at least, not with current methods. I estimate you could have done up to 50 in the amount of time and energy we have been spinning on how to avoid it. And, you're welcome. I appreciate the number of times you have said "thanks." I would also appreciate confirmation - when you find the actual Personal Information Notes field - that in fact has the LoadDVD filepath in there. Otherwise, I fail to understand why XMBC was launched when you clicked the LoadDVD disc icon. | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | Oh, and I like that other way you said thanks. A new VIP customer! | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | @ellisr63: Here is a little goodie that may or may not be of help: (1) Create a new HTML Section, "Browser" (View > HTML Windows > Edit) (2) After the <Body> tag, paste the following: <SCRIPT language=javascript> window.onload = window_onload; function window_onload() { var title = '<DP NAME="TITLE">' window.location.href ="https://www.google.com/#q=" +title+" dvd upc" } </SCRIPT> (3) Click OK (4) Now back in DVDP, View HTML Windows > Browser (5) You can dock the floating browser window onto the DVDP surface (6) As you have discovered by then, the browser window will pop up whenever you select a new DVD and automatically do a Google search of the DVD title with "DVD UPC" appended. Then you just copy any UPC and paste it into Change UPC I'm not sure it is actually any faster than what you are doing. Based on your PM, you are probably 70% done by now. Good job! (This is probably the method that BulkEdit will do "under the covers" someday. And I got the idea from working with you. ) (Edit: made a change to the HTML window script so the annoying popup does not happen. Stays in the docked window for easy copy / paste) | | | Thanks for your support. Free Plugins available here. Advanced plugins available here. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
|
Registered: May 12, 2007 | Posts: 29 |
| Posted: | | | | One little problem... It appears that when I export the xml file from DVDprofiler it is not exporting the location of the movie that is in the notes box. How do I get it to include it?
Disregard I found it. | | | Last edited: by ellisr63 |
|