1) As you know Alpha Five offers the opportunity to export any report to a HTML-page, although I have found the HTML-coding options rather limited, if you make it to detailed, the function holds.
2) I put one button on a form that creates the actual HTML-page. Don't forget to tell Alpha where to save the file, and state the filename in the Options tab of the Print a Layout function that you call from Action Scripting.
If you mark the check-box for Alpha to open the newly created HTML page in the program attached, it will show you how the HTML page has turned out.
3) Then I create another button on the form that actually sends this HTML page to my FTP server, using the built-in Windows Command Line FTP interpreter.
Normaly, you would find this program (when running XP) in the directory c:/windows/system32/ftp.exe
On this second button, you choose for Opening Another Program again by action scripting.
The address of the program is like I stated above (you need to verify that on your own machine).
Then, on the second line, you can enter commandline parameters for this program.
In my case, this would be:
-n -s:upload.text
The -n option has to be used if automatic login on your FTP server is implemented, otherwise it won't work. Just try it. The file upload.txt is a text file that has to be in your actual Alpha Five Application Directory.
This is what the file looks like:
open 000.000.00.00
user
xxxxxxxxxx
yyyyyyyyyy
put upload.txt
quit
the zero's have to be replaced by your FTP server's IP address. The xxxxxx have to be replaced by your loginname, and the yyyyyy has to be replaced by your password.
The second button starts FTP.EXE, connects with your FTP Server, logs-in, gets your file from the directory, uploads it, and quits the server.
This is a nice feature to embedd HTML pages that are automatically created from your Alpha application into your website with just a few pushes on buttons.
Works great, especially if you do not use V6 (yet).
Regards,
Marcel
2) I put one button on a form that creates the actual HTML-page. Don't forget to tell Alpha where to save the file, and state the filename in the Options tab of the Print a Layout function that you call from Action Scripting.
If you mark the check-box for Alpha to open the newly created HTML page in the program attached, it will show you how the HTML page has turned out.
3) Then I create another button on the form that actually sends this HTML page to my FTP server, using the built-in Windows Command Line FTP interpreter.
Normaly, you would find this program (when running XP) in the directory c:/windows/system32/ftp.exe
On this second button, you choose for Opening Another Program again by action scripting.
The address of the program is like I stated above (you need to verify that on your own machine).
Then, on the second line, you can enter commandline parameters for this program.
In my case, this would be:
-n -s:upload.text
The -n option has to be used if automatic login on your FTP server is implemented, otherwise it won't work. Just try it. The file upload.txt is a text file that has to be in your actual Alpha Five Application Directory.
This is what the file looks like:
open 000.000.00.00
user
xxxxxxxxxx
yyyyyyyyyy
put upload.txt
quit
the zero's have to be replaced by your FTP server's IP address. The xxxxxx have to be replaced by your loginname, and the yyyyyy has to be replaced by your password.
The second button starts FTP.EXE, connects with your FTP Server, logs-in, gets your file from the directory, uploads it, and quits the server.
This is a nice feature to embedd HTML pages that are automatically created from your Alpha application into your website with just a few pushes on buttons.
Works great, especially if you do not use V6 (yet).
Regards,
Marcel