[mythtv-users] mythvideo file ordering weirdness

Karl Buckland karl at digital-end.com
Tue Apr 24 15:14:05 UTC 2007

ryan patterson wrote:
  > I think it is clear that I am not using MythVideo the way it is 
> to be used.  But I have absolutely no desire to edit meta data.  I edit 
> the file name and the directory structure to tell me everything I need 
> to know.  I simply want a menu system in MythFrontend that can navigate 
> the directory structure and allow me to pick from the files I place in 
> the directories.  In order to do that I need to see the complete file 
> name.  Yes the complete file name includes stuff in brackets/braces and 
> the file extension.  Even if some people want MythVideo to automatically 
> guess titles from file names I can't imagine throwing away the removed 
> information is a good idea.
> I'm not trying to say the current design is wrong or bad.  Just it 
> doesn't fit my usage method.  Also I don't know what the majority of 
> users would prefer.  I will see if I can figure out how to change this 
> behavior myself.

I too expected behaviour like this. The current MythVideo behaviour is 
far more advanced than I need. I recently moved from using 'Mediaportal' 
on Windows which simply browses the directories and so I was a little 
surprised that the MythTV equivalent was so much more complicated/powerful.
I also expected MythVideo to generate thumbnails from the videos 
themselves. If Nautilus on Gnome can do it, why can't MythTV?
But it's easy to forget that this is all written by volunteers in their 
free time. I wish I had the time to help them!

Still, altering the SQL is relatively simple, especially with the SQL 
posted previously:

update videometadata set title = 
substring_index(substring_index(filename, '/', -1), '.', 1) where title 
like 'Stargate SG-1%';

I removed the last part 'where title...' to apply this to all my videos 
and now the titles appear as I want them. It's good that it's this easy 
to modify!

Karl Buckland

More information about the mythtv-users mailing list