I've been tidying up my external hard drives, which involved merging several Lightroom libraries as well as importing a bunch of stuff that I haven't properly catalogued before. Unfortunately things have gotten extremely messy. Because it's so easy to use catalogues or arbitrary metadata filtering inside Lightroom, I want all the photos to simply be arranged in a
YYYY/MM/DD/file.ext sort of fashion in a single place. Right now, everything is sitting in the same master directory, but they're kind of all over the place inside there.
Is there a command like the "consolidate library" function in iTunes, which just moves all the files on disk to a specified location, based on metadata? I really don't want to do this manually because we're talking 30k+ files.
Moving files around needs to happen inside Lightroom. If I use an external tool, Lightroom will not be aware of the files being moved, and I will need to re-locate all the images. I'm using Windows 7, but since the photo archive is on an external drive I could potentially connect it to my Mac and do it there instead.