Jump to content


Photo

Playback Reporting - breakdown series by playcount

Playback Reporting breakdown series playcount

  • Please log in to reply
7 replies to this topic

#1 daedalus OFFLINE  

daedalus

    Advanced Member

  • Members
  • 1385 posts
  • Local time: 04:34 PM

Posted 25 February 2020 - 09:29 AM

i'm trying to figure out, what episodes of a specific series got played the most

i thought this could be achieved by the playback reporting plugin, but i can't even find any way to show any playcounts at all

could someone please help out here how this could be done?


Edited by daedalus, 25 February 2020 - 09:36 AM.


#2 PenkethBoy OFFLINE  

PenkethBoy

    Advanced Member

  • Members
  • 4297 posts
  • Local time: 03:34 PM
  • LocationWarrington,UK

Posted 25 February 2020 - 09:47 AM

it does just not at the episode level

 

series have playcounts as do movies

 

not by episode in the interface



#3 daedalus OFFLINE  

daedalus

    Advanced Member

  • Members
  • 1385 posts
  • Local time: 04:34 PM

Posted 25 February 2020 - 10:00 AM

you eventually know any other way i could find that out?



#4 PenkethBoy OFFLINE  

PenkethBoy

    Advanced Member

  • Members
  • 4297 posts
  • Local time: 03:34 PM
  • LocationWarrington,UK

Posted 25 February 2020 - 10:06 AM

its in the db userdatas table - has all played counts from db start

 

or look at the backup of the playback plugin its a tab delimited csv and do a count from that - although its only going to show what you have watched since you added it



#5 daedalus OFFLINE  

daedalus

    Advanced Member

  • Members
  • 1385 posts
  • Local time: 04:34 PM

Posted 25 February 2020 - 10:27 AM

db userdatas table only has them "encrypted" behind some ids, no easy task if not being familiar with db handling

urgh so playback reporting is collecting its "own" data, thought it would read that from the db

too bad there is no easy way


Edited by daedalus, 25 February 2020 - 10:27 AM.


#6 PenkethBoy OFFLINE  

PenkethBoy

    Advanced Member

  • Members
  • 4297 posts
  • Local time: 03:34 PM
  • LocationWarrington,UK

Posted 25 February 2020 - 10:54 AM

This will give you a start - use the Execute SQL Tab in Db browser for sqlite - after you open the library.db

Select MediaItems.Id, MediaItems.type, MediaItems.name, MediaItems.UserDataKeyId, MediaItems.SeriesName, MediaItems.ParentIndexNumber, MediaItems.IndexNumber, UserDatas.playCount from MediaItems, UserDatas
where MediaItems.UserDataKeyId = UserDatas.UserDataKeyId
order by MediaItems.SeriesName, MediaItems.ParentIndexNumber, MediaItems.IndexNumber

5e5534f4ed825_Annotation20200225145223.j

 

@daedalus


  • daedalus likes this

#7 daedalus OFFLINE  

daedalus

    Advanced Member

  • Members
  • 1385 posts
  • Local time: 04:34 PM

Posted 25 February 2020 - 11:39 AM

thx for pointing me in the right direction

got the basic thing running


  • PenkethBoy likes this

#8 PenkethBoy OFFLINE  

PenkethBoy

    Advanced Member

  • Members
  • 4297 posts
  • Local time: 03:34 PM
  • LocationWarrington,UK

Posted 25 February 2020 - 11:49 AM

No Problem







Also tagged with one or more of these keywords: Playback Reporting, breakdown, series, playcount

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users