Making list of all recordings?

[steingra]

Hi all,

I am hoping someone can explain to me how I can get a list of all recordings in my sagetv database. I just want the filename property to be in my exported list. Is there anyway to do this with a script or from Studio?

Files:
\\vader\video4\NFLFootball-ChicagoBearsatStLouisRams-5492147-0.mpg
\\vader\video4\NFLFootball-ChicagoBearsatStLouisRams-5492147-0.mpg
\\vader\video4\NFLFootball-ChicagoBearsatDetroit-12234543-0.mpg
...
\\deathstar1\video1\Someshowname.mpg
\\deathstar1\video1\SomeOtherShowname.mpg
...

If I had a list like that, it will help me in my quest. Im just hoping there is an easy way to make this list without digging into the API's and writing my own code. Maybe someone has already done this before?

Im about to embark on a mission to clean up a lot of problems (due to faulty hard drives or other hardware issues that are plauging my network) and it would be nice if I could just have a list in xls format that I can print off and see where all my files are listed at in sagetv.

I have been reading the FAQ's and such, to start moving files from one recording directory to other directories. I think I am ready to do it. I have installed new larger hard drives in my NasLite server...and now I just would like this list/printout so I can see where they are all at and check them off my list as I go along.

Thanks once again, for any advice.

[naln]

how about using external applications like directory lister? I use it to make a list of stuff on my HD from time to time....but yes-its not automatic...still relatively quick all the same....

[steingra]

Originally Posted by naln

how about using external applications like directory lister? I use it to make a list of stuff on my HD from time to time....but yes-its not automatic...still relatively quick all the same....

Well I need to read the information contained inside sagetv...:-) since I have multiple servers (6 of them) and lots of files all over a bunch of drives.

I wanted to get the information from sagetv and export it from there.

[stanger89]

FilterByBoolMethod(GetMediaFiles(),"IsTVFile") should (if my syntax is correct) return a list of all recordings.

GetFileForSegment(MediaFile,int) will return the file ( filename/path string) for the "int"th segement of each MediaFile returned by the above.

[steingra]

Originally Posted by stanger89

GetFileForSegment(MediaFile,int) will return the file ( filename/path string) for the "int"th segement of each MediaFile returned by the above.

This would be needed if the file was recorded in more than one part? I think all my shows are just one file.

Originally Posted by stanger89

FilterByBoolMethod(GetMediaFiles(),"IsTVFile") should (if my syntax is correct) return a list of all recordings.

Can I run this from within Studio easily? Or do I need to make a program that does it? Sorry I havent experimented with SageTV Studio (yet). A few months ago I started looking at the API's...but I never got any further. Too many work demands lately. Just dont have the extra *ooomph* I need to dig into another technical system. Hoping there is an easy way to implement this little puppy.

Thank you.

[stanger89]

Originally Posted by steingra

This would be needed if the file was recorded in more than one part? I think all my shows are just one file.

Then you'd just specify 0 for the number. GetMediaFiles returns media file objects not filenames, GetFileForSegment returns the filename for each mediafile object.

Can I run this from within Studio easily? Or do I need to make a program that does it? Sorry I havent experimented with SageTV Studio (yet). A few months ago I started looking at the API's...but I never got any further. Too many work demands lately. Just dont have the extra *ooomph* I need to dig into another technical system. Hoping there is an easy way to implement this little puppy.

Thank you.

That's the raw API, it's easiest to run that directly from an STV. Probably create a button, and put that code under it. What's not there is anything to write that list to a file. Actually if you're just experimenting, you can run that from the Execute line option in Studio.

[nyplayer]

steingra ,

If you use the Nielm webbroswer you can create a XMl file with all the recordings then you can use a vbscript or something else to get the file names.
If you use the web browser here is a simple script that will do what you want.
Just change recordingsxml to your path. It will create a recordings.txt in c:\temp

recordingsxml="C:\wget\Movefiles\recordings.xml"

Const ForReading = 1, ForWriting = 2, ForAppending = 8
set fso = CreateObject("Scripting.FileSystemObject")
Set objFSO = CreateObject("Scripting.FileSystemObject")
If objFSO.FolderExists("C:\temp") Then
    Else
    ParentFolder = "C:\" 
set objShell = CreateObject("Shell.Application")
set objFolder = objShell.NameSpace(ParentFolder) 
objFolder.NewFolder "temp"
End If
Set fso = CreateObject("Scripting.FileSystemObject")
Set filesys = CreateObject("Scripting.FileSystemObject")
filesys.CreateTextFile "c:\temp\recordings.txt", true
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.OpenTextFile("c:\temp\recordings.txt", ForAppending,TristateFalse)
Dim Fso      : Set Fso = CreateObject("Scripting.FileSystemObject")
Dim TextFile : TextFile = recordingsxml
Dim StrLine, Ts
  Set Ts = Fso.OpenTextFile(TextFile,ForReading)
   Do Until Ts.AtEndOfStream
    StrLine = Ts.ReadLine
strSearchThis=StrLine
if instr(strSearchThis, "filePath") > 0 then
arr=split(StrLine,"filePath=")
StrLine=arr(0)
dim arr2
arr2=split(arr(1),"startTime")
StrLine=arr2(0)
f.write StrLine
f.Write VbCrLf
    else
end if
Loop
f.close

[steingra]

Originally Posted by nyplayer

steingra ,

If you use the Nielm webbroswer you can create a XMl file with all the recordings then you can use a vbscript or something else to get the file names. If you use the web browser here is a simple script that will do what you want. Just change recordingsxml to your path. It will create a recordings.txt in c:\temp

Yes I have Nielm webserver installed. I dont see any option to create an xml file?? Where do I find that option? I thought I remembered seeing it in the SageTV Web Interface from Nielm's web server...but after taking a closer look, dont see it. hmmmmm