dbTalk Databases Forums  

Any way to save automatically to avoid data loss in crash?

comp.databases.filemaker comp.databases.filemaker


Discuss Any way to save automatically to avoid data loss in crash? in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jd@jdconservation.com
 
Posts: n/a

Default Any way to save automatically to avoid data loss in crash? - 01-30-2007 , 07:27 AM






I realize that FMP 8 is supposed to save cache contents regularly
(either during idle time or at pre-set intervals), but when my
computer crashes I invariably lose a day's work and have to restore
from my daily backup file. Is there a way to get FMP to save
regularly so this doesn't happen? Any help would be greatly
appreciated!


Reply With Quote
  #2  
Old   
NScheffey
 
Posts: n/a

Default Re: Any way to save automatically to avoid data loss in crash? - 01-30-2007 , 07:49 AM






Under Edit, Preferences, Memory tab, you can set an interval of how
often FileMaker flushes the cache to disk. This can also be done
manually via the Flush Cache script step.

Nate



On Jan 30, 8:27 am, j... (AT) jdconservation (DOT) com wrote:
Quote:
I realize that FMP 8 is supposed to save cache contents regularly
(either during idle time or at pre-set intervals), but when my
computer crashes I invariably lose a day's work and have to restore
from my daily backup file. Is there a way to get FMP to save
regularly so this doesn't happen? Any help would be greatly
appreciated!



Reply With Quote
  #3  
Old   
jd@jdconservation.com
 
Posts: n/a

Default Re: Any way to save automatically to avoid data loss in crash? - 01-30-2007 , 09:54 AM



Thanks Nate, I've tried that, but it doesn't seem to work. I've set
up a "Flush Cache" script, made changes to a field, performed the
"Flush Cache" script and then Force Quitted FMP. When I re-open the
file, the changes were not saved. I need a solution that will save
those changes on a regular basis. I've had it set to Flush every 10
minutes under preferences, but it isn't saving changes. Any
suggestions?

Thanks, Jon

On Jan 30, 8:49 am, "NScheffey" <NSchef... (AT) gmail (DOT) com> wrote:
Quote:
Under Edit, Preferences, Memory tab, you can set an interval of how
often FileMaker flushes the cache to disk. This can also be done
manually via the Flush Cache script step.

Nate

On Jan 30, 8:27 am, j... (AT) jdconservation (DOT) com wrote:

I realize that FMP 8 is supposed to save cache contents regularly
(either during idle time or at pre-set intervals), but when my
computer crashes I invariably lose a day's work and have to restore
from my daily backup file. Is there a way to get FMP to save
regularly so this doesn't happen? Any help would be greatly
appreciated!


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

Default Re: Any way to save automatically to avoid data loss in crash? - 01-30-2007 , 10:31 AM



I would aproach this from the other end. It is not filemakers' fault your
system crashes so often. There is almost no software that is completely
crash-proof. I would try to solve any underlying problems why your system is
crashing. or buy a new Mac :-))

Ursus

<jd (AT) jdconservation (DOT) com> schreef in bericht
news:1170172481.691861.269340 (AT) q2g2000cwa (DOT) googlegroups.com...
Quote:
Thanks Nate, I've tried that, but it doesn't seem to work. I've set
up a "Flush Cache" script, made changes to a field, performed the
"Flush Cache" script and then Force Quitted FMP. When I re-open the
file, the changes were not saved. I need a solution that will save
those changes on a regular basis. I've had it set to Flush every 10
minutes under preferences, but it isn't saving changes. Any
suggestions?

Thanks, Jon

On Jan 30, 8:49 am, "NScheffey" <NSchef... (AT) gmail (DOT) com> wrote:
Under Edit, Preferences, Memory tab, you can set an interval of how
often FileMaker flushes the cache to disk. This can also be done
manually via the Flush Cache script step.

Nate

On Jan 30, 8:27 am, j... (AT) jdconservation (DOT) com wrote:

