collecting web visitor info? help
Discussion
Hello. We have a client that wants to offer a free trial for a product. They want to have a page on their website (or a link to a portal) that simply collects the required info, ie name, address, email, tel number etc - then for a welcome email to be sent - the client would need to be able to log on to view the collected info and crucially export that info to excel (csv)
Anybody know any cheapish solutions / CMS ?
Thanks
Anybody know any cheapish solutions / CMS ?
Thanks
Ultra cheap bodge-it solution: form data is stored in an Access database by the system. They can view this data in a hidden section of the site (password-protected, of course) in its entirety on the screen. Simple copy and paste to Excel.
Emailing: just use a free downloadable script and asp module (not the right word but I forget!) to send the email.
Emailing: just use a free downloadable script and asp module (not the right word but I forget!) to send the email.
Thanks plotless, we have installed this now, and are running tests on the system.
The client wants to use Frontpage (yes I know) to update the site themselves. I am aware that we could technically convert a standard frontpage form to export to a database and then as a CSV to excel, but having looked at this it seems a real pain in the ar5e to setup.
The client wants to use Frontpage (yes I know) to update the site themselves. I am aware that we could technically convert a standard frontpage form to export to a database and then as a CSV to excel, but having looked at this it seems a real pain in the ar5e to setup.
http://www.tectite.com/fmhowto/csvfiles.php
That creates a CSV format file on the server, first time it runs it creates the headings and then adds lines as formdata is submitted (you can also mail each record submitted in addition to storing them in a CSV) it adds the records to the CSV
Then at the client site, provide an MS-DOS batch file that periodically logs onto the FTP server, gets the CSV file and copies it to a directory either locally or across their LAN.
If you just want incremental records between downloads, just copy the a shell (headings, no data) of the CSV over the server version in the same batch file.
That creates a CSV format file on the server, first time it runs it creates the headings and then adds lines as formdata is submitted (you can also mail each record submitted in addition to storing them in a CSV) it adds the records to the CSV
Then at the client site, provide an MS-DOS batch file that periodically logs onto the FTP server, gets the CSV file and copies it to a directory either locally or across their LAN.
If you just want incremental records between downloads, just copy the a shell (headings, no data) of the CSV over the server version in the same batch file.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


