Movie collection database/catalog software

Questions about applications and software
Forum rules
Before you post please read how to get help
Post Reply
Doranwen
Level 3
Level 3
Posts: 133
Joined: Mon Nov 05, 2012 1:53 am

Movie collection database/catalog software

Post by Doranwen » Mon Sep 09, 2019 12:19 am

On Windows years ago, I used to use EMDB. It worked great; the three features I particularly loved were the ability to import data from IMDB, the ability to sort all the films by file length (so if I had just 80 minutes to watch a film, I could find one that would fit in the timeframe), and the ability to store info on files stored on the hard drive by first linking them and then providing a button to launch them. I even used it for a while on Mint with Wine, but somewhere in upgrading from Mint 13 to 18.1 (or updating EMDB itself, I'm not sure which) it started having trouble with displaying/using the database properly, and I had to move it to a virtual machine, which works for the first two features I listed but doesn't have a way to tell the Linux system to launch any of the files. So I've kind of been without a good one for a while, and finally decided to try to look again.

I've poked at several Linux equivalents (GCStar I've actually played with), and they all seem to fail one or more of those three things, mainly these two:
- they don't pull the data from IMDB (or anywhere, for that matter) - typing everything in gets old quickly
- they have no way to store the file location on the hard drive and/or launch the films

Mostly the first is the problem - nearly all the collection managers I could find ceased being worked on two or more years ago, and IMDB seems to have changed things since then so none of the previous interface methods (the old API?) work anymore.

So now I'm stuck between two options:
a) use a Windows program which pulls the data from IMDB correctly but doesn't let me launch files OR
b) use a native Linux program which I have to type all the data in manually but I can launch files easily

Neither is really suitable. I really want to be able to select a film and launch it, that was half the point of the collection program - and there's no way I have the time to enter everything manually all over again (GCStar supposedly can import existing databases but EMDB's database isn't stored in a file GCStar recognizes for import so that won't work, and it couldn't get info from anywhere that I tried).

Have I missed a program that can do both? Let me know if you know any. I run Mint 18.1 Mate 64-bit if that helps.

User avatar
xenopeek
Level 24
Level 24
Posts: 24063
Joined: Wed Jul 06, 2011 3:58 am
Location: The Netherlands

Re: Movie collection database/catalog software

Post by xenopeek » Mon Sep 09, 2019 1:54 am

Have you tried http://www.datacrow.net/? Looks to be actively maintained. Requires you to install Java. I didn't try this one.

I tried Tellico as well (install from terminal with apt install --install-recommends tellico) and unfortunately it has bug a with IMDB, fixed in a later version but that's not available anywhere that I could find unless you compile it yourself from source. However, if I create a new video collection and then use search and set it to search using https://www.TheMovieDB.org I can find movies and import the data. Don't know if that's as complete as IMDB but worth a try?
Image

Doranwen
Level 3
Level 3
Posts: 133
Joined: Mon Nov 05, 2012 1:53 am

Re: Movie collection database/catalog software

Post by Doranwen » Mon Sep 09, 2019 3:11 am

DataCrow I had stumbled across, but it looked like it didn't have a method for launching video files on one's hard drive - at least, I didn't see it in any of the screenshots I looked at. I've used Java for things but it's not the most stable on my system and tends to suck up more CPU than it should so I'm wary of testing it too, lol.

Tellico, on the other hand, doesn't have a visible option for links, but there's a way to create your own fields (and assign one to be a URL), and you're right, the data retrieval does work once you switch it to TheMovieDB as you said (the only area it fails is in mini-series, which I think of as long films but which TheMovieDB must consider TV and therefore doesn't have in its system). Playing around with the field views made it possible to sort the way I wanted. I think that may work for me overall. I had tried it months before but somehow ended up with a weird list that was nothing more than a list of the file names and URLs to where they were on my hard drive - not very useful! (And it definitely wasn't a movie collection type, so I don't know what I ended up doing to get it, lol.)

Thanks! Suggesting that I try TheMovieDB somehow sparked my mind to poke around and find the right options where I'd missed them before. Tellico is pretty nifty. :D

