Go to the FMserver Documents folder, do Get Info and check your path. Also the Get ( TemporaryPath ) version should work: 
"filemac:" & Get ( TemporaryPath ) & myfilename.mer )

-- 
Steve Gerow
FileMaker 9/8/7 Certified Developer
President
Abrazos Data Consulting, Inc.
Pasadena, California
Member FileMaker Bus. Alliance


>  -------Original Message-------
>  From: Sue <[log in to unmask]>
>  To: [log in to unmask]
>  Subject: Re: Export records in Server script
>  Sent: Jul 29 '10 14:58
>  
>  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 <[log in to unmask]>
>  >> To: [log in to unmask]
>  >> 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
>  >>
>