Reply to thread

Message

<blockquote data-quote="depassp" data-source="post: 506343" data-attributes="member: 81592">Thanks for the tip on TVRename.&nbsp; It seems to build its own database, though.&nbsp; My problem is some of my media is named pretty badly.&nbsp; I've done a lot of work with string parsing and manually adding it to the db, and it's now in the SQLite db properly.As far as having to re-import my media after it's moved, that shouldn't be necessary if I have a tool that uses the SQLite db directly.Here's an quasi-example:[CODE]DECLARE @v_oldfilename varchar(50), @v_season integer, @v_episode integer, @v_newfilename varchar(50)SELECT @v_oldfilename=EpisodeFilename, @v_season=SeasonIndex, @v_episode=EpisodeIndexFROM local_episodesParse a new filename, move local file from @v_oldfilename to @v_newfilenameUPDATE local_episodesSET EpisodeFilename = @v_newfilenameWHERE EpisodeFilename = @v_oldfilename[/CODE]Come to think of it, I could probably code this up, I just don't like having to re-invent the wheel if there's already a tool out there...</blockquote>

[QUOTE="depassp, post: 506343, member: 81592"] Thanks for the tip on TVRename. It seems to build its own database, though. My problem is some of my media is named pretty badly. I've done a lot of work with string parsing and manually adding it to the db, and it's now in the SQLite db properly. As far as having to re-import my media after it's moved, that shouldn't be necessary if I have a tool that uses the SQLite db directly. Here's an quasi-example: [CODE]DECLARE @v_oldfilename varchar(50), @v_season integer, @v_episode integer, @v_newfilename varchar(50) SELECT @v_oldfilename=EpisodeFilename, @v_season=SeasonIndex, @v_episode=EpisodeIndex FROM local_episodes Parse a new filename, move local file from @v_oldfilename to @v_newfilename UPDATE local_episodes SET EpisodeFilename = @v_newfilename WHERE EpisodeFilename = @v_oldfilename[/CODE] Come to think of it, I could probably code this up, I just don't like having to re-invent the wheel if there's already a tool out there... [/QUOTE]

Verification