antp.be forum

Hello,

I have been using excel to catalogue my movie collection mainly to record where they are stored but also to input information. Obviously this is very archaic and I want to use a program like amc to create a real database. I have over 2.5 K movies all listed by their folder name in excel. I also have quality, ratings, size, genres and some other info, but not consistently across all titles. I thought AMC had the ability to determine the movie title from a csv field but apparently one has to input the title name for each movie and fetch the information one by one. This is not feasible with the size of my collection. I was hoping there was a way that amc could determine the title from the folder name which always starts with the title of the movie and then the year. Maybe there is a plugin for this. I have tried poking around but nothing I have tried really works. ANY help with this would be greatly appreciated.

Hi,
You can import the CSV file in AMC, and assign each column to a field of AMC.
Once the CSV is loaded in the preview pane, you can click on column headers to assign each to a field.
If you check the help file the process for that is somewhat well described.
Once you have your catalog in AMC with all the titles and other info, you can complete these info by running a script on it. For 2500 movies maybe better do it in several times, on smaller selection of the catalog (if you select a part of the list before opening the script window, you can execute the script on selection only rather than whole catalog).

Thank you for the response. What I am trying to do is to have AMC pull the movie title from the Folder Names I have in the excel file. Unfortunately they are not in a consistent format but almost all have the movie title and the date. Sometimes it will be As.good.as.it.gets.2006, sometimes it may be As good as it gets (2006), but the information to use is still there. There is also other dummy information, like codec used, BD Remux etc, but the movie title is always at the beginning of the folder name and 95% of the time it is followed by the release date. At the end I usually have the folder size using parenthesis or square brackets to encapsulate them. I have found a python script Parse-torrent-name that can do this, I think, but I have no idea how to use it or import it into AMC. The problem is that ANT does not seem to be able to determine the Movie Title from the folder name and having to input the title each time to scrape imdb using the script is really laborious. I have a feeling there is a way to do this, I am just unaware.

Is this possible?

Will you show some examples of your files structures/filenames?

Sorry for the delay, I don't check the forum often enough.
Once your Excel is in text format (CSV or tab-delimited) you can "easily" process your file with a text editor like Notepad++ for example.
Using regular expressions you can extract info from these fields.
I've put quotes around "easily" as regular expressions are easy only if you know these well.
Otherwise if you put a few lines of the file, containing different cases, I can provide you an expression to use in Notepad++ to add the title+year columns And if you don't want to install Notepad++ you can send me the whole file, but it can still be interesting for others to post here first, so they can find the info if needed

antp wrote: ↑2023-09-26 07:05:14 it can still be interesting for others

I'm really interested!