I have a video clip locator database which will have about 14,000 video clips from the past four years and growing at roughly 4,000 clips per year. When the clips are imported either into FCP or iMovie they are named Clip 1.dv, Clip 2.dv etc for each project, so with seven or eight projects a year there may well be 24 Clip 1.dv's. As each projects clips are held in seperate folders, when the clips in each folder are imported into the database, is there a way to automatically get the folder name or path name into a clip location field or do I have to copy and paste the location via a loop into the clip location field after each folders clips are imported.

See if this helps