GamCat

Utilities

Source (link to git-repo or to original if based on someone elses unmodified work): Add the source-code for this project on opencode.net

3
Score 70.0%
Description:

This is a CD/DVD and folder catalogizer written in Gambas. It uses sqlite3 server for the database.It can browse inside the ARJ, ACE, TAR, RAR, and ZIP archives. The Virtual Compilation feature requires mkisofs package for .ISO creation.

Features:
- Scanning removable devices, partitions and folders and FTP servers
- Scanning inside archives
- Exporting the results
- Browsing the scanned archive file
- Virtual Compilation. This is an option to create a CD/DVD from the files listed in database in form of k3b project and .ISO file
- Managing the disks and video DVDs, you can add video DVDs from a filelist in .TXT format.
- Managing your customers, to know to whom you've given your disks and when.
- Rating your disks and specifying their genres
- You can exclude certain files from being scanned (like Thumbs.db or ReadMe.txt)
- You can search through categories
- You can quickly remove unwanted hits from within the search results by a right-click menu.
- Reports in various formats about a volume: .TXT and .HTML
- Ability to create a complete website from out of your catalog.
- Possibility to create thumbnails of image files of following type: JPG, PNG, BMP, TIFF, PCX, GIF and PDF.
- Scanning through .ISO image files
- Scanning the tags of MP3 files
- PDF and GIF thumbnails
- PowerQuery - sophisticated search algorithm for complex searches
- Import of Advanced Disk Catalog files via XML.


Lyrics providers:
lyrics.wikia.com
lyricstime.com
lyricsmania.com
zeneszoveg.hu
lyricsdownload.com
darklyrics.com
elyrics.com
hotlyrics.net
azlyrics.com
lyricsreg.com
lyrics007.com
metrolyrics.com


WARNING: This is a Gambas 3.4.1 project now, although the Kde-Apps is not ready for that

- GamCat can create thumbnails for the following movie formats: .3GP, .MOV, .MP4, .FLV, .AVI, .MKV, .MPG, .VOB, .MPEG
- There can be sequences of thumbnails for each movie file (1-25 images). This has been done using ffmpeg
- The thumbnails can be copied to a separate folder for easy access, as well as creation of a montage image of all the thumbnails with movie data.
- The thumbnail's resolution can be set
- You can create custom playlist from the MP3 database
- You can play the playlist as .m3u file in external players
- It is possible to search for a song using a fragment of its lyrics
- FTP scan dialog has been fixed
- A powerful statistic tool which can:
* compare two volumes
* make deep analysis of a volume
* check the scanned HDD folders for changes


GamCat is avilable also in Polish language: special thanks to Gnomek for translation and ideas/wishes, and the countless testings.
GamCat is now available in German language, thanks to work of Andrea Ambrus!

The German translation is not complete.
Last changelog:

7 years ago

Version 1.0.9:
- Contains bugfix script for wrong file and folder numbers (the first run is slower)
- Added options to copy general catalog informations to the clipboard (Catalog tab)
- Single save saves the lyrics, "Save" button moved to menu item (MP3 tab)
- The Statistic is now synchronized with volume tree on Catalog tab
- Other small bugfixes

bacay

10 years ago

just started using your applikation for the first time
while scanning a directory on harddrive i'l get an errormessage reading:

This application has raised an unexpected error and must abort
[21] Out of bounds
Archs.?.0

that wasn't funny, what to do?

Report

C

mohareve

10 years ago

And what if you turn off the scanning for the archives?

The most of the errors comes from special characters in filenames which are allowed, unfortunately. I'm speaking about ",!,',% which are not easy to use together with databases.

Still, since I've changed a lot in the program there can be errors. I'll try to fix it.

Report

C

mohareve

10 years ago

I suspect to the RAR archives. Try to switch the scan off and repeat the addition.

Report

C

mohareve

10 years ago

