[mythtv-users] Mythlink Questions

[Thomas Boehm]

On 09/10/15 22:05, Michael Wisniewski wrote:
> 1225_20150417133000.mp4
> 
> What I would like to do is rename these files to something more useful,
> such as 
> 
> <TV Show Name>\<Season x>\<Episode Name.mp4>

Just query all these information from the database in your userjob
script and rename the file at the end.

I have this in my script

-------------------
...
mysqlcommand() {
        echo "$1"|mysql --skip-column-names --database=${DBName}
--user=${DBUserName} --password=${DBPassword} --host=${DBHostName}
}
...
TITLE=`mysqlcommand "SELECT title FROM recorded WHERE basename = '$FILE';"`
SUBTITLE=`mysqlcommand "SELECT subtitle FROM recorded WHERE basename =
'$FILE';"`
DESCRIPTION=`mysqlcommand "SELECT description FROM recorded WHERE
basename = '$FILE';"`
SEASON=`mysqlcommand "SELECT season FROM recorded WHERE basename =
'$FILE';"`
EPISODE=`mysqlcommand "SELECT episode FROM recorded WHERE basename =
'$FILE';"`
SE=$(echo "S${SEASON}E${EPISODE}"|awk -F '[SE]' '/S/
{printf("S%02dE%02d\n",$2,$3)}')
...
-------------------

HTH