Can I modify the date when a movie was added ?

Hi !

 

Sometimes, when i add a movie "two" like "Die Hard 2.avi", PMS add it like the first Die Hard. If i already have "Die Hard 1.avi" in my library, Die Hard 2 takes all the information of Die Hard 1. I can change it manually, no problem. But when i modify in Die Hard 2, it doensn't appear in the "recently added" section because Die Hard 2 keeps the date when the first die hard was added.

 

So, is it possible to modify manually  in PMS the date when the movie was added ?

 

And so, the movie will appear in "recently added" section.

 

Thanks !

 

Oizo007.

No one can help me ?

Come on Guys, I'm getting the same issue and it is one of the most annoying bugs.

1 Like

I'll be happy to know if there is a way to do it :)

This is usefull when doing merge between sections where 'long time ago added files' are showing in recently added in the section where they have been added.

Thanks

For the first posts, not sure if you are still looking or not but you movies are named wrong.

Plex thinks it is a 2 part movie named Die Hard.

The proper naming is Die Hard (1988).avi and Die Hard 2 (1990).avi.

A lot of problems can be solved by following the directions on setting up the system.

frisco - not sure what your issue is, can you elaborate?

I have no problem with files scanning because I follow toroughly the naming conventions; this really avoid having trouble.

My concern is more on the default sorting available in PLEX mac Media center; the added date. On a day by day use this is just perfect because files added are shown as we expect to see them; latest additions are on top of the list, all fine!

Things are going little bit complicated in case you want to restore or make 'big' reorg in your sections. My example above was trying to explain how I wanted to merge a 'old' movie section to my 'main' one. The 'main' is the section were I keep adding daily movies and where I like to figure out which files are the latest one added. As soon as I merged the 'old' section to the 'main' one; the time line was just messed up with all the movies coming from the 'old' section.

The merge action described above was done simply by adding the folder from 'old' into the 'main' section and then removing the needless 'old' section.

I hope its now little bit more clear.

One of the possible (easy?) way to implement this feature can be by adding the 'date added' field in the Plex web edit view or allowing to update this date by batch. Another way would be to reset 'date added' with the file creation date

Thanks for the support and for doing such great products.

I am in the same boat.  I am doing some clean-up of my library and converting a lot of files into MP4 from other formats.  I would like to retain the original Date Added date if possible.

In my case after I scan I end up with two entries.  What I would like to do is merge the newer one into the older one and then delete the file I no longer need.  When I merge though it always merges into the newer entry.

Ok, so that quick I figured it out.  I need to select the older entry first to have it merged the way I want.

You can simply unmatch the movie in question and then do another match to correctly associate the movie.  Odds are the process you were using wasn't removing the previous movie, just appending the metadata.  Unmatch removes all metadata giving to a clean slate to work from.

That being said, if you incorrectly identify the movie (don't follow the conventions), it will probably mismatch the movie again.

Okay so my work around is no longer working with the latest update to Plex server.  Now no matter what I do when I merge movies it always takes the earliest date and not the original date from months ago.  Any ideas?

Still looking for a solution for this. The merging of files doesn’t work as it’s supposed to–it doesn’t matter which you click first, it always merges to the one that’s LISTED first in my alphabetical view.

Not being able to edit the “added” date is really messing me up. I have a pretty extensive library, and I’m going through many of my older videos and renaming them/repackaging them in MKV etc, and because of the rename they don’t auto merge with the older file, and because of the glitch in merging, they don’t let me merge to the older file–half the time they merge the older file to the new (no matter which I click first). That’s causing my “recently added” section to be filled with videos that have been in my library for 3 years.

Can ANYONE advise how to edit when a video was added to the library?

I would love to have a way to change this too, as I would like to add some movies to the library that I don’t want showing up on “recently added”.
I’d like to just upload them normally and then change the date back to a year ago,

Here I am almost a year later having the same issues with no answer or fix. Plex keeps incorrectly matching a video file I’m adding to one I already have in my library. I can split them and rematch to the correct movie, but it retains the date added of the old, so the new video does not show in my recently added. Whether I ‘fix’ the wrong match, or unmatch and rematch, neither results in a correct added date.

@StPatty33 said:
Here I am almost a year later having the same issues with no answer or fix. Plex keeps incorrectly matching a video file I’m adding to one I already have in my library. I can split them and rematch to the correct movie, but it retains the date added of the old, so the new video does not show in my recently added. Whether I ‘fix’ the wrong match, or unmatch and rematch, neither results in a correct added date.

I’m with you, the problem must be solved somehow, please consider the issue !

Thanks,

1 Like

Not tried yet but found this:

I can’t figure how to edit my previous post, but it worked and here’s what I did to alter the added_at date for ‘Wreck-It Ralph’:

  1. Find the database location and the appropriate editing tool using this Plex support post:
    https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database
    (note I’m on Linux, not MacOS, sorry)

  2. Open the database:

root@mypmsbox:Databases# sqlite3 com.plexapp.plugins.library.db

  1. Find the right media item:

sqlite> SELECT id,metadata_item_id,hints FROM media_items WHERE hints LIKE ‘%Wreck%’;
11551|5984|guid=tt1772341&name=Wreck%20It%20Ralph&year=2012
The 2nd field is the metadata_id that you’ll need next.

  1. Check the metadata to make sure you’ve got the right id:

sqlite> SELECT id,title,added_at,created_at,updated_at FROM metadata_items WHERE id=‘5984’;
5984|Wreck-It Ralph|2017-11-16 06:10:01|2016-05-28 05:51:15|2017-11-17 20:19:22

  1. Update the metadata added_at field:

sqlite> UPDATE metadata_items SET added_at = ‘2016-05-28 05:51:15’ WHERE id=‘5984’;

  1. Check the metadata to confirm:

sqlite> SELECT id,title,added_at,created_at,updated_at FROM metadata_items WHERE id=‘5984’;
5984|Wreck-It Ralph|2016-05-28 05:51:15|2016-05-28 05:51:15|2017-11-17 20:19:22

  1. Type “.quit” to exit :smile:

Done. Insert caveats around database backups/not knowing what you’re doing/your cat catching fire/etc here.

3 Likes

Jeremy thanks for breaking that down for us. Another way to find the ID is to “View XML” of the item in question in Plex, then look for the following bit in the url :

.plex.direct:32400/library/metadata/6248?checkFiles=1& (6248 is then the ID)

1 Like

This is a blanket update command line – so be careful and know what it’s doing. This script updates the metadata_items table and sets the item’s added_at value to the originally_available_at +90 days (ballpark of when the DVD/BR was released)

sqlite3 (install it if you need)
syntax: sqlite3 /path/to/database/file.db “query to execute;”

example: (windows)

sqlite3 /cygdrive/c/Users/user/AppData/Local/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db "update metadata_items set added_at = datetime(originally_available_at,'+90 days');"

1 Like

I’ve just added a Help post on removing files from Recently Added using a Database editor. It’s easy enough to modify or edit any field with it, so may help with the above. forums.plex.tv/discussion/308170/remove-individual-recent-added-movie-s-from-home-view-on-synology-ds918-the-definitive-guide/p1?new=1

1 Like

Since Plex decided to crap all over the forums by changing platforms, let me assist with the working link::