"Hi,
this won't work for me. Here is my mtab
/dev/sda1 / ext3 rw 0 0
proc /proc proc rw 0 0
sysfs /sys sysfs rw 0 0
devpts /dev/pts devpts rw,gid=5,mode=620 0 0
tmpfs /dev/shm tmpfs rw 0 0
none /sys/bus/usb/drivers usbfs rw,devgid=502,devmode=664 0 0
none /proc/sys/fs/binfmt_misc binfmt_misc rw 0 0
sunrpc /var/lib/nfs/rpc_pipefs rpc_pipefs rw 0 0
gvfs-fuse-daemon /home/mateus/.gvfs fuse.gvfs-fuse-daemon rw,nosuid,nodev,user=mateus 0 0
/dev/sda4 /media/disk fuseblk rw,nosuid,nodev,allow_other,blksize=4096 0 0
/dev/sda5 /media/disk-1 fuseblk rw,nosuid,nodev,allow_other,blksize=4096 0 0
sistemas@200.254.228.1:/cygdrive/f/inetpub/wwwroot/intermar /media/inter_www fuse.sshfs rw,nosuid,nodev,max_read=65536,user=mateus 0 0
mmachado@192.168.0.3:/net/ /media/inter_net fuse.sshfs rw,nosuid,nodev,max_read=65536,user=mateus 0 0
/dev/sr0 /media/Novo iso9660 ro,nosuid,nodev,uhelper=hal,uid=500 0 0


No sucess still. What can I do now?"

Please describe me, how it doesn't work:
1. Do you have installed gambas2-gb-db-sqlite package?
2. Do you have sqlite3 installed on your system?
3. GamCat reads /etc/mtab for the mounted devices, and no fstab.

Report

C

mohareve

10 years ago

"Hi,
this won't work for me. Here is my mtab
/dev/sda1 / ext3 rw 0 0
proc /proc proc rw 0 0
sysfs /sys sysfs rw 0 0
devpts /dev/pts devpts rw,gid=5,mode=620 0 0
tmpfs /dev/shm tmpfs rw 0 0
none /sys/bus/usb/drivers usbfs rw,devgid=502,devmode=664 0 0
none /proc/sys/fs/binfmt_misc binfmt_misc rw 0 0
sunrpc /var/lib/nfs/rpc_pipefs rpc_pipefs rw 0 0
gvfs-fuse-daemon /home/mateus/.gvfs fuse.gvfs-fuse-daemon rw,nosuid,nodev,user=mateus 0 0
/dev/sda4 /media/disk fuseblk rw,nosuid,nodev,allow_other,blksize=4096 0 0
/dev/sda5 /media/disk-1 fuseblk rw,nosuid,nodev,allow_other,blksize=4096 0 0
sistemas@200.254.228.1:/cygdrive/f/inetpub/wwwroot/intermar /media/inter_www fuse.sshfs rw,nosuid,nodev,max_read=65536,user=mateus 0 0
mmachado@192.168.0.3:/net/ /media/inter_net fuse.sshfs rw,nosuid,nodev,max_read=65536,user=mateus 0 0
/dev/sr0 /media/Novo iso9660 ro,nosuid,nodev,uhelper=hal,uid=500 0 0


No sucess still. What can I do now?"

Please describe me, how it doesn't work:
1. Do you have installed gambas2-gb-db-sqlite package?
2. Do you have sqlite3 installed on your system?
3. GamCat reads /etc/mtab for the mounted devices, and no fstab.

Report

Maras

10 years ago

Hello.
First of all I want to thank you for this project. GamCat is first CD/DVD collection manager for linux that promises a lot of features.

Now about some flaws - maybee it helps you. Or maybee I am doing something incorrectly. My system - Debian Sid, version of GamCat - 0.0.5.1

Import from WhereIsIt XML is not working. I did export in WhereIsIt after that tutorial: http://getsatisfaction.com/obviousmatter/topics/import_where_is_it_dbs and tried importing all my collection or only one disk from my collection. Error was: "Query failed: SQL error or missing database. F.Main.?.0" and program disappeared. When I tried import XML that was generated by "Disk explorer professional" [only as try, I know, that it isn't supported], error was the same.
CdCat is only program in linux that managed to import the same WhereIsIt XML correctly for me.

Browsing in rar archives is incomplete. While from tar and zip archives program manages to read all filenames, from rar it reads only first word or only number of track, sometimes - nothing. Bad work of unrar (I have unrar and unrar-free installed)?

Report

C

mohareve

10 years ago

First of all, the WhereIsIt is an ATTEMPT, it isn't tested (I have no examples, I've done the import module based upon 1 or two exported databases in XML!) so I hope you've backuped your database before the attempt. It was planned to import database all at once.

For the RAR archives: GamCat utilizes the console line command:
unrar l "yourfile.rar"

Please try to check whether your unrar package gives back the content correctly in terminal. There are some difficulties with the Window - Linux passing over:
1. Character encoding. Maybe your system cannot recognize the correct characters.
2. Special characters and sqlite database. I think I'll check this part of the program. I've built in some basic character filtration to evade the program crash, so maybe some files are missing because of that.

