Hi

I re-wrote my script that run on the server so if any left over in the
previous one was bad....
It work and now yesterday night... It stop working again !

The script now is the simple you can get.
Win 2003, FMS10
The script run daily at 8:00pm

I have a search query
Export to a xls file (on the server local drive)
Mail with attachment.

The export stop working
The send mail send the mail but no xls file attach

When I go look in my Documents folder, the file is there, but the
modification/creation date is the one from 2 days ago, (when it was
still working)

WHY WHY WHY ?!?! I remove all the previous get last error.... if...
then.. to make it easy to check.... but now it's simple, and the
thing is WHY did it stop exporting ?? (the script still run on the
server (Server Admin last run OK) I receive the e-mail OK but no
attachment and the export didn't work because the file have the
wednesday date on it

the script again:

Allow User Abort [ Off ]
Set Error Capture [ On ]
Go to Layout [ “E_Fiche” (Entretien) ]
Enter Find Mode [ ]
Insert Calculated Result [ Entretien_Data::ED_DateFin_Contrat;
"1/1/10...12/12/10"
[ Select ]
Perform Find [ ]
If [ Get ( FoundCount )=0 ]
Send Mail [ Send via SMTP Server; To: "a@c.com"; Subject: "*** List is
empty ***";
Message: "Empty list."; Name: "FM_Serveur"; Email Address:
"info@c.com"; Reply-To Address:
"noreply (AT) noreply (DOT) com"; SMTP Server: "relais.v.ca"; Port: 25;
Authentication Type: None ]
[ No dialog ]
Exit Script [ ]
End If
Go to Layout [ “E_Liste_Renouvellement” (Entretien) ]
Sort Records [ Specified Sort Order:
Entretien_Data::ED_DateFin_Contrat; ascending
Entretien::E_Numéro_Contrat; ascending ]
[ Restore; No dialog ]
Set Variable [ $path; Value:"filewin:" & Get ( DocumentsPath ) &
"ppm_expires.xls" ]
Export Records [ File Name: “$path”; Use field names as column names;
Character Set: “Unicode (UTF-16)”; Field Order: Entretien_Data::
ED_DateFin_Contrat
cr0107_Client::no_client
Entretien::E_Numéro_Contrat
cr0106_Livraison::nom_livraison
cr0106_Livraison::adresse1 ]
[ No dialog ]
Send Mail [ Send via SMTP Server; To: "j@c.com"; Subject: "*** List of
contract SUCCÈS ***";
Message: "List of contract."; Attachment: “$path”; Name: "FM_Serveur";
Email Address:
"info@c.com"; Reply-To Address: "info@c.com"; SMTP Server:
"relais.v.ca"; Port: 25;
Authentication Type: None ]
[ No dialog ]


Thank you

JF

Bizouman wrote:

I'm not sure how an export script handles the situation where a document
already exists with the same name. Does it overwrite or just not write
anything? Could that be the problem?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker Certified Developer
Associate Member, FileMaker Business Alliance

On 30 avr, 12:08, Howard Schlossberg
<how... (AT) nospam (DOT) fmprosolutions.com> wrote:
in the case it was the problem I change the file name to be a variable
name that change each day, but that was not the case....

Yesterday, the script run OK... go figure ?!?!

JF

"Bizouman" <bizouman (AT) gmail (DOT) com> schreef in bericht
news:2a0eb5a8-74c6-44ec-ad30-edabf2649cf2 (AT) i10g2000yqh (DOT) googlegroups.com...
On 30 avr, 12:08, Howard Schlossberg
<how... (AT) nospam (DOT) fmprosolutions.com> wrote:
in the case it was the problem I change the file name to be a variable
name that change each day, but that was not the case....

Yesterday, the script run OK... go figure ?!?!

JF

--------------------------------------------------------

Yesterday it worked
today it doesn't
so what has changed between yesterday and today?
You wrote that you changed the name to a variable.
Did you check the exportfile is created? Does it exist right after the
'export'script step.
Create a 'halt script' or a 'pause script' directly after you export step.
Look if the file is there.

Are you sure the correct file gets attached?
If you have changed the name on one place, make sure you change it
everywhere.

--
Keep well / Hou je goed

Ursus

On 2 mai, 04:10, "Ursus" <ursus.k... (AT) ziggo (DOT) nl> wrote:
Variable for file name is the same for both export and attached mail
but the export over right the existing file, so that is not an issue.

#2 not the script hang up on the server, this morning when I look...
not e-mail.... so It check the FM Admin console.... the script is in a
state of "running" since may 2nd 6:40PM (I use the french version so I
don't know the english statut this is display)
How can we stop a server runing script that is stuck there ??
Why did it hang up there ?!?
Why there's no option to STOP current script ? you can do bunch of
stuff, but not stoping it !!

#3 is it possible that the server script try to "open" the file before
it try to run the script ?? on the Admin console I got an error from
the server scheduled script, at the time I setup, but it try to run
the OPEN script setup in the database file, and of course it's a
client script and generate an error..... then it run the server script
setup to be run from the schedule in the programme of the Admin
console ?!?1 pretty weird.

The scheduler run a script that is no where to be found in the
programm task list, it ran it a the same time as my exporte file,
create an error #4 (custom dialog) than it run the export/e-mail
script ?!?! that is the one in the program task?? after that it stay
stuck in "run " mode...

If only we could spoke to someone at FM to explain all these and we
didn't need to enter our credit card info !! sometime it's our
error, but sometime it's an unknow phenomena !!

Variable for file name is the same for both export and attached mail
but the export over right the existing file, so that is not an issue.

#2 not the script hang up on the server, this morning when I look...
not e-mail.... so It check the FM Admin console.... the script is in a
state of "running" since may 2nd 6:40PM (I use the french version so I
don't know the english statut this is display)
How can we stop a server runing script that is stuck there ??
Why did it hang up there ?!?
Why there's no option to STOP current script ? you can do bunch of
stuff, but not stoping it !!

#3 is it possible that the server script try to "open" the file before
it try to run the script ?? on the Admin console I got an error from
the server scheduled script, at the time I setup, but it try to run
the OPEN script setup in the database file, and of course it's a
client script and generate an error..... then it run the server script
setup to be run from the schedule in the programme of the Admin
console ?!?1 pretty weird.

The scheduler run a script that is no where to be found in the
programm task list, it ran it a the same time as my exporte file,
create an error #4 (custom dialog) than it run the export/e-mail
script ?!?! that is the one in the program task?? after that it stay
stuck in "run " mode...

If only we could spoke to someone at FM to explain all these and we
didn't need to enter our credit card info !! sometime it's our
error, but sometime it's an unknow phenomena !!

-------------

are you sure the script isn't looping without end?
It looks like somehow the script didn't terminate in an expected way.
Which also might explain it worked once (first time it looped)
I always create an admin-script that will end all current running/looping
scripts.
You might try holding the ESC key, but this doesn't always work.

Error #4 is a 'command unknown' error. Are you running on OSX and did you
use applescript?
Or perhaps a plug-in.
I have never before seen this in one of my files.

Ursus

On 5 mai, 02:36, "Ursus" <ursus.k... (AT) ziggo (DOT) nl> wrote:
If you look the 1st message in this thread, the script is there,
there's no LOOP.
On a server script the ESC key ?!? can't use that option
How do you create a master script to stop current script ?? under
FMS11 they add a new option to limit the run time of a script, in
FMS10... nope ?!
I run under Win 2003

I look at my program task list in FM Admin console, the eport script
is still runing, and now I have my daily backup routine also that is
stuck there runing since May 5th 10am !! wow what a server tools the
built in task hang up and is not done since... a chance I go and have
a look, I didn't use the send e-mail for the daily backup, only for
the weekly but that is a pain in the @$$ the pre-set programm not
working propelly !! the Log file don't report anything wrong...

I want into the Admin-Client and see who's connected, I see the server
script runing under the Admin user, I click DISCONNECT, I have to send
a message (to who ?? it's a server script!!) ... it didn't work
then I try to disconnect me on my PC using the same way... send
message..... I didn't receive any message on my PC telling me
anything, disconnect please in 2 mins olr the custome message...

That FMS10.... is it working ?? one thing for sure, it's not a fail
safe application.... is the FMS11 better ???