Getting Your Mac Disk Catalog into a FileMaker Database

Diskcatalogmaker

I don’t know about you, but as a FileMaker developer, I have about 12 usable hard drives in my house. I don’t seem to ever get around to reconciling them so that I can stop buying hard drives for a while.

I was getting into the project last night because I have a misbehaving 1 terabyte drive I need to exchange. That means I need to move a terabyte somewhere else temporarily. To do this, I need to eliminate 1 terabyte worth of redundancy in a hurry.

So, I figured, I’ll create a FileMaker database: a table called hard drives and a table called folders. I looked in Automator to see if it would take a folder and give me a list of its contents as text. Let me know if I missed this. I can’t imagine someone hasn’t added this to an automator script but I couldn’t find one on short notice. That lead to me typing in about 50 folders and a couple drives. NOT!

Today is a new day, and I wanted a utility to give me the contents of a drive as a text file. Voilà, I found one called DiskCatalogMaker and it works great. Prints catalogs. It’s fast too.

You get 60 days to try this out with full functionality so that’s where I am with it for now. MacDiskCatalog is a nice little Cocoa app. VERY straightforward. You select Scan and it gives you an open dialog. You select a hard drive and it scans that sucker into its own catalog in 3 minutes or so for maybe 300 gigs of files.

Then you have a nice and handy export to text button. It creates a tab-delimited (I think) file with 5 fields: Name, Size, Type, Creator, Date Modified. I just dragged and dropped the exported text file onto FileMaker Pro 9 Advanced and it gave me the option to use the first row as field names – choose yes.

I wound up with a 179 mb file after I had done some Finds and Replace commands on it. Name is the full file path with the file name at the right of that path. I got rid of the hard drive as part of the path for my current purposes and put that name into its own hard drive field. I can always create a calculation to get that drive name back into the path if I need it.

From here, I’ll do a bit more cleaning and perhaps export summary data cause I don’t really want to know all the files on here or at least want to work with less than about 500,000 files for most purposes. If you want to be able to use filemaker to see how many copies of things you have, give DiskCatalogMaker a try!

For me this is fun and is a great relief. I might learn something about FileMaker 9’s capabilities when handling a 1/2 million records at a time along the way. Remember, I got a lot more hard drives left to do but it is going to be very fast to get them in here.

Now that I have my hard drive files and directories safely in FileMaker, I’m still playing around with DiskCatalogMaker to see what all it can do. If it was smart enough to tell me what to delete without my searching on big folders, I’d be totally sold. As it is though, I’ve got a terabyte I need getting rid of and I think I can use it to guide me to some quick scores.

3 thoughts on “Getting Your Mac Disk Catalog into a FileMaker Database

  1. connectionfailure

    Also CDFinder can do stuff with FileMaker as well. That is, the developer provides a sample database which calls an AppleScript that can retrieve the data catalogged by CDFinder.
    Disclaimer: I own a license for CDFinder but I don’t work for them.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *