Yes it would and there are probably a variety of ways to do it.

One method would be to provide a link or button to allow the user to start
the process. In this link (or as a hidden field in a button/form) you would
need to have an argument that would allow the correct data to be retrieved
from the database.

Perform a database search using the criteria of the argument. Save the
returned results to a local variable. Create a File action. In the file
action select write, and select an appropriate location and file name.
Remember that if you want the file to be deposited into the calling
directory of the taf file you need to use <@WEBROOT><@APPFILEPATH>. You can
use a variable for the file name provided you've assigned a value prior to
the file action being called.

Then in the 'Data to write' area of the file action call the variable. You
can add any additional text/characters you wish in this area. It could even
be a combination of more than one variable. If your search results create an
array variable, and you want to omit the table tags that would normally
appear use the <@ROWS ARRAY=xxx> along with <@COL NUM=x> tags to position
each field of data in your 'Data to write' area.

Finally make your selection for 'If file exists' as to whether you want to
create a new file each time or append to the existing file.

Then provide your user with a method of retrieving the file. A link in a
results window will do or you can email the text file as an attachment by
adding a mail action immediately after your file action.

Hope this helps,

Steve Smith

Skadt Information Solutions
Office: (519) 624-4388
GTA:    (416) 606-3885
Fax:    (519) 624-3353
Cell:   (416) 606-3885
Email:  [EMAIL PROTECTED]
Web:    http://www.skadt.com


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Marc Leblanc
Sent: May 14, 2002 9:30 AM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: exporting data to a text file


Hi all,
I would like to know if it was possible to export the data from a lookup
action to a text file from a user intervention.

Let's say a user sees his order on the screen then by the click of a button
would be able to save it in a text format.

Is that possible at all?

thanks

Marc Leblanc


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

Reply via email to