Rename Recording

[David]

Sure, I can do this. Do you just want it to rename to the show name, or do you want anything else added on like the date or time? While I'm asking, is there any other function that anyone wants that I should add to this utility?

Actually, I need the "Episode Name" only, which was the default of renamerecording. Renamerecording added the -t parameter to get "show name_episode name", like your utility does. I'd be happy with a single -e to get episode only.

If you could make the command line switch accept a format string, then you would probably satisfy a lot of people at once, but I am sure this would be a bit of programming work up front. Maybe something like:

addepisode.exe -f sn_ep_ddmm %1

Where:
sn = showname
ep = episodename
dd = two digit day of recording
mm = two digit month of recording

[turkey]

I have uploaded the newest version of addepisode.exe to this post.

I have added in the ability to rename to only the episode name if it exists. Also, I have added a switch to keep a log file of each file renamed, as well as some of the sqlite errors if they come up. Also, I have cleaned up the code a bit. See this post for the command line switches and format.

[b00sfuk]

New version working well but had a problem tonight with it failing to update the database. I.e. I had a correctly renamed file in the recording directory but the programme had disappeared from the database. Also had this in the log, can only think it had something to do with the episode name having a quote in it:

[SIZE="2"][SIZE="1"]$iRval<> $SQLITE_OK , $sOutput=
Incomplete SQL: UPDATE RECORDING_SCHEDULE SET filename= 'E:\CAPTURE-DIRECTORY\Supernatural - Devil's Trap.mpg' WHERE ROWID= 5;
commit;
E:\CAPTURE-DIRECTORY\Supernatural_20060618_21002200 Renamed to E:\CAPTURE-DIRECTORY\Supernatural - Devil's Trap at 22:01 06/18/2006[/SIZE][/SIZE]

Cheers

[turkey]

it had something to do with the episode name having a quote in it:

You are correct, thanks for finding this problem. I have added two things to the utility that will help in this and similar situations. First, I have made it so apostrophes (') are stripped from the episode name. I am fairly sure that GBPVR strips them from the regular file names, so I think this is an acceptable option.

Also, I have added in a check to see if the database has been updated correctly before renaming the file. Now the utility checks to make sure both the file can be renamed properly, and the database can be updated properly.

Hope everything works well for a while, as I will be away from my computer for a few days. Keep posting any problems you are having, and I'll fix them when I get back.

Get the new version here.

[a_dee]

Just hit this problem when recording an episode containing ? in the file name. See the log below:

RenameRecording v1.1 build20051223
Title: CSI Crime Scene Investigation
Argument: -t D:\My Videos\Recordings\CSI Crime Scene Investigation\CSI Crime Scene Investigation_20060702_16001700.mpg
Episode name: CSI Crime Scene Investigation - Paper or Plastic?
Episode Oid: 194
System.ApplicationException: Error renaming program 'D:\My Videos\Recordings\CSI Crime Scene Investigation\CSI Crime Scene Investigation_20060702_16001700.mpg' to 'CSI Crime Scene Investigation - Paper or Plastic?' (oid 194) ---> System.ArgumentException: Illegal characters in path.
at System.Security.Permissions.FileIOPermission.HasIllegalCharacters(String[] str)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath)
at System.IO.FileInfo..ctor(String fileName)
at RenameRecording.RenameRecordingClass.RenameRecording(String sEpisodeName, Int32 iEpisodeOid)
--- End of inner exception stack trace ---
at RenameRecording.RenameRecordingClass.RenameRecording(String sEpisodeName, Int32 iEpisodeOid)
at RenameRecording.RenameRecordingClass.RenameRecordingTitle(String sEpisodeName, Int32 iEpisodeOid)
at RenameRecording.RenameRecordingClass.DoMain()
System.ArgumentException: Illegal characters in path.
at System.Security.Permissions.FileIOPermission.HasIllegalCharacters(String[] str)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath)
at System.IO.FileInfo..ctor(String fileName)
at RenameRecording.RenameRecordingClass.RenameRecording(String sEpisodeName, Int32 iEpisodeOid)

[zehd]

Hi.... Is there any information available in the zap2it xml, or even the extended data, that indicates the season number and episode number of a tv show?

A lot of rips have filenames like: lost.s02e04.avi

I just wondered if someone knew before I started trying myself...

[turkey]

Hi.... Is there any information available in the zap2it xml, or even the extended data, that indicates the season number and episode number of a tv show?

This information is not available from zap2it.

[zehd]

Hah I think I might have to parse epguides.com

[turkey]

Hah I think I might have to parse epguides.com

That's the way to do it. I do a similar thing on my gbpvr system, but I have been reluctant to release it to the public because I am not quite sure about the how the owners of the television information websites like epguides.com would react. However, if you would like to use my utility "addepisode" to rename the file once you have the data on your computer, I would be happy to give you a version that has the ability to add in the episode and season numbers. Let me know if your interested, and i'll give more details.

[Jim_]

Hah I think I might have to parse epguides.com

Actually Zap2It sends an onscreen episode-number field that contains that information. Some shows (like the example below) give the season “8” and episode number “06” but others just give the episode number.
<episode-num system="onscreen">806</episode-num>

TVGuide Supercharger adds the EP number to the beginning of the subtitle, so RemaneRecording uses it in the filename by default.
If a subtitle doesn’t exist, the Original-Air-Date is also added to the subtitle so the filename ends up looking like this.
Fear Factor - 305 - (2002-10-14).mpg

I have a feeling we're all thinking along parallel lines.
Using the actual EPG entry, it would be possible to define the filename based on all the Zap2It information sent, not just the fields saved in the GBPVR database. Or save a txt file with extended information like cast and crew.