Jump to content
Sign in to follow this  
Dave Martin Austin

Auto-filling container fields from URLs

Recommended Posts

Okay. I am building a FMP database to keep track of my Cafepress shops. I want one to simply contain all my products, including images.

I can create the URL to the image from the product number, but want to be able to use that to pull the image into the container automatically, rather than going record by record, click the button link to the URL, then copying the image manually, returning to FMP and pasting.

With all the automation options -- FMP scripting, AppleScript, Automator -- you'd think it would be a breeze to do this.

Does anybody have any suggestions?

Thanks.

Dave

Share this post


Link to post
Share on other sites

A combination of FileMaker and AppleScript, using:

do shell script "curl theURL > local_path"

This downloads the image to a local path, say the desktop, to a fixed file name (assuming you're embedding the image in FileMaker, and don't want to keep the file). FileMaker can then import it. Then you can use command line again to remove the file.

do shell script "rm local_path"

I recently uploaded a file showing this (hopefully this path works from here):

http://www.fmforums.com/forum/attachment.php?attid/11007/

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.