Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Feature Requests Page: 1 2 3 4 5  Previous   Next
Scan hard disk to import movies or tv series from movie digital files located on hard disk
Author Message
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Thanks, I will let you know how it works out!.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,460
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Ok, here is a script that converts your XML to CSV for BulkEdit.

It is expecting to find the data in JRiverXML.txt - I think you can see where to change that.
It then creates a file JriverMovies.CSV - which you will give to BulkEdit

Copy and paste the following into "JRiver2CSV.wsf" or whatever name you want. Then run it by double click on the file. Good luck.

<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>", "")
                outstr = """[filepath]"+tmpstr+"[/filepath]"""
              End If
              If InStr (str, "<Field Name=""Name"">") Then
                tmpstr = Replace(str, "<Field Name=""Name"">", "")
                tmpstr = Replace(tmpstr, "</Field>", "")
                outstr = """"+tmpstr+""""+ ",file,"+outstr
                outf.writeline outstr
                outstr = ""
              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.
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I must be doing something wrong... I copied the file text into notepad and saved it as "JRiver2CSV.wsf", and when I double click on it nothing happens. If it is doing it silently... Where would it save the CSV file?

tia,
Ron
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I got it to load the file... Now when I click in Bulk edit it is loading
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,460
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting ellisr63:
Quote:
I must be doing something wrong... I copied the file text into notepad and saved it as "JRiver2CSV.wsf", and when I double click on it nothing happens. If it is doing it silently... Where would it save the CSV file?

tia,
Ron

C'mon man, did you even read the post? You have to put your XML data into a file called "JRiverXML.txt" - it has to be in the same folder with the .wsf file. It was like the second sentence of my post ...

And I got your PM - remember you are not trying to load the XML with BulkEdit - you are loading the CSV created by the script (if it works).
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Did you see my second post? I reread the instructions and it is working so far. When it is done I will check and see how it came out. I appreciate your taking the time to get this to work for me.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,460
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting ellisr63:
Quote:
I got it to load the file... Now when I click in Bulk edit it is loading

Sounds good - does it load all 300? Remember, you will have only Title, Notes (with filepath in there) and 1 disc  with the Location field filled in with the word "file", so that LoadDVD can play your media.

If you needed any other data from JRiver, you have to tell me so I can update the script, and you can re-run it.

In the future:
- I will add JRiver to the direct XML import of BulkEdit
- I will add automatic UPC matching, so that movie data is downloaded automatically, but I already explained why that is hard to do and will be imperfect, even when done.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
It is still loading... Any idea on how long it should take to load 300?
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
JRiver also put my music videos in the file... Is there a way to have the script only do the ones that are in my HDMovies folder and not the music videos part? If not, no big deal. So far it is at 1% and it is showing over 100 in the collection.  I can see where it is most likely best to run the script at night when everyone is sleeping.

Thanks again for getting this to work!
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,460
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting ellisr63:
Quote:
JRiver also put my music videos in the file... Is there a way to have the script only do the ones that are in my HDMovies folder and not the music videos part? If not, no big deal. So far it is at 1% and it is showing over 100 in the collection.  I can see where it is most likely best to run the script at night when everyone is sleeping.

Thanks again for getting this to work!

Sure, just tell me how to identify which is which. Do I simply check for "HD Movies" in the filename and use only those?

Sorry about the slowness of the import - I think if you click on the progress bar, you can interrupt it if you want. I think it must be past 1%, just the screen didn't refresh yet. I might have some old code that doesn't allow screen refresh during the loop. I'll check and fix that if necessary.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
It is at over 1400 so far, with 15% listed... I will just let it go until it hits the grand total. Strange thing is I didn't think I had more than around 300 music videos either. No big deal.
 Last edited: by ellisr63
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
It is grabbing all my music too... not just my movies, and music videos. That explains why there are so many.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,460
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Seems like we are always cross posting. Can you answer my question about how to recognize just the ones you want? I can fix the script and yu can re-run it in far less time than waiting. Stop it by clicking on the progress bar.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I stopped it.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,460
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting ellisr63:
Quote:
I stopped it.

And for the third time, how do I recognize just the ones you want?
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Unlimited Registrantellisr63
Registered: May 12, 2007
Posts: 29
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
They will only be in the path of "Tower/ My HD Movies". I sent you a download link for the 3 files, as I am not sure which ones you need. 
 Last edited: by ellisr63
    Invelos Forums->DVD Profiler: Desktop Feature Requests Page: 1 2 3 4 5  Previous   Next