Export from FileMaker: some things missing...

Posted on 2009-04-28
Last Modified: 2013-11-05

We are using the standard Email Campaign Management database on FileMaker 8.5.
We have created some Groups and want to export the whole database into csv.

When we export, the groups are not listed in the csv file. Also in the full table view in FileMaker no group assignments show.

Q: How do we export all our contacts sorted by groups - - or how do we export our contacts so we can sort them later by our groups?

Question by:Sumukha

    Author Comment

    LVL 12

    Accepted Solution

    First, remember that exporting is not like printing.  You do not get the benefit of layout parts (header, footer, etc...).

    But having said that and if what you want is the raw data, this can be easily done.  I did the following:

    1) Create a new layout (I called it Export).  Show records from the groups_Contacts table instance (TI) (not the Contacts TI).
    2) Add the fields to the layout you would like to export.  This doesn't have to look pretty, just through them on.  :-)
    3) Find the records you want to export and sort them as desired.  
    4) Select the Export Menu and select the type of output you would like.  Click Save.
    5) The default fields list should contain the fields from the Export layout.
    6) Move the fields into the "Field export order" in the order you would like.
    7) Export

    There is one extra thing in the Export dialog box you may want to consider, "Group By".  If you sorted the records in step 3, the fields you sorted by will be displayed in this box.  You can check the ones you want to "Group by".  What FileMaker will do is remove duplicate values from that field in the export.  So, if you have sorted by Group Name and selected it in the Group by, The export will only export the group name on the first row of data as the group name changes.  This is may or may not be what you want. Play around a little to see the results until you get what you want.

    LVL 28

    Assisted Solution

    you should add the group field (name or ID?) to be exported from the related table, as it won't show up from the current layout list if not placed on the layout.
    another way, if you don't feel confirtable with that, is to put all the field you need (from current table and from the related group table) and export as excel which automatically takes all present fields on the current layout.

    Author Comment

    Thanks to both of you for the comments.
    I usually don't work with FM, so I have to battle my way through this.

    "2) Add the fields to the layout you would like to export."
    When I go to add the groups_Contacts table I cannot add anything related to Groups,

    Failed to "add the group field (name or ID?) to be exported from the related table".
    How do I do your next step "put all the field you need (from current table and from the related group table)"


    Author Comment

    I made it! Both of you were right, so I double the pints and split them.

    Author Closing Comment

    Thanks, guys!
    LVL 28

    Expert Comment

    this is because you export from a layout which is not based on the right table occurence. this is a quite weird thing specific to fm! so the layout you create should be based on groups_group_contacts in fact, because this db allows a user to belong to several groups, so its a N to N relation.
    see my example:


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now