Aircraft Spotting Database

Read the forum code of contact

Member for

17 years 2 months

Posts: 763

Hi all

I am looking for an easy to use database that I can serach by date, aircraft type, location and registration that I can transfer the info I have in my excel database log into it. I'd like ideally to be able to upload pictures as well of each aircraft if possible.

Any suggestions are welcome.

Thanks

Rich

Original post

Member for

24 years 2 months

Posts: 16,832

If you can locate a copy of Lotus Approach (Not made for at least fifteen years) it will do all you need and is quite easy to learn.

Used to come as part of a Lotus Suite with a spreadsheet and a word processor

Found it: http://www.amazon.co.uk/Lotus-SmartSuite-9-8-2-Windows-XP/dp/B0027CLI7I/ref=sr_1_1?s=software&ie=UTF8&qid=1416779721&sr=1-1&keywords=lotus+smartsuite

Will run on Windows 7 with a bit of fiddling apparently

Moggy

Member for

24 years 2 months

Posts: 4,887

If you do not mind me asking, why do you want to move away from Excel? Except for uploading the photos it does everything you need. Microsoft Access does the same, againt without uploading photos, but can better handle large volumes of data.

What you can also do is use Adobe Lightroom. It's a photo editing and databasing program. You can assign keywords to each photo. Thus you can assign B737, KLM, AMS etc etc. I do not use the program myself but I've been told it is possible to upload the data from Excel as well.

Member for

24 years 2 months

Posts: 16,832

So in Excel you can search for (say) All Tornados seen in Scotland during 2002?

If so, any chance you could let me in on the secret as it will solve a huge work issue I am facing?

Moggy

Member for

17 years 2 months

Posts: 763

Thanks for your help guys, but one of the guys on AiX has come up with something that looks quite good. http://www.planebase.biz/

Cheers

Rich

Member for

24 years 2 months

Posts: 4,887

So in Excel you can search for (say) All Tornados seen in Scotland during 2002?

If so, any chance you could let me in on the secret as it will solve a huge work issue I am facing?

Moggy

You can just drop in a filter:
https://support.office.com/en-ca/article/Filter-data-in-an-Excel-table-7d8e9739-2898-4bfe-9d0f-c6204e6e5c8a?ui=en-US&rs=en-CA&ad=CA

Or create a pivot table:
https://support.office.com/en-ca/article/About-PivotTables-12104365-1fa9-46b1-bc4d-15c6d3d98c7a?ui=en-US&rs=en-CA&ad=CA

Member for

24 years 2 months

Posts: 16,832

Thanks. I'll take a look at that when I get to my desk.

Moggy

Member for

6 months 2 weeks

Posts: 1

You could try out SpottingHub it’s a new platform to the plane spotting world and one of the cheapest https://www.spottinghub.co.uk