asked on

Export from FileMaker: some things missing...

Hello,

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?

Thanks!

Sumukha

ASKER

Just adding the link to that fp7 file:
http://developer.filemaker.com/solutions/detail/?item=solution.10000000541&web=US

ASKER CERTIFIED SOLUTION

North2Alaska

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Member_2_908359

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sumukha

ASKER

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

@North2Alaska
"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,

@lesouef
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)"

Thanks!

Sumukha

ASKER

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

Sumukha

ASKER

Thanks, guys!

Member_2_908359

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:
https://filedb.experts-exchange.com/incoming/ee-stuff/7617-Email-Campaign-Management.zip