Linux.com

Feature

Manage your media library with Data Crow

By Joe 'Zonker' Brockmeier on February 06, 2007 (8:00:00 AM)

Share    Print    Comments   

Many Linux apps let you manage your movie collection, or your book collection, or your music collection -- but Data Crow is one of the few that handles all of the above, plus software and images. It also puts a lot of import tools at your fingertips that can save you from entering information about your media manually -- including importing information directly from online services and text files, and extracting information from music files.

Data Crow is a Java application, so you'll need to have Java installed on your machine before you download the most recent production version's binary zipfile. Unzip the file in a directory where you want Data Crow to live, and start Data Crow by running java -jar datacrow.jar. You might notice that it takes Data Crow a bit of time to start, even on a relatively fast machine. I'm running it on an AMD X2 4200+ system with 4GB of RAM and it still seems slow to start. However, once it's loaded, Data Crow is respectably fast.

Adding and editing items

After Data Crow starts, you'll see the main window with the media types displayed in the left-hand module list, and you'll have one item in your database -- an entry for Data Crow itself. You can add items to the database manually, you can try to get Data Crow to coax the information out of online services like Amazon, MusicBrainz, and Internet Movie Database, or you can import data from text files. Let's start with the manual process.

To add an item manually, click the New button in the Data Crow toolbar or press Ctrl-n, which will bring up the new item dialog. You'll see several tabs for item data (these will vary, depending on the type of item you're adding) and the Save and Cancel buttons. You should need to add only the Title information for any given item; the rest of the fields are optional. Once you've entered all the information you want to add, click Save and the item will be added to your collection.

Obviously, this is the slow way to go about things. I'd recommend this only if you have items that aren't going to be found via online services, because if you're adding any quantity of items it's going to take quite a while.

To search via online sources, click the Online Search button and select the service you want to use. For instance, if you're searching for audio CDs, you can search using Amazon, MusicBrainz, and FreeDB. With Amazon, you have the option of searching regional Amazon databases as well. Note that you can also do this via the Item Wizard, but it allows you to select only one item at a time, and otherwise works pretty much like the Online Search feature.

Provide the artist or title in the Keywords field and hit Find. Depending on the type of media, you can also search by barcode, ISBN, or the Amazon Standard Identification Number (ASIN) (the ASIN is the same as the ISBN for books).

Search results are displayed in the online search window. If you want to add one or more items to your collection, click them and hit Add Items. The window closes and you'll see the new items in the tab for new items for whatever module you're working with. Click Save and the items are added to your collection.

Data Crow loan administration
Data Crow loan administration - click to view

It may take multiple searches via Amazon and MusicBrainz to turn up all the CDs you want to add to your Data Crow database. Data Crow seems to be hard-coded to return only 10 results for any search, so if you're trying to add, for example, all of your Pink Floyd CDs to your database, a search will fail to report some of the titles you'd expect to see. Unfortunately, there doesn't seem to be any way to increase the number of results or search for the next 10 items -- re-running the search only provides the same 10 results.

If you have the CD in your computer, you can use Data Crow to search FreeDB for information. If you have a lot of CDs, this can be a time-consuming way to add items to your database.

Unfortunately, many of the search results lack an image. You can add an image to an item that doesn't have one, but the way to do it is not obvious. Double-click on the item you want to edit, then select the Picture Front tab. You'll see a big question mark, but no "add image" button. Double-click on the question mark to bring up a picture viewer dialog. Click on the small folder to the right of the dialog and navigate to the image you want to add. Click Save, and then click Cancel to close the item window.

To add data from a tab-delimited text file, go to the Tools menu and select File Import. Click the folder next to "Select source" in the File Import dialog and then click Apply. Data Crow will let you match up the fields in the text file with the field names used by Data Crow. After you've done that, click Run and Data Crow will import the file.

You can use Data Crow to manage images too. Select Images from the left-hand list of modules and then click Import. You'll see an Image Import dialog, which you can use to select a directory of images to import into Data Crow. Give a location identifier (just a name for the directory) and click Run. After Data Crow has imported the pictures, you can click Cancel to exit the dialog.

