Issues with Report plugin.

[JonTripp 3]

I have the latest report plug-in loaded, but when I create a report I can see it in my broweser, but I can not export is a Excel file or CSV file, all i get is this error message.

Trying to list the alums I have in my libarry.

What am I doing wrong. I am running version 4.8.8.0  and 1.0.50 on the plugin.

 

Thank you for any help

 

Method not found: 'MediaBrowser.Model.Querying.QueryResult`1<MediaBrowser.Controller.Entities.BaseItem> MediaBrowser.Controller.Entities.Audio.MusicAlbum.GetTracks(MediaBrowser.Controller.Entities.InternalItemsQuery)'.

[JonTripp 3]

As a follow up, I can get an excell spread sheet export if a as for a report on activity, but not on media.

[Happy2Play 9780]

Yes there are specific issues with Music and the plugin as it is pretty much obsolete now.  It would require a community member to potentially make necessary updates to the plugin.

 

@Lukeneeds to add export options to the UI tables view.

[JonTripp 3]

Thank You for the info. I suspect it maybe this when I noticed the date of the last update. 

So I guess my next question is, How does one get a list of the albums loaded into the system. 

I am not a programer, just a music person that likes to stream my music to my sterio syetem.

 

Thank You

 

Jon

 

[Happy2Play 9780]

Currently there is no export option just what you see in the UI.

I guess directly from the api

http://localhost:8096/emby/Items?Recursive=true&IncludeItemTypes=MusicAlbum&api_key={api-key}

There is a link to the API at the bottom of the dashboard.  Depending on your connection you may get CORS issue as it requires localhost or https connections unless you provide workaround mentioned in first section of this how to.

[Luke 42077]

In the meantime I've posted a compatibility update to the reports plugin to resolve this issue. Thanks.

[Dizzy49 99]

Is there a way I can query the sqllite database?  I am trying to get a list of movies that my account has watched.

[JonTripp 3]

Luke,

 

Thank You, it workes great.

 

Jon

[Happy2Play 9780]

11 hours ago, Dizzy49 said:

Is there a way I can query the sqllite database?  I am trying to get a list of movies that my account has watched.

Playback Reporting plugin does this but only from the time of install. 

But to your question enable the hidden system.xml flag <LogAllQueryTimes> to show query commands and perform what you need in the UI to see the command in log as you will need IDs specific info to your setup.

Example from my test system lists all played movies for Userid 1 from specific library.  This library just happened to have 6 folders.

select count(*) OVER() AS TotalRecordCount,A.Id,A.EndDate,A.Name,A.Path,A.ProductionYear,A.RunTimeTicks,A.ParentId,A.Images,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlaybackPositionTicks,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And UserDatas.UserId=1 where A.Type=5 AND UserDatas.played=1 AND A.Id in (select ItemId from AncestorIds2 where AncestorId in (103812,103813,103814,148543,148544,148545) ) Group by A.PresentationUniqueKey ORDER BY A.SortName

I guess the Reports plugin will do this but limited to the logged in user ie the admin.

Edited July 23, 2024 by Happy2Play