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