4 Replies Latest reply on Aug 21, 2012 4:17 PM by EileenWaterston

    Filemaker Pro closing when trying to Export data.

    EileenWaterston

      Summary

      Filemaker Pro closing when trying to Export data.

      Product

      FileMaker Pro

      Version

      11.2

      Operating system version

      Windows 7

      Description of the issue

      Exporting data to create a tab file intermittently causing the programme to close.

      Steps to reproduce the problem

      Having selected the records from which the data is to be exported, click on Export and select Tab file, name the file and Save.  Programme unexpectedly closes.

      Expected result

      Another box should appear, allowing for the selection of the appropriate fields.  Thereafter, the file should be created.

      Actual result

      An empty tab file is produced.

      Exact text of any error message(s) that appear

      Filemaker Pro has stopped working.
      Windows is checking for a solution to the problem.

      A problem caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available.

      Workaround

      The last time this happened,it unexpectedly started to work again, while I was preparing this report.

        • 1. Re: Filemaker Pro closing when trying to Export data.
          philmodjunk

          Any time you get a crash, you need to check your file for damage. Damage to your file could be the cause of the crash and the crash itself can damage your file.

          Run a recover on your file and see if any issues are found. Test the recovered copy even if no issues are reported as found and fixed to see if it exports reliably.

          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".
          2. Recover does not detect all problems
          3. Recover doesn't always fix all problems correctly
          4. 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.
          • 2. Re: Filemaker Pro closing when trying to Export data.
            EileenWaterston

            Thanks for your help and advice - the Recover did not throw up any identified problems, but it seems to be working ok on the Export.  I'll take more time over this tomorrow and check it out fully.

            • 3. Re: Filemaker Pro closing when trying to Export data.
              philmodjunk

              If recover fixed the problem, it may be due to the fact that recover rebuilds all the indexes in the recovered file from scratch. If so, you may want to test a copy recovered like this:

              If you have FileMaker 11 or newer, you can use Advanced Recovery options to rebuild your file's indexes:

              1. With the file closed, select Recover from the File Menu.
              2. Select "Use advanced Options"
              3. Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".

               

              This produces a file where the only change was rebuilt indexes and it thus should be safe to use to replace your current file and avoids the need to import a bunch of data into a clone of a back up file or to risk using the original recovered copy.

              • 4. Re: Filemaker Pro closing when trying to Export data.
                EileenWaterston

                Tried that, but it won't Export and just closes down.