[addon] BTV Command Line Tools

[queler]

Originally Posted by Kilrsat

"Contains a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (UTC)."

So that sounds like it's FILETIME. I'm a little unclear how to get it into that struct defined there, to use any tools to manipulate it. I tried using these tools here but I wasn't able to either get or set any filetime's that made sense. For example, I was able to see what a particular time field was with btvshowinfo, but converting that into a filetime didn't get me the value that was in the xml file.

I really just want to be able to set the sortabletime field with the command line tools, is there a way to read or write these XML files with date/time values other than the jumble of integers?

[queler]

OK I answered my own question kinda. i really haven't programmed in a while. For anyone else trying to do this. You have to convert the filetime string into hex, and divide the hex in to two 32 bit strings, then convert each hex string to longs in order to populate the two words.

[queler]

Here's the VBA/VB6 solution, maybe it will be helpful to others. It uses date functions found here, hex functions here, and longtounsigned here.

Function date2ft(d As Date) As String
    Dim ft As FileTime
    Dim hHex As String
    Dim lhex As String
    
    Call SerialTimeToFileTime(d, ft)
    hHex = DecToHex(LongToUnsigned(ft.dwHighDateTime))
    lhex = DecToHex(LongToUnsigned(ft.dwLowDateTime))
    Do Until Len(hHex) >= 8
         hHex = "0" & hHex
    Loop
    Do Until Len(lhex) >= 8
        lhex = "0" & lhex
    Loop
    'now both high and low hexes are 8 chars=32 bit
    date2ft = Application.WorksheetFunction.Text(HexToDec(hHex & lhex), "0")
End Function

[bobbo]

Here's a much simpler date/time conversion using VBScript (and no external functions):

'adjusted for EST, change -4 to +2 for GMT
dateResult = DateAdd("h", intTargetStart/36000000000 + 2, "1/1/1601")
strDate = Year(dateResult) & "-" & Month(dateResult) & "-" & Day(dateResult)
strTime = FormatDateTime(dateResult,3)

Example:
intTargetStart = 128963268000000000
strDate = "2009-09-08"
strTime = "09:00:00 PM"

[leecole]

I am attempting to add mp4 support to EpisodeData.exe.
I get this error:
System.Web.Services.Protocols.SoapException:
Server was unable to process request. ---> System.NullReferenceException:
Object reference not set to an instance of an object.
at SnapStream.BeyondTV.WebServices.BTVLibrary.GetMedi aByFullName(String authTicket, String fullName)
--- End of inner exception stack trace ---

Here is what the xml looks like:
<?xml version="1.0" encoding="utf-8"?>
<episode-properties>
<property name="Recommendation">False</property>
<property name="Duration">5600000000</property>
<property name="FileFormat">H.264/MPEG-4</property>
<property name="StationCallsign">WNCN</property>
<property name="EpisodeDescription">[Edited] Actor Robert Pattinson (``The Twilight Saga: New Moon'').</property>
<property name="Title">The Ellen DeGeneres Show</property>
<property name="UniqueChannelID">000000000000007000000012010 </property>
<property name="TargetStart">129032208000000000</property>
<property name="EPGID">EP5992701093</property>
<property name="EpisodeTitle">#1093 </property>
<property name="Description"></property>
<property name="InProgress">False</property>
<property name="UserID"></property>
<property name="OriginalAirDate">20091120</property>
<property name="DisplayTitle">The Ellen DeGeneres Show</property>
<property name="Length">524832798</property>
<property name="DVDReady">True</property>
<property name="MovieYear"></property>
<property name="Channel">7</property>
<property name="Editable">TRUE</property>
<property name="TZBias">300</property>
<property name="Actors">Robert Pattinson</property>
<property name="TargetDuration">36000000000</property>
<property name="ActualStart">129032233669531250</property>
<property name="Rating"></property>
<property name="Genre">Talk</property>
<property name="FullName">G:\Movies and TV\TV\the ellen degeneres show-2009-11-20-0_cut.mp4</property>
<property name="ReadOnly">False</property>
<property name="Managed">False</property>
<property name="Name">G:\Movies and TV\TV\the ellen degeneres show-2009-11-20-0_cut.mp4</property>
<property name="Folder">BTV</property>
<property name="LastWriteTime">129032253828125000</property>
<property name="LastExistsTime">129038073389062500</property>
<property name="Added">129032233676406250</property>
<property name="AddedBias">300</property>
<property name="TSIndexFilename">H:\BTV\ts0.index.dat</property>
<property name="ParentGUID">746e40fd-39d9-4b11-83d9-94c12a1639d4</property>
<property name="SrtExists">False</property>
<property name="DisplayText">The Ellen DeGeneres Show</property>
<property name="SortableName">the ellen degeneres show</property>
<property name="SortableTime">129032053669531250</property>
<property name="Watched"></property>
<property name="LastPosition"></property>
</episode-properties>

Can you tell me what I am doing wrong?
It appears to me that BeyondTV is in fact updating it's library, but EpisodeData thinks the operation failed because of the error that gets logged.


I may have figured this out myself:
I had the new fields
Folder
TSIndexFilename
wrong. I needed to update them.

[psionic]

Originally Posted by leecole

I am attempting to add mp4 support to EpisodeData.exe.
I get this error:
System.Web.Services.Protocols.SoapException:
Server was unable to process request. ---> System.NullReferenceException:
Object reference not set to an instance of an object.
at SnapStream.BeyondTV.WebServices.BTVLibrary.GetMedi aByFullName(String authTicket, String fullName)
--- End of inner exception stack trace ---

