Hi

I try to find the list of error code for the FM Server 10.... I have
an e-mail from the server

2010-04-15 08:40:00.709 -0400 Error 643 FMServer10 Schedule "E-mail
List Contract" aborted; unsupported script step.

Error 643 ?!?!
an when I edit the script, I select the SERVER only script step, and
all of them are ok...

I try to export a list in XLS format, I retry using "winfile:/c:/dive/
folder/name.xls" because "winfile://serveurname/path/name.xls" was
working when testing on my side but not on the server....

Not the Error 643 is gone, the script run OK but don't create the
file.
(After that I send an e-mail with the attach file, using another
script step, the e-mail is send but not file attached since it was not
created)

How do we test a server script ? how do we trap error ?? when runing
on the user side it's working perfect.

Thank you

Bizouman wrote:

From the FM Pro help file:

When using the Export Records script step or Import Records script step
in a FileMaker Server scheduled script, keep the following in mind:

• Any specified file must be in the FileMaker Server Documents
folder, the temporary folder, or a child folder of either the FileMaker
Server Documents folder or the temporary folder. For example, the
following are all valid paths for file.csv:

<Documents>/file.csv
<Temporary Path>/file.csv
<Documents>/Folder1/file.csv
<Temporary Path>/Folder1/Folder2/Folder3/Folder4/file.csv

Hope that helps...

Thanks but i'm nor sure I get the right path...

In the export file I have selected this path
C:\Program Files\FileMaker\FileMaker Server 10\Data\Documents\file.xls

I'm not sure but I thing the "documents" folder was created with the
installation process??

I also red the fallowing
http://www.filemaker.com/help/html/s...ef1.36.69.html

and I don't see what I'm doing wrong ??

Thank you

JF

Bizouman wrote:
No, that Documents folder is not installed there by default.
Nonetheless, that is not the folder referred to in the list.

On a Windows machine running FM Server, you need to use something like
this path (depending on what version of Windows is run on the server),
where where [UserName] is whatever account the server is logged in as.
I happen to be on Windows XP, where the paths are something like this:

C:\Documents and Settings\[UserName]\My Documents\file.csv
C:\Documents and Settings\[UserName]\My Documents\Folder1\file.csv

C:\Documents and Settings\[UserName]\Local Settings\Temp\file.csv
C:\Documents and Settings\[UserName]\Local Settings\Temp\Folder1\file.csv

Thank you

but I still receive an Error from the server script : Error 643
SERVEUR2003 Schedule "Liste des PPM" aborted; unsupported script step.

But none of the script step are shadowed when I look at it ??
and FM10 Server is too dummy to tell my which line is creating the
error !!

As I was copying my script here, I notice a Custom Fonction.... is the
server able to use a custom fonction in a server script ?

TY

JF

Bizouman wrote:
Can you show us the script?

Here it is, I shorten some of the info and I disable some so it can
run every day for testing purpose.


If[ Day ( Get ( CurrentDate ))=1 or Day ( Get ( CurrentDate ))=16 ]
Go to Layout [ “E_Fiche� (Entretien) ]
Enter Find Mode [ ]
Insert Calculated Result [ THE CUSTOM FONCTION IS HERE, BECAUSE OF A
SEARCH RANGE "date...date" in French format ]
Perform Find [ ]
If [ Get ( FoundCount )=0 ]
Send Mail [ Send via SMTP Server; To: "NO RECORD FOUND"..... Port:
25; Authentication Type: None ] [ No dialog ]
Exit Script [ ]
End If
Go to Layout [ “E_Liste_Renouvellement� (Entretien) ]
Sort Records [ Specified Sort Order: ... ]
Export Records [ File Name: “filepm_expires.xls�; ..... ] [ No
dialog; Format output using current layout ]
End If
If [ Get ( LastError ) â‰* 0 ]
Send Mail [ Send via SMTP Server; "ERROR EXPORT FAIL E-MAIL" ] [ No
dialog ]
Exit Script [ ]
Else
Send Mail [ Send via SMTP Server; Subject: "*** SUCCÈS ***"; Message:
""; Attachment: “filewin:C:/Program Files/FileMaker/FileMaker Server/
Data/Documents/ppm_expires.xls�; Name: ""; Email Address: ""; Reply-To
Address:""; SMTP Server: "relais.videotron.ca"; Port: 25;
Authentication Type: None ][ No dialog ]
End If

in the export records step, I try all the possible way to write the
file path
try with both "file:" of "filewin:"
filewin: name.xls
filewin:/path/directory/name.xls

I also try the to set a variable $path=Get(documentpath)
and export to "filewin:/ & $path & name.xls"
always the same result... no file is created but no error are
generated because I receive the 2nd e-mail where get(lasterror) = 0

Thank you


Now the script is returning no more erreur, but the file "name.xls" is
no where to be found on the server HD I search the hole C:, it's not
in the filemaker directory or the user's default documents folder....

Is it possible that FM Server10 does'nt have the user permission to
write the files on the local HD ??

Bizouman wrote:
Well, it seems I may have been mistaken in my reply the other day when I
said there is no Documents folder installed by default by FM Server.

I see the path, too, and this must be the documents path that was
referred to: C:\Program Files\FileMaker\FileMaker Server\Data\Documents

Writing to that folder should work. I would write it as:
filewin:/c:/Program Files/FileMaker/FileMaker Server/Data/Documents/name.xls

Are you sure it's not in the folder above?

I like your concept of using "filewin:/ & $path & name.xls" but,
although the file location dialog will accept that, it cannot process it.

You can, however, set a variable to "filewin:/ & $path & name.xls" and
then just enter that variable name into the file location dialog. It
accepts variables, but it does not accept calc strings. Go figure.

Bizouman wrote:

One other thing you should add to the beginning of your script is:
Allow User Abort [Off]
Set Error Capture [On]

Without these, scripts running on FM Server will stop at the first error
or invalid command it hits. Adding these may or may not help in your
particular situation.

Opps the SET ERROR CAPTURE script step was there, I just didn't copy
it, I add the Allow user abort line, change the variable $path to be
"filewin:" & Get ( DocumentsPath ) & "name.xls" and in the export
dialog use the $path
You are right, it did accept the calculation, but it's a text
box ?!?! (if someone at FM read those message.... it's a BUG !!! )

and now guess what..... IT'S WORKING !!!

so I guess the dialog box for the export have something wrong when you
manually enter the path.... or if it's misstype and since it not a
calc, FM is not checking for syntax error ?!

Also I read this article that point me to use the Get command
http://filemaker.custhelp.com/app/an..._id/7035/p/874

Thank you Howard