glenncogar

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

Outcomes