Anyway, I'll try to fix it.
In new release there will be a new tab for MP3 files. I've already made download scripts for some lyric providers so it will be possible to store the lyrics together with the files.
Regards,
Csaba

Report

Maras

10 years ago

Thank you for quick answer.

Oh yes, I backuped, but program crash didn't destroyed existing database.
I tried some tricks when exporting xml - minimized information as possible (1 disk with Western European characters in filenames only, only filenames in description - without flags, categories etc.). But program chrashed nonetheless.
Maybee this depends on WhereIsIt version? My is 3.84.

Checked "unrar l" and saw in terminal all the names of archived files with all diacritiks and cyrilic too.
The only problem was a file with double commas ["] - unrar didn't see it (GamCat see nothing inside this archive too). I added underscores [_] instead empty places in name and unrar recognized archive. But GamCat didn't see nothing in such archive. Only when I removed double commas from archive name program managed to see names of it content. But only track number and first word of name.
So, limitations isn't due unrar. And cyrilic names of archives and files haven't matter at all in my case.

Hope, this information will be usefull for you.

What are you thinking about tagging and other sorting of files, like WhereIsIt flags and categories? I understand, that your plans are not to be equivalent of WhereIsIt, but need for a powerfull catalogizer of various CD/DVD content is big in linux (catalogizers of movies, music or books exists already), so this is a niche for this program, I think. Search in hundreds of DVD is hard work :). So limitations of searching in archived files is big disatvantage, in my oppinion.

Best regards,
Valdemaras.

Report

C

mohareve

10 years ago

If I red you correctly, you'd like to see an option to add comments/categories to the file? For example if you'd click on a file, you'd have options 'Add comment' and 'Add category'
, and after that you'd be able to search for a file inside a category?

I've fixed some errors, so the next release is going to be more useful.

Report

neprosto

10 years ago

Screenshots and the description look nice, so I tried to install the app on OpenSuse 11.2. Gambas is provided by
http://download.opensuse.org/repositories/Education/openSUSE_11.2 and contains the package gambas2-gb-opengl, while the app requires gambas2-gb-qt-opengl. I suppose that they are the same thing but the app surely cannot recognize this. What should I do?

Also I can try to help with translation of the app into Russian if it will involve the work with text only and will not require any knowledge about Gambas programming.

Report

C

mohareve

10 years ago

I'm sorry, I've left some dependencies turned on after the development. They are not required at all. Please repeat the download and try it again. I've changed the files today, so they will work now for you. The translation is very easy. I've posted the translation file for Hungarian, and all you need is to replace the Hungarian terms, which are below the English original ones with Russian ones (please keep in mind the length of the text!), and to send me the file GamCat-ru-0.0.49.po, and in next release it will be available.

Please post me, whether it works on openSuse! I've never tried it on that distro.

Report

C

mohareve

10 years ago

I've updated the links, so you can now download all the packages from this page.

Report

brserek

10 years ago

All you offer to download is Debian package, Unace for Mandriva (this is very strange) and translation files. I would really like to try this application, but I'm Fedora user...

Report

C

mohareve

10 years ago

I've tested GamCat on Fedora 12 LiveCD and it works. Still, this was a live version, and I had some troubles with font sizes.

Report

brserek

10 years ago

Tried to install rpm, but there are unresolved dependency: gambas2-gb-db-sqlite2. I've found only gambas2-gb-db-sqlite3 in repositories, but it won't work.
I've just downloaded sources and will try to compile later.

Report

C

mohareve

10 years ago

Please download the package again. I've uploaded the version with no gambas2-gb-db-sqlite dependency just in this afternoon. Hopefully you'll manage to install it. Read the notes.

Report

brserek

10 years ago

Now package simply installs. But there's another problem. After starting it tells me to put in discs in drives to recognize them. And I've tried everything: CDs, DVDs, automounting, manual mounting, but nothing works.

Report

C

mohareve

10 years ago

Please download the 'First aid kit',
extract to your home folder, and go into ~/.GamCat folder of your home folder.
There is a config.txt file in it.
Open it, and replace the lines with the ones you can find in /etc/mtab.
(you can do it as regular user with command:
kate /etc/mtab )
Search for lines similar to

/dev/sr1 /media/cdrom0 iso9660 ro,nosuid,nodev,utf8,user=minthaka 0 0

