Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Tap Forms Template Exchange › Watched TV Shows
Tagged: rjames86
- This topic has 29 replies, 10 voices, and was last updated 1 year, 10 months ago by Glen Forister.
-
AuthorPosts
-
December 9, 2018 at 2:45 PM #32553
Ryan MParticipantPlaying around some more with Tap Forms’ scripting. I created a form that lets me pull a TV series from IMDB and then also creates a table within each record with a list of all of the episodes. I have a checkbox that I can check off whenever I watch an episode.
Couple of nice features:
- The “Completed” checkbox in the form will check off all of the episodes in the table</l1>
- If all of the episodes are marked as watched, the “Completed” checkbox will get checked
- You can add the same series twice. It won’t create a new record. If there are new episodes, it will automatically add them to the existing record.
To use this, you’ll need to create an API key at http://www.omdbapi.com
Attachments:
You must be logged in to view attached files.December 9, 2018 at 2:47 PM #32556
Ryan MParticipantFor those curious, here is the script for pulling the TV show and its episodes from omdbapi.com
https://gist.github.com/rjames86/d29ae0de333a863c831a8f7379c973e3
December 9, 2018 at 10:22 PM #32567
BrendanKeymasterHi Ryan,
That’s fantastic! Great job with the scripting!
Brendan
July 13, 2019 at 6:41 PM #35899
Andrew MeadParticipantHi Ryan,
This looks great but I’m a bit stuck on how to make it work. I have imported the template, but unsure how to generate the api key or where to put it
Any help would be appreciated
Thanks
AndrewJuly 13, 2019 at 7:18 PM #35900
Andrew MeadParticipantHi
Ok I have now managed to generate an API key and have pasted that in the script in TF.
Now when I run the script it asks for a IMDB URL which I paste in (example for The 100 would be https://www.imdb.com/title/tt2661044/ but then the script does not seem to do anything after that.Is there something I am missing.?
Thanks
AndrewJuly 17, 2019 at 9:19 PM #35934
Ryan MParticipantHey Andrew,
I just tried the script again in my own form and it worked fine. Do you see any errors or anything when clicking on the menu Scripts > Show Console Log? Keep that window open when running the script.
One thing I’ve noticed is that the TV show won’t automatically appear. You have to click out to another form and come back and it’ll be there.
– Ryan
July 19, 2019 at 7:11 PM #35960
Andrew MeadParticipantHi Ryan,
Thanks for your response. Yes the clicking away from the form did resolve the issue of the script not appearing to run.
I have found one other oddity though if you wouldn’t mind checking it out. Again using the V series The 100 via https://www.imdb.com/title/tt2661044/ if I run it now it does not pick up any new episodes since the first time the script was run.
In the case of the The 100 there are at least 9 new episodes list on imdb that the script is not picking up and adding to the table.
I have tried deleting the table and re running the script but I get the same result. In case you want to try he same I have added a screenshot showing what my most recent episodes are
Many Thanks for your help
AndrewAttachments:
You must be logged in to view attached files.July 20, 2019 at 7:58 AM #35963
Ryan MParticipantHey Andrew – Do you see any errors or anything when clicking on the menu Scripts > Show Console Log? Keep that window open when running the script.
July 20, 2019 at 9:36 AM #35964
Yvette MParticipantWhere do you use the API key? I’m a total newbie, so this is probably too advanced for me- BUT, I’d love help. I got the API key. And, I imported the form. Just don’t know where to go after that…
Thanks in advance,
YvetteJuly 20, 2019 at 1:36 PM #35971
Yvette MParticipantHi, I figured out where to put the API key. Now, how do you make the script run? When I go to scripts/ show console log/ it stays blank
July 20, 2019 at 1:44 PM #35974
BrendanKeymasterHi Yvette,
There’s a Run Script button on the Scripts tab for Mac. Click the Scripts tab, then select
Import from imdb
and then press the Run button. It looks like a black triangle. Like a play button on a video or an MP3 player.On iOS, view the list of records in the form, then tap the action menu button, then tap on the Run Script command.
Thanks!
Brendan
July 28, 2019 at 6:27 AM #36073
Peter RileyParticipantThis is brilliant, thanks. Until now I have been tracking my TV show progress with a spreadsheet, but this script does a much better job.
One issue though – the table seems to miss some episodes, even though they’re there on IMDb (see attached).
Attachments:
You must be logged in to view attached files.December 5, 2019 at 2:29 PM #38494
Nacho ManParticipantIt looks like my post didn’t show up. This is a test post to see if I should go through the trouble of posting again.
December 5, 2019 at 2:55 PM #38496
Nacho ManParticipantWell that showed up… Ill ask my Question again.
I’m brand new to Tap Forms 5 – Still in the trial period – Using it on Mac
When I run the script to import a show it adds a record titled ‘No’ but no information is imported. If I try to run the script again on the script console log I get the error “series already exists undefined” regardless if it’s the same show or not.
URL Used: https://www.imdb.com/title/tt3107288/
December 27, 2019 at 9:39 PM #38463
Nacho ManParticipantI’m trying out Tap Forms 5 on MAC (Catalina), Still in the trial period. I imported this template but am unable to run it successfully.
When I run the script, it creates a new record (titled ‘No’), but it is blank. No information about the show is imported.
When I run the script again the script console gives this error “series already exists undefined”
When I run the script a third time with a different show URL I get the same error again. “series already exists undefined”
1st URL Provided: https://www.imdb.com/title/tt8712204/
2nd URL Provided: https://www.imdb.com/title/tt3107288/Do anybody have any suggestions?
December 28, 2019 at 4:15 PM #38993
Sam MoffattParticipantI did one change to the script that was imported to change line 26 which had
apikey=BanMePlz
or similar. I changed it toapikey=${apiKey}
and it was able to import both of those links you provide.You need to get an OMDB API key and set it at the top of the script and it looks like the source link that was posted is correct: https://gist.githubusercontent.com/rjames86/d29ae0de333a863c831a8f7379c973e3/raw/d5d6e39dc0f7177037ca0e2fe5e43f5cba37d76d/tvShows.js
If you copy and paste that in and then change the first line to include the API key from http://www.omdbapi.com like this:
var apiKey = 'YOURAPIKEYHERE';
I did try importing The Orville but it didn’t fully import properly for some reason (looks like the data is missing from the API). I also tried Star Trek Enterprise and that seemed to work properly.
June 10, 2020 at 7:57 AM #40868
pierrot_rennesParticipantHi,
I imported the Watched TV Show form but it doesn’t work.
Same problem as previous posts.
When we launch the script, it inserts a new recording only marked NO (example: the Band of Brothers file – https://www.imdb.com/title/tt0185906).
No information from the chosen TV show on IMDB
In the script, I put my IMDb Api key in quotes otherwise there is an error in the script.
When we launch the script, no file is inserted except a “No”
See my screenshots in case I made a mistake.
thank you in advanceAttachments:
You must be logged in to view attached files.June 10, 2020 at 6:13 PM #40873
Sam MoffattParticipantLooks like you’re missing the trailing slash. When I go to IMDB, it adds the slash for me and the regexp for the script is looking for the final slash. Try
https://www.imdb.com/title/tt0185906/
instead.June 11, 2020 at 2:45 AM #40877
pierrot_rennesParticipantHi,
I’ve tried with /… but no..Attachments:
You must be logged in to view attached files.June 11, 2020 at 9:27 AM #40884
Sam MoffattParticipantIf you open the script up in the script editor, the text box on the bottom right is the console log. Can you share the output of that corner with the input?
June 11, 2020 at 9:48 AM #40886
pierrot_rennesParticipantHi,
Of course ;-))
See join, I numbered the actions and results in orderAttachments:
You must be logged in to view attached files.June 11, 2020 at 10:01 PM #40893
Sam MoffattParticipantTry replacing the script with the contents of this gist: https://gist.github.com/pasamio/3086e8209676e956459f6325b38ab95d. It should output some debugging messages once you submit the input, e.g.:
11/6/20, 9:58:32 pm / TV Shows / Import from imdb ["/title/tt0185906/","tt0185906"] Requesting: https://www.omdbapi.com/?i=tt0185906&apikey=???&type=series&r=json series already exists Band of Brothers getting season number 1 Requesting: https://www.omdbapi.com/?i=tt0185906&apikey=???&season=1 Getting episode 2 epsiode already exists: Day of Days Getting episode 3 epsiode already exists: Carentan Getting episode 5 epsiode already exists: Crossroads Getting episode 6 epsiode already exists: Bastogne Getting episode 7 epsiode already exists: The Breaking Point Getting episode 8 epsiode already exists: The Last Patrol Getting episode 9 epsiode already exists: Why We Fight Getting episode 10 epsiode already exists: Points
June 12, 2020 at 1:23 AM #40905
pierrot_rennesParticipantHi,
Yeah !!! ? It works
Just to understand … Did you have an error in the script?
Another question :
Do you have an explanation for the fact that not all episodes are integrated?
For example, Band of Brothers (still ;-) but with others series too, there are missing episodes
See screenshots
Thank you very much for the correctionAttachments:
You must be logged in to view attached files.June 12, 2020 at 5:37 PM #40932
Sam MoffattParticipantNo idea if there was an error in the script, I might have fixed something but it wasn’t mine to begin with and to be honest I don’t actually generally use this template.
I don’t know why there are gaps, I noticed that earlier but I wonder if that is because it’s not actually IMDB but an open version.
June 12, 2020 at 11:49 PM #40934
pierrot_rennesParticipantHi,
What’s your model, please ? ;-))June 13, 2020 at 12:32 AM #40935
Sam MoffattParticipantI don’t generally track my TV in TF, I have queues in various platforms with more than enough content to keep me busy.
June 13, 2020 at 9:11 AM #40942
Daniel LeuParticipantI would copy the
https://www.omdbapi.com/?i=tt0185906&apikey=???&type=series&r=json
string into your browser and see if there is an episode 1. If there is, then there is an issue with the script, if there isn’t, then it is coming from ombpapi.com.June 13, 2020 at 9:38 AM #40943
pierrot_rennesParticipantHi,
Thanks for your perseverance ;-))
No episode… only this*******
{“Title”:”Band of Brothers”,”Year”:”2001″,”Rated”:”TV-MA”,”Released”:”09 Sep 2001″,”Runtime”:”594 min”,”Genre”:”Action, Drama, History, War”,”Director”:”N/A”,”Writer”:”N/A”,”Actors”:”Scott Grimes, Damian Lewis, Ron Livingston, Shane Taylor”,”Plot”:”The story of Easy Company of the U.S. Army 101st Airborne Division, and their mission in World War II Europe, from Operation Overlord, through V-J Day.”,”Language”:”English, Dutch, French, German, Lithuanian”,”Country”:”USA, UK”,”Awards”:”Won 1 Golden Globe. Another 33 wins & 25 nominations.”,”Poster”:”https://m.media-amazon.com/images/M/MV5BMTI3ODc2ODc0M15BMl5BanBnXkFtZTYwMjgzNjc3._V1_SX300.jpg”,”Ratings”:[{“Source”:”Internet Movie Database”,”Value”:”9.4/10″}],”Metascore”:”N/A”,”imdbRating”:”9.4″,”imdbVotes”:”352,211″,”imdbID”:”tt0185906″,”Type”:”series”,”totalSeasons”:”1″,”Response”:”True”}June 13, 2020 at 12:47 PM #40947
Daniel LeuParticipantOops, I copied the wrong line of code….
https://www.omdbapi.com/?i=tt0185906&apikey=???&season=1
should provide the season 1 results.February 12, 2023 at 10:40 AM #48899
Glen ForisterParticipantThis application seems to use a lot of graphics. So, does it take up a lot of space on an iPhone? I recently had to delete a bunch of programs and now have 5 GB of free space.
Also, reading about getting an API key seems to indicate that you get charged for what you download. Is that true?
- This reply was modified 1 year, 10 months ago by Glen Forister.
-
AuthorPosts
You must be logged in to reply to this topic.