2 Replies Latest reply on Jun 19, 2017 11:07 AM by ahum

    Importing new field names and data from Excel to existing FM Pro 8 table - possible?

    RebeccaRichter

      Title

      Importing new field names and data from Excel to existing FM Pro 8 table - possible?

      Post

           Every year, I need to perform this daunting task of adding 200+ new field names to a new layout in our FileMaker Pro 8 database table. Instead of going to Define Fields and adding new field names one by one, is there a way to import the new field names and data from an Excel file to an existing FM Pro table? I know how to do a simple export and match field names, but what if there are extra fields in the import file (200+) that I really would rather not have to add manually? Please tell me there is a batch upload solution! And I'm not talking about creating a new table or database--I want to append our current table with the additional fields and data from the Excel file.

           Thanks in advance!!

        • 1. Re: Importing new field names and data from Excel to existing FM Pro 8 table - possible?
          FentonJones

                

               OK, I'm going to tell you how I'd do it. It may be possible to do something similar with something fancier, put I don't know of any way to automatically add "some" fields to a table.

               FileMaker can add fields upon an Import (or creation). So, what I'd do is open the Excel file with FileMaker. You can either create, a new file, or use the option to add a New Table (Target:) during an Import. I'd just use "Open" and create a new file, because I'm going to throw it away when I'm done with it (and it's less confusing).

               You now have a table with all the new fields. It likely also has existing fields. So you view the fields. This next method requires FileMaker Pro Advanced. It allows you to select all fields (on Mac, Cmd-a). Then, holding the Command key, click on the fields you do not want; they will no longer be selected. Now Copy. You can then go to the table you want to add these to and Paste. The new fields have been added to your existing table. (While this works like copy/pasting data, this is NOT data, it is special; it does not go to the "clipboard".)

               You now can do an Import Records from the file/table, where you have the new data. Choose "Matching Names" as the option. Once you've got the data, you can throw away the file/table. As you said, the next one is likely to be different.

               In both the "Open" or "Import", be sure to click: [x] Don't import first record (contains field names). FileMaker will still be able to create the fields if needed.

               I know, this sounds like many steps. But each can go fairly quickly; faster than creating hundreds of fields; FileMaker should get the correct types of fields from Excel.

               P.S. I see that you could do the Paste of the new fields right in the Import itself, by choosing the "Manage Database" button (lower right). Also, I do know whether FileMaker Pro Advanced 8 has all this. I no longer have it on this computer.

          • 2. Re: Importing new field names and data from Excel to existing FM Pro 8 table - possible?
            ahum

            This method saved me lots of time to import all the field names.

            Thanks