Here is what the xml looks like:
<?xml version="1.0" encoding="utf-8"?>
<episode-properties>
<property name="Recommendation">False</property>
<property name="Duration">5600000000</property>
<property name="FileFormat">H.264/MPEG-4</property>
<property name="StationCallsign">WNCN</property>
<property name="EpisodeDescription">[Edited] Actor Robert Pattinson (``The Twilight Saga: New Moon'').</property>
<property name="Title">The Ellen DeGeneres Show</property>
<property name="UniqueChannelID">000000000000007000000012010 </property>
<property name="TargetStart">129032208000000000</property>
<property name="EPGID">EP5992701093</property>
<property name="EpisodeTitle">#1093 </property>
<property name="Description"></property>
<property name="InProgress">False</property>
<property name="UserID"></property>
<property name="OriginalAirDate">20091120</property>
<property name="DisplayTitle">The Ellen DeGeneres Show</property>
<property name="Length">524832798</property>
<property name="DVDReady">True</property>
<property name="MovieYear"></property>
<property name="Channel">7</property>
<property name="Editable">TRUE</property>
<property name="TZBias">300</property>
<property name="Actors">Robert Pattinson</property>
<property name="TargetDuration">36000000000</property>
<property name="ActualStart">129032233669531250</property>
<property name="Rating"></property>
<property name="Genre">Talk</property>
<property name="FullName">G:\Movies and TV\TV\the ellen degeneres show-2009-11-20-0_cut.mp4</property>
<property name="ReadOnly">False</property>
<property name="Managed">False</property>
<property name="Name">G:\Movies and TV\TV\the ellen degeneres show-2009-11-20-0_cut.mp4</property>
<property name="Folder">BTV</property>
<property name="LastWriteTime">129032253828125000</property>
<property name="LastExistsTime">129038073389062500</property>
<property name="Added">129032233676406250</property>
<property name="AddedBias">300</property>
<property name="TSIndexFilename">H:\BTV\ts0.index.dat</property>
<property name="ParentGUID">746e40fd-39d9-4b11-83d9-94c12a1639d4</property>
<property name="SrtExists">False</property>
<property name="DisplayText">The Ellen DeGeneres Show</property>
<property name="SortableName">the ellen degeneres show</property>
<property name="SortableTime">129032053669531250</property>
<property name="Watched"></property>
<property name="LastPosition"></property>
</episode-properties>

Can you tell me what I am doing wrong?
It appears to me that BeyondTV is in fact updating it's library, but EpisodeData thinks the operation failed because of the error that gets logged.


I may have figured this out myself:
I had the new fields
Folder
TSIndexFilename
wrong. I needed to update them.

Lee,

It usually throws this error when it asks BTV to lookup the metadata by filename. It doesn't give me much opportunity to tell whether the metadata wasn't found because the record is locked, or it simply can't find the show. BTV does some sort of locking just after a show completes recording and if the Library service is updating the metadata. I don't see a way to (1) detect a lock and (2) wait until the lock is finished (it could lead to a race condition). Because of these issues, I've taken the approach of fail early and retry.

I double checked my code and I'm not doing anything to require or expect .mpg or .tp file extensions. Any new fields in the metadata should be passed through during export and passed back to BTV during import. There's only a few fields that I rely on (Name is one of them).

[leecole]

Originally Posted by psionic

Lee,

It usually throws this error when it asks BTV to lookup the metadata by filename. It doesn't give me much opportunity to tell whether the metadata wasn't found because the record is locked, or it simply can't find the show. BTV does some sort of locking just after a show completes recording and if the Library service is updating the metadata. I don't see a way to (1) detect a lock and (2) wait until the lock is finished (it could lead to a race condition). Because of these issues, I've taken the approach of fail early and retry.

I double checked my code and I'm not doing anything to require or expect .mpg or .tp file extensions. Any new fields in the metadata should be passed through during export and passed back to BTV during import. There's only a few fields that I rely on (Name is one of them).

I have double checked it. The problem I had was because, in the last BTV release, BTV has added two new fields to their MetaData. Both fields are related to the file path. One is Folder, which now holds the Beyond TV folder name, and the other, is TSIndexFilename which is the hard drive and path to the folder.
I hadn't noticed that these fields existed, so I wasn't changing them when I moved a recording to another folder. This was causing the Error. I have fixed these problems in the latest version of EpisodeData.exe.

[tscales]

I'm getting the error on getbyfilename. 4.9.2 on local machine.

Perhaps I'm downloading the wrong version of the tools? Which link is right?

[tscales]

Never mind. File name has to be fully qualified

[The_Keymaker]

I have BTV v 4.9.2 and Metadataextractor works for me when I use local filepaths like, "K:\PVR Recordings\recordingName.mpg" but NOT when I use UNC file paths like "\\Dataserver\PVR Recordings\recordingName.mpg"

Has anyone else had this problem?

Regards

[jeff_dwork]

Where can I find the most recent version of the tools? The only files I see to download are from 4/4/2008.

Thanks,
jeff

[tracytax5]

I have been using BTVMetaData on new recordings with Beyond TV 4.8. Everything gets filled in when importing except the Episode Description.

Is anyone else having this problem?

[tracytax5]

also this I checked the XML file created and noticed that the EpisodeDescription field is blank. However, the Description field has what appears to be the Episode Description.

[tracytax5]

I double checked my code and I'm not doing anything to require or expect .mpg or .tp file extensions. Any new fields in the metadata should be passed through during export and passed back to BTV during import. There's only a few fields that I rely on (Name is one of them).

[empty1969]

I have been having an issue when the metadata contains non standard letters. I have extracted the xml file from a movie and one of the actors name is Clémence Poésy. After importing back into another file the name gets converted to Clémence Poésy. I can add this character into a filed through the web interface, but I do not have access to all the fields.

Thanks

Empty