Attaching multiple mediafiles to catalogue

[Rolf Howarth]

Try the following steps:

Save the Excel spreadsheet as tab separated text. If necessary, add a row of columns at the top, and maybe add an extra column which contains something that looks like timecode 0:00:00:00. After playing around a bit you should be able to import the tab separated text file to end up with one clip per row in CatDV, but without the thumbnail attached. You might already have done this by the sound of it. If not, see https://www.squarebox.co.uk/faq145.html for additional tips.

Next, import all the JPEG files, into a separate window if that makes it easier. You should have the same number of clips in each window, one with metadata and no media, the other with media and no metadata. Sort both windows so they’re in the same order (eg. based on image file name), then select all the clips with no thumbnail and do Edit > Copy. Then select all the clips with thumbnails and do Edit > Paste Metadata.

[Andrew Pearson]

Hi Rolf
That worked great! You’re right – I’d managed to import the metadata, tho’ your link is useful to confirm my hypotheses! I’d also imported the jpegs on a seperate occasion, but missed the ‘Paste Metadata’ bit. Now that works too. I just have to go back to the owner to clean up his work and make sure each jpeg has a discreet catalogue entry, as there’re some discrepancies, it has become apparent…

Is there any way to actually link a metadata object to the correct filename, or is it just a matter of getting it right in the pre-import stage?

Thanks for your help
Andrew

Andrew Pearson
British Library