Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Export from FileMaker: some things missing...

Posted on 2009-04-28
Medium Priority
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
  • 4
  • 2

Author Comment

ID: 24257058
LVL 12

Accepted Solution

North2Alaska earned 1000 total points
ID: 24259331
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

lesouef earned 1000 total points
ID: 24260520
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.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 24261745
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

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

Author Closing Comment

ID: 31575748
Thanks, guys!
LVL 28

Expert Comment

ID: 24262634
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

580 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