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
>>