1 Reply Latest reply on Mar 2, 2012 7:06 PM by ch0c0halic

    How can I automate save as compacted process


      Does anyone have a precess in place to automatically compact a file and place back on server and open ?


      I would like to create a process to close a database on the FM 10 or 11 server ftp to a client desktop and remove from server, open the file on the desktop, save as compacted, delete original from desktop, rename copy to orginal filename, ftp to server, open file on server.


      Would a combination of a dos script ftp and an on start up script to do the save as (only for an admin account) work or does anybody have a better solution?

        • 1. Re: How can I automate save as compacted process

          lgodin may be in overkill mode,


          Why do you think this is needed?


          Maybe on a Macintosh systems using AppleScript it might be doable. But, you'd sacrifice server security to allow external AppleScript access and control. If you are on windows I doubt it can be done but I'm not a windows expert.


          Compacting a file like this not one of the FMS recommended practices and I've not heard of any need for file compression since FMP-pre7 and in-expensive drives. FMS does file clean up within the database and dynamically reallocates the internal storage blocks as required. You may not see any file size changes on the drive but that doesn't mean FMS isn't keeping the file in top shape.


          If your files have grown to large for the backups to fit, get a bigger drive or add a second one. Its much cheaper than developing what you've described.