Jump to content
Sign in to follow this  
laudmusic

Excel export yields extra blank rows

Recommended Posts

I'm having a consistent problem when I export to Excel. When I do, there are empty row created between records. This doesn't occur in every record but enough to be annoying.

Any thought about this?

Share this post


Link to post
Share on other sites

Hey laudmusic,

I was having the same problem, and here is what I traced mine to.

My database is relational, having several tables of related data. I was exporting data from both the parent table, as well as related tables. Some of my related tables had more than one child record related to the parent record. In these cases, the excel file showed the parent record, and the "blank record" was the second child record, only it was blank for all fields EXCEPT the different value.

The way I solved it in my export solution was to sort by the primary key in my parent table, and in the export step, I choose "group by" my primary key during export. Warning: you have to choose the group by before you choose the primary key to export (why? I dunno, ask the filemaker gods). And the primary key does have to be in your export file, too.

After that, all my records showed up as expected, and no blank rows!

Feel free to contact me for clarification, if needed.

Cheers,

Tony

Share this post


Link to post
Share on other sites

This is so great Tony. Even though it's months after your post, thanks heaps! You've saved me from the asylum.

For the sake of posterity and other searchers, this extra blank row problem also applies to HTML exports, and probably other formats too (CSV, XML etc).

Cheers, Craig

Share this post


Link to post
Share on other sites

Thank you Tony!

We were having the same problem (extra records created during export) with FM 17 in a couple of different formats (mer and csv), and checking "group by" my primary sorting key during export, as you recommended, worked nicely with no extra records, yay!

Take care and thank you again, -Sonya

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.