Home. 
Search
.

transparent
transparent
transparent
  Library.Mailing List Archive

Altova Mailing List Archives


RE: [xml-dev] Using pre-arranged arrays to render charts

From: "Stephen E. Beller" <sbeller@----.--->
To: <xml-dev@-----.---.--->
Date: 3/2/2004 9:10:00 PM
Thanks ... You guys are great!

I can see how the layout generator would be challenging. 

One question I still have is how I can replicate the functionality of an
interactive chart in which I select a subset of an array for rendering. Say,
for example, I have 20 retail stores with monthly sales data across several
years, which are broken down by customer. I first want to view the sales
data of a particular store for a specific year. Then I want to view the same
data broken down customers. Then I want to view all stores ... etc. There
could be thousands of different views.

My current method is to select particular "ranges" of data in the arrays
(stored in the CSV file) and render them as bar graphs. I don't know how the
method below would do it?

I may be asking XML to do too much in this case. Is there some kind of
JavaScript called from and XML file, or an IE plug-in, or some other way to
access pre-configured arrays, possibly stored in an external text file, and
apply appropriate parsing and rendering routines to display the chart in a
browser?

Steve


-----Original Message-----
From: Bullard, Claude L (Len) [mailto:clbullar@i...] 
Sent: Tuesday, March 02, 2004 3:01 PM
To: 'Thomas B. Passin'; xml-dev@l...
Subject: RE: [xml-dev] Using pre-arranged arrays to render charts

That's easy. See below.  Run's without a plugin right there 
in the HTML.  ;-)

The layout generator is modestly challenging.

len


From: Thomas B. Passin [mailto:tpassin@c...]

Anyway, how are you rendering charts in a browser?

*************************************************************************

