Jump to content
Sign in to follow this  
Tony Morosco

Recovery and reopening of FM7 files

Recommended Posts

I'm a botanist, and the tables I am working with are for tracking botanical garden collections. The data represents plants in the garden, and the plants are tagged and show up in the database.  The tables I am working with were created in FMP 7, and I'd like to open them up in FMP 11 (or later.)  The system hasn't been used in years, but still has valuable information.

One of the tables is giving me problems using the FMP convert and recover commands.

These tables are all inter-related.  The main table is the Accessions table, which contains records for all of one kind of plant, from the same source, received on the same date.  It is basically a museum standard.

The other tables are related to each other through this one main table.  The Species table is related to the locations table through the Accessions table. 
(i.e.  table A relates to table C through the table B, the intermediary)  
From the Locations table, we can't see the the species information unless the accessions table is present.

When issuing the open command on the main table to convert the database to FMP 11, I get the message:

 "Accessions.fmp7" is damaged and cannot be opened.  Use the Recover command to recover this file.

When using the Recover command from v. 11, I get another message:

WARNING: problems were detected while recovering the database.  Please review the Recover.log file to see where problems were found and their severity.  The recovered file should NOT be used going forward; copy only the most recent work from it into a backup copy of the original file.
Recovery results:
  File blocks: scanned and rebuilt 563 blocks, dropped 214 invalid data blocks.
  Schema: scanned fields and tables, 1 items modified
  Structure: scanned; 1 items modified
  Field indexes: rebuilt

 

Opening the recovered database, there are only three records present.  There should be hundreds.  So obviously I am looking on how to wrangle this database open.

I've attached the log file here, as well as the database structure map.  

The other files have converted just fine.  But since the main table won't open, we are kind of stuck.
I can share the files with you through Dropbox or whatever, if needed.

Please let me know any thoughts you have, either basic or advanced.  And ask for any clarifications or additional questions.   :-)  

Thanks!

-Tony

Recover.log

Database relationships.PNG

Share this post


Link to post
Share on other sites

Clearly the file was damaged and in order to make it open FM had to delete large chunks of the corrupted file.  In this case that were data blocks.

Nothing much that can be done with it.  You can try to recover with different versions of FM.  You can try to recover on Mac and on Windows.  Those are all long shots but you never know.

What it really points to is that the file was used in a manner that led to this corruption.  Very often that is because of OS-level file sharing, AV scanning,...  If you have other FM files in use, carefully scrutenize your deployment to make sure you minimize the risk that other files will get damaged.

  • Like 2

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By JH Howland
      Filemaker Pro 11 is running on two Windows 10 computers connected as Host and Client over a network.
      The script to import data from an Excel .csv file utilizes the following script step options:
          1. Un-Checked - Specify data source - File
          2. Check - Specify import order, Import Action
              a. Select - Update existing records in found set
              b. Check - Don't import first record (contains field names)
          3. Check - Perform without dialog
      When the Import script is run from the Host computer, and the desired .csv file is manually selected, the Excel first row field names are not imported and the second row with the data is imported as expected. (See Host Import Mapping)
      When the same script is run from the Client computer, the Excel first row field names are imported and not the second row data.  To get the proper result, I have to leave the check box for "Perform without dialog" unchecked and then manually, from the "Import Action" group, check the box for "Don't import first record (contains field names)" to get the proper data imported. (See Client Import Mapping, check box is no longer checked)
      Is this caused by a defect in FMP 11?  I can't figure out why this is happening.


    • By JH Howland
      After my Windows 10 based Filemaker Pro 11 MarinaPro Solution is launched (Path = C:/MarinaPro/Marina.fp7), I need to create a variable ($$source = filewin:/C:/MarinaPro/ResScheduler/) to a revised default "Open File" path.  Because I need to select from several reservation request attachment Excel .csv files, placed in the ResScheduler directory by an Outlook 2010 Macro, my "Import Records" script is set with an "unspecified" data source.
      When my script is activated with Error Capture "Off", I get the obligatory Filemaker Pro Error message, "The file <unknown> could not be found..." and the "Open File window is still set to "Look in: "MarinaPro" (Default).  And, of course with Error Capture "On" there is no Open File window presented.
      I have to manually select and import the first Excel.csv file before the default directory becomes "ResScheduler".
      I want my default "Open File" "Look in:" directory changed from "MarinaPro" to "ResScheduler" before I open the first Excel.csv file.
      Is there a way, nothing I have tried is working.
      Import.pdf
    • By transpower
      I've updated my computer from Windows 7 Pro to Windows 10 Pro.  My FileMaker Pro Advanced 11 does not launch.  I get the message "The application has failed to start because its side-by-side configuration is incorrect."  What's the solution for this issue?
      Update:  I clicked on an fp7 file, and then Windows asked me to insert the FileMaker CD, which I did.  Some files were quickly copied over, and everything works fine now!
       
    • By JH Howland
      I have several customers that utilize our MarinaPro Marina Dockage Management solution.  All are running Windows 10 Pro 64Bit and Filemaker Pro 11.0v2.
      All the MarinaPro solutions are functioning well with exception to the one marina that is using an HP LaserJet Professional M1217nfw MFP printer.  The printer has been named "HP LaserJet".
      The problem is that scripted reports will not print after an updated/revised solution is installed on the computer.  However, a test page can be printed from the Windows default printer.
      Print scripts are utilized by more than one report and this sample is named -  "Master Portrait Printer | Current Record | All | 1 |" and is formatted as:
      #Used by: Print Float Plan Form
      #Used by: Toggle Printer Mode
      #Portrait Orientation
      #Print: Current Record | Print Range All | Copies: 1
      Print [Restore: HP LaserJet; No dialog]
      Filemaker Help states, "If you do not specify an output destination before saving the script or 'if the specified printer cannot be found' when the script executes, the 'output from the script step is sent to the user’s default' printer."
      It appears that the "specified" printer is not being found and the output from the script is "not" being sent to the user's default printer.
      However, if I "re-specify print options" and "Save" the script it will start working again.  And now I am unclear whether it is actually finding the FMP "specified" printer or the Windows "default" printer.
      Any ideas why this occurs?
       
    • By JH Howland
      In Filemaker Pro Advanced 11 ( and 14 ), is it possible to launch the Windows 10 Mail program (WinMail.exe.mui) using the Filemaker "Send event" or some other approach?
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.