And how is the FileMaker database structured?
It sounds like you have one table for donors and one table for donations and that you are exporting data from the donors table with related data from the donations table, but that's just a guess. There could be any number of tables and you would need to export the data from each table that holds needed data separately.
The Merge file export option will include field names as column headers.
I've included a screenshot of a record in addition to how I set up the export rules. All of the contributions related information is included in the options for Contributions_ID field option in the export instructions.
I was not with the organization when they were using FileMaker, nor am I familiar with the database structure and how/where information is stored.
Could you do us a favor and go to "File" - "Manage" - "Database" and take some screenshots there? Especially from the third tab "Relationships".
Would be nice.
If your structure is like phil said. One Contacts table and one Contributions table and you export form the Contacts table you will get every contact once, and you can get one record from the Contribution table in there as well.
But if you export from the Contributions table you will get every single contribution but you will get your contact information multiple times. Every contacts full information will be given for every contribution they made.
I think in your case this is probably the best way to go. But we need to be sure of your structure first.
The portal shown would appear to support the guess that there are at least two related tables involved.