You only need the
/dev/sr1 part to be put into the config.txt.

Save the file, and start Gamcat.
hopefully that helps.

Report

mmachado

10 years ago

Hi,
this won't work for me. Here is my mtab
/dev/sda1 / ext3 rw 0 0
proc /proc proc rw 0 0
sysfs /sys sysfs rw 0 0
devpts /dev/pts devpts rw,gid=5,mode=620 0 0
tmpfs /dev/shm tmpfs rw 0 0
none /sys/bus/usb/drivers usbfs rw,devgid=502,devmode=664 0 0
none /proc/sys/fs/binfmt_misc binfmt_misc rw 0 0
sunrpc /var/lib/nfs/rpc_pipefs rpc_pipefs rw 0 0
gvfs-fuse-daemon /home/mateus/.gvfs fuse.gvfs-fuse-daemon rw,nosuid,nodev,user=mateus 0 0
/dev/sda4 /media/disk fuseblk rw,nosuid,nodev,allow_other,blksize=4096 0 0
/dev/sda5 /media/disk-1 fuseblk rw,nosuid,nodev,allow_other,blksize=4096 0 0
sistemas@200.254.228.1:/cygdrive/f/inetpub/wwwroot/intermar /media/inter_www fuse.sshfs rw,nosuid,nodev,max_read=65536,user=mateus 0 0
mmachado@192.168.0.3:/net/ /media/inter_net fuse.sshfs rw,nosuid,nodev,max_read=65536,user=mateus 0 0
/dev/sr0 /media/Novo iso9660 ro,nosuid,nodev,uhelper=hal,uid=500 0 0


No sucess still. What canI do now?

Report

brserek

10 years ago

Sorry for not answering, but I'm very busy these days. I've just updated to version 0.45 and downloaded First Aid Kit. No time to do some testing, but program starts and I'm able to add discs to database.
I've got no /dev/sr0 or /dev/sr1 in my mtab. Those are actual devices, and disks are automounting, but no entries in mtab - to complicated for me :)
Thanks for help.

Report

C

mohareve

10 years ago

Wait until monday, I'll upload a zipped directory structure, with an empty database, so you'll be able to extract into your home folder, and to skip the installation's misery, oh beauties of Linux!

Report

C

mohareve

10 years ago

Can you post me the content of your /etc/mtab file?

As I told you, I never tested it on Fedora.

A better idea:

see where are mounted your DVD and CD drives, e.g.
/dev/dvd
/dev/cd

or similar.

Create a config file inside your /home/your/.GamCat folder, and put the corresponding lines inside the config file, and save it. Restart GamCat

Report

C

mohareve

10 years ago

I suggest you to try the unace provided with the Fedora.I hope it will work for you. I've never tested GamCat on Fedora, only with Ubuntu, Debian and Mandriva, but hopefully you can use the Mandriva's or openSuse's version. I'm really curious about it's usability. Please post me your experiences, if you're willing!

Report

C

mohareve

10 years ago

http://sourceforge.net/projects/gamcat/files/

Here are the files!

Report

junkDawgie

11 years ago

when adding volumes to the disk catalog, I get an error:

[21] Out of bounds.
FMain.?.0

the application closes immediately after the error msg is acknowledged. Restarting the application shows the volume was added to the catalog successfully.

suggestions?

Report

7 years ago

Version 1.0.9:
- Contains bugfix script for wrong file and folder numbers (the first run is slower)
- Added options to copy general catalog informations to the clipboard (Catalog tab)
- Single save saves the lyrics, "Save" button moved to menu item (MP3 tab)
- The Statistic is now synchronized with volume tree on Catalog tab
- Other small bugfixes

12345678910
4
product-maker RAIDENSUB Apr 26 2013 9 excellent
product-maker posixru Apr 02 2013 9 excellent
product-maker remix Mar 08 2012 9 excellent
product-maker koko2k Oct 08 2010 9 excellent
product-maker Base: 4 x 5.0 Ratings
Stincjatclava
Apr 27 2013
remix
Mar 08 2012
VectoR
Oct 14 2009
File (click to download) Version Description PackagetypeArchitectureRelease Channel Downloads Date Filesize DL OCS-Install MD5SUM
*Needs pling-store or ocs-url to install things
Pling
0 Affiliates
Details
license
version
1.0.9
updated Apr 06 2013
added Mar 08 2009
downloads 24h
0
mediaviews 24h 0
pageviews 24h 2
System Tags app software