[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

creating comma separated values with perl ??

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
mfrappie
Asked:
mfrappie
1 Solution
 
julio011597Commented:
Sure, but you should show your current code to get advice on the changes needed.

-julio
0
 
mfrappieAuthor Commented:
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
 
mfrappieAuthor Commented:
Adjusted points to 195
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
dmethvinCommented:
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
 
mfrappieAuthor Commented:
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
 
wormzerCommented:
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
 
wormzerCommented:
Sorry... I did mean for that to be an answer.  Let me know if there's anything else I can do.
0
 
mfrappieAuthor Commented:
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now