1 Reply Latest reply on Jan 13, 2015 2:43 PM by TSGal

    File with data, but it is not visible in record



      File with data, but it is not visible in record


      FileMaker Pro



      Operating system version


      Description of the issue


      I use FileMaker to collect data in layouts, with tables specific to each layout.

      I have one layout which has a slider on the bottom, providing two different panels in which data can be entered.

      I have 3 separate files that are showing data in the file size (when compared to the original file prior to data collection). And are also showing the creation of 1 record... however the data is not actually visible in the file. The file has data entered in text fields & 6 photos.

      So the process for this is I prepare a file for someone else, this file then gets loaded to an ipad, data is collected and the file is then downloaded. So the original starting size of these files was 8,736 KB and they returned to me showing the size of 21,003 KB.

      However, when I open the file you cannot actually see any of the data.

      I will describe the many ways I have tried to see it/solve the issue:

      - export to excel. I can see the data fields of the 1 record created but no text is there.

      -save/send to excel. I can see the data fields of the 1 record created, but no text is there.

      - reload to ipad. data is still not visible.

      - unload the file I reloaded to the iPad back to the computer. Still not visible.

      - Save as a compressed file, and open as a recover file. Still no luck.

      - Place the same fields in a new layout (referencing from the accurate table) to see if they were 'falling' off of the layout. No luck.

      So I am curious if any of you have ever had an issue where your file size is showing that data was entered, but you couldnt see it. If so, could you recover it? Or can files actually show that the size is changed, and still lose the data?

      Thank you so much!

      Steps to reproduce the problem

      So I did try to replicate a possible issue.. leaving the progam open on the iPad while transferring it, but this did not create the issue.

      I also tried leaving the cursor in a text box while transferring it. But the data transferred fine and is visible.

      Expected result

      My intent was to be able to see the text and photos that were entered into FileMakerGo when I opened them on my computer.

      Actual result

      However the file size shows they are there, but I cannot actually see them.

      Exact text of any error message(s) that appear



        • 1. Re: File with data, but it is not visible in record

          Alyssa Phelps:

          Thank you for your post, and I apologize for the late reply.

          When you add a new record to a database file, the record is created.  When you being updating the information for that record, the file size will increase to accommodate the data (especially pictures), but if the record is not committed (due to crash or force quit), the data will be lost, but the file size will not be reclaimed.

          From your description, it sounds like the data was not committed for that one record.  I do not know the cause, but I would repeat the steps you had previously, commit the data, and see if the data is then present.  If the issue still occurs, then you may have a damaged/corrupt file.  If this is the case, execute Recover (from the File menu) on the database file.  When Recover finishes, open the Recovered file and try again.

          FileMaker, Inc.