Is track resolution stored in the database?:

I'd like to get an export of this data using the API, if possible. I have some older recordings in lower res and I thought the database might have the info that I could export to find all of them, but I haven't been able to find this, which makes me think it might only be gathered when asked by "View Details"

You are correct.

If it's not already been done, I'm sure somebody could come up with a script to accomplish this.
I'll see if I have enough time before the weekend ends to throw one together. Unless somebody else beats me to it. :slightly_smiling_face:

To start, what information would you like to see other than the information about track #0?

1 Like

That's the case. It uses an internal API to get the data.
/dvr/files/file#/mediainfo.json
i.e. for recorded file 9054 /dvr/files/9054/mediainfo.json

1 Like

Thank you, but only if it something you'd like to do.

Ideally the path, filename, file size and primary track video resolution in any file format that I can put in a table and sort.

I was about to try to figure out how to do this on PowerShell or something but then wondered if the data was already cataloged.

I started playing with this but I haven't finalized it yet. I will try to have something ready for you to use this week.

Cool, thanks!

Here is a first script you can try:
mjitkop/cdvr-export-shows: Export TV show and episode details from a Channels DVR library to a CSV file.

Hopefully, it will work for you.
Note: requires Python on your computer.

Don't hesitate to let me know if you see any problems with it or if you have feature requests. :slight_smile:

If it works well enough for you, maybe @bnhf will consider adding it to OliveTin. :grin:

C:\Users\mjitk\Documents\Scripts\cdvr-export-shows>python cdvr_export_shows.py
Using Channels DVR at: http://127.0.0.1:8089

Fetching list of TV shows from Channels DVR…
 → Retrieved 450 TV shows

Retrieving media info for each show...
 → Retrieved media info for 450 TV shows

Fetching list of episodes from Channels DVR…
 → Retrieved 20631 episodes

Retrieving media info for each episode...
 → Retrieved media info for 20631 episodes

Preparing to write CSV with 21081 total entries…
 → Prepared 21081 rows for CSV export

Writing 21081 entries to channels_dvr_shows_20260211-184339.csv…
 → Successfully wrote 21081 entries to channels_dvr_shows_20260211-184339.csv

@manowell I'm curious to know if this is working for you. :smiley: