Sponsor Message:
Aviation Photography Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
My Own Aviation Photo Database!  
User currently offlineKaitak From Ireland, joined Aug 1999, 12463 posts, RR: 37
Posted (14 years 6 months 1 week 4 days 23 hours ago) and read 1634 times:



Instead of spending hundreds on a programme for your photos and reggies, why not build one yourself using Microsoft Excel (assuming that 90% of those who access the internet have access to Microsoft Excel).

You can find this when you select "programs" from the drop down/up box where you have "Start". On Excel, you can set up boxes in such a way that you can have the info you want.

If (like me) you have your photos in albums, you can separate them like this:

Aircraft reg
Aircraft type
Airline
Where photographed
Date (roughly)
Which album
Which page

That way, if you need to find a photo, you can go to Excel and ask, by aircraft reg, where it is, and it should,hopefully, bring up the entry for the aircraft,
e.g.

EI-CPD A321 Aer Lingus LHR August 1998 Album 2, Page 10

You can also sort the registrations in alphabetical order, or in any particular
order you wish - e.g. start with Airbus and working in numerical order, e.g. A319 up for Airbus, the 707, 717, 727 etc. for Boeing.


7 replies: All unread, jump to last
 
User currently offlinePlanefreak From United States of America, joined Jan 2000, 202 posts, RR: 0
Reply 1, posted (14 years 6 months 1 week 4 days 21 hours ago) and read 1371 times:

Good idea! It sounds like a winner, however I have my pictures grouped into books of airlines, not the aircarft. I guess you can do it anyway you like. I am currently writing down N numbers on the bottom of photos in the books inorder to present them at trade shows.

Planefreak


User currently offlineLindy From , joined Dec 1969, posts, RR:
Reply 2, posted (14 years 6 months 1 week 4 days 14 hours ago) and read 1361 times:

Yes, but tell me what I should do if I dont keep pictures in albums. Albums only destroy pictures. I would like to make some kind of data base of my pic collection. I have over 5000 pictures, but I keep them in the shoe boxes.

Rafal


User currently offlineAirliner From Germany, joined May 2005, 0 posts, RR: 0
Reply 3, posted (14 years 6 months 1 week 4 days 8 hours ago) and read 1361 times:

have you tried Microsoft Access for your database. Its the way to go. Store your own pictures and data on each shot.
Very simple to add pictures and update your shots.


User currently offlineFlyf15 From , joined Dec 1969, posts, RR:
Reply 4, posted (14 years 6 months 1 week 3 days 18 hours ago) and read 1347 times:

I have all mine cataloged in Borland Quattro Pro. Each photo has a serial number. The info I store is:

Serial Number
Operator
Aircraft
Location
Date
Reg#
Special Flight info
Negative serial number (yes, I have all of them cataloged too)
Remarks


User currently offlineHawaiian717 From United States of America, joined May 1999, 3193 posts, RR: 7
Reply 5, posted (14 years 6 months 1 week 20 hours ago) and read 1349 times:

A database program like FileMaker or Access is better suited to this task than a spreadsheet like Excel. Personally, I built a HyperCard program to function as my database, and included the functionality to generate the pages for my web site as well. Windows users could probably do something similar with Visual Basic.

User currently offlineKaitak From Ireland, joined Aug 1999, 12463 posts, RR: 37
Reply 6, posted (14 years 6 months 6 days 23 hours ago) and read 1341 times:

I've now got up to No.1000, although I'm only getting about 50-60% logged, as I'm sticking to ones where the aircraft reg. is clearly legible.

As for Excel, I find it quite alright. It does what I want it to do, which is fine. For example, if you want to find a particular acft, scroll down from EDIT to LOOK FOR (with binoculars beside it), select "By columns" and "values",enter your reg in the box and press "Look Next" and it'll take you right to it. I don't know about the other ones, but Excel does I all I want.


User currently offlineDazed767 From United States of America, joined May 1999, 5498 posts, RR: 51
Reply 7, posted (14 years 6 months 1 day 11 hours ago) and read 1335 times:

I actually do that, with flights I've been on. Airline, Aircraft, Depart, Arrive, Reg# etc.

Top Of Page
Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

Similar topics:More similar topics...
Aviation Photo Database Release Candidate Version posted Sun Sep 26 2004 18:44:00 by Karlok
Aviation Photo Database Beta Testers posted Sun Sep 5 2004 18:52:32 by Karlok
My Own Aviation Photo Database! posted Thu Mar 9 2000 18:43:05 by Kaitak
Cheap Camera For Collecting My Own Airliner Photos posted Sat May 5 2007 08:59:43 by Yellowstone
Netmodels Stole My Moon/AF Photo. posted Tue Apr 10 2007 15:25:52 by Tappan
Eurocontrol Photo Database Update To Photographers posted Thu Sep 7 2006 11:19:53 by FlyAUA
Linking To My Own Photos posted Sun Jul 9 2006 21:11:37 by Hpr7
How Can I Improve My A380 (LHR) Photo? posted Tue May 23 2006 17:13:25 by SmithAir747
A Nice Surprise (My Yak 52 Photo) posted Thu May 4 2006 23:26:04 by LHRSIMON
Whoo Hooo My First Special Photo. posted Sun Mar 19 2006 00:10:59 by Pauara