I realize that FMP 8 is supposed to save cache contents regularly
(either during idle time or at pre-set intervals), but when my
computer crashes I invariably lose a day's work and have to restore
from my daily backup file. Is there a way to get FMP to save
regularly so this doesn't happen? Any help would be greatly
appreciated!




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

Default Re: Any way to save automatically to avoid data loss in crash? - 01-30-2007 , 11:02 AM





On Jan 30, 4:31 pm, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:
Quote:
I would aproach this from the other end. It is not filemakers' fault your
system crashes so often. There is almost no software that is completely
crash-proof. I would try to solve any underlying problems why your system is
crashing. or buy a new Mac :-))

Ursus

j... (AT) jdconservation (DOT) com> schreef in berichtnews:1170172481.691861.269340 (AT) q2g2000cwa (DOT) googlegroups.com...

Thanks Nate, I've tried that, but it doesn't seem to work. I've set
up a "Flush Cache" script, made changes to a field, performed the
"Flush Cache" script and then Force Quitted FMP. When I re-open the
file, the changes were not saved. I need a solution that will save
those changes on a regular basis. I've had it set to Flush every 10
minutes under preferences, but it isn't saving changes. Any
suggestions?

Thanks, Jon

On Jan 30, 8:49 am, "NScheffey" <NSchef... (AT) gmail (DOT) com> wrote:
Under Edit, Preferences, Memory tab, you can set an interval of how
often FileMaker flushes the cache to disk. This can also be done
manually via the Flush Cache script step.

Nate

On Jan 30, 8:27 am, j... (AT) jdconservation (DOT) com wrote:

I realize that FMP 8 is supposed to save cache contents regularly
(either during idle time or at pre-set intervals), but when my
computer crashes I invariably lose a day's work and have to restore
from my daily backup file. Is there a way to get FMP to save
regularly so this doesn't happen? Any help would be greatly
appreciated!
Here's another approach. Use the "Save a copy as" script step. This
will work if you are using FileMaker locally ie not off a server. It
can save a copy of your solution file/s to disk without you having to
quit the system.

You can incorporate this into your navigation scripts. The script can
be set to trigger if no backup has been made in the last 90 minutes.
The time of the last backup can be stored in a global.

Regards
Kevin



Reply With Quote
  #6  
Old   
jd@jdconservation.com
 
Posts: n/a

Default Re: Any way to save automatically to avoid data loss in crash? - 01-30-2007 , 11:28 AM





Kevin,

That seems like a solution but I have a few questions:
Is it possible to run this script in the background? When I run a
"Save a Copy As" script a dialog box opens and names the file
"copy". When I run the script again, it names it "copy 1". If I let
that go on, it will fill up my drive with copies. Can it be set to
replace the existing copy file? Also, how to I set the script to
trigger "if no backup has been made in the last 90 minutes"?

Thanks for your help.
Jon



On Jan 30, 12:02 pm, "KevinSmith"
<pleasedonotusethisaddr... (AT) gmail (DOT) com> wrote:
Quote:
On Jan 30, 4:31 pm, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:



I would aproach this from the other end. It is not filemakers' fault your
system crashes so often. There is almost no software that is completely
crash-proof. I would try to solve any underlying problems why your system is
crashing. or buy a new Mac :-))

Ursus

j... (AT) jdconservation (DOT) com> schreef in berichtnews:1170172481.691861.269340 (AT) q2g2000cwa (DOT) googlegroups.com...

Thanks Nate, I've tried that, but it doesn't seem to work. I've set
up a "FlushCache" script, made changes to a field, performed the
"FlushCache" script and then Force Quitted FMP. When I re-open the
file, the changes were not saved. I need a solution that will save
those changes on a regular basis. I've had it set toFlushevery 10
minutes under preferences, but it isn't saving changes. Any
suggestions?

Thanks, Jon

On Jan 30, 8:49 am, "NScheffey" <NSchef... (AT) gmail (DOT) com> wrote:
Under Edit, Preferences, Memory tab, you can set an interval of how
often FileMaker flushes thecacheto disk. This can also be done
manually via theFlushCachescript step.

Nate

On Jan 30, 8:27 am, j... (AT) jdconservation (DOT) com wrote:

