Charles J. Vella 0 Report post Posted July 13, 2023 Hi I am getting a message that one of my .fpt files is missing or corrupted, specifically the I.fpt file. It definitely exists, so may be a corrupted data file. When attempting to print out an individual detail report, I ge: Memo file c:\Dropbox\TMG8\2 MHSXMHSJ.FPT is missing or is invalid. Any clues how I can fix this file? Many thanks Charlie Vella Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 14, 2023 We've repeatedly warned about exposing your working project to cloud services since the project very easily can be corrupted. It's difficult to locate the damaged record and repair a .FPT file and having the project in the Dropbox folder makes things much more complicated. Do you have a current copy of the project in a location such as the TMG projects folder? If you haven't recently added any exhibits, you can use the _I.dbf and _I.fpt files from your most recent backup. (That's I (eye) right?) You would need to reindex after refreshing the files. %%%%%%%%%% Since you got the error running a report, you could identify all of the exhibits being output in that report. Then check each exhibit and delete the one that has corruption. It might be the caption for example. There are 15 fields in the memo file any one of which could be corrupted. Although only a few of those fields are likely to be used. It's possible that only one field in the memo linked to one exhibit record is corrupted. Although I typically find the entire memo linked to one record is corrupted. Then re-add and configure the exhibit. Share this post Link to post Share on other sites
Charles J. Vella 0 Report post Posted July 15, 2023 Jim This is example of a printout of all the obits in my project (it spits out 7 copies of the same memo). I have not added exhibits in awhile: Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 15, 2023 This doesn't help since I have no context. This is a Individual Detail report (with default settings) for Ann Pulis (don't know her birthname) who has one Obituary event (and no exhibits appear to be involved in the report)? Share this post Link to post Share on other sites
Charles J. Vella 0 Report post Posted July 15, 2023 Correct. Share this post Link to post Share on other sites
Charles J. Vella 0 Report post Posted July 16, 2023 Is there a way to get into the actual data file to correct it? Many thanks. Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 16, 2023 Did you try to replace the files with those from a recent backup? That's easy if you have a backup with an undamaged .FPT file. You must replace both the .DBF and .FPT files. Editing the files requires proper tools and then you need to locate the damaged .FPT memo(s) and that's non-trivial. Share this post Link to post Share on other sites
Charles J. Vella 0 Report post Posted July 17, 2023 Jim Unfortunately all my backups have same issue. I have tried multiple replacements of both files and all come up with same extra garbage in the printout. What databse was used to create these data file? Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 17, 2023 You are getting both a exhibit .FTP error and reports with missing text? There are separate issues? If so you have damage to more than one table. TMG 9 was created using Visual FoxPro 9 with Service Pack 2 (plus additional add-ons and libraries). For example, GenBridge and the report manager are additional libraries. Share this post Link to post Share on other sites
Charles J. Vella 0 Report post Posted July 18, 2023 Jim I tried running a individual narrative asking to print out all obits whose memo was not empty and I got a perfect print out of all 1379 obits. Which solves the original problem I had. Individual detail still does not work for same output. Many thanks for your help. Do you still use TMG9 or have you switched? Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted July 18, 2023 I moved my main data set to RootsMagic almost 9 years ago and, from there, to Family Historian about 2.5 years ago. Share this post Link to post Share on other sites
Michael Hannah 0 Report post Posted August 21, 2023 Charles, I have heard mentioned of a rare few cases where the specific filters "Is empty" and "Is not empty" do not work, as reported in my on-line list of remaining bugs in TMG9. I am not totally surprised that a different report will work with that filter as that seems common. If you care you might try the operator "Contains" in an Individual Detail report if you can think of something like the text "the" which they will all contain. P.S. I am still actively using TMG9 with SecondSite output. Share this post Link to post Share on other sites