?
Solved

EXPORT to CSV or Excel?

Posted on 2010-09-14
8
Medium Priority
?
626 Views
Last Modified: 2012-05-10
While in Filemaker Pro Website List View, is there a way to EXPORT to CSV or Excel the display?

Hell even a Print of it, where it prints the data, but NOT the web browser screen info is helpful.

Any idea..

Chip
0
Comment
Question by:OSXFreak
8 Comments
 
LVL 9

Expert Comment

by:jvaldes
ID: 33673932
If you have the field names that are on the list view, you can use the export file command and save the same data to an excel sheet. If you want the exact selection and you are using FM9 or better there is the save/send record as> excel
0
 

Author Comment

by:OSXFreak
ID: 33674129
I am using FMP 11 and I see that while in the FMP program, I can do the File>Save/SendRecord as option, but was wondering if while in the Web sharing screen, is there a way to do the same thing.. export as excel?
If not a way, is there a way to PRINT the filtered table? and anyway to suppress those things that are not needed for printing? But are needed for view?

Thanks
Chip
0
 
LVL 6

Expert Comment

by:ThomDroz
ID: 33678442
OSXFreak:

Couple solutions
you can have a print button, that prints a runs a script that moves to another similar layout with the information in table view and print that, or a script that will export the data with a "save records as excel" step
hope that helps!
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Accepted Solution

by:
Tocacar earned 2000 total points
ID: 33680326
As far as I know, it is not possible to use any native Filemaker functionality on IWP that would communicate with the user's desktop or local resources (i.e., printer), other than a straight forward print of the browser screen.  This means that export, save as PDF, etc. shouldn't work, nor should "fancy" printing requests (anything above or beyond printing the browser window).
0
 
LVL 8

Expert Comment

by:Tocacar
ID: 33716516
Hi Chip
You've opted to close this question instead of awarding points.  Also, you should award points to the expert who provides the best solution/ answer to your question (rather than just share them between all those who answered :o)
0
 

Author Closing Comment

by:OSXFreak
ID: 33716596
Sorry, did not mean to upset you. I figured taking your information, I'd not be able to do an export or print of the data from the filter list.  BUT he also gave me a solution. Create a Report, and then from there YOU CAN do exports to PDF or Excel. So that is my plan.

I figured I'd offer both since I took your info and learned, and also took his info and learned as well.

Thanks

Chip
0
 
LVL 8

Expert Comment

by:Tocacar
ID: 33716640
Hi Chip
I'm not upset at all... I simply misunderstood the point you made when you closed the question.  You seemed to agree with my point that Save by PDF (or Export to PDF/Excel) wouldn't work via an IWP interface and you intended to share the points simply because we both answered.  Please by all means ask a moderator to share the points between myself and ThomDroz.  
0
 
LVL 8

Expert Comment

by:Tocacar
ID: 33716654
Oops, and jvaldes (didn't notice his/her comment up the top there).  No hard feelings, I hope.  :o)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

809 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