Reorganizing local files based on TVSeries QLite db (1 Viewer)

[depassp]

After much work, I finally have all my TV Series imported properly into My TVSeries. As far as I understand, this is stored in a SQLite flat file TVSeriesDatabase4.db3

Is it now possible to re-organize the local filesystem? Ie: move all the files to a specific format, like

<series>\Season <season>\Episode <episode>.<ext>

or similar?

Is there another tool I can use to do this?

 

[marvenius]

You could do a search for TVRename (or similar). Connects to thetvdb.com for info and standard supported naming scheme of MP-TVSeries.

 

[ltfearme]

Just so you know renaming all your files will mean all your files will need to be re-imported.

 

[depassp]

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:

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

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...

 

[dqv69]

I had also ask the question before, but I had the same answer.
https://forum.team-mediaportal.com/my-tvseries-162/rename-episode-imported-68835/
If there's more people interesting by this feature, I can make a little application that can do this thing.
I prefer an external application because I think this feature may be useful for the MovingPicture plug-in also.