Exporting my ratings

Plex Media Server NAS & Devices
1

Server Version#: 1.40.4.8679
Player Version#:
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>

I am going to upgrade my TVS-x872xt to ZFS from QTS. This involves wiping the disk and installing from scratch. So a couple of questions:

  1. Not knowing ZFS I assume the file locations/names will be different so I won’t just be able to just copy the old QTS database to the new ZFS volumes.

  2. The only data that I am concerned about is my ratings of my personal media. Even if I can just copy the database to be safe I would also want to have a list of the file names for my movies and my personal rating which I can manipulate in excel.

  3. If a simple copy is not possible I would like to export it and import just my ratings at the new location. If not possible then with a copy of movie name/myrating in excel I can just re-enter it manually.

How can I do all of this?

2

  • You can manually export view state and ratings from the database an import it to a new one. https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/ This works because items will have the same GUID if using the same agents on both installs regardless of file name or path. This would not work for “other video” libraries and not sure how it would work for music however.

  • If you are using the newer agents and have Syncing Watch State & Ratings enabled it will save all your movie and TV ratings to your account. Like above works because they will have the same GUID. If you create a new server. delete movies and add them back or whatever the ratings will sync back to the new server (or any server you use). ( this will not do it for ratings on Music or “other video” libraries.

  • You can use the Export Tools module of WebTools to export a CSV that you can open in Excel. WebTools-NG

1 Like
3

Thanks for your detailed response!

Exported the sql database.

  1. The resulting file just had the GUID rather than the file name so there is no way to get a movie name/personal rating list from it. I don’t want to wipe the disk unless I can visually confirm that I have the data to restore personal ratings.

Not sure what agent is supposed to be used for my personal videos to get the data.

Since these are personal videos (not music) assumed suggestion #1 would not work.

  1. Saving to my Plex account might work. I need to visually verify whether the data is correct and don’t see how to do that if I synch.

  2. Tried Webtools. It keeps giving me the error that I haven’t set the export format. Went through all of the settings and could not find where to set it.

I spent nearly 3 hours trying to get this to work. Had to do a SSH to the NAS as the Database directory wasn’t showing on my mac. Turns out there were no read permissions so couldn’t get it. Useful discovery as it meant all of my backups were missing a critical file.

I hope that Plex will include this functionality at some point. This takes a considerable level of computer expertise to work.

1 Like
4

The only other way I know of making sure personal ratings are maintained (beyond hoping that a restored database works) is via Trakt.
Sadly Plex has no idea what Trakt is. But Plex supports webhooks and there’s one for Trakt but unfortunately the webhook can only sync from Plex to Trakt. However that webhook can be ran alongside PlexTraktSync and PlexTraktSync can be set to sync either (or both) ways.

But yeah I feel your pain.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.