import images into container field in database table

Discussion created by glenncogar on Apr 25, 2014
Latest reply on Feb 19, 2017 by arjen.evertse

Hi, I am new to FM and I am trying to set up a new database solution to hold details of products I sell.


I have images of each of the products and I have created a container field in the products table in the database.


I know I can drag and drop the images into the relevant container fields for each product but I have 100's of products and I am looking for a way I can bulk update the relevant products with the product image from a folder on my Mac. I can match the product images to the relevant product records using the value of a text field I already have stored in the database i.e. value of field = xxx image file for that product = xxx.jpg


I was hoping I could do the updates with an import but I cant find a way of importing images to container fields.


Maybe I need a script to do this?


Can anyone point me in the right direction?


Thanks in advance