Hi,

I'm trying to set up a database in wich different user can add digital
images from their digital cameras. I don't want to link the container to the
content, because if the camera is gone, the link is broken. I also don't
want the files to be embed in the database because it soon will have a very
large filesize.
Therefor I want Filemaker to store the content of the container field
automatically in a specific location (directory). I thought this could be
done with the "exporting field" script but I can't specify a specific
directory in Filemaker.
Using the export field command only works with a dialog box, but in this
case the user will have to specify the destination directory and I want to
run the script without a dialog box.

This is how it should work:
1 - User hits the import button
2 - Dialog box pops up and user select the file to import
3 - FileMaker copies the file to a specific location (no dialog box!)
4 - FileMaker shows the image in a container field using a link to the new
storage location.

Sounds simple, doesn't it??

Newbe from Holland, Using FMP8

Sharky

It does sound simple but FileMaker is a database.
It would be nice if it could create move, create, and delete files &
folders but it can't.
Try the Troi-File Plugin.

In FM8, you should be able to set a variable to your desired folder path
and file name, and then use the variable name (i.e. $$FilePath) as the
destination in your Export script step.

For your link, just be sure to store the path and file name in a text
field after you've imported it. Clear the container where the user
placed the original image, and then import from that location as a
reference link only.


Sharky wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

Anyone ???


"Sharky" <mistermister2003 (AT) hotmail (DOT) com> schreef in bericht
news:b2484$4374d314$3ec2a2bb$9423 (AT) news (DOT) chello.nl...

I think Howard gave you the solution. But to be explicit: write the
following script (this is designed for windows and sends the contents
to the current user's desktop with a fixed filename- but all of this
can be done in a calculation field.)

Set Variable[$$filepath: Value :"filewin:" & Get(DesktopPath) &
"filename.jpg"
Export Field Contents [sendit:icture;"$$filepath"]

You are using the variable $$filepath to specify where the file goes
and the name of the file and this is a calculation. In the Export Field
Content specify the (container) field that you are exporting I've
called it picture in the table sendit and then in the filepath dialog
box type $$filename - the name of the variable NOT its definition. This
script will do the exporting - step 3 in your list.

Step 4 can, I think, be done by SetField[sendit:icture;$$filename].

It seems that Set Field does not work try Insert File instead. There is
another thread here Insrting Files from folders that might be worth
looking at as well.

Thanks Dan, I got it finally running!

"Dan Fretwell" <dan (AT) owlsnet (DOT) co.uk> schreef in bericht
news:1132069906.468010.75700 (AT) g43g2000cwa (DOT) googlegroups.com...