PDA

View Full Version : Web form data to CSV


fopa
06-02-2009, 08:19 AM
I nornmally submit all my form data via the mail function, but i have been asked to submit the data into a text file, which the data can then be extracted into excel.

I have had look around the net for a solution but no joy so far, can this be achieved or will i have to look for an alternative solution

(php is not an option :()

coloeagle
06-02-2009, 10:40 AM
This might help you.
http://www.tectite.com/fmhowto/csvfiles.php

fopa
06-02-2009, 10:43 AM
Thanks i shall give it a try! Just one thing, is this purely for a PHP solution?

coloeagle
06-02-2009, 11:15 AM
Yes it is. Thought it would help get you headed in the right direction.

Just curious, why is php not an option?

fopa
06-02-2009, 11:57 AM
due to where the files will be stored, the server is near full. Not my decision, but one made for me.

fopa
06-02-2009, 11:59 AM
Would it be safe to say, this cannot be achieved via html alone?

coloeagle
06-02-2009, 12:11 PM
Not having done this personally, I would have to say no. I understand that it would require the need to write to a database, which requires a scripting language.

In the mean time I will email a couple of www buddies and see what they have to say.

fopa
06-02-2009, 12:13 PM
Thanks coloeagle, it needs to write to a CSV or .txt and then somebody else can copy that data into excel for analysis etc.

coloeagle
06-02-2009, 01:03 PM
While waiting I have been doing some searching. (I like learning new things :mrgreen:)

If you can't do it on your own server you can use an alternative. Take a review of this site and their program. http://www.formbreeze.com/
download here. http://formbreeze.formbreeze-com.qarchive.org/

DWcourse
06-02-2009, 01:17 PM
Why not just output it to an email with the fields separated by commas. Whoever gets the email cuts & pastes it into excel?

Corrosive
06-02-2009, 01:55 PM
Why not just output it to an email with the fields separated by commas. Whoever gets the email cuts & pastes it into excel?

They'll be climbing over each other to get that job in the office :wink:

davidj
06-02-2009, 03:25 PM
if php is not an option then you could use an HTA application

HTA uses the IE platform and by changing an HTML extension to hta you give the platform a lot more permissions and rights. You have access to the application library within IE

I wrote something in hta about 8 year ago and never touched it since

I will see if i can refresh my memory and have a dig about

DWcourse
06-02-2009, 03:32 PM
They'll be climbing over each other to get that job in the office :wink:
Sounds like my Dream job!

If you're willing to go with a commercial solution, Forms To Go (http://www.bebosoft.com/products/formstogo/features.php) can generate php, asp or perl scripts that can write form fileds to a text file on the server (or a database or an email)

coloeagle
06-02-2009, 03:49 PM
OK, general consensus is that your options are going to be limited.

fopa
06-04-2009, 09:02 AM
Sorry for my late reply, i spent all day yesterday trying to get a PHP solution to work. I got the ok to use PHP on another server etc.

Regarding the E-mail solution, there will be a couple of hundred replies per month and i for one dont fancy collating data, but i guess i might have to if i cant get php to work.

Anyway, i guess i should post my php problem in the right section of the forum.

http://www.dreamweaverclub.com/forum/showthread.php?p=160769#post160769