I have 300 product photos in server, in library/filemaker server/data/documents/photos-tcm folder.
In my table I already have the filenames.
I'd like to use the following script to insert the references into a container field, as not to bloat the solution (smaller backups).
I have a feeling that when I run the script on a client machine it searches for the images on the client and not on the server. (path_img is just for verification).
Go to Layout [ “Photos_MP” (Photos_MP) ]
Show All Records
Go to Record/Request/Page [ First ]
Set Variable [ $path; Value:"<documents>/Photos-tcm/" & Photos_MP::nom_img ]
Set Field [ Photos_MP::path_img; $path ]
Go to Field [ Photos_MP::photo_mp ]
Insert Picture [ Reference; “$path” ]
Go to Record/Request/Page [ Next; Exit after last:on ]
Instead of <documents> I have tried filemac:/Macintosh HD/.../Photos-tcm, filemac:// file:// etc
Could it be that Library in french mac os is Bibliothéque, and has to be used as such in the path?