?
Solved

creating comma separated values with perl ??

Posted on 1997-07-29
8
Medium Priority
?
171 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Congratulations! You’re Certified – Now What?

Starting a new career can be overwhelming. Becoming certified in your field of expertise is a great start, but where do you go from here?  Here are some tips to help you on your career journey.

 
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 760 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This article will show, step by step, how to integrate R code into a R Sweave document
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
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 …
Suggested Courses

801 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