Viewing Forms Data On The Web Site

A

Arthur Shurn

After I create a form using FP2003 and have the results stored as a file .CSV
on the server, can I also disply this information for future viewers to see.
I understnad I may need to review before allowing all to see and will do that
manually. Just want to know if I can do this without a real database.
 
A

Andrew Murray

Unless you type the data into into the web page manually, yes you need some form
of basic database which is at a very basic level, a file of records manipulated
by some programming to display certain results via a "query".

Try www.ezscripting.co.uk for a free script (a suite of scripts) that mainuplate
flat-text databases (CSV/Text files). - cgi/perl. the data source is a plain
notepad/text file - character separated value(CSV) file. The site offers free
the basic version of the scripts and an advanced version for 30.00 (US$) for all
six scripts in the suite (create record, search, read, edit and backup).

They are excellent for database stuff where you don't need the highest security
for data and so on, but it is good to learn the basics of databases and perl
scripts.

It may or may not suit your needs and works on Linux/Unix. You might want to try
instead, to put the data into an Access Database through the FP results
wizard/interface wizard. ASP/Access/FP extensions.

Have you tried using the results wizard in frontpage, but point the wizard
results to the csv file instead of to the mdb file?

What is your server type - Windows or Unix/Linux?

If you do know a bit about scripts (all you need to know in the case of the
ezscripting.co.uk is how to set up the path to perl, change a few variables and
you're done. They have comprehensive instructions and a help forum to discuss
and ask questions.

Hope this helps.
 
Top