Hooray! Got it. It worked. I remembered that our Server was not
called MacIntosh HD but instead Server HD so I changed that in the
calculation, and also had IT make sure the to set permissions in Data
and Documents the same.
Thank you both!!
When re-run, the script is automatically replacing the existing file
without any prompt that a file already exists with namex--which is
what I wanted it to do-- I was afraid this might present another
problem. But it looks like it is good to go forward.
Thank you both--I will be able to sleep well tonight as my new ability
to make this work will help me solve several problems!
Sue
On Jul 29, 2010, at 5:08 PM, Stephen Wonfor wrote:
Sue
Data/Documents/" needs to have same permissions as Data/
Try Batchmod or X-ray to fix..
Stephen
----
WIRE WHEEL: Cleans paint off bolts and then throws them somewhere
under the workbench with the speed of light. Also removes
fingerprints and hard-earned calluses from fingers in about the time
it takes you to say, "Oh, s---!" (---Attributed to the list at http://techtalk.parts-express.com/
; Also claimed by others...)
On Jul 29, 2010, at 4:58 PM, Sue wrote:
Well, in theory, since it was the server running the script, not
me, the Get (DocumentsPath) should have worked.
However, I tried changing the calculation for the script path to
the example you provided (with my file name of course), and still
no go.
Thank you for the suggestion, however. Any other thoughts?
Sue
On Jul 29, 2010, at 4:46 PM, Steve B. Gerow wrote:
Get ( DocumentsPath ) gives the wrong documents folder - it gives
the User Documents folder.
I'm setting the following into a variable, then setting the path
to the variable:
"filemac:/Macintosh HD/Library/FileMaker Server/Data/Documents/" &
MyTextFile.mer )
--
Steve Gerow
FileMaker 9/8/7 Certified Developer
President
Abrazos Data Consulting, Inc.
Member FileMaker Bus. Alliance
-------Original Message-------
From: Sue <[email protected]>
To: [email protected]
Subject: Re: Export records in Server script
Sent: Jul 29 '10 14:35
Thanks. That page seems very helpful.
However, when I tried the script using simply: filemac: &
Get(DocumentsPath) & filename to generate the address for the
server
to export the records file to, it still didn't work. I get an 800
error code.
The temporary folder option described sounds more complicated and
if I
can't get the first option to work, then I suspect I couldn't get
that
to work either.
Any other helpful suggestions or webpages to help me figure this
out?
Thanks so much!
Sue
On Jul 29, 2010, at 3:31 PM, Stephen Wonfor wrote:
Sue
See http://www.fmforums.com/forum/showpost.php?post/316043/
Stephen
----------
“I am easily satisfied with the very best.” - Winston Churchill
On Jul 29, 2010, at 3:19 PM, Sue wrote:
I am trying, for the first time, to set up a scheduled script to
export records from one of my files via the Server Administrator
(version 10). It all seems pretty straightforward, but my script
isn't working.
I am trying to save the exported records as a csv file in a
folder
on the server. I can run the filemaker script that exports the
records quite successfully from my computer or another computer,
and as long as the computer is connected to the appropriate
folder
on the server, it works.
But when the Server Admin runs the script, nothing happens. I
suspect that the server needs a different address or address
format
to figure out where to put the exported record file than what
works
from my computer, but I can't figure out how to name the correct
address for the server's use into my script.
From my computer: filemac:/foldername/filename.csv works
fine.
Can anyone offer advice on what I might need to change to get
this
working from the server?
Thanks very much for any help,
Sue
