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