txt file to html > right forum ?

saavik · 03-19-2002, 01:53 PM

first:

i don`t know if this is the right forum but:

i would like to transfer a txt file order like this:

name familiename departement telefon number mail address

max peterson edv 12345 max.edv@firm.de

into a html file that is showing the people in a beautiful way.

any ideas?

crabboy · 03-19-2002, 11:01 PM

If you are sure that all the fields will be there then the following simple shell script will do. Note that the HTML in this sample is invalid, it's just for example purposes only. Execute somethink like: cat filewithnames | createhtml.sh

Code:

#!/bin/sh

echo "<HTML>"

while [ 1 ]; do
   read ENTRY
   if [ "x$ENTRY" = "x" ]; then
      break;
   fi
   NAME=`echo $ENTRY | awk ' { print $1 } '`
   LAST=`echo $ENTRY | awk ' { print $2 } '`
   DEPT=`echo $ENTRY | awk ' { print $3 } '`
   PHONE=`echo $ENTRY | awk ' { print $4 } '`
   EMAIL=`echo $ENTRY | awk ' { print $5 } '`

   echo "<TAG>Name: $NAME $LAST</TAG>"
   echo "<TAG>Dep: $DEPT</TAG>"
   echo "<TAG>Phone: $PHONE   Email: $EMAIL</TAG>"

done

echo "<HTML>"

saavik · 03-20-2002, 05:00 AM

really great thanks for your help.
here some more information.
i will need that script for the intranet in our firm.
i want a someone to care for the txt file and a conjob every x houres to update the html file.
so how would the real file (txt) look?
is it like :

"Tom","Tomason","12345","dep"

or

Thom Tomason 12345 dep

?

and what does "Note that the HTML in this sample is invalid, it's just for example purposes only. " mean?
can`t i just write the script in the vi and make it executable and make a cron every x houres to execute the script?

thank you so much.....

saavik · 03-20-2002, 05:02 AM

oh i just understood !
you meen the tags in the html file will be wrong!
well ok !
thats no problem.
i have some experience in html but not with scripts!
sorry for that..

saavik · 04-16-2002, 07:22 AM

Well hello again!
I have now written the following skript:

-----------------------------------------------------------------
#!/bin/sh

echo "<HTML>"

while [1]; do
read ENTRY
if ["x$ENTRY"="x"];then
break;
fi
Name=`echo $ENTRY | awk '{ print $1}'`
Last=`echo $ENTRY | awk '{ print $2}'`
Dept=`echo $ENTRY | awk '{ print $3}'`
Phone=`echo $ENTRY | awk '{ print $4}'`
Email=`echo $ENTRY | awk '{ print $5}'`

echo "<p> Name: $Name $Last </p>"
echo "<p> Abteilung: $Dept </p>"
echo "<p> Telefon: $Phone </p>"

echo "</HTML>"
-----------------------------------------------------------------

i tried to execute it by typing:

-----------------------------------------------------------------
cat testtelefon | createhtml
-----------------------------------------------------------------

and than the pc sayed:

-----------------------------------------------------------------
<HTML>
/usr/bin/createhtml: line 21: syntax error: unexpected end of file
-----------------------------------------------------------------

1. what does that mean?
2. how can i tell the pc where to generate the file ?

thanx for each idea !

hanzerik · 04-16-2002, 07:33 AM

I dont know if this helps:
http://linuxcommand.org/writing_shel....html#contents

It shows how to write a script to create a web page using a bash shell script.

here one i did to create a html file to view my firewall logs.

<-----code--------->
#!/bin/bash

# system_page - A script to produce an system information HTML file

##### Constants

TITLE="Firewall Information for $HOSTNAME"
RIGHT_NOW=$(date +"%x %r %Z")
TIME_STAMP="Updated on $RIGHT_NOW by $USER"
DATE_FORMAT=$(date +%f.%y.%T)
##### Functions

function uptime_info
{
echo "<h2>System uptime</h2>"
echo "<pre>"
uptime
echo "</pre>"
}

function firewall_log
{
echo "<h2>Firewall logs</h2>"
echo "<pre>"
cat /var/log/linksys.log
echo "</pre>"
}

##### Main

cat <<- _EOF_ > /html/index.$DATE_FORMAT.html
<html>
<head>
<title>$TITLE</title>
</head>

<body>
<h1>$TITLE</h1>
<p>$TIME_STAMP</p>
$(uptime_info)
$(firewall_log)
</body>
</html>
_EOF_

<-------end code------->

I did this from memory so some things may be different.

Baloo · 04-16-2002, 08:25 AM

Do you have a blank line on the end of the script?

Baloo*

saavik · 04-16-2002, 08:42 AM

is that bad?

well, i will have a trie!