Fmstrat 3 Posted May 5, 2015 Share Posted May 5, 2015 Hi all, I've got a fairly intricate knowledge of the DB structure for Plex, and I'd like to write a utility for those migrating from Plex to Emby for exporting the watched status for TV and Movies for a specified user. I.E. something that can run like this: Plex2Emby.sh <plex.db> <plexuser> <emby.db> <embyuser> Or, at a minimum, a series of sqlite queries that can be migrated manually. The Question Given the above, is there anyone with experience in the Emby database structure that could help guide me so I don't have to figure it all out in detail? Specifically I'm looking for: Where the trigger for "watched" status is stored (is it based on play count, a separate flag)? Does Emby store anything I can use a match reference, such as an ID from the metadata provider that is also used in Plex? Thanks. Link to comment Share on other sites More sharing options...
ebr 14850 Posted May 5, 2015 Share Posted May 5, 2015 Don't mess with the database directly - at least not for us. We have defined interfaces that will allow you to get or set all user data (where watched status is stored) for a given user. So, you would want to write plug-in for us that read the Plex db and allowed someone to direct the information to an Emby user. Link to comment Share on other sites More sharing options...
Fmstrat 3 Posted May 5, 2015 Author Share Posted May 5, 2015 Even better. Is there a sample piece of code anywhere that accomplishes both a query based on some shared piece of data such as a meta-data id from a provider, and subsequently marking as watched/unwatched? Thanks. Link to comment Share on other sites More sharing options...
CBers 6742 Posted May 5, 2015 Share Posted May 5, 2015 Does Plex have a Trakt plugin to update watched status? If do sync Plex to Trakt, then switch to Emby and sync Trakt status to Emby. Or is that not possible. Link to comment Share on other sites More sharing options...
Fmstrat 3 Posted May 5, 2015 Author Share Posted May 5, 2015 Yes: https://github.com/trakt/Plex-Trakt-Scrobbler I may go this route and just writeup a HOWTO for the Tutorial section. Let's see how lazy I get. 1 Link to comment Share on other sites More sharing options...
Scot 27 Posted May 20, 2015 Share Posted May 20, 2015 How about partially watched shows? Does the Plex Trakt and indeed the Emby Add-On work for partially watched content? -SM Link to comment Share on other sites More sharing options...
Vidman 589 Posted May 20, 2015 Share Posted May 20, 2015 So you want to transfer resume points? Link to comment Share on other sites More sharing options...
ebr 14850 Posted May 20, 2015 Share Posted May 20, 2015 If you take my route, you will get resume points, likes, favorites, etc. At least from us. I'm not sure how much of all that Plex has. Link to comment Share on other sites More sharing options...
Scot 27 Posted May 20, 2015 Share Posted May 20, 2015 (edited) Hi Vidman, Correct, back and forth....I really like Kodi with the Emby plug-in but find Plex's iPad/iPhone iOS apps better.....since I use resume a lot if it is possible to sync resume status back and forth it would be fantastic... -SM PS EBR, what's 'your way' sorry? I have Trakt for Plex and for Emby, both are working however resume points are not getting sync'ed....just watched/unwatched status Edited May 20, 2015 by Scot Link to comment Share on other sites More sharing options...
ebr 14850 Posted May 20, 2015 Share Posted May 20, 2015 This was originally a development question about building an integration between the two. We have the necessary end points to do that - if a plug-in were developed. However, your end game may be solved by our new iOS app which should be out soon. Then you won't need the sync . Link to comment Share on other sites More sharing options...
Scot 27 Posted May 20, 2015 Share Posted May 20, 2015 Hi ebr I believe with a really good iOS app I do agree my reason for sync would disappear....I just assumed that the iOS app wasn't high on the priority list therefore virtually gave up waiting...don't get my excited ;-) If it's any consolation I became a supporter in the hope that my little contribution would help speed development along. I know you may not be able to give me an ETA however is the release of iOS apps days, weeks or many months away? -SM Link to comment Share on other sites More sharing options...
ebr 14850 Posted May 20, 2015 Share Posted May 20, 2015 It is in testing now. It won't be months. Link to comment Share on other sites More sharing options...
futrader8 3 Posted December 26, 2015 Share Posted December 26, 2015 Thought I would revive this thread, but has anyone found a way to sync resume points between Plex and Emby? Trakt works fine for watched status. Link to comment Share on other sites More sharing options...
mbc0 61 Posted September 26, 2017 Share Posted September 26, 2017 I guess not being a 2 year old thread but with a lot of people coming from Plex to Emby due to recent privacy changes within Plex it would be great to be able to do this! Link to comment Share on other sites More sharing options...
Luke 36878 Posted September 27, 2017 Share Posted September 27, 2017 I know some people have posted scripts or ways to do it before I just don't quite have those links handy. Link to comment Share on other sites More sharing options...
mwongjay 64 Posted September 27, 2017 Share Posted September 27, 2017 It is in testing now. It won't be months. Where can I find a changelog for the iOS beta app? Link to comment Share on other sites More sharing options...
Luke 36878 Posted September 27, 2017 Share Posted September 27, 2017 Where can I find a changelog for the iOS beta app? See the iOS Testing Area. 1 Link to comment Share on other sites More sharing options...
mbc0 61 Posted September 27, 2017 Share Posted September 27, 2017 I know some people have posted scripts or ways to do it before I just don't quite have those links handy. Thanks Luke, I have been searching to no avail so if you ever find them please let me know.. Cheers Link to comment Share on other sites More sharing options...
randomevents 38 Posted September 28, 2017 Share Posted September 28, 2017 After looking at Emby's multiple sqlite DBs, I'm just going to write a quick program that pulls all the data from the Plex DBs, matches it the correct entry for Emby, sets the tick if need be and dumps it in the Emby DB. Link to comment Share on other sites More sharing options...
mbc0 61 Posted September 28, 2017 Share Posted September 28, 2017 That would be great randomevents, are you exPlex as well? Link to comment Share on other sites More sharing options...
randomevents 38 Posted September 28, 2017 Share Posted September 28, 2017 Yes mbc0 I am. I guess I got my lifetime pass's worth (almost 3 years). I've been doing a feasibility study on a switch since yesterday. Except for the fact that every UI looks like it's designed for a person that has cataracts and a phone with BIG buttons, there's a lot of good in here. When I port over PlexSentry, I'll have to take some features out as they're not needed. 1 Link to comment Share on other sites More sharing options...
Luke 36878 Posted September 28, 2017 Share Posted September 28, 2017 Yes mbc0 I am. I guess I got my lifetime pass's worth (almost 3 years). I've been doing a feasibility study on a switch since yesterday. Except for the fact that every UI looks like it's designed for a person that has cataracts and a phone with BIG buttons, there's a lot of good in here. When I port over PlexSentry, I'll have to take some features out as they're not needed. You mean to say you think things are too big? Link to comment Share on other sites More sharing options...
mbc0 61 Posted September 28, 2017 Share Posted September 28, 2017 Yes mbc0 I am. I guess I got my lifetime pass's worth (almost 3 years). I've been doing a feasibility study on a switch since yesterday. Except for the fact that every UI looks like it's designed for a person that has cataracts and a phone with BIG buttons, there's a lot of good in here. When I port over PlexSentry, I'll have to take some features out as they're not needed. It has been a good few years since I was last here (I was an original Mediabrowser user) and things have definitely improved massively! (no pun intended) I know what you mean about everything being big but I much prefer the server management UI and the handling of libraries. Also it's nice to actually get a response from Admin (Luke especially) I have unanswered questions (lot's of them!) going back years with Plex! Looking forward to your watched status porting tool mate Link to comment Share on other sites More sharing options...
randomevents 38 Posted September 28, 2017 Share Posted September 28, 2017 You mean to say you think things are too big? Yes, big and a lot of dead space. Which is funny, because of how well everything is sized and laid out in the Server Management portion of the web app. For the theater apps, I understand, it's more or less the common thing now. But the mobile (iphone 7, Nexus 6p, Ipad Mini 4, and Large ipad something test) and web apps seem like they were sized for a phone and then scaled up from there. I think that's what people are griping about when they talk down about the web app UI. That being said, I know it's a pain in the arse doing UI's from scratch as a full stack developer myself. I actually need to make a choice like two days ago on wheter or not to finally split the phone size ui from the tablet desktop UI on a project I'm working on. Link to comment Share on other sites More sharing options...
randomevents 38 Posted September 28, 2017 Share Posted September 28, 2017 (edited) It has been a good few years since I was last here (I was an original Mediabrowser user) and things have definitely improved massively! (no pun intended) I know what you mean about everything being big but I much prefer the server management UI and the handling of libraries. Also it's nice to actually get a response from Admin (Luke especially) I have unanswered questions (lot's of them!) going back years with Plex! Looking forward to your watched status porting tool mate I'll make sure and write it with a new sqlite db as a middle man (instead of my usual sql server) so others can use it. You're right the management UI is right on, there's a couple ideas in there, I'll be "borrowing" for my own projects. Edited September 28, 2017 by randomevents 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now