2 Replies Latest reply on Nov 9, 2012 8:39 AM by philmodjunk

    Import Repeating Fields



      Import Repeating Fields


           I recently had a catastrophic system failure. I and had to send the file to FMP for reconstruction. I have since received the file back. I have a known working file and have cloned and compacted it. The data I received from FMP has been exported to xlsx files. Now I see that repeating fields will only import the first line. Is there a way to import all the data from all the fields that have multiple lines? I know that I could retype the data but my solution is  a bit large, 170 tables, and that would consume alot of time. I'm using FMP 11 advanced. Please accept my thanks in advance for all your help.

        • 1. Re: Import Repeating Fields

               The first suggestion that will be offered by most designers is replace repeating fields with a table. There are logical reasons for using repeating fields, but the problems their use cause often offset the design ease of display.

               If the repeating field is in one table, it might make sense to create an intermediate database for import, that way you have greater control of the process.

               Trimming a clone of the database may be faster than constructing from a blank database.

               More information about the data structure would be helpful.

          Please Help Us to Help You...   Please Help Us to Help You... .

          • 2. Re: Import Repeating Fields

                 I hope after you get everything back up and running that you take two lessons to heart, one small, one huge:


                 All databases should be backed up frequently, with numerous sequential copies preserved and stored in at least two completely separate physical locations. Such back ups should have minimized or elminated the need for the rebuild that you are having to do.


                 Repeating fields aren't usually the best design option for a FileMaker database.