AnsweredAssumed Answered

Scripting Insert Picture on server

Question asked by paulkana on Jul 11, 2018
Latest reply on Jul 12, 2018 by monkeybreadsoftware

Hey,

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 ]

Loop

     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 ]

End Loop

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?

Outcomes