I have only been working on my families history for almost 2 years now, but especially in the last 8 months I have collected a huge stash of photos, audio, documents, and even just a touch of video. I have over 17,000 files which takes up just over 50 gigs. My final destination for all of this of course is not where it is currently, but a Wiki that I have made and use for my family. If anyone is interested I can make a post about said wiki because it really is an amazing, especially to help share with family.
My question here is what is the best way to keep it all straight? There is a lot of information that I know simply off the top of my head, but there is probably more that I just don't know who/when/where. I can slowly find out which isn't the problem, but when you have well over 5000 photos where do you store that information of who is in each, when it was taken, where it was taken, and why?
When I only had a few hundred photos I just used a spread sheet, that worked well, but now the problem is that with so many photos is there a better way? I know Windows Live Photo Gallery has a tagging tool, which does all of that very well (especially the tagging of people, so in a large group you know who is actually who), but does that information carry over to other systems well? Like if I sent it to a Mac, will they be able to see those tags?
How do you keep it all straight?