rows to excel columns

[David Jondreau]

Does anyone have any tips on converting my nice normalized database into an Excel spreadsheet?

A client wants to export Contact Info and Address for Contacts to Excel. There are multiple Contact Info records (phone, e-mail) per Contact and there may be multiple Addresses records per Contact as well. All three are separate tables.

The client would like each related record in separate cells in one row per Contact, ideally with the Address and Contact Info data in the same row.

I'll take just the multiple related Contact Info records in one row per Contact though, if anyone has any suggestions.

Thanks

Edited April 10, 2008 by Guest
typo

[Fenton]

This is going beyond "flat," this is more like "squashed" :-]

You might want to look at the Custom Function, GetRows, and GetNthRow (need both), at:

http://www.briandunning.com/filemaker-custom-functions/list.php

It can flatten a portal into its records, all in one calculation field. If you exported that as Excel or CSV it might work. I'm not sure though how the FileMaker internal returns translate into an Excel cell. Perhaps they use the same character, or at least understand each other.

I'd test it, but I'm running a batch operation; FileMaker is busy.

[Fenton]

I just exported a field with returns to Excel. It worked OK (kind of, perhaps). At first it seemed to put it all on one line of the cell. But when I clicked into the editing box (function box), then it put it on two lines, and adjusted the cell height.