Sponsored Content
Top Forums Shell Programming and Scripting Script to convert csv file to html with good visibility Post 302710311 by sv0081493 on Thursday 4th of October 2012 08:04:38 AM
Old 10-04-2012
Script to convert csv file to html with good visibility

Hi,

I have Below script which converts csv file to html succesfully.but the visiblity is simple in black n white. I want to have better visibilty of each columns in different colours(like green).As it is a Database report suppose some tablespace available space is less than 20% then it should come up in red colour.If the available space is above 20% then it should come up in green.

Code:
perl -F',' -lane 'BEGIN{open O, ">output_db.html"; print O "<html><body><table border=1>"}; chomp;
print O "<tr>";
print O "<th>$_<\/th>" for (@F);
print O "<\/tr>";
END {print O "<\/table><\/body><\/html>"; close O}' DBA_CHECKS.csv


Your prompt help is much appreciated.

Moderator's Comments:
Mod Comment Please stop using ALL CAPS for your subject titles, and use code tags. Thanks


Moderator's Comments:
Mod Comment And while you're at it, please stop double posting and post in the currect forum.

Last edited by Scott; 10-04-2012 at 09:17 AM.. Reason: Code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sample Unix script file to convert .xml to .csv

Dear all, Can you send me a script file the changes .xml to .csv file. Thanks, Srinivasa (4 Replies)
Discussion started by: srinivasaphani
4 Replies

2. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies

3. UNIX for Dummies Questions & Answers

convert csv to html file

Hi All, I am new to this forum,not sure where to post this query...so posted here Kindly need any of your help on the below ------------ I am using shell scripting and trying to convert a csv file to html file... example.csv --------------- Name Country Age Sex Andy India 25 ... (4 Replies)
Discussion started by: sumithra
4 Replies

4. Shell Programming and Scripting

Is there any script which convert binary file to CSV format

Dear guys; I have a binary file and I need to convert its data to csv format ...appreciating your help. Best Regards (14 Replies)
Discussion started by: ahmad.diab
14 Replies

5. Shell Programming and Scripting

Awk script to convert csv to html

