Downloading and CDML on Apache?

[bkraatz]

Hello all--several questions.

First, how can I make a database downloadable. Well, I know the first I'd like to make the entire database (actually databases since there are several) downloadable--probably via an excel file. Here's another question, can I put information from several dbs into an excel file to download. Next question, can I do the above for a limited portion of said database(s), i.e. just data that users found in a specific query online? Basically, dynamically produce a downloadable file.

Second question, although it should be the first because it is probably infinitely more important and speaks to the potential danger I may be in. I have most of a database up and running online on my office computer. It is now being served with the web companion. I need to switch it to a windows server taht I think will be running Apache. I was once told, by what I hope to be a reliable source, that if I serve the database via a windows server such as Apache it will still read the CDML correctly. And although Filemaker doesn't recommend this, it should work. Will this be the case?

Thanks for any help,

Brian

[Garry Claridge]

First: You would be able to achieve this with a combination of a CDML query, a Script to export the data, then some html to download the file. Or, perhaps some XML exporting.

Second: Go for it!

All the best.

Garry

[bkraatz]

Just to clarify your "Go for it!"

If I put by databases on the Apache Server along with my HTML (with CDML interbedded) it should work just as well as it is now on my web companion server?

[Vaughan]

Ummm, you have to have at least one server that is running FMP (Unlimited) to share the databases and run Web Companion. The CDML format fiels must be inside the Web folder in this machine.

[Garry Claridge]

As Vaughan said you need to have FM running to be able to access the databases.

You can have FM and Apache on the one computer. They will use different ports. If you use Unlimited you can use the WebConnector which attempts to integrate the two servers better.

FMI advises against this single computer setup because of performance reasons. If the databases and Apache will be receiving a lot of hits, you may wish to consider two computers.

All the best.

Garry

[Anatoli]

Also, during the script run your WebCompanion will not process any web requests or requests may cancel the script.