Need data from web form to drop into spreadsheet

[Cinda_...@adobeforums.com]

Help.

I’ve built a site in GoLive 8.0.1 that includes a couple of web forms. My host company uses FormMail, which has worked well to forward form data to me via email. I then take that data from Mail and manually enter it into FileMaker Pro.

Given the amount of traffic the site is getting, I can’t keep up with manual data entry and need a spreadsheet solution. Translated, I need the web form data to drop into a format that can be imported and/or read by Excel.

FormMail doesn’t do this, so no luck there. I realize this may well be a third party software issue (something that needs to be installed on the server), but am clueless about where else to turn. A 45-minute exploration on Google turned up a zillion ways to convert a spreadsheet INTO a web form, but nothing about how to get web form data to move INTO a spreadsheet.

Is there a plugin or anything that helps? Any idea what third party software would work? Don’t want to try something like Google docs since the form needs to remain inside the site to keep a consistent professional look across the board.

Thanks in advance!

[Jim_J...@adobeforums.com]

If you have PHP enabled on your server, you could easily write to a CSV file. Then you could access that CSV file from <http://www.yourdomain.com/log.csv>

Here's an example form processing script:

<?php
// DETERMINE THE DATE FOR A TIMESTAMP
$date = date("ymd-Hi");
// CHOOSE THE FILE TO WRITE TO
$LogFile = "log.csv";
// OPEN THE FILE
$FilePointer = fopen ($LogFile, "a");
// WRITE TO THE FILE
fwrite ($FilePointer, "\"$date\",\"$_SERVER[REMOTE_ADDR]\",\"$_POST[firstname]\",\"$_POST[lastname]\",\"$_POST[email]\"\n");
// CLOSE THE FILE
fclose ($FilePointer);
?>

This script assumes you are gathering a first name, last name and email address from a form submitted by the POST method. Tweak as needed with additional fields. It adds two optional columns to identify the date/time the form was submitted and from which IP address. You will need to create an empty/blank text file, name it log.csv, and upload to your server.