Solved

EXPORT to CSV or Excel?

Posted on 2010-09-14
8
603 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
 
LVL 8

Accepted Solution

by:
Tocacar earned 500 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

947 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now