Futterman From United States of America, joined Sep 2003, 1301 posts, RR: 39 Posted (11 years 5 months 2 weeks 9 hours ago) and read 3080 times:
In the midst of the "Do You Keep All Your Pics?" and other archival-related threads, storing photos on CDs, DVDs, or multiple HDs seems to be nothing more than just that. Storage.
I'm interested in having an A.net-esq personal database that would make it easy to locate photos via a simple search function.
Want all shots of an Emirates A345 landing at JFK on March 3? How about all La Guardia departures from July 7? I'm not sure the default Windows search feature would be able to cope with that.
Do programs like BreezeBrowser have anything like this? I really don't want to have hundreds of folders by date/airline/aircraft/location, dozens of discs to load up just to see what's on it, or a gallery (PBase) on the web. Maybe, "OK, Brian, here are your photos of Qantas 747s from February 2."
Well, it doesn't have to talk, but an organized program where I can save all my images to one place, put in a search query, and come up with what I was trying to find would be nice.
If any of you know the Jetsons, that might help too.
Benyhone From United States of America, joined Mar 2001, 206 posts, RR: 2
Reply 3, posted (11 years 5 months 2 weeks 8 hours ago) and read 3022 times:
I don't know of an off-the-shelf solution. But, keep in mind, that whatever "program" you end up with, it will take time on your part to input all of the bits of data you want to record (like date, place, type of aircraft). I don't know how you could get around that time-consuming step.
I used to do this for every print & slide I photographed, first into Excel, later Access. In Access, there are wizards to help you set up a "query", which once properly set up, will return the type of answer you are looking for. My old database did exactly that (... All America West B737-200s shot in January 1992, etc).
Lindy From , joined Dec 1969, posts, RR:
Reply 7, posted (11 years 5 months 2 weeks 7 hours ago) and read 2964 times:
I created Access database over 2.5 years ago. It takes a lot of time to enter the data. Right now I'm finishing just my prints, so far I've entered 6000 records. Also I have another 25 rolls of film waiting to be developed and aproximately 3000 digital pictures in line to be entered into database. Its time consuming but when you enter your data you can search anyway you like it. Here is the snapshot of the main form.
Futterman From United States of America, joined Sep 2003, 1301 posts, RR: 39
Reply 8, posted (11 years 5 months 2 weeks 7 hours ago) and read 2946 times:
Thanks for all the suggestions. I think Terry and Rafal have me bent on something with Access, so I'll see what it's all about when I get home in a few hours.
I gather it's a comprehensive, searchable database (but not photo storage). Entering the information and the time associated with it is no huge problem--it'll save me lots of frustration as well as the cash for hair-restoration procedures.
In the mean time, can anyone break down the 'development' stage of creating a database via Access for me? How do I start this off? You can post here or email me privately at firstname.lastname@example.org.
After spending time with dBase, Excel, Access this was the answer for me - unlike other systems which are essentially text based with links to images, Imatch uses the image as the core of the database with textual annotations.
Advantages for the photographer include ability to access EXIF info, handle most file formats (including RAW), span volumes (including CDs) and pattern match within the image database. Its shareware (free demo), reliable and amazingly fast - even with 10s of thousands of images.
Gerardo From Spain, joined May 2000, 3481 posts, RR: 26
Reply 10, posted (11 years 5 months 1 week 6 days 20 hours ago) and read 2866 times:
After having tried many database software packages, I decided to go with ThumbsPlus. It allows me to creat and manage an archive of all my CD's. I can now look for example for all "SWISS A332 at ZRH on take off" or "all SQ B744 on touch down in July 2002" and so on.
Lindy From , joined Dec 1969, posts, RR:
Reply 11, posted (11 years 5 months 1 week 6 days 13 hours ago) and read 2820 times:
Creating this particular database was very time consuming. If you want I can send you my blank dbase so you can try it.
I've send it before to other people from this forum. Here is Read Me First text. From this text you can get idea how does it work:
READ MEA Middle East Airlines (Lebanon)">ME FIRST!!!
When you click on FORMS another 5 options will be displayed
1.Add Photo Info
2.Add Aircraft Maker
3.Add Airline Info
4.Add Location Info
Option #1 - Add Photo Info.
This is main table where you will enter all your data. But before you enter any info you
should go and add AIRLINE INFO. I left some airline names in that field so they will show in the pull down menu when you go to main ADD PHOTO INFO table.
Option #3 - Add Airline Info.
Here you will add names of your airlines. Remember - Airline Code ID is your UNIQUE KEY. If you have pictures of United Airlines then Airline Code ID can be UA or UAL. You will have to enter it only once for each airline.
TIP - To make your life easier entering data to this database follow one rule. In Add
Airline Info enter name of (egz.) United Express with Code ID UAX, then when you are ready to enter United Express pictures, just pull down from the menu UNITED EXPRESS, and in Operated By field enter (egz.) Air Wisconsin or Atlantic Coast Airlines. Always try to minimize you AIRLINE LIST because it can take you some time to look it up in the pull down menu. (Like US Airways Express - I'm using CODE ID USX, which is universal, and in Operated By I'm typing PSA or Piedmont).
Option #2 - Add Aircraft Maker
If you have pictures of different type of aircrafts that are not in the database then just
add it there.
Option #4 - Add Location Information
I'm using 3-letter code for the airports. You can use either one, 3 or 4 letter codes.
3 letter codes will save you some space in your reports.
Option #5 - Back
Will take you back to previous main screen.
In the first field number will be assigned automatically.
Photo date - field is set for USA format (egz. 10/29/99 - Month/Day/Year)
Location - Select desired location
Airline Name - Whatever you have entered in Add Airline Info box, this will be displayed in that pull down menu.
Aircraft Maker - if something is missing here just add aircraft in Add Aircraft Maker box.
Aircraft Type - Purposely I didn't make it Pull down because your list would be endless.
After selecting Aircraft Maker (egz. Boeing) type 757-223, or just type 757-200. I'm typing 757 or 757-200 because it takes less time and after you enter 100+ pictures you can do batch update which saves you lots of time.
Rest in this table is pretty easy and you can figure it out by itself.
* REMEMBER!!!!!! PHOTOID IS YOUR UNIQUE/UNIVERSAL PICTURE * *NUMBER. DON'T *
* CHANGE IT IN DATABASE WHILE OPENING WITH THE SHIFT KEY. * * *
On the very bottom of your ADD PHOTO INFO Table you have 3 icons.
1.Diskette with pencil - it saves your record
2.Two Tables - Registration Number Search option (good for batch updates)
3.Door - Exit to Switchbox
BDLGUY From United States of America, joined Dec 2000, 194 posts, RR: 4
Reply 12, posted (11 years 5 months 1 week 6 days 4 hours ago) and read 2785 times:
As a tail numbers collector, I use an Excel for my aviation logs database but in the future, I am planning to create my new "Aviation Logs" in the Access database. Does anyone use the Access database for logging the registration numbers? I am interested in seeing the sample Access database like Lindy posted his cool "Aviation Photo Database" in this forum which would help me some ideas what I want to create the Access database for my registration number logs.
Thanks a lot!
John A. Perrotta (KBDL/BDL) - Canon 300D/400D & EF 75-300mm f/4-5.6 IS USM
Bruce From United States of America, joined May 1999, 5089 posts, RR: 13
Reply 13, posted (11 years 5 months 1 week 6 days 2 hours ago) and read 2754 times:
I use an Excel database which I created. it holds all of the info about the airplane and/or the shot but it doesnt actually have a link to the photo on my h/d, I supppose i cold put a link in one of the colums but i am not an excel expert. The "finished" aviation photos are saved on my h/d with the filename being the photo id number so i can cross reference a picture from my excel db.
Also, Excel has a function called auto Filter for each column so I can with a couple of clicks sort thru my 1,359 a.net uploads and see that of Comair I have 22 shots of CRJ-100, 6 shots of CRJ-700, 9 shots of CRJ-200. I just have not figured out how to sort by unique reg #s since i might have 2 shots of one plane.
I looked at Lindy's Access database but for some reason Access seems quite complex for me.
Breezebrowser doesn't do what you are looking for, Brian. If you'd like a sample copy of my excel database to see what it looks like just write me.
Karlok, what program do you use for that? Excel or Access or ?
Bruce Leibowitz - Jackson, MS (KJAN) - Canon 50D/100-400L IS lens
Futterman From United States of America, joined Sep 2003, 1301 posts, RR: 39
Reply 14, posted (11 years 5 months 1 week 6 days 1 hour ago) and read 2750 times:
Wow. Lots to cover...
Although not SO expensive, I don't want to buy a program right now. Elaborate file conversion and filing formats are nifty, but basically all I'm after is a database with complete photo information and where to find it--not necessarily something that'll fetch the image...I just want it to tell me where it is. If it saves me $50+, I'm not complaining.
(Actually, disregarding what I just said, I'll keep www.photools.com in mind. If it's good enough for Colin, well, it's good. )
Rafal, the readme looks interesting and I think it's worth a shot. It seems as if Access isn't on my home PC, so I'll try and get the copy of MS Office from my dad's office to download it.
He (dad) did tell me, though, that creating a database with Access is as thorough and complicated as the new inventory management system that the distribution company he works for just implemented.
You have mail.
Bruce, I think Excel is a little too basic for archival purposes like these--an 'automated' system like the ones Karlok and Rafal have created (and to which Royal and Colin have linked) practically ensure a consistent, even display of information where formatting grids and messing around with information isn't necessary.
Thanks. I MAY buy a program, I may not, but something about the elbow grease associated with Access appeals to me.
Elbow grease...yeah, and if my flexing self-portrait comes to mind...go figure, right? lol
Basically each table except tblImage contains a unique key (auto generated int) and the description. tblImage contains the image info, plus the look up info for each of the four info tables.
So the query would look something like:
Select tblImage.ImagID, tblImage.ImagDesc, tblImage.AircID, tblImage.AirlID, tblImage.AirpID, tblImage.ManuID, tblAircraft.Aircraft, tblAirport.Airline, tblAirport.Airport, tblManufacturer.Manufacturer
LEFT JOIN tblAircraft on tblImage.AircID = tblAircraft.ID
LEFT JOIN tblAirline on tblImage.AirlID = tblAirline.ID
LEFT JOIN tblAirport on tblImage.AirpID = tblAirport.ID
LEFT JOIN tblManufacturer on tblImage.ManuID = tblManufacturer.ID
or something like that, im watching Major League now, great movie
Bronko From United States of America, joined Jul 2001, 810 posts, RR: 10
Reply 16, posted (11 years 5 months 1 week 5 days 23 hours ago) and read 2708 times:
Royal, I would be happy to help test your app, being in the software testing biz and all.
I just setup a server for home that has a 750 GB RAID 5 array, and I want to get serious about setting up a database. I have lost a few sales because I could not efficiently find the photo(s) of the plane in question.
Clickhappy From United States of America, joined Sep 2001, 9823 posts, RR: 64
Reply 17, posted (11 years 5 months 1 week 5 days 22 hours ago) and read 2707 times:
The front end takes the query results, and outputs a thumbnail gallery. From there you can click thru to a larger version of the file. I don't store the image as a BLOB, rather the path of the image is stored in tblImage.
Still trying to work out the directory structure for storing the photos. Am open to suggestions on that. Im storing the actual RAW file name, so it would look like something like: