The Movie Database Support

I have a database created in excel with a release date for movies on Brazilian television. I want to add a column for the English titles, release date and main cast, but get this data from TMDB. What is the easiest and fastest way to do this? The only thing I have typed is the Portuguese name of the film.

7 replies (on page 1 of 1)

• Jump to last post

How many titles does this Excel spreadsheet have?
If there are 20 titles, then it is easier to collect this data manually.
If there are 2000 titles, then you will need to use the TMDb API.
And it's going to be a little bit of work, I think.


EDIT
Perhaps the solution is the same that Kodi accepts to make the database of a collection of physical Movies (Bluray, DVD and VHS).
3 months ago I made this BD with 200 films that are in my brother's DVD collection.

I'm afraid there is no easy way to accomplish that and you must have at least some basic programming skills. I'm keeping my own spreadsheet lists for the original Czech content on TMDb, and the steps I follow are:
1/ I made a python script to download all desired data (via discover or by iterating through the range of TMDb ids while calling movie method). If you don't want to write your own code to handle TMDb API calls, here you can find some premade libraries and wrappers.
2/ Downloaded data are in JSON format, so they need to be imported to your script native data types (e.g. using json.loads() in python)
3/ Save downloaded data as CSV file (e.g. using csv module in python)
4/ Import CSV file manually to the spreadsheet software

You can try to match imported CSV file in your Excel list using spreadsheet functions, or if it is more comfortable for you, you can match your list directly in your download script.

Another approach could be to make a script to iterate through your list and call search method for each item, try to get the best match based on the data you know (Portuguese title, Brazilian release date) and export results to CSV.

@izaiascj said:
... English titles, release date and main cast, ....

Talestalker's solution is for professionals who know programming.
My solution is for amateurs, with very little knowledge, like me. :-)
Either way, in both solutions, you will have problems with your need for main cast.
The API does not differentiate the cast into more important and less important.
The most we have is the order in which the cast appears on the Movie page.
Usually based on the importance of the artist / character.
So perhaps selecting only the top 5 or 10 from the list is the solution.

Well, then there is this step-by-step guide for TMDb API connector in Google sheets, which could be used to make API search call for each item in the @izaiascj list (and doesn't require any programming skill at all). Seems to be interesting, but I didn't try it...

@ticao2 said:

How many titles does this Excel spreadsheet have?
If there are 20 titles, then it is easier to collect this data manually.
If there are 2000 titles, then you will need to use the TMDb API.
And it's going to be a little bit of work, I think.


EDIT
Perhaps the solution is the same that Kodi accepts to make the database of a collection of physical Movies (Bluray, DVD and VHS).
3 months ago I made this BD with 200 films that are in my brother's DVD collection.

The database has more than 3000 films and increasing

@izaiascj said:
The database has more than 3000 films and increasing

Well, in this case you will certainly need to use the API service.
It remains to be seen what your level of knowledge is.
If you understand something about programming, such as Python, then the Talestalker solution is the best.
I suggest you read and see the suggestions and links.
Now, if this Talestalker solution is beyond your knowledge, then I can try to explain how I made my brother's collection.
And I can export to an Excel table.

ToDo DVD Library

1 Create .txt file with movie titles
2 Create a file with a .disc extension, for each movie. ( .bat file does that)
3 Create folder for each movie. (MediaElch does that)
4 Scraper data on TMDb (MediaElch does this)
5 Export data to file*.csv* (MediaElch does this)
6 Import .csv data into spreadsheet.

I can give the .bat file and instructions for use.
I can give instructions for using MediaElch.
I can give the export templates to .csv file

Can't find a movie or TV show? Login to create it.

Want to rate or add this item to a list?

Login