How To Create a Movie Database in Obsidian

Timestamps:
00:00 - Intro
00:40 - Why Bother?
01:16 - Requirements
03:04 - Template
05:50 - Dataview
08:14 - Further Customization

Find Stephan at:

My movie template:

poster: {{VALUE:Poster}}
imdbId: {{VALUE:imdbID}}
scoreImdb: {{VALUE:imdbRating}}
length: {{VALUE:Runtime}}
genre: {{VALUE:Genre}}
year: {{VALUE:Year}}
cast: {{VALUE:Actors}}
director: {{VALUE:Director}}
rating:
status:

plot:: {{VALUE:Plot}}

File name format: {{VALUE:fileName}}

Stephans Dataview query
``dataview
table without id
("![](" + poster + ")") as Poster,
string(year) as Year,
"by " + director as Director,
"⭐ " + scoreImdb as "⭐ IMDB",
rating
from #movies
where poster != null
```

My dataview query:
```
table without id
("![](" + poster + ")") as Poster,
year as Year, director as Director,
"⭐ " + scoreImdb as "⭐ IMDB",
rating, genre
from "movies"
where contains(status, "complete")
`

Some of the above are affiliate links which means I get a small commission at no extra cost to you, which helps support the channel.

[kepano]

Really well done! Very clear and easy to follow explanation. I will add a link to this in the Minimal documentation.

[hchilcoat]

This is a really solid tutorial. I'm really grateful for it. I'm going to share the basic mistake I made in case someone else has the same issue.
PROBLEM: My table was all dashes and blanks except for the movie titles. The titles linked back to the the right notes with all the correct data, but it didn't display in Dataview.
SOLUTION: When I cut and pasted the information for the template I didn't get the last dashes to close out the YAML. Instead I got backticks which made the table display as empty. It was a subtle enough difference that it took a few minutes to spot it.

[ReheatedDonut]

This is AWESOME. I was using Joplin until recently and once I discovered dataview and things like this, I made the move ASAP. I've already transferred all my notes, and also setup watched movies, tv shows, and to watch for both. Thanks for this.

[tomer.nosrati]

I love how you find the exact balance between: Meta talk (setup/config), main focus of the video, usage example and keeping it all short and clear. You share just the information I need to evaluate the feature/idea and get the basic understanding I need if I want to implement it myself.

About the actual topic - I love it. IMDB is such a small use case IMHO as this can be used for much other useful professional stuff.

Lastly - Love the presentation, calm and enjoyful.

P.S
Just noticed there's been a few new videos recently, gonna catch up soon!!

[rpywyvbuerdopvpoeblt]

Great and helpful video! Excited to see what other projects you'll show us in the future. Thank you Stephan and Sergio.

[HeyQuinton]

Very nice. It was a nightmare trying to set this up initially when it first came to Reddit but this really helps!

[chogurt]

Hey Sergio, I tried everything you said but while adding the movie name it says:
QuickAdd: (ERROR) failed to run user script
movies. Error:
Request failed, status 401

[Mikarevival]

Great Guide! Thank you Sergio!! I saw the Movie "The Man from Earth" (2007) and I wanted to add this in Obsidian (Because it is a great Movie!!) and I didn`t know how. I knew that you did a Video about it, so I searched for it in YouTube. I found you and I applied all what you have explained and now I can enjoy my personal Movie Library!!

[jamestraver]

I can get everything to work except for the "poster" or the card view. I am getting the information from imdb and can create a database, but I cannot get any card style view. Any help would be appreciated. Thanks.

[jdcv]

Any plans on doing a follow up video? Obsidian now has Properties so some of the old frontmatter or YAML needs editing. Would be nice to see a tutorial about Properties and the Media DB plugin.

[maurolimaok]

Again, I'm gonna need to watch a couple of times to "get the thing" at useful level, but it seems amazing to be able to customize it.
As I see it's not so difficult, i'm just not used to this environment but, as times goes by, it will become easier and easier.
Thanks a lot.

[sinisky]

i followed all the steps but on the dataview query it fails to load the movies to the list, what am i doing wrong

[jdcv]

Thanks for this tutorial! I watched this before but didn't really feel that I need it. I tried Book Search and realized that the Media DB Plugin is what fits my need more. Hope you'd make some more tutorials on the Media DB Plugin with other databases; I'd like to see a tutorial with the currently supported APIs (Jikan, MusicBrainz, Wikipedia, Steam).

[goldstein]

I did every step but i cant lookup movies
Error message:
quickadd:17468 QuickAdd: (ERROR) failed to run user script m.
Error: Request failed, status 401


Im stuck, IDK what to do. i followed everything twice. Not went to gallery part yet

[michaelwelsh]

Thank you so much - so happy I have found your channel - I may have finally settled on my note taking app...hopefully!

[johnevans]

Great series for learning Obsidian. Thanks.

[misplacedaggression]

Does anyone have any suggestions as to why my movies.js isn't populating when I try to add it as a User Script in Macros of QuickAdd? I downloaded it from Steph's site and it was already named movies.js- I moved it into

[emil]

Thanks for the video unfortunately I cant get it to work. I followed your exact steps three times to check if i missed something but i keep getting the same error: quickadd: ERROR failed to run user script movies. error: request failed status 401

Any clues?

[FreakWithAMustache]

Any idea why am I getting "Quickadd failed to run user script movies. Error: request failed, status 401"?

[victoraoliver]

I can't see the poster of the movies in the Dataview table, something with the CSS file or something.