Need data from web form to drop into spreadsheet

help.

ive built site in golive 8.0.1 includes couple of web forms. host company uses formmail, has worked forward form data me via email. take data mail , manually enter filemaker pro.

given amount of traffic site getting, cant keep manual data entry , need spreadsheet solution. translated, need web form data drop format can imported and/or read excel.

formmail doesnt this, no luck there. realize may third party software issue (something needs installed on server), clueless else turn. 45-minute exploration on google turned zillion ways convert spreadsheet web form, nothing how web form data move spreadsheet.

is there plugin or helps? idea third party software work? dont want try google docs since form needs remain inside site keep consistent professional across board.

thanks in advance!

if have php enabled on server, write csv file. access csv file http://www.yourdomain.com/log.csv

here's example form processing script:

 
<?php 
// determine date timestamp 
$date = date("ymd-hi"); 
// choose file write 
$logfile = "log.csv"; 
// open file 
$filepointer = fopen ($logfile, "a"); 
// write file 
fwrite ($filepointer, "\"$date\",\"$_server[remote_addr]\",\"$_post[firstname]\",\"$_post[lastname]\",\"$_post[email]\"\n"); 
// close file 
fclose ($filepointer); 
?> 
 

this script assumes gathering first name, last name , email address form submitted post method. tweak needed additional fields. adds 2 optional columns identify date/time form submitted , ip address. need create empty/blank text file, name log.csv, , upload server.

and if still want email alert sent well, insert these lines before closing php tag: ?>

 
$emailmessage = "data has been submitted:\n\nfirst name: $_post[firstname]\nlast name: $_post[lastname]\nemail: $_post[email]\n"; 
 
mail("you@yourdomain.com", "form submission data", $emailmessage, 
     "from: you@yourdomain.com\r\n" . 
     "reply-to: you@yourdomain.com\r\n" . 
     "x-mailer: php/" . phpversion()); 
 

More discussions in GoLive

adobe