Batch Importing and Merging: a) photos and b) excel with image descriptions
I am new to FileMaker and evaluate how easily I cam make it work for my only use case: I am helping my dad to organize his collection of old cameras, photos etc.
I already know that FM does most of what I need, and am confident to figure out most. I would appreciate support in getting started though: Importing all information.
Starting points are:
- a folder with 2,000images
- an excel file with different columns, describing all images. The spreadsheet contains a column that has the exact image name and path
How can I import both sources and merge / match them?
one way would be to use a different tool to write the metadata from the excel to the image, and then use the getcontainer script (though I don't know yet how to use it). That seems to involve too many error prone steps though, and might limit how I use the fields in FM for items that would be added later.
I much appreciate help on the direction I need to investigate, don't need a step by step guide (I hope ;)