<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<style>
v\:* {behavior:url(#default#VML);}
</style>
</head>

<body>
<h2>Name Main Table Entity-Relationship Diagram </h2>
<!-- Shape Prototypes -->
<!-- Strong Relationship -->
<v:shapetype id="SRelationship"
path="m10800,0l0,10800,10800,21600,21600,10800xe" fillcolor="blue" 
     coordsize="21600,21600" strokecolor="black" strokeweight="1pt" />

<!-- Child Relationship -->
<v:shapetype id="CRelationship"
path="m10800,0l0,10800,10800,21600,21600,10800xe" fillcolor="green" 
     coordsize="21600,21600" strokecolor="black" strokeweight="1pt"  />  

<!-- Weak/Child Relationship -->
<v:shapetype id="WCRelationship"
path="m10800,0l0,10800,10800,21600,21600,10800xe" fillcolor="green" 
     coordsize="21600,21600" strokecolor="black" strokeweight="3pt" >
    <v:stroke linestyle="thinthin" />  
</v:shapetype> 

<!-- Primary Group -->
<v:group id="ERD" style="position:absolute; left:40pt;top:115pt;
width:40pt;height:40pt;">
  
  <!-- Primary Entity -->
  <v:group id="nmmainEnt" style='left:1pt;top:0pt; width:50pt;height:50pt;'>
     <v:rect style='width:70pt;height:40pt; top:25pt;'  fillcolor="red">
      <v:textbox>
         <b><center>Name Main Table</b><br /><a
href="#nmmain">(NMMAIN)</a></center>PK: Name_id
      </v:textbox>
      <v:fill type="gradient" />
      <v:fill color2="yellow" type="gradient" /> 
     </v:rect>
     <v:line from="0pt,.085pt" to=".175pt,.085pt" />
  </v:group>

  <!-- Entity -->
  <v:group id="lomainEnt"  style="left:10pt;top:0pt;
width:50pt;height:50pt;">
    <v:rect  style='left:200pt; top:30pt; width:65pt;height:35pt'
fillcolor="yellow"  strokecolor="black" strokeweight="1pt">
      <v:textbox><b><center>Master Location Table</b><a
href="#lomain">(LOMAIN)</a></center></v:textbox>
    </v:rect>
    <v:line from="0.505pt, 0.096pt" to="0.666pt, 0.096pt" />
  </v:group> 

  <v:group id="systab1Ent"  style="left:10pt;top:-80pt;
width:50pt;height:50pt;">
    <v:rect  style='left:200pt; top:30pt; width:65pt;height:35pt'
fillcolor="yellow"  strokecolor="black" strokeweight="1pt">
      <v:textbox><b><center>System Table 1</b><br><a
href="#systab1">SYSTAB1</a></center></v:textbox>
    </v:rect>
    <v:line from="0.505pt, 0.096pt" to="0.666pt, 0.096pt" />
  </v:group> 


<!-- Child Entities -->

  <v:group id="childEnts1" style='left:1pt;top:0pt;
width:50pt;height:50pt;'>
     <v:rect style='width:70pt;height:40pt; top:125pt;'  fillcolor="yellow"
strokeweight="3pt">
      <v:stroke linestyle="thinthin" />
      <v:textbox>
         <b><center>Name MO Table</b><br /><a
href="#nmmodop">(NMMODOP)</a></center>
      </v:textbox>
     </v:rect>
     <v:line from="0pt,.338pt" to=".175pt,.338pt" />
  </v:group>

  <v:group id="childEnts2" style='left:150pt;top:0pt;
width:50pt;height:50pt;'>
     <v:rect style='width:70pt;height:40pt; top:125pt;'  fillcolor="yellow"
strokeweight="3pt">
      <v:stroke linestyle="thinthin" />
      <v:textbox>
         <b><center>Name Physical</b><br /><a
href="#nmphys">(NMPHYS)</a></center>
      </v:textbox>
     </v:rect>
     <v:line from="0pt,.338pt" to=".175pt,.338pt" />
  </v:group>

  <v:group id="childEnts3" style='left:300pt;top:0pt;
width:50pt;height:50pt;'>
     <v:rect style='width:70pt;height:40pt; top:125pt;'  fillcolor="yellow"
strokeweight="3pt">
      <v:stroke linestyle="thinthin" />
      <v:textbox>
         <b><center>Related Names</b><br /><a
href="#nmrelat">(NMRELAT)</a></center>
      </v:textbox>
     </v:rect>
     <v:line from="0pt,.338pt" to=".175pt,.338pt" />
  </v:group>

  <v:group id="childEnts4" style='left:450pt;top:0pt;
width:50pt;height:50pt;'>
     <v:rect style='width:70pt;height:40pt; top:125pt;'  fillcolor="yellow"
strokeweight="3pt">
      <v:stroke linestyle="thinthin" />
      <v:textbox>
         <b><center>Scars, Marks, Tattoos</b><br /><a
href="#nmsmt">(NMSMT)</a></center>
      </v:textbox>
     </v:rect>
     <v:line from="0pt,.338pt" to=".175pt,.338pt" />
  </v:group>


  <!-- Relationship -->
  <v:group id="relationshipLKMAINID" style="left:5pt; top:0pt;  width:60pt;
height:50pt;">
      <v:shape type="#SRelationship" style='left:100pt; top:36pt; width:
30pt; height: 20pt;' ></v:shape>
        <v:textbox style="position:relative; top:50pt;">
        <center>FK: lkmainid</center>
        </v:textbox>
  </v:group>

  <v:group id="SYSTAB1Relationship" style="left:175pt; top:-150pt;
width:60pt; height:50pt">
      <v:shape type="#SRelationship" style='left:10pt; top:80pt; width:
30pt; height: 20pt;'  />
        <v:textbox style="position:relative; top:45pt;">
        <center>FK: Code Keys</center>
        </v:textbox>
  </v:group>

  <v:group id="childRelationships" style="left:5pt; top:0pt; width:60pt;
height:50pt">
      <v:shape type="#WCRelationship" style='left:10pt; top:80pt; width:
30pt; height: 20pt;'  />
        <v:textbox style="position:relative; left:70pt; top:40pt;">
        <center>FK: name_id</center>
        </v:textbox>
        <v:line from="0.063pt, 0.165pt" to="0.063pt, 0.2pt" />
  </v:group>

  <v:group id="selfRelationship" style="left:5pt; top:-150pt; width:60pt;
height:50pt">
      <v:shape type="#WCRelationship" style='left:10pt; top:80pt; width:
30pt; height: 20pt;'  />
        <v:textbox style="position:relative; left:70pt; top:0pt;">
        <center>SK: alias_id</center>
        </v:textbox>
  </v:group>

<!-- Connectors -->
  <v:group id="connectors" style="left:5pt; top:0pt; width:50pt;
height:50pt;">
     <!-- NMMAIN to Relationship -->  
      <v:line from="0.170pt,0.116pt" to="0.305pt,0.116pt" />
      <v:line from="0.2pt,0.105pt" to="0.2pt,0.125pt" />
      <!-- To Code Table Entity -->
      <v:line from="0.170pt,0.089pt" to="0.25pt,0.089pt" />
      <v:line from=".25pt, -.01pt" to=".25pt, .089pt" />
      <v:line from=".25pt, -.01pt" to=".30pt, -.01pt" />
      <v:line from=".387pt, -.01pt" to=".512pt, -.01pt" />
 
     <!-- To Child Relationship -->
      <v:line from="0.390pt,0.1155pt "  to="0.510pt,0.1155pt" />
      <!-- To Child Group -->
      <v:line from="0.0752pt,0.25pt "  to="0.0752pt,0.2855pt" />
      <!-- Across Child Entities -->
      <v:line from="0.0752pt,0.2855pt "  to="0.780pt,0.2855pt" />
      <!-- To Children L to R -->
      <v:line from="0.0752pt,0.2855pt "  to="0.0752pt,0.3158pt" />
      <v:line from="0.3200pt,0.2855pt "  to="0.3200pt,0.3158pt" />
      <v:line from="0.5500pt,0.2855pt "  to="0.5500pt,0.3158pt" />
      <v:line from="0.7800pt,0.2855pt "  to="0.7800pt,0.3158pt" />
      <!-- Self-reference: NMMAIN -->
      <!-- Top Left -->
      <v:line from="-.03pt, -.01pt" to=".028pt, -.01pt" />
      <!-- Top Right -->
      <v:line from=".12pt, -.01pt" to=".19pt, -.01pt" />
      <!-- Bottom Left -->
      <v:line from="-.03pt, .075pt" to="-.007pt, .075pt" />
      <!-- Bottom Right -->
      <v:line from=".17pt, .075pt" to=".19pt, .075pt" />
      <!-- Left -->
      <v:line from="-.03pt, -.01pt" to="-.03pt, .075pt" />
      <!-- Right -->
      <v:line from=".19pt, -.01pt" to=".19pt, .075pt" />
  </v:group>
</v:group>
</body>
</html>

-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS <http://www.oasis-open.org>

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this list use the subscription
manager: <http://www.oasis-open.org/mlmanage/index.php>


transparent
Print
Mail
Like It
Disclaimer
.

These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.

.
.

transparent
transparent
 
Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site
 
Use of this site is governed by our Terms & Conditions and Privacy Policy Copyright 2005-2012 Altova. All Rights Reserved.
transparentGSA