Though I like Data Crow for managing movies, books, and music, I prefer digiKam for working with my photos. Data Crow lacks a lot of features that you find in specialized photo management apps, such as the ability to resize, crop, and rotate photos.

Note that Data Crow has a third tab in each module called Blocknote for saving notes about your media collection, like the books and CDs you want buy. I haven't found much use for this feature, but if you keep notes about your media collection, it'll come in handy.

Item views

Data Crow offers two views of your collection: a "card view," which displays thumbnails of your media's artwork (if available) and the title, and a table view, which displays the data in a spreadsheet format. You can toggle between the two by using the View menu, or by pressing F2 for the table view and F3 for the card view.

The table view is particularly useful if you want to go through your collection to edit information you grabbed online or by importing information from another source.

Tracking loaned items

Once you start to amass a respectable library, you might want to loan out books, movies, and CDs to friends and family. You can track loaned items by adding people to the Contact Persons module, then double-clicking an item and selecting the Loan Administration tab, as in this figure. Select the Contact Person you want to loan an item to, and the start date if it's different from the current date, then click Lend this Item. Once you're done, just click Cancel. It seems more intuitive that you'd click Save after adding the loan information, but Data Crow just complains that there's no information to save.

Once an item is returned, you go back to the Loan Administration tab and click Return Item. Again, to exit the dialog, click Cancel.

You'll also be able to see the lending history for any item under the Loan Administration tab. This is useful when you go looking for your copy of The Lust Lizard of Melancholy Cove and can't find it on the shelf, and can't remember who you've loaned it to.

Backing up your collection

After you've spent time entering hundreds of books, CDs, DVDs, and whatnot into Data Crow, you'll probably want to make a backup of the database just in case you have a catastrophic disk failure or just want to import the database onto a different system.

To make a backup, go to the Tools menu and select Backup & Restore. All you need to do here is select the directory where you'd like to save the backup, and click Backup. One word of caution -- the backup does not seem to carry over to cover images. I did a few tests of the backup/restore functions and noticed that if I deleted items and then did a restore, the items were re-imported, but the cover images were gone.

Reports

If you want to share a list of the items you have in your media collection, you can use Data Crow to generate a report with information on all of your media. For instance, if you want to share your CD collection, just go to the Audio CD tab, then go to Tools -> Create Report, or just press Ctrl-e. That will bring up the Create Report wizard. You can select/deselect the data fields you want in the report and give Data Crow a name for the file Data Crow will create when it generates the PDF.

If you're really particular about the format, you can adjust the header, footer, font, and colors used for the report. Just click the Settings button and tweak to your heart's content.

The only thing missing from Data Crow is a way to scan bar codes on media, which would make it easier to build your database in the first place. Other than that, it's an excellent program that is well worth trying for anybody who wants a way to track their media collection on a Linux system.

Share    Print    Comments   

Comments

on Manage your media library with Data Crow

Note: Comments are owned by the poster. We are not responsible for their content.

I've Never Really Understood

Posted by: Anonymous Coward on February 06, 2007 11:21 PM
I suppose that I must not have as large collections as some people, or perhaps I am simply the disorganized type but, I have never really seen the need for applications such as this. If I was running a video store or library, sure. But, for a personal collection I've never really seen the point.

But, there must be a lot of demand for it because there are countless collection manager applications out there. Looking at SourceForge collection managers seem only slightly less popular than borked MP3 players, which number in the kajillions.

The strange thing to me is that there is a need for a collection manager type application that doesn't seem to be being filled, that is file or records management for businesses. I referring to the manila file folders that store paper records and are being invariably lost in offices everywhere. Think of the racks of these folders in doctors and lawyers offices, banks and all other types of businesses where numerous people access and move these paper files around.

A collection manager that tracked these file folders and reported where they are and who had them last would be a very useful application, in my mind. But, I don't see any of these. I only see CD collection managers which, like I said earlier, I don't get. Mine are easily managed by a bookshelf or an iPod.