I realize that FMP 8 is supposed to savecachecontents regularly
(either during idle time or at pre-set intervals), but when my
computer crashes I invariably lose a day's work and have to restore
from my daily backup file. Is there a way to get FMP to save
regularly so this doesn't happen? Any help would be greatly
appreciated!Here's another approach. Use the "Save a copy as" script step. This
will work if you are using FileMaker locally ie not off a server. It
can save a copy of your solution file/s to disk without you having to
quit the system.

You can incorporate this into your navigation scripts. The script can
be set to trigger if no backup has been made in the last 90 minutes.
The time of the last backup can be stored in a global.

Regards
Kevin


Reply With Quote
  #7  
Old   
KevinSmith
 
Posts: n/a

Default Re: Any way to save automatically to avoid data loss in crash? - 01-30-2007 , 12:03 PM





On Jan 30, 5:28 pm, j... (AT) jdconservation (DOT) com wrote:
Quote:
Kevin,

That seems like a solution but I have a few questions:
Is it possible to run this script in the background? When I run a
"Save a Copy As" script a dialog box opens and names the file
"copy".
When you define the script, you can specify a file name eg
"SalesSystem_LiveBackup.fp7". You will also specify where to save it.
Once the script is created, it will run without any dialogues. There
will be a short lag as the file is actually saved.

When I run the script again, it names it "copy 1". If I let
Quote:
that go on, it will fill up my drive with copies. Can it be set to
replace the existing copy file?
Using the above method, it will just save over the older copy.

Also, how to I set the script to
Quote:
trigger "if no backup has been made in the last 90 minutes"?
Choose a fairly frequent function eg when user switches to main menu.
Prior to navigating to main menu do a check on a global called eg
"zg_LastBackup_DateStamp".

If "zg_LastBackup_DateStamp" + 90 minutes < "current time and date"
then perform script "Backup"

Sorry above is in fake code ie not literally how it's worded. It's
something I always need to fiddle with before getting right. But
you're going to need to get dirty with the time and date functions.

I hope that helps.

Good luck.

Quote:
Thanks for your help.
Jon

On Jan 30, 12:02 pm, "KevinSmith"

pleasedonotusethisaddr... (AT) gmail (DOT) com> wrote:
On Jan 30, 4:31 pm, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:

I would aproach this from the other end. It is not filemakers' fault your
system crashes so often. There is almost no software that is completely
crash-proof. I would try to solve any underlying problems why your system is
crashing. or buy a new Mac :-))

Ursus

j... (AT) jdconservation (DOT) com> schreef in berichtnews:1170172481.691861.269340 (AT) q2g2000cwa (DOT) googlegroups.com...

Thanks Nate, I've tried that, but it doesn't seem to work. I've set
up a "FlushCache" script, made changes to a field, performed the
"FlushCache" script and then Force Quitted FMP. When I re-open the
file, the changes were not saved. I need a solution that will save
those changes on a regular basis. I've had it set toFlushevery 10
minutes under preferences, but it isn't saving changes. Any
suggestions?

Thanks, Jon

On Jan 30, 8:49 am, "NScheffey" <NSchef... (AT) gmail (DOT) com> wrote:
Under Edit, Preferences, Memory tab, you can set an interval of how
often FileMaker flushes thecacheto disk. This can also be done
manually via theFlushCachescript step.

Nate

On Jan 30, 8:27 am, j... (AT) jdconservation (DOT) com wrote:

I realize that FMP 8 is supposed to savecachecontents regularly
(either during idle time or at pre-set intervals), but when my
computer crashes I invariably lose a day's work and have to restore
from my daily backup file. Is there a way to get FMP to save
regularly so this doesn't happen? Any help would be greatly
appreciated!Here's another approach. Use the "Save a copy as" script step. This
will work if you are using FileMaker locally ie not off a server. It
can save a copy of your solution file/s to disk without you having to
quit the system.

You can incorporate this into your navigation scripts. The script can
be set to trigger if no backup has been made in the last 90 minutes.
The time of the last backup can be stored in a global.

Regards
Kevin


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.