excel web queries with fm on the web

[the walker]

can you use excel to run web queries on file maker database that are on line through the web companion

[Anatoli]

Strange request - IMHO no.

WebCompanion is serving browsers with HTML.

[the walker]

what about an import from filemaker over the web

basically i was just wondering is there any way to extract data from filemaker online without having to write a massive program to parse all the data from html

[ February 25, 2002, 02:36 AM: Message edited by: thewalker ]

[the walker]

what about exporting records is that possible

[CyberSport]

the way i do this is to save the results page as an HTML file, then open the .htm file in excel. usually works, keeping most of the formatting even (i use excel 2001 for mac). of course, if you have access to the FMP database directly, much much easire.

bevin

[Hammerton]

Yikes! Keith has proposed a -script solution

Actually, depending on how frequently you need to file updated, you can use a plug-in called schedule-it to run a script that exports the data into a txt file. You can simply make a link to that file and it should download to the client. The up side of that is that you do not have to enable cdml-run scripts. The downside is that the client might get a version of the txt file that is not perfectly up to date.

[Keith M. Davie]

Whether db initiated or www initiated, scripts in any multi-user environment can be problematic. And, done improperly, an edit also can be problematic. Thus one must always take precautions to ensure that data is not lost, that clients are properly informed and that users (employee or stranger) are not impeded. A simple concept with no simple answers. But there are answers. Developers provide them.

[Keith M. Davie]

Well if there is no other way to export to Excel, perhaps a -script would be appropriate.