#

Re:I've Never Really Understood

Posted by: Anonymous Coward on February 07, 2007 02:48 AM
Agreed. While I find these applications interesting, I do not really see myself making much use of any of them. What I would like to see is a more generic kind of data/thing manager. Something customizable so I can eeasily tailor it to the kind of thing I want to keep track of.

For instance, if I want to keep track of wine, it should be easy to add varietal, quantity, etc. and reduce the count when I drink them.

If I am a lawyer and want to keep track of wills, court motions, etc, it should be easy to organize these by case or client and link documents, urls, etc.

My thought is something like the Eclipse development environment with easy to create plugins that could be shared by the users.

I suppose that is what OpenOffice Base is supposed to be, but I am thinking somethihng a bit simpler fro the end user.

#

Re:I've Never Really Understood

Posted by: Anonymous Coward on February 07, 2007 04:00 AM
What would really make these useful is a barcode scanner, so you're not faced with typing in all kinds of data manually. As the OP said, when your CDs are all lined up on shelves, why do you need a big ole complex time-eating database? Then a checkout/checkin system would be easy, and actually useful. For example, if you loan out books or CDs, swipe them in and out, and then all you have to do is make notes like "loaned book to Tom. Tom likes to read in the bathroom- inspect carefully upon return."

#

Re:I've Never Really Understood

Posted by: Anonymous Coward on February 07, 2007 05:07 AM
bar code scanners generally work like a keyboard. Instead of pressing keys, the scanner simply translates the barcode into "keys" to be pressed. You should be able to grab any bar code scanner and be off to the races.

If someone knows of a scanner that does not simply run through the ps/2 port as an alternative keyboard then, I stand corrected.

#

Re:I've Never Really Understood

Posted by: Anonymous Coward on February 07, 2007 09:54 PM
The CueCat had both PS/2 and USB versions. You need a modified version to use it as a plain ole Bar code readers.

There are stand-alone models that are quite a bit more expensive, but you would want the more standard variety for this kind of application, I think.

#

Re:I've Never Really Understood

Posted by: Anonymous Coward on February 07, 2007 04:10 AM
"For instance, if I want to keep track of wine, it should be easy to add varietal, quantity, etc. and reduce the count when I drink them."

www.cellartracker.com

While some sort of generic application can do lots of things half-well, there is nothing like a good application to do one task well. And in this case, it works really nicely with keeping track of reviews, notes, tells you "when" to drink things, etc.

#

Re:I've Never Really Understood

Posted by: Anonymous Coward on February 07, 2007 05:44 AM
My collection is rather large, and several times I have found myself buying a book I already had. It's really annoying going to a book store and buying a book (sometimes even hard covers) that is in the "New Releases" section only to find out later that it is actually 9 years old!!! Doh! Check those copyright dates.

If I can save a copy onto a palm pilot or something, then I can make sure this doesn't happen.

#

Compulsive or ADD??

Posted by: Anonymous Coward on February 07, 2007 06:30 AM
several times I have found myself buying a book I already had.

I find this to be s strange phenomenon. Is the problem that you need a collection manager or is the problem that you are a compulsive consumer? Or perhaps you have a disorder that causes you to forget books that you have read.

Personally, I would get some psychologocal help if I had a compulsive disorder or I would concentrate more on my reading retention and comprehension if that were the problem. I just can't imagine accidentally repurchasing a book that I have already read. Even if this was a problem for me, a collection manager still wouldn't help as I would be unlikely to have access to it while strolling through the mall or bookstore.

Now, if you are about to tell me that you are never without your collection manager because of an ssh connection via your EVDO enabled PDA/laptop, or some such scenario, then I would have to suggest the compulsive disorder as a likelihood.

#

Re:Compulsive or ADD??

Posted by: Anonymous Coward on February 07, 2007 10:23 PM
Yes, I admit it. I'm a compulsive reader. My book collection spans 25 years of reading on average, a book every two to three days. That's a LOT of books. While I retain a lot of information from these books, I don't have a photographic memory, and therefore can't remember the titles and exact contents of the ~3000 books in my collection... So yes, I sometimes buy duplicates.

