PlexEmail - Email Recently Added Media

got a few feature requests if interested.

ability to add additional links in the navbar. i also use the request app and had a link there, but it disappeared when the new html was created.

how about adding links for the imdb page and a movie trailer?

would there be any reason or benefit to accessing the ratings api through the plex app?

where are the settings for time? this is set to go out daily, but i think you mentioned creating a new one for weekly, how is this done?

oh, maybe even a config page gui, rather than having to edit the config file. easy to make mistakes when changing for testing. i had false instead of False and was wondering why it was not working. then ran manually in a cmd window and found out :slight_smile:

@sydeburnz said:
got a few feature requests if interested.

ability to add additional links in the navbar. i also use the request app and had a link there, but it disappeared when the new html was created.

how about adding links for the imdb page and a movie trailer?

would there be any reason or benefit to accessing the ratings api through the plex app?

where are the settings for time? this is set to go out daily, but i think you mentioned creating a new one for weekly, how is this done?

Schedule the script to run when you want it. Personally I have a scheduled task on windows that runs weekly on a Friday.

and do i schedule the vbs script or the py script? i think is the vbs script, right?

@sydeburnz said:
and do i schedule the vbs script or the py script? i think is the vbs script, right?

The VBS script.

Hi sorry to be a pest can anyone help me with this error?

c:\Plexemail\scripts>python plexemail.py
Traceback (most recent call last):
  File "plexemail.py", line 669, in <module>
    cur.execute('SELECT machine_identifier FROM remote_servers     WHERE url LIKE "h
ttp://127.0.0.1%";')
sqlite3.DatabaseError: file is encrypted or is not a database

I have Python 32bit with the SQLite3 from the instructions in the correct folder

did you install the requester?

Yes I did I’ll try again to be 100%

Edit:
I cd into the folder and ran
Python setup.py install
And it ran
I then tried Plexemail again and got the same error

and you put the sqllite in the dll folder, right? let me look over the install again, maybe i will see something.

Yep the SQLite it in the dll folder
I tried to save it again up it told me it was in use

so, when you copy those dll files, does it ask if you want to replace? i think i remember when python was running, it took me a few drags to get the actual files to want to move over.

it didnt ask if i wanted to replace the files the first couple times is what i meant. so the copy never really happened.
also found this:

Just replace the sqlite3.dll in the pythonXX\DLLs with sqlite3.dll in the CLI sqllite folder which originally contains sqlite3.exe and the problem was solved

http://www.sqlite.org/2015/sqlite-dll-win32-x86-3080803.zip

im pretty sure i dragged both files into the python dll folder

one more thing to try. right click and run your command window as admin before going to the path and installing.

I don’t know which one work either admin request or replace SQLite with you attachement but it worked

Thank you :slight_smile:

i actually think it was the elevated command prompt. are you on windows server?

can someone tell me the rationale of how the email/webpage is sorted? it would make sense to sort by most recent, but i can see someone getting the email and seeing the same move on the top and not reading on. i have had 6 more movies added and pulp fiction has stayed at the top the last 6 days.

Just wanted to say I love the script, but I had a request:

Can you add a general info section we can add whatever to? I have added a comment about replying and asking to unsubscribe if they don’t want to receive the emails, and I also have added a link to my Plex Requests website for folks to be able to request new shows/movies.

@sydeburnz said:
i actually think it was the elevated command prompt. are you on windows server?

Windows 8

This is working beautifully for me in a FreeNAS jail. Thanks!