File Renaming Utility: AddEpisode

[Pioneer4x4]

(moved from the community announcements thread)



This sounds easy enough. give me a few days, and ill work on it. Thanks for the suggestion.

THANKS!! It is less of a need for me since I have been getting my feed wet in SQL, but it will be nice.
While I'm being a pain, what I REALLY would like is to add the last 2-4 digits (perhaps an optional flag for length...) of the unique_identifier to the beginning of the filename.

[turkey]

what I REALLY would like is to add the last 2-4 digits (perhaps an optional flag for length...) of the unique_identifier to the beginning of the filename.

so, before i release an update with this function, i want to make sure it will do what people want it to do. Looking at the unique_identifier, i found that there are four prefixes that indicate sports, movies, episodes, and shows. Only the episodes have unique identifiers based on the specific episode. With all other prefixes, the unique_identifier only refers to the show, and the last four digits are "0000". So I have addepisode only return a unique identifier if it has an "ep" prefix. There will be two settings: return the last four digits, and return the last two digits.

Hopefully, those that will use this feature can understand my explanation, and tell me if this feature will work for you as I have described it.

[willyperkins]

has the new version run succesfully at all?

this error indicates that you did not call addepisode correctly. the correct format is:

addepisode %1 "{format tokens}"

All of the formatting tokens can be found in the help file, or on the wiki. This is the line that I have in my postprocessing.bat file:

addepisode %1 "{show}{[ - ]}{episode}"

if you think you have called addepisode correctly, post the line you have added to the postprocessing.bat file, as it may be a bug.

Yes, you are right, I didn't know I had to make that change for the new version... Works fine now, thank-you...

[Pioneer4x4]

so, before i release an update with this function, i want to make sure it will do what people want it to do. Looking at the unique_identifier, i found that there are four prefixes that indicate sports, movies, episodes, and shows. Only the episodes have unique identifiers based on the specific episode. With all other prefixes, the unique_identifier only refers to the show, and the last four digits are "0000". So I have addepisode only return a unique identifier if it has an "ep" prefix. There will be two settings: return the last four digits, and return the last two digits.

Hopefully, those that will use this feature can understand my explanation, and tell me if this feature will work for you as I have described it.

I definately seem to be one of the only people doing this, but that is exactly what I was wanting. I have been able to use SQL code to do the same thing to the db before the show records, and your util will rename fine.
basically, don't change it just for me, even though I would appreciate it

[Mr. Seldon]

Hi there,

nice tool, just what i needed. In my case it renames the recordings (and all the files comskip creates) properly but it kicks them out of the sqlite database... The reording and renaming is done, but the show is not available in GBPVR.

My postprocessing.bat:

addepisode %1 "{show}{[ - ]}{season and episode}{[ - ]}{day}{[-]}{month}{[-]}{year}"

I`m using comskip in the recent version, it runs during the recording. Whats my mistake?

[turkey]

Whats my mistake?

Have a look at the log file for addepisode. It is a text file in the gbpvr directory called addepsiode. If there are any sqlite errors, post them for me to see.

[Mr. Seldon]

checked that log. no errors. just two (old, from yesterday morning) entries.

E:\Video\Aufnahmen\Zeit im Bild\Zeit im Bild_20060912_09000905 Renamed to E:\Video\Aufnahmen\Zeit im Bild\Zeit im Bild - Nachrichten 5-388-386 at 09:09 09/12/2006
E:\Video\Aufnahmen\SpongeBob Schwammkopf\SpongeBob Schwammkopf_20060912_09301000 Renamed to E:\Video\Aufnahmen\SpongeBob Schwammkopf\SpongeBob Schwammkopf - 12 - 09 - 2006 at 10:02 09/12/2006

no sign of the recordings i did afterwards.

[turkey]

Well, I dont have much to go on, but you can try a few things. Try restarting the gbpvr recording service. If the database is locked up, this should unlock it. Also, you may want to put a delay in your postprocessing.bat file. I accomplish this by adding this line before the addepisode line:

sleep 60

I am not sure if sleep.exe come with windows, or if i downloaded it, but it will just pause the batch file for the number of seconds you call it for. The reason I do this is to cut down on concurrent access of the database. I am not sure that this is your problem, but it may be worth trying.

[ww4397]

A new version of addepisode has been released

Just wondering if the Manual Recording error bug is fixed in the update before I install it?

Thanks.

[Pioneer4x4]

I definately seem to be one of the only people doing this, but that is exactly what I was wanting. I have been able to use SQL code to do the same thing to the db before the show records, and your util will rename fine.
basically, don't change it just for me, even though I would appreciate it

I think I have everything working the way "I" like.

I have this in my "PostUpdateEPG.bat"
sqlite3 gbpvr.db3 <testupdate.sql


And this is the contents of "testupdate.sql"

UPDATE PROGRAMME
SET sub_title=SUBSTR(unique_identifier,-4,4)||' - '||sub_title WHERE (SUBSTR(sub_title,1,1)>"9" OR sub_title='') AND unique_identifier <"F";

What it does is:
changes the sub_title (episode name) field to start with the last 4 digits of the unique_identifier only if it is an "Episode" not "Show" or "Movie" or "Sports" and only if it doesn't already start with a number.

Then Turkey's File Renaming Utility: AddEpisode will rename the .mpg to filename with sortable episode number and name.