3 Replies Latest reply on Aug 6, 2014 11:44 AM by philmodjunk

    FileMaker crash after export in Excel



      FileMaker crash after export in Excel


      FileMaker Pro



      Operating system version

      Windows 7

      Description of the issue

      Crash occurs in script mode only, on "Export" and "Save as Excel" steps.

      The crash occurs right after the excel file is produced and opened.

      Works fine in other DB.
      Works fine when the debugger is open.
      Works fine via the menu commands.

      Steps to reproduce the problem

      Go to related
      set variable ($path)
      Save as Excel

      ==== BOOOOOMMM ======

      Expected result

      no BOOM ;-)

      Exact text of any error message(s) that appear

      Windows' "Filemaker as stop working"


      If I stop my script and put a button that will perform the export, it work!


        • 1. Re: FileMaker crash after export in Excel

               Have you tried using recover to check your file for damage. Not only can a crash like this be due to a damaged file. But a damaged file might produce the crash that you are reporting here.

               Things to keep in mind about Recover:

               While Recover almost always detects and fully corrects any problems with your file...

          1.           The recovered copy may behave differently even if recover reports "no problems found".
          3.           Recover does not detect all problems
          5.           Recover doesn't always fix all problems correctly
          7.           Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.


               And here's a knowledgebase article that you may find useful: What to do when your file is corrupt (KB5421).

          • 2. Re: FileMaker crash after export in Excel

                 Thank you Phil for the answer. I have already tried that, and it didn't work sad. I guess my back-up is also corrupted.

            • 3. Re: FileMaker crash after export in Excel

                   That, at this point is a possibility, but one that is unproven. Wonder if FMDiff would report anything here that Recover was unable to detect?