If you brush up on your own reading comprehension, you will see that I never claimed to have a collection manager, but that I thought it would be useful. I also mentioned exporting it to a PDA, not having a real-time connection to some collection manager on my home PC.

It's probably not a good idea to go around criticizing someone about reading comprehension when it's quite clear that you don't have any yourself. Idiot.

#

Re:I've Never Really Understood

Posted by: Joe 'Zonker' Brockmeier on February 08, 2007 06:28 AM
You might not have a large enough collection to need something like this, but there are plenty of valid reasons:

1. Insurance purposes -- if you have a large collection, keeping a list is a good idea in case of fire, theft, etc. (I'd also recommend taking pictures of the collection.)

2. Send a list of what you have to friends / family so they can get you CDs/DVDs/books for Christmas/birtdays/whatever without worrying about duplicating what you have already.

3. Send the list to friends you might want to swap media with. "Oh, hey, I see you've got David Bowie's 'Heroes,' can I borrow that?"

4. Most importantly, just because you can.

#

tellico

Posted by: Anonymous Coward on February 07, 2007 09:15 AM
Hm, I'll pass at this one. The UI is too inconsistent with what I'm used to, which is KDE.

Others might want to take a look at Tellico (<a href="http://periapsis.org/tellico/" title="periapsis.org">http://periapsis.org/tellico/</a periapsis.org>) too.

For myself, I have some little need for a collection manager, even though I have hundreds of music albums in various media (cds, vinyl, mp3, flac). I find it important to use a _player_ that can quickly look things up, but I've tried using collection managers and found that I just don't use them enough.

One thing I appreciate and continue to use them for is for keeping track of what I don't have but want to check out, or to buy. People suggest movies/books/music all the time, and without writing it down, it's easily forgotten. Of course, a collection manager should make this process easy enough as writing it down on a piece of paper, with lots of added benefits. At least Tellico does this for me.

#

Sounds evil

Posted by: Anonymous Coward on February 07, 2007 11:09 PM
The name "Data Crow" sounds evil.<nobr> <wbr></nobr>:D

#

I agree

Posted by: Anonymous Coward on April 25, 2007 05:48 AM
This sort of thing is a waste of time, just another way to look at all the things you've collected.

I do use mediamate just to keep track of who I have loaned things to, and only put the things I loan out in there. Too many people have kept my stuff and I am very absent minded / forgetful.

#

Time wasting saver

Posted by: Anonymous Coward on May 19, 2007 01:03 AM
Instead of importing information from Amazon, you could just use their application called <a href="http://amazon.com/gp/ays" title="amazon.com">Your Media Library</a amazon.com>. It'll auto-populate all of the media you've purchased on amazon. It supports software, but not images.

And since it's a webpage, it works just fine on Linux. Konqueror has some issues with it (it's very heavy on css & javascript), but FF works fine.

#

hmm

Posted by: Administrator on February 07, 2007 12:06 AM
looks pretty handy!

#

Re:I've Never Really Understood

Posted by: Anonymous [ip: 200.155.226.165] on December 20, 2007 08:02 PM
For me, this is actually a huge time saver. I have around 350 regular audio CDs, and it's amazingly hard to find the one I'm looking for. Even harder is keeping them in order: when you buy a new CD, it never fits in the space where it belongs, and you're always moving the CDs from shelf to shelf (and it doesn't matter if they're ordered alphabetically, by artist or genre).

With Data Crow, I'm using small numbered labels for each CD, and associating the number on the label with a field (auto-numbered) in the database. When I buy a new CD, I just place it in the last spot with a new label, import it in Data Crow, and it's all done. I'll do the same with DVDs as soon as I have more than 50 of them.

#

This story has been archived. Comments can no longer be posted.



 
Tableless layout Validate XHTML 1.0 Strict Validate CSS Powered by Xaraya