CDML & Export

[mortemar]

Hi there,

is there a way to export records using CDML ?

I need to enable "exporting" as offered within FileMaker ( a .tab file).

Any idea ?

I've been developing a solution using odbc and sql requests, but I was wondering if there existed a faster/easier solution with CDML.

Thx,

Jerry

[Garry Claridge]

Do you want the exported file to save to the computer with the browser?

You can use Applescript and CDML to achieve something similar.

Or

CDML can run a Script to export a file.

Good Luck.

Garry

[mortemar]

Pretty much !

What I need is for the user to be able to select fields to be exported, and then format the output into a file such as :

data1;data2;data3

data1;data2;data3

I've read that script and CDML wasn't a good option when multiple users can access the database simultaneously.

Using php I was able to create an export file, but I had to use an apache server and go with sql queries.

What I'm trying to find out actually is if I could do the same using the FM webserver and CDML+javascript(eventually)

Thanx for the suggestion anyway !

Jerry

[Garry Claridge]

The only pure CDML way is to present the raw data to the browser then for the user to save the page as a file.

A Script could be used if the probability of collision was very low, or you could use the "Simplify" method for running Scripts from the Web. This would be combined with a little bit of Javascript to then download the file.

All the best.

Garry