dbTalk Databases Forums  

Need guidance

comp.databases.filemaker comp.databases.filemaker


Discuss Need guidance in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Albert Pasion
 
Posts: n/a

Default Need guidance - 09-14-2005 , 12:01 PM






I have a Filemaker Server 7 running under OS X. I am not very familiar with
Mac OS.

What i like to do is to create a schedule job within FM7 server that will
do the following.

Close all database that are being shared.
Open Filemaker 7 and call a script that already created
close filemaker 7
open all databases to be shared.

Thanks for your help.

Al



Reply With Quote
  #2  
Old   
Lynn allen
 
Posts: n/a

Default Re: Need guidance - 09-14-2005 , 12:25 PM






Albert Pasion <apasion (AT) jsgroup (DOT) com> wrote:

Quote:
I have a Filemaker Server 7 running under OS X. I am not very familiar with
Mac OS.

What i like to do is to create a schedule job within FM7 server that will
do the following.

Close all database that are being shared.
Open Filemaker 7 and call a script that already created
close filemaker 7
open all databases to be shared.


It might help if you let us know what you're actually trying to
accomplish with your interim script. If it's a backup, there are ways to
construct "Schedules" from within the FM Server admin tool that pause
access to the dbs and create backup files on the HD. Those files can
then be copied off or backed up by software to another drive or media.

This way you never copy open and running FM files, which is an extremely
bad idea. But there is no reason to shut the server down for a script.

If you're wanting to run a script in FM 7 for some maintenance reason,
or because you're performing an action like importing some data, then it
might be more effective to set up a timed action on a guest machine,
rather than the server.

Anyway, let us know your ultimate purpose and we can answer more
effectively.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting


Reply With Quote
  #3  
Old   
Albert Pasion
 
Posts: n/a

Default Re: Need guidance - 09-14-2005 , 05:13 PM



I thank you for your suggestion but its not a good solution at this time.

Basically i use to run Filemaker server 5.5 and it was not a problem running
apple script to do this task. Since i upgraded to FM7 Server and FM7 pro
plus to OSX my apple script that use to do the job no longer work. Would i
be able to do this under windows??/


Albert


"Martin Trautmann" <t-use (AT) gmx (DOT) net> wrote

Quote:
On Wed, 14 Sep 2005 13:01:15 -0400, Albert Pasion wrote:
I have a Filemaker Server 7 running under OS X. I am not very familiar
with
Mac OS.

What i like to do is to create a schedule job within FM7 server that
will
do the following.

Close all database that are being shared.
Open Filemaker 7 and call a script that already created
close filemaker 7
open all databases to be shared.

The easiest job is

- energy setup: shutdown your computer, start again

- if the computer hangs, you might add a real power timer
that turns off power within the shutdown time
just to make it very sure

- put the database into the startup items

This database may proceed the open all required databases.

However, once a database is stuck or a script is terminated, I see
little help to proceed from within FMP.

If you can't shut down the server, one of the options is
- check by external access whether the database is operating
e.g. via web interface, asking for the current time
- trigger to start your operations
(optional: check whether it was done or whether the database is still
running)


You might check for the unix command 'cron' - and how to set this up on
your server. While 'cron' is the typical solution, there are third party
tools which can do the same.


What you really will do will depend on the probability and damage of a
real lockup situation.

- Martin



Reply With Quote
  #4  
Old   
FP
 
Posts: n/a

Default Re: Need guidance - 09-14-2005 , 06:46 PM



Quote:
Basically i use to run Filemaker server 5.5 and it was not a problem running
apple script to do this task. Since i upgraded to FM7 Server and FM7 pro
plus to OSX my apple script that use to do the job no longer work. Would i
be able to do this under windows??/

Are you nuts?
You can't trust Windows to do anything. I forget which CEO said this,
but I believe the exact phrase was "You can't trust Microsoft to run a
refrigerator properly".
I apologize to all Windows users, I know this may be a bit extreme.

What I would suggest to you instead is post your apple script on an
apple script group and ask them how to make it work with the new
software.
Just as an aside, if you can restart the computer after your script
ran, it would be advisable... after all even a Mac hangs sometimes.



Reply With Quote
  #5  
Old   
Albert
 
Posts: n/a

Default Re: Need guidance - 09-14-2005 , 08:56 PM



Hello,
Basically, I am trying to write an apple script under MAC OS 10 to do the
following:

Close all databases that are being shared by FM7 sever.
Open FM7 pro 7 to execute a script that will import data from another file
which is comma delimited
Close FM7 pro
Open all databases in FM7 server to be shared.

One thing that i noticed during importing new set of data i need to close
the all databases in FM7 server otherwise i dont get 100% of the new data
this is the reason i need to close the databases before i do the import.

Thanks again,
Albert


"Lynn allen" <lynn (AT) NOT-semiotics (DOT) com> wrote

Quote:
Albert Pasion <apasion (AT) jsgroup (DOT) com> wrote:

I have a Filemaker Server 7 running under OS X. I am not very familiar
with
Mac OS.

What i like to do is to create a schedule job within FM7 server that
will
do the following.

Close all database that are being shared.
Open Filemaker 7 and call a script that already created
close filemaker 7
open all databases to be shared.



It might help if you let us know what you're actually trying to
accomplish with your interim script. If it's a backup, there are ways to
construct "Schedules" from within the FM Server admin tool that pause
access to the dbs and create backup files on the HD. Those files can
then be copied off or backed up by software to another drive or media.

This way you never copy open and running FM files, which is an extremely
bad idea. But there is no reason to shut the server down for a script.

If you're wanting to run a script in FM 7 for some maintenance reason,
or because you're performing an action like importing some data, then it
might be more effective to set up a timed action on a guest machine,
rather than the server.

Anyway, let us know your ultimate purpose and we can answer more
effectively.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.