(Though if anyone stumbles across this and knows of software that will retrieve info from IMDB correctly as well as have the ability to launch the video file from the hard drive, I'd love to know what it is.)

User avatar
lsemmens
Level 8
Level 8
Posts: 2342
Joined: Wed Sep 10, 2014 9:07 pm
Location: Rural South Australia

Re: Movie collection database/catalog software

Post by lsemmens » Mon Sep 09, 2019 6:36 am

I played with GCSTAR before settling on Libre Office Base for my Stamp Collection. You can modify it, (GCSTAR) but it is messy and no longer appears to be supported. You may well be better off developing your own solution using Base. I've not bothered trying to import data from other resources, so cannot comment on that. I do know that the LO forums are almost as active and helpful as the Mint Forums.
Kernel: 4.15.0-46-generic x86_64 bits
Desktop: Cinnamon 3.8.9
Distro: Linux Mint 19 Tara

Laptop HP-ProBook-470-G2 8Gb RAM SSD
Server AMD Phenom 9650 - GEForce 9400GT 6Gb RAM
+ three other Mint machines
Out of my mind - please leave a message

Doranwen
Level 3
Level 3
Posts: 133
Joined: Mon Nov 05, 2012 1:53 am

Re: Movie collection database/catalog software

Post by Doranwen » Mon Sep 09, 2019 5:42 pm

I've created a database with Base before, to store information on fanfics I had saved to my hard drive (ended up needing 15 tables, nearly half of which were junction tables with dual primary keys; it's rather complex but I have fun using it now - I used the OpenOffice forums there for the help when I needed it, and I definitely did). Unfortunately, there's no easy way to generate links to click on, which is one of the key things I wanted, to be able to launch the video file from within the database program, and the way it would have to handle images wouldn't work that well. So I was pretty sure right away that Base wasn't going to work for this situation.

Tellico appears to work mostly well for this, it's just the interfacing with IMDB that would be nice to fix - but is definitely something I don't know how to do myself.

User avatar
lsemmens
Level 8
Level 8
Posts: 2342
Joined: Wed Sep 10, 2014 9:07 pm
Location: Rural South Australia

Re: Movie collection database/catalog software

Post by lsemmens » Mon Sep 09, 2019 6:39 pm

Sub OpenFormImage(Number) ' called from image subroutines
Dim oForm 'Reference to the form containing the primary record.
Dim oSubForm 'Reference to the subform containing the data
Dim sSG 'Reference to the data to be displayed
Dim lSG 'Reference to the data location
REM Get the button's view model from the event Source.
REM Get the button's data model from the view model.
REM Get the form from the data model.
oForm = ThisComponent.DrawPage.Forms.getByIndex(0) ' Main Form
oSubForm = oForm.GetByName("Stamp") ' SubForm Name

REM Find the column that contains the NAME field.
If Number = 3 then
lSG = oSubForm.findColumn("SM_VARIANT")
Elseif Number= 2 then
lSG = oSubForm.findColumn("SM_WATERMARK")
ELse
lSG = oSubForm.findColumn("SM_IMAGE")
End If
REM Get the data for the current record.
sSG = oSubForm.getString(lSG)
IF sSG = "" then sSG = "MyImages/Australia/No_Image.jpg"
sSG = "/home/leigh/Documents/Stamps/" & sSG
REM Open the window and diplay the image
Shell "xviewer " & sSG 'this opens the image viewer program - xviewer

End Sub
The highlighted bit above does the work. I call this sub from other ones attached to various buttons hence the "number"

The Shell command just calls an external program, in my case, an image viewer. sSG is the reference name of said image. I don't see why you could not change that to anything else.
Kernel: 4.15.0-46-generic x86_64 bits
Desktop: Cinnamon 3.8.9
Distro: Linux Mint 19 Tara

Laptop HP-ProBook-470-G2 8Gb RAM SSD
Server AMD Phenom 9650 - GEForce 9400GT 6Gb RAM
+ three other Mint machines
Out of my mind - please leave a message

Doranwen
Level 3
Level 3
Posts: 133
Joined: Mon Nov 05, 2012 1:53 am

Re: Movie collection database/catalog software

Post by Doranwen » Mon Sep 09, 2019 9:33 pm

Well, the simple answer is that I'd like a program that I don't have to learn programming to create/use, lol. Setting up the form to enter data into my database was enough for me - I had never done SQL before and I had to have someone supply the macros for me to use. I may be comfortable doing things with computers that most people wouldn't have a clue about, but that doesn't mean I want to go as far as your example just to make something work. I did that for the database I built because I knew there would never be anything out there that would have the options I wanted, and I would be frustrated not being able to customize it. This is a lot simpler set of requirements, for what should be a much broader base of users. Given the abundance of GUI programs for this on Windows, I was looking for a similar one for Linux.

Post Reply

Return to “Software & Applications”