Is there a way by which we can select the fields manually from the layout in the form of checkbox selection. And only that fields will be exported as excel.
This might be possible, but the following suggestion has limitations:
Use a looping scropt to transfer data to a temporary table made up of text fields. Then export to excel from the temp table.
Getting the data into the temp table will be slow and there may be issues with exported time and date data.
Thanks for the reply . I am thinking of an alternative way to make use of XSLT .
Is there any resource or pdfs available to learn the use of XSLT on filemaker ?
Here's how I do this now.
Drag & Drop jQuery UI for Exporting | Soliant Consulting
A colleague came up with a good use of the web viewer to drag/drop excel. It isn't quite what you're looking for but it works. I've implemented this for a few clients and they love the ease of the method.
IT does require some setup: A table (or value list) of the fields you will make available for export, a web viewer, and a script. But I believe i was pretty much able to import the script and point some steps to my solution.
Thank You . i shall look into it.
I saw it .Export field contents is used .But if the data contents increased , then there shall be problem.
Thanks for the help.
You’re welcome. Let me know if you need any advice on it. It took me about 30 minutes to get my bearings and set up the first client, but for subsequent setups, it was much faster. The task of setting up the table (or value list (I prefer a table ) ) took the longest.
If you know anything about web viewers, you’ll be fine at this. Let me know if I can help.!
Thanks . i shall tell if anything needed. i am looking for some resource to learn xslt implementation in filemaker.
Can you provide me any links or learning pdfs etc..
Web search "Base Elements". The Goya site used to have a pretty good primer on XML/XSLT as I recall.
If you study Table View, and allow modification to this view (which will not affect other Views for the same layout), you can check/uncheck fields to be shown by the Modify dialog. You can also re-arrange the fields.
ONLY those fields (in Table View) will be exported to Excel.
Thanks for the help . i shall look into this.
Retrieving data ...