Solved

Convert Email Data from Web Form to a delimited file or Excel / Access file

Posted on 2004-08-09
19
190 Views
Last Modified: 2013-12-25
Can anyone help?
I need to Convert Email Data from Web Form into a delimited file or Excel / Access file so that I can then easily import the data into a spreadsheet or database.

Can anyone help?

I am using a mac, using Dreamweaver to build my form and the cgi script "formmail" - although if I need to use ASP I think I could manage this.
0
Comment
Question by:sandpetra
  • 5
  • 3
  • 2
  • +2
19 Comments
 
LVL 9

Accepted Solution

by:
dutchfoxer earned 250 total points
Comment Utility
Here is a simple script that will write the results from a form to a delimited file.... it has no extra options, just simple conversion of what comes in -> output this to file:

Create a file called saveform.cgi   and put the following text in it:

#!/usr/local/bin/perl
use CGI;
CGI::ReadParse(*in);
$file = '../tutorial_files/responses.txt';
print "Content-type:text/html\n\n";
print '<HTML><HEAD><TITLE>saveform.cgi results</TITLE></HEAD>';
print '<BODY BGCOLOR="FF0066">';
print '<h2>Thank you for your form submission.</h2>';
print '</BODY></HTML>';
open(FILE, ">>$file")||die "Can't open $file";
flock(FILE, 2)||die "Can't lock $file";
foreach $i (keys %in) {
       print FILE "$in{$i}\t";
}
print FILE "\n";
close(FILE) || die "Can't close $file";


Then do this:
chmod 755 cgi-bin/saveform.cgi


------------
Or download an existing Form script that has the feature of saving files (CSV) in it!
Example of one: http://www.ezscripting.co.uk/csvwrite/

Instead of Perl CGI you could maybe also use PHP for processing the form;
http://www.arecaweb.com/php/newmmex/index.php

nb: With ASP it is also possible. Better you put your question in the ASP area in this case.
0
 
LVL 6

Expert Comment

by:nitinsawhney
Comment Utility
Could you please throw some more light on your requirement.
Is that there is a form and u need all its fields to be saved as a csv file so that it opens within a spreadsheet.
0
 

Author Comment

by:sandpetra
Comment Utility
Yes - I think that is all I require.
0
 
LVL 51

Assisted Solution

by:ahoffmann
ahoffmann earned 250 total points
Comment Utility
# assuming perl:

use CGI;
my $q = new CGI;
print join(",",grep(($_=$q->param($_)),$q->param()));

keep in mind that you data should not contain , itself
0
 
LVL 9

Expert Comment

by:dutchfoxer
Comment Utility
Dont want to be fuzzy, but  nitinsawhney {http:#11796732}  did not give any answer whatsoever, he asked a question  instead. So no points for him I would assume.
0
 
LVL 51

Expert Comment

by:ahoffmann
Comment Utility
Cc dutchfoxer
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 9

Expert Comment

by:dutchfoxer
Comment Utility
LOL what is this? I better post "can u shed some light" in many many questions.... you never know, you might end up with points anyway   :)
0
 
LVL 6

Expert Comment

by:nitinsawhney
Comment Utility
Any way to re-distribute the points...
I don't think so i should be awarded these points.

Cheers!!
Nitin
0
 
LVL 9

Expert Comment

by:dutchfoxer
Comment Utility
thats fair of you  nitinsawhney   , but enjoy the points, it is just points and not money

0
 
LVL 53

Expert Comment

by:COBOLdinosaur
Comment Utility
Well... If this needs fixing up, that is what PEs do, so just let me know how think it should be and I will do thy bidding. :^)

It looks like it should be :

Split: dutchfoxer {http:#11753602} & ahoffmann {http:#11807974}

Correct?

COBOLdinosaur
Page Editor, CGI
0
 
LVL 9

Expert Comment

by:dutchfoxer
Comment Utility
COBOL,

yes correct.
thanks for all the work and the effort!
0
 

Author Comment

by:sandpetra
Comment Utility
Hi There

Sorry i havent awarded points for my question -- family probs meant I was out of action for a while....I didnt realise it would generate this controversy. I am looking at the solution now.. I will make sure I reply to questions I post in the future...sorry!

Thanks again.
0
 
LVL 6

Expert Comment

by:nitinsawhney
Comment Utility
COBOLdinosaur,
Thanks for all your time and effort.
Hope this time justice is done with awarding points... ;-) ... lol...

Cheers!!
Nitin
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

In this tutorial I will aim to show you how simple is making a small application in WhizBase, how to add, remove and update data in the DB. I will make a small address book application where you can add, browse, update and remove addresses. I wi…
Introduction This tutorial will give you a fast look what you can do with WhizBase. I expect you already know how to work with HTML at least, and that you understand the basics of the internet and how the internet works. WhizBase is a server-s…
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now