I have images (student id photos) in jpg format. I have a csv file that contains two fields, one contains a value from a field in the FMP database (an id) for the student and the other field is the name of the image that is related to that student. Very simple two columns: student ID and student photo filename. There are no duplicates for either of the fields in the csv.
The solution is hosted by fmphosts.com. I have a container file on the layout where I want the photos to appear and some have photos that have been dragged into the container and that works fine, but I do want to overwrite the current photo with the new one.
Where do I put the actual image files so FMP "find" them in the hosted environment?
I can envision a script that might do this, but I've not worked with container fields in scripts before. I could certainly import the jpg filename into a field in the table, but I'm not sure how to "connect" the data in that field OR the data in the csv to the actual jpg files.