# Export user on deck items from database?

**URL:** https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608
**Category:** Plex Media Server
**Tags:** server-linux, library-management
**Created:** [April 20, 2021, 3:01pm UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608 "2021-04-20T15:01:03Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Potato\_Bob](https://avatars.discourse-cdn.com/v4/letter/p/35a633/32.png) [@Potato\_Bob](https://forums.plex.tv/u/Potato_Bob)
#### Post date: [April 20, 2021, 3:01pm UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608/1 "2021-04-20T15:01:03Z")

</div>

Server Version#: 1.22.3.4392  
Player Version#: 4.55.0

Hi,

I’ve moved my Plex server to a new host and have successfully restored view history from the database by following [Move Viewstate/Ratings from One Install to Another | Plex Support](https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/).

If I open a show that I have started watching it will show the correct episodes as watched or not watched but there are no shows in the on deck section, how can I update the on deck section?

Is there another section of data I can export and reimport into the new database or some other method besides just copying the entire database?

Thanks,

---

<div class="post-metadata">

### Author: ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)
#### Post date: [April 20, 2021, 8:29pm UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608/2 "2021-04-20T20:29:01Z")

</div>

That’s all that is needed. However, recent versions of PMS have combined the Continue Watching and On Deck rows into a single Continue Watching row. Are you possibly seeing this?

---

<div class="post-metadata">

### Author: ![Potato\_Bob](https://avatars.discourse-cdn.com/v4/letter/p/35a633/32.png) [@Potato\_Bob](https://forums.plex.tv/u/Potato_Bob)
#### Post date: [April 20, 2021, 8:58pm UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608/3 "2021-04-20T20:58:58Z")

</div>

No. There is no on deck or continue watching at all if I go into the recommendation tab next to library.

---

<div class="post-metadata">

### Author: ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)
#### Post date: [April 21, 2021, 4:53pm UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608/4 "2021-04-21T16:53:00Z")

</div>

Using Web, if you go to the show of something that you think should be OnDeck, do you see that episode listed under the poster. Like this?

 ![image](https://global.discourse-cdn.com/plex/original/3X/a/4/a4ec2e61f3f1d43088150b31eb11e479ac379406.jpeg)

---

<div class="post-metadata">

### Author: ![Potato\_Bob](https://avatars.discourse-cdn.com/v4/letter/p/35a633/32.png) [@Potato\_Bob](https://forums.plex.tv/u/Potato_Bob)
#### Post date: [April 21, 2021, 6:48pm UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608/5 "2021-04-21T18:48:34Z")

</div>

No, I don’t see that under each poster either, the play button also just says play not next episode but it does have a mixture of watched and not watched episodes.

I’m thinking I’ll just bring over the entire database and the blob database file and be done with it.

I was trying to avoid that though as I had a lot of movies and shows with manually edited metadata that is locked and I wanted it reset back to a fresh install or as close to that as I could get it while maintaining user history.

---

<div class="post-metadata">

### Author: ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)
#### Post date: [April 21, 2021, 6:53pm UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608/6 "2021-04-21T18:53:41Z")

</div>

Try analyzing your library.  
 ![image](https://global.discourse-cdn.com/plex/original/3X/d/a/da0facfc746e0b1e80de4420ab6c6f5027997671.jpeg)

---

<div class="post-metadata">

### Author: ![Potato\_Bob](https://avatars.discourse-cdn.com/v4/letter/p/35a633/32.png) [@Potato\_Bob](https://forums.plex.tv/u/Potato_Bob)
#### Post date: [April 22, 2021, 3:38am UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608/7 "2021-04-22T03:38:40Z")

</div>

That seems to have worked for whatever reason.

Thank you for the help.

---

<div class="post-metadata">

### Author: ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)
#### Post date: [July 21, 2021, 3:38am UTC](https://forums.plex.tv/t/export-user-on-deck-items-from-database/710608/8 "2021-07-21T03:38:53Z")

</div>

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