[mythtv-users] List of recordings by disc drive -Solved

[John Pilkington]

On 09/02/15 21:20, Mike's JdJ wrote:
>
> On 02/09/2015 12:53 AM, Bill Meek wrote:
>> On 02/08/2015 10:48 PM, Stephen Worthington wrote:
>
>>
>> Here's a script using Python bindings that can probably be adapted
>> to print what was requested (for the 1st part.)
>>
>>      http://pastebin.com/wfpBfQ19
>>
>
> Thanks to Mike, Hika, Stephen, and Bill for the responses.
>
>
> I ran Bill's report and it had the path/filename in it.  I took the
> output and imported into LibreOffice Calc.  I chose fields for the disc
> name and the timestamp portion of the file name.  I then sorted on disc
> and timestamp.  This gives me a list of titles chronologically per
> disc.  Multi-step, but this is a one-time need.
>
> My goal is to use my newly-developed skills in editing and transcoding
> and go after my two 1.8 TeraByte discs that are 98% full.  My other two
> 1.8 TB discs are at 66% and 80% full.  The DBA in me says to start with
> the oldest file in the fullest disc first, then reduce the size of the
> next-oldest file, and so on.  With 1,883 recordings, this will take a
> while.
>
>
> I suspected that the path/file name was not stored when I could only
> find the file name in Playback Data on the Back End computer.
>
>
> The mythlink.pl looks good, but do I understand correctly that it
> renames the files?  I've been staying out of SQL and avoiding changing
> MythTV as much as possible.  I had an upgrade issue in 2011 and ruined
> my database and couldn't access my old recordings.  I deleted the
> recordings from the discs and started new.
>
>
> Thanks again,
> Mike
>

mythlink provides links with readable names in a specified directory. 
Here's a sample from 'ls -l  pretty'

lrwxrwxrwx. 1 john john 46 Feb  9 18:32 Wilderness Walks with Ray 
Mears-3-20141223-1928- Britain's wildest places.mpg -> 
/home/john/SGs/RecsSG1/1003_20141223192800.mpg
lrwxrwxrwx. 1 john john 46 Feb  9 18:32 Wilderness Walks with Ray 
Mears-3-20141230-1928- Untitled.mpg -> 
/home/john/SGs/RecsSG1/1003_20141230192800.mpg
lrwxrwxrwx. 1 john john 46 Feb  9 18:32 Wolf Hall-2-20150121-2058-1-6. 
Three Card Trick.mpg -> /home/john/SGs/RecsSG1/1002_20150121205800.mpg
lrwxrwxrwx. 1 john john 46 Feb  9 18:32 Wolf Hall-2-20150128-2058-2-6. 
Entirely Beloved.mpg -> /home/john/SGs/RecsSG1/1002_20150128205800.mpg
lrwxrwxrwx. 1 john john 46 Feb  9 18:32 Wolf Hall-2-20150204-2058-3-6. 
Anna Regina.mpg -> /home/john/SGs/RecsSG1/1002_20150204205800.mpg

I display the folder in a file manager and can sort 'instantly' on any 
column.
----------
#!/bin/bash
# Create a readable list of recordings in /home/john/pretty
#
echo "Creating a pretty list of recordings in /home/john/pretty"
#
perl /usr/share/doc/mythtv-docs-master/contrib/user_jobs/mythlink_KN.pl 
--link \
  /home/john/pretty --format  '%T-%cn-%Y%m%d-%H%i-%S'
date
exit
--------------

John P