Basic Script Help for Beginner

[MarkSQL]

Hi, 

 

My client has photos stored in a container field in a table. There are a few thousand, so obviously I need to script it. There are some examples for scripting an export from container fields out there, but I'm getting stuck with an 800 error "filename could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk." I'm trying to write to my /tmp/ folder, so permissions shouldn't be an issue and I don't see any other obvious problems. I've attached a screen shot of my script. Any ideas?

 

Once I get past this, I guess I'll see if the looping actually gets me through all the records in the table. 

 

Thanks!

Mark

[comment]

I'm trying to write to my /tmp/ folder, so permissions shouldn't be an issue and I don't see any other obvious problems.

 

This error usually indicates an invalid path. If you're trying to write to the (Filemaker) temporary folder, use the Get(TemporaryPath) function to get its path.

 

See also:

http://fmforums.com/forum/topic/45545-looping-script-to-extract-container-jpegs/?view=findpost&p=212714

[MarkSQL]

Hi Comment,

 

Thanks. I'm using Get ( TemporaryPath ) now, but I'm still running into the issue. I even used the data viewer to see the filepath to the temp folder and set full 777 permissions to that folder, just in case. 

 

The data viewer shows my filepath as "filemac:/Macintosh HD/private/var/folders/2y/cs6gwg3s07j7j9k8n7px7f9h0000gn/T/S10.3/C00001.jpg". The expression is: "filemac:" & Get ( TemporaryPath ) & Contacts::_k_ContactID & ".jpg"

 

The other post was useful and helped me add a Show All Records and Go To Layout at the beginning. Attached is my updated script steps.

 

Thoughts?

 

[comment]

I am afraid I don't see anything out of the ordinary. Can you reproduce the problem in a new file? Or using a path to a folder on the desktop?

[MarkSQL]

I figured it out mostly by copying this thread: http://www.filemakertoday.com/com/showthread.php/30469-Filemaker-Pro-12-Export-images-script-loop-nube

 

Attached is the script that works. I think my filepath was invalid.