And it would be helpful to describe/show why you think all records are there but the data isn't. It might be something that is merely creating the illusion that the data is missing.
And there's another way to rebuild indexes. The above method rebuilds a single index and that might do the trick. But you can use advanced recover options to rebuild all the indexes in a file in one process.
Open FileMaker without opening the file.
Select Recover from the file menu
Select "advanced options"
Copy File Blocks "as is"
Rebuild Indexes Now
While I usually do not attempt to put a recovered file back into production if I can help it, this is my one exception. Since the file itself is not modified except for rebuilt indexes. The result obtained here would be identical to importing all your data into a clone of your file--but with many fewer steps if you have a lot of tables in the same file.
Is it possible that someone used the Replace Field Contents command at some stage? If someone, say, intended to delete the contents of a field on single record and used this approach to do it, it would have deleted all contents from all records in the found set.
Have you done any recent imports?
What would probably be best is to find a way to let a skilled outsider take a look at your file or a copy of your file.
Each of the records has a Company ID field: it still has data, but all the other fields do not.
I tried your reindex method but it didn’t work
I had a couple of similar sounding occurrences a year ago. In different databases on different systems. The records appeared to be there but ? in all the fields
A single record turned out to be the pivotal culprit, in both instances, and index corruption.
From memory, the record count indicator was one less than (? or one more) the last primary key value in one of the databases; which was only helpful because there weren't any deleted records ( could establish that looking at backups), so it did help at the time in terms of indicating there was a problematic record, and eventually identifying it.
I mention the record count as it may be useful, in comparing a backup to the live data, up to a common last record.
Working on a copy, I would first export all records from the table as a merge file, just to see if the data is actually still there; probably not but worth a look.
Delete all records from the file copy table, close the file, quit FileMaker, re-open the copy then import from the back up, cross check the record counts.
there are a few other things that can be done to investigate problem records.
Basically it is probably an indexing issue, as others have indicated, but it may be file based.
Despite repeating delete and import processes on one of my problem files last year, the problem re-occured, and I eventually replaced the file with a good clone and reimported all data.
As Bruce suggested, probably a good idea to get an experienced dev to have a look.
1 of 1 people found this helpful
If the file is "corrupt", anything is possible
Run Recover, and check the Recover Log for any changes. It might provide a clue
I once had a large file that reported "Records: 0", and went blank, yet the data was there
"Delete all records" alone won't help. Make a Clone, if you need to re-import
> I just suddenly lost all data in one table within my database but yet all the records remain
Know any skilled person?
Please also contact FileMaker Tech Support
They need to be aware of problems like this ( and may be able to quickly confirm if all your data is really gone )
Which Version of FileMaker are you using ?
> Know any skilled person ?
Does the table have a modification timestamp field? If it does, and it shows all records were last modified at the same time, that might give you a clue.
I have FM 12 pro
The layout may be corrupt, not the table. You may have created the layout using a TO that was delected.
Double click on any field that doesn't show data and see if the correct table and field show up as selected. If not you can redirect the fields to the correct TO. Sometimes we create form layouts from the non master TO and delete that TO.
Have you created a Table Layout and if not do so. Does that show the data in the fields? If so, the layout in question is probably corrupt.
Use a copy of the file and open the layout in layout mode. Do a select all and cut all the fields. Now save the layout out. Paste the cut data back into the layout and position it to fit correctly. Now enter browse mode. Does the data appear?
Can you drag any field onto the layout and have its data appear in browse mode?
IF the data shows in a new table layout and not the layout in question consider one of these options (or others)
- Test these ideas on a copy of the table
- Create a new table layout and verify the data
- You can repoint the fields to the correct table if the TO was deleted
- You need to create a new layout from scratch.
- You can select all and cut the objects on the layout, save it and then paste everything back onto the layout
- Use the recover ideas mentioned above
Note the wide ranging "guesses" as to what may have happened. This is largely due to the fact that you have said very little about your database, what happened exactly and what you see in the database that leads you to believe that your records are still there but the data is gone. One of the very first posts here suggested a back up--ultimately back up copies are your most important way to protect data integrity.
More detail: I do have a backup copy.
But its a not completely up to date.
Since my assistant works on the database its hard for me to know what
if anythingshe did. I have a database with many tables. Two tables are the core: contacts and organizations. The key or common field is "Contact ID". The organization table has what I estimate to be the same number of records (2374) as it did before the data loss. Only the Contact ID field still has information in it.
Its possible that the computer was improperly shut down while the database was open.
I do use Outlook Manipulator plug in (pulls in email)