Exporting statistics

Feature request
1

Hello,

I would like to export my listening statistics in numerical form. Is this possible? I didn’t find a button within the app on the statistics screen. I also exported the database to see if I could find it there or recreate it from scratch but there doesn’t seem to be any listening data at all.

2

The statistics are in the database export. Every episode (FeedItem) has a column for the duration that it was listened to.

3

Thought I’d get a notification by email for new messages, sorry for the apparent thread abandonment.

Thanks for the reply. I fetched the “FeedItems” table, but there doesn’t seem like there’s anything to do with duration. These are the column names I see:

> colnames(a)
 [1] "id"                  "title"              
 [3] "content_encoded"     "pubDate"            
 [5] "read"                "link"               
 [7] "description"         "payment_link"       
 [9] "media"               "feed"               
[11] "has_simple_chapters" "item_identifier"    
[13] "flattr_status"       "image_url"          
[15] "auto_download"

Here are the available tables:

[1] "DownloadLog"      "Favorites"        "FeedItems"       
[4] "FeedMedia"        "Feeds"            "Queue"           
[7] "SimpleChapters"   "android_metadata" "sqlite_sequence"

What am I missing? I am not very familiar with SQL so I might have a blind spot.

4

Oh, I think it might be in the FeedMedia table. Each FeedItem has a corresponding FeedMedia row, linked by the ID.

The forum’s logs indicate that it sent you an email. Maybe it was classified as spam.

5

It was in FeedMedia, thanks!

1 Like