Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Question Unanswered: Automatic Closing/Opening of FMP FILE

    Does anyone know how I would be able to automatically close a FMP file at a certain time, and then reopen it?

    Here's the problem - I'm operating a Win 2003 Server that has a tape backup. I need to do the following things:

    1) Make the mac drive, folder, whatever available to be seen from the Server.

    2) Sometime around 9:00 pm, have the FMP file close so that it can be backed-up around 10:00. Re-open the file near 7:45 am so that the users can access it.

    Any advice will help.

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    San Francisco
    Posts
    70
    Quick fix, not using FM Server:
    If you're NOT using FileMaker Server, then create an .fp5 file that exits the application at start up (write a script that exits application, then set that as the startup script). Create another file that opens all the files. Create windows scheduled tasks that will run launch these new Closing an Opener files.

    Quick fix, using FM Server:
    Send FM Server the "FMServer STOP" and "FMServer START" commands (in the command shell) using windows scheduled tasks.

    Another idea:
    Assuming you're using FM Server, you can setup scheduled tasks in FileMaker Server that will pause the service, backup the files, and then restart the service. (You don't have to do anything in the command shell, just point and click to what files to backup, when days to backup, what times to backup, and where to backup to). Then, your tape backup would just grab the data from the FM Server backup directory, not the live data.

    Another idea:
    I don't think this method will work, but I'm dying to know. Win 2003 server has an implementation of shadow copying (VSS, I think), whereby the OS silently (and invisibly to applications) grabs open/in-use files out from under services and applications and creates backups of them - so you don't have to interrupt services or applications.

    Could you try using this to create a backup of FileMaker files while they're open, then try opening the back up files created by the shadow copy? I think the files will open with errors ("This file was not closed correctly, FileMaker is performing a consistency check, etc..."), since the backup was made while some flag in the FMP app was still set to "dirty" (the new file is created with the flag telling it that it is still open). Let us know what you find Thanks!

  3. #3
    Join Date
    Sep 2003
    Posts
    2

    Thumbs up

    Thanks for the reply! I should have written that I don't have FMP server.

    I'm not a great Windows script writer, but I'll look into how to make a scheduling script run.

    Thanks!

  4. #4
    Join Date
    Sep 2003
    Location
    San Francisco
    Posts
    70
    Its very easy to configure scheduled tasks in Windows.

    Go to Start > Settings > Control Panel > Scheduled Tasks

    Double click the "add scheduled task" icon. Click "next".

    When prompted to "click the program you want windows to run", click the browse button and select your "opener.fp5" file.

    Follow the prompts to set the appropriate schedule for running that file.

    Good luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •