Solved

creating comma separated values with perl ??

Posted on 1997-07-29
8
157 Views
Last Modified: 2013-12-25
I have a set of forms with scripts that save the form input data to a file. This file is later downloaded to my pc so I can transfer the data to a database program (Access). Is there any way to convert this form data to comma separated values with the perl cgi script before the data is saved to the file? That way it can be imported directly to my Access database.
0
Comment
Question by:mfrappie
8 Comments
 
LVL 5

Expert Comment

by:julio011597
ID: 1829464
Sure, but you should show your current code to get advice on the changes needed.

-julio
0
 

Author Comment

by:mfrappie
ID: 1829465
SCRIPT # 1:

#! /usr/bin/perl

print "Content-type: text/html\n\n";

$rid = $$ . "-" . time();

print <<end;
<HTML><HEAD><TITLE>Survey Introduction</TITLE></HEAD>
<BODY background="whitebak.gif" bgcolor="#ffffff" text="#000080" link="#0064ff" vlink="#00a800" alink="#800000">

<FORM ACTION="demog.cgi" METHOD=POST>

<INPUT TYPE="hidden" NAME="respondent_id" VALUE="$rid">

[*HTML DELETED*]

<INPUT TYPE="submit" VALUE="START SURVEY">
</FORM>
</body>
</html>
end


SCRIPT # 2:

#! /usr/bin/perl

read(STDIN, $message, $ENV{'CONTENT_LENGTH'});

@pairs=split(/&/, $message);
foreach $pair (@pairs) {
($name,$value)=split(/=/,$pair);
$value =~ tr/+/ /;
$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("c",hex($1))/eg;
$FORM{$name} = $value;
}
$rid=$FORM{"respondent_id"};

open(LOGFILE, ">survey_results/$rid") || die "Can't open logfile!\n";
print LOGFILE "$message\n";
close (LOGFILE);

print "Content-type: text/html\n\n";

print <<end;
<HTML><HEAD><TITLE>Demographics</TITLE></HEAD>
<BODY background="whitebak.gif" bgcolor="#ffffff"
text="#000080" link="#0064ff" vlink="#00a800" alink="#800000">

<FORM ACTION="fam_hx.cgi" METHOD=POST>

<INPUT TYPE="hidden" NAME="respondent_id" VALUE="$rid">

[*HTML DELETED*]

<INPUT TYPE="submit" VALUE="Go to the next section">
<INPUT TYPE="reset" VALUE="Reset/Re-enter data">
</FORM>
</body>
</html>
end

There are more scripts that are the same as these that continue to add form data to the logfile.
0
 

Author Comment

by:mfrappie
ID: 1829466
Adjusted points to 195
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 2

Expert Comment

by:dmethvin
ID: 1829467
There's no doubt something very quick and dirty you can do here, just to get a CSV file but not do any data validation. Does your CGI program already do data validation of some kind, or are you discarding incomplete/incorrect records once you get them into Access?
0
 

Author Comment

by:mfrappie
ID: 1829468
There's no validation. I'm pretty inexperienced, i.e., I'm not a programmer. I'm not even real sure what you mean by data valadation. The whole script is listed above except for the html questions. Thanks
0
 
LVL 1

Expert Comment

by:wormzer
ID: 1829469
You really need to do something more than "print LOGFILE $message" to your file.

in your variable-splitting code... you are breaking up the message into separate variables.  You need to use something else in the place of the 'print LOGFILE $message' that prints out each of these variables.

Lets say in your form, you had an <INPUT name=answer1> and an <INPUT name=answer2>.  THEN you should have the variables:

   $FORM{'answer1} and $FORM{'answer1'}

to play with.  You could replace your "print LOGFILE $message" with something else like this:

   print LOGFILE "$FORM{'answer1'}, $FORM{'answer2'}";

or better yet

   print LOGFILE join(', ', values(@FORM));

which have the problem of coming out in some strange order.
0
 
LVL 1

Accepted Solution

by:
wormzer earned 190 total points
ID: 1829470
Sorry... I did mean for that to be an answer.  Let me know if there's anything else I can do.
0
 

Author Comment

by:mfrappie
ID: 1829471
Thanks. I found a small script that does something very similar to your suggestion. Between your answer and that script I should be able to make something work. If anyone else looks at this answer and wants to take a look at a script that does this Take a look at the SimpleBase script by Dave Palmer at:
http://www.upstatepress.com/dave/perl.shtml
 
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Making a simple AJAX shopping cart Couple years ago I made my first shopping cart, I used iframe and JavaScript, it was very good at that time, there were no sessions or AJAX, I used cookies on clients machine. Today we have more advanced techno…
In this tutorial I will show you how to provide a dynamic RTF document on your website generated with data from your database. For this tutorial you will need Microsoft Word or WordPad, WhizBase and Microsoft Access. In this tutorial I will show …
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.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

832 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