HTML Export on PC version 4.0

Wed Jan 16 06:37:13 PST 2008

>In anticipation of an updated PC version coming 
>this year (I hope), I am back and playing and 
>relearning Version 4.2.0 PC.  I am trying to 
>generate an HTML file using the wizard and have 
>run into a problem of trying to get group 
>headers onto the HTML form so that my resulting 
>HTML looks something like this:
>
>55 Meter Dash
>1.         6.34      Marty Wilson     1/4/08   Reggie Lewis Center
>2.         6.55      Jab Webb          1/4/08   Reggie Lewis Center
>
>Right now I can only make it look like the following:
>
>55 Meter Dash   1. 6.34 Marty Wilson     1/4/08   Reggie Lewis Center
>55 Meter Dash   2. 6.55  Jab Webb          1/4/08 Reggie Lewis Center
>
>I am downloading the exported HTML into 
>FrontPage 2003.  Is it possible to do the first 
>version or will I have to go into Front Page and 
>manually make changes?
>
>The data is grouped by event prior to my doing 
>an export wizard. When I do a hard copy printout 
>the first version is generated.
>
>Thanks for your help.

The best method I have found is one that doesn't 
seem to be documented any more. When I did this I 
was using Panorama 3.1.5, so there wasn't any 
wizard, and the wizard wouldn't have helped to 
format it that way anyway.

I used a form as a template, and exported the 
file with a SaveAsText command. The template form 
contained Group Header (2), Group Header (1), 
Data, Summary (1), and Summary (2) tiles. Each 
tile must have exactly one auto-wrap text object 
containing the text and formulas.

On the Group Header (2) tile, I had this.

<HTML> <HEAD>
<META HTTP-EQUIV="content-type"  CONTENT="text/html;charset=iso-8859-1">
<META NAME="generator" CONTENT="Panorama by Provue">
<TITLE>Big 10 Performance List</TITLE></HEAD>
<BODY BGCOLOR="#FFFFFF" LINK="0000FF" VLINK="FF6600">
<CENTER><P><B><FONT SIZE="7" COLOR="#0000FF"><A 
NAME="TOP">Big 10 Men<BR>Track & 
Field<BR>Performance List</A></FONT></B><BR><A 
HREF="performance.w.html">Women's 
List</A><p>Other Best Lists
<br><a 
href="http://www.indiana.edu/~athlweb/graphic/sports/m-track/bests/mtroteambl.html">Indiana</a>,
<a 
href="http://www.hawkeyesports.com/sports/track/men/2001/outbests.pdf">Iowa</a>,
<a href="http://www.mgoblue.com/track-m/00-01/statistics/">Michigan</a>,
<a 
href="http://msuspartans.fansonly.com/sports/m-track/spec-rel/msu-m-track-CumulativeStats.html">Michigan
State</a>, <a 
href="http://graphics.fansonly.com//photos/schools/pur/sports/m-otrack/auto_pdf/cumulative-stats.pdf">Purdue</a>,
<a 
href="http://www.uwbadgers.com/sport_news/mtrk/stat_poll/outdoor_team_stats.pdf
">Wisconsin</a></CENTER>
</P><P>
Last updated on {datepattern(today(),"Month dd, 
yyyy")} at {timepattern(now(),"hh:mm am/pm")}
</P>{FGLinkTable}<P>
<CENTER>
<TABLE BORDER CELLSPACING=0 CELLPADDING=0 WIDTH="90%" ><CAPTION>
<B><FONT SIZE="5" COLOR="#0000FF"><CENTER><A 
NAME="{replace(«Event Abbrev»," ","_")}">{ 
HTMLencode(replace(«Event 
Full»,"20#","35#"))}</A></CENTER></FONT></B></CAPTION>

On the Group Header (1) tile I had this.

<BR><TABLE BORDER CELLSPACING=0 CELLPADDING=0 WIDTH="90%" ><CAPTION>
<B><FONT SIZE="5" COLOR="#0000FF"><CENTER><A 
NAME="{replace(«Event Abbrev»," ","_")}">{ 
HTMLencode(replace(«Event 
Full»,"20#","35#"))}</A></CENTER></FONT></B></CAPTION>
<TR><TH>Performance</TH><TH>Name</TH><TH>School</TH><TH>When 
and Where</TH></TR>

On the data tile I had this.

<TR><TD 
ALIGN="CENTER">{Performance+Letter+sandwich(" 
(",Feet,")")}</TD><TD>{HTMLencode(?(Type="R",«Relay 
Names»,strip(Name[",",-1][2,-1]+" "+ 
strip((Name+",")[1,","][1,-2]))))}</TD><TD>«Team»</TD><TD>{ 
HTMLencode(Where)}</TD></TR>

On the Summary (1) tile I had this

</TABLE><A HREF="#TOP">Return to top</A><BR>

and on the Summary(2) tile I had this.

</CENTER></BODY></HTML>

If you like, I can send you the file off line for you to play with.

Dave