Solved

FM - Exporting Records from a Portal

Posted on 2013-05-29
6
1,147 Views
Last Modified: 2013-05-29
Trying to export records from a portal into an Excel file, but getting too many records.  Doesn't limit it to the TO relationship.  Am I going to just have to create a layout and then do a Find for those records and then export?
0
Comment
Question by:rvfowler2
  • 3
  • 3
6 Comments
 
LVL 25

Expert Comment

by:Will Loving
ID: 39205441
To export from a portal, you would use Go To Related Record, specifying the relationship the portal is based on. The GTRR script step should specify any layout based on the table you wish to export from.

Whether you use GTRR or a Find before doing your export, you don't really need to create a layout to do the export unless you have no layouts at all based table being viewed in the portal. All you need is a layout based on the table; it doesn't even have to have fields on it.
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 39205561
Thanks, though I don't want all the fields, just certain ones, so what I did was create a layout with only the fields I want to export, set the fields and do my Find (turns out find fields do not have to be showing), then do a SaveRecordsas Excel.  This script step also has the advantage of only exporting the field name in the title, not the table name as well.  Is this what you're talking about or is there a better way?
0
 
LVL 25

Assisted Solution

by:Will Loving
Will Loving earned 500 total points
ID: 39205659
Using Go To Related Record (GTRR) does the Find, change layout and Sort (if the relationship is sorted) in one single step followed by Export of course. Using Freeze Window, Go to Layout, Find, Sort, and then export is a few more steps but it's essentially the same and though I don't know for certain I think FM is doing essentially the same thing under the hood.

The only thing I will note is that neither the Find nor the Export require you to have any fields on the layout. The default list of fields on the left side of the Export dialog will show only the fields on the layout (or none if there are none) but you can easily change that to "Fields in Table" and select whatever fields you wish for export regardless of their presence on the layout.
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 2

Author Comment

by:rvfowler2
ID: 39205673
Users will be using this, so I don't want to leave it up to them.  I was thinking of creating different layouts depending on about 5-7 different options for exporting certain fields.  Users will select from a global checklist field so they can select the fields they want to export and then my script will run off this to select the correct layout and export.
0
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39205734
Depending on how varied the export sets are, you could simply save the Export script step with a default set of already selected fields on the right using the "Restore" option and them teach them how to Clear fields by double-clicking on them on the right (or clicking once and then clicking "Clear"). If the exports are quite varied then multiple layouts as you suggest, or have the script offer a choice of various default steps and then use If and Else If to determine which Export Records step to use, each with a different set of saved selected fields.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 39205766
Thanks, yes there are hundreds of fields, so too much to choose from, but thanks for giving me so many options; I'm recording them for future use.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

791 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