collecting web visitor info? help
collecting web visitor info? help
Author
Discussion

jamesuk28

Original Poster:

2,176 posts

284 months

Thursday 2nd August 2007
quotequote all
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

shadowninja

80,189 posts

313 months

Thursday 2nd August 2007
quotequote all
Very easy to do. Don't they have a web developer to hand?

jamesuk28

Original Poster:

2,176 posts

284 months

Thursday 2nd August 2007
quotequote all
We are designing the site, but never done one of these before. Its the exporting to excel / welcome email that concerns us.

jagnet

4,442 posts

233 months

Thursday 2nd August 2007
quotequote all
If you need any assistance setting up the email/export feel free to email me.

shadowninja

80,189 posts

313 months

Thursday 2nd August 2007
quotequote all
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.

Plotloss

67,280 posts

301 months

Thursday 2nd August 2007
quotequote all
Google for Tectite FormMail

That will do everything you need and more, its in PHP and completely free.

jamesuk28

Original Poster:

2,176 posts

284 months

Thursday 2nd August 2007
quotequote all
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.


Plotloss

67,280 posts

301 months

Friday 3rd August 2007
quotequote all
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.