Hi Written some script to convert csv to html but could not add table headers.Below are the errors iam getting ./csv2html | more + awk -v border=1 -v width=10 -v bgcolor=black -v fgcolor=white BEGIN { printf("<table border=\"%d\" bordercolor=\"%s\" width=\"%d\"... (2 Replies)
Discussion started by: zeebala1981
2 Replies

6. Shell Programming and Scripting

Convert shell script output txt file to html table

Hi, I have script which generates the output as below: Jobname Date Time Status abc 12/9/11 17:00 Completed xyz 13/9/11 21:00 Running I have the output as a text file. I need to convert it into a HTML Table and sent it thru email ... (6 Replies)
Discussion started by: a12ka4
6 Replies

7. Shell Programming and Scripting

Script to convert CSV file to HTML

Hi, I have made a a script which creates a csv file as daily database report However i want to covert that csv file to html because csv file does not have a good visibilty. So it is possible to have such csv to html coversion script. Your prompt help much appreciated. Thanks in advance (4 Replies)
Discussion started by: sv0081493
4 Replies

8. Shell Programming and Scripting

Need script to convert TXT file into CSV

Hi Team, i have some script which give output in TXT format , need script to convert TXT file into CSV. Output.TXT 413. U-UU-LVDT-NOD-6002 macro_outcome_dist-8.0.0(v1_0_2) KK:1.2.494 (1234:333:aaa:2333:3:2:333:a) 414. U-UU-LVDT-NOD-6004 ... (10 Replies)
Discussion started by: Ganesh Mankar
10 Replies

9. Shell Programming and Scripting

Convert shell script output txt file to html table

My concnern related to the post -Convert shell script output txt file to html table, in this how to print the heading as color. awk 'BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' <filename> (8 Replies)
Discussion started by: sarajobmai
8 Replies

10. Shell Programming and Scripting

Convert csv data to html format

I am new to html and need to convert the attached csv file data to html format ; running into issues. please assist. #!/bin/ksh echo "<html>" ; echo "<head><style> table {border-collapse: collapse;} table, td, th {border: 1px solid black;} </style></head>" echo "<title> REPORT </title>" echo... (0 Replies)
Discussion started by: archana25
0 Replies
libapache2-mod-perl2-2.0.7::docs::api::ModPerl::RegistryUser)Contributed Perl Documenlibapache2-mod-perl2-2.0.7::docs::api::ModPerl::Registry(3pm)

NAME
ModPerl::Registry - Run unaltered CGI scripts persistently under mod_perl Synopsis # httpd.conf PerlModule ModPerl::Registry Alias /perl/ /home/httpd/perl/ <Location /perl> SetHandler perl-script PerlResponseHandler ModPerl::Registry #PerlOptions +ParseHeaders #PerlOptions -GlobalRequest Options +ExecCGI </Location> Description URIs in the form of "http://example.com/perl/test.pl" will be compiled as the body of a Perl subroutine and executed. Each child process will compile the subroutine once and store it in memory. It will recompile it whenever the file (e.g. test.pl in our example) is updated on disk. Think of it as an object oriented server with each script implementing a class loaded at runtime. The file looks much like a "normal" script, but it is compiled into a subroutine. For example: my $r = Apache2::RequestUtil->request; $r->content_type("text/html"); $r->print("mod_perl rules!"); XXX: STOPPED here. Below is the old Apache::Registry document which I haven't worked through yet. META: document that for now we don't chdir() into the script's dir, because it affects the whole process under threads. "ModPerl::RegistryPrefork" should be used by those who run only under prefork MPM. This module emulates the CGI environment, allowing programmers to write scripts that run under CGI or mod_perl without change. Existing CGI scripts may require some changes, simply because a CGI script has a very short lifetime of one HTTP request, allowing you to get away with "quick and dirty" scripting. Using mod_perl and ModPerl::Registry requires you to be more careful, but it also gives new meaning to the word "quick"! Be sure to read all mod_perl related documentation for more details, including instructions for setting up an environment that looks exactly like CGI: print "Content-type: text/html "; print "Hi There!"; Note that each httpd process or "child" must compile each script once, so the first request to one server may seem slow, but each request there after will be faster. If your scripts are large and/or make use of many Perl modules, this difference should be noticeable to the human eye. DirectoryIndex If you are trying setup a DirectoryIndex under a Location covered by ModPerl::Registry* you might run into some trouble. META: if this gets added to core, replace with real documenation. See http://marc.theaimsgroup.com/?l=apache-modperl&m=112805393100758&w=2 Special Blocks "BEGIN" Blocks "BEGIN" blocks defined in scripts running under the "ModPerl::Registry" handler behave similarly to the normal mod_perl handlers plus: o Only once, if pulled in by the parent process via "Apache2::RegistryLoader". o An additional time, once per child process or Perl interpreter, each time the script file changes on disk. "BEGIN" blocks defined in modules loaded from "ModPerl::Registry" scripts behave identically to the normal mod_perl handlers, regardless of whether they define a package or not. "CHECK" and "INIT" Blocks Same as normal mod_perl handlers. "END" Blocks "END" blocks encountered during compilation of a script, are called after the script has completed its run, including subsequent invocations when the script is cached in memory. This is assuming that the script itself doesn't define a package on its own. If the script defines its own package, the "END" blocks in the scope of that package will be executed at the end of the interpretor's life. "END" blocks residing in modules loaded by registry script will be executed only once, when the interpreter exits. Security "ModPerl::Registry::handler" performs the same sanity checks as mod_cgi does, before running the script. Environment The Apache function `exit' overrides the Perl core built-in function. Commandline Switches In First Line Normally when a Perl script is run from the command line or under CGI, arguments on the `#!' line are passed to the perl interpreter for processing. "ModPerl::Registry" currently only honors the -w switch and will enable the "warnings" pragma in such case. Another common switch used with CGI scripts is -T to turn on taint checking. This can only be enabled when the server starts with the configuration directive: PerlSwitches -T However, if taint checking is not enabled, but the -T switch is seen, "ModPerl::Registry" will write a warning to the error_log file. Debugging You may set the debug level with the $ModPerl::Registry::Debug bitmask 1 => log recompile in errorlog 2 => ModPerl::Debug::dump in case of $@ 4 => trace pedantically Caveats ModPerl::Registry makes things look just the CGI environment, however, you must understand that this *is not CGI*. Each httpd child will compile your script into memory and keep it there, whereas CGI will run it once, cleaning out the entire process space. Many times you have heard "always use "-w", always use "-w" and 'use strict'". This is more important here than anywhere else! Some other important caveats to keep in mind are discussed on the Perl Reference page. Authors Andreas J. Koenig, Doug MacEachern and Stas Bekman. See Also "ModPerl::RegistryCooker", "ModPerl::RegistryBB" and "ModPerl::PerlRun". perl v5.14.2 2013-03-12 libapache2-mod-perl2-2.0.7::docs::api::ModPerl::Registry(3pm)
All times are GMT -4. The time now is 05:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy