Hi. I have Kodi on a Shield and also on a Laptop and RPi on a spare TV. I take the laptop away with me. I’m looking for a simple way to export – on any system – the Resume-Time of the TV Shows and Movies…as some sort of Report. This means i can manually check the Report so I can pick up on another Kodi system.
On a 4th box – Windows PC – I’ve got the basic SQL working, something like (for the last 14 days):
Code:
select lastPlayed, strTitle, c12 as s_, c13 as e_, c00 as 'epTitle', round(ResumeTimeInSeconds /60,2) as 'R T Mins', strFileName from episode_view
where lastplayed >date('now','-14 day')
order by datetime(lastPlayed) desc;
Plus a batch file which invokes this SQL and converts it to HTML for saving to Dropbox.
Is there any way I can get Kodi per se to do this type of thing? Even just dumping the raw SQL output as plain text? Maybe a plug in?
Thanks.