"Fossies" - the Fresh Open Source Software Archive

Member "lib/welcome/welcome_files/tour.html" (5 Aug 2010, 2982 Bytes) of package /linux/privat/old/entranceCommunity.zip:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) HTML source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

A hint: This file contains one or more very long lines, so maybe it is better readable using the pure text view mode that shows the contents as wrapped lines within the browser window.


    1 <html>
    2 <body>
    3 Click on the tab, and when the table appears enter some text in the "Matchbox" at the upper right hand corner of the window.  For example, enter "194", press return, and you will see all the rows that have text matching "194" in any of their fields:
    4 <br>
    5 <br>
    6 <img align="center" src="welcome_files/match2.png">
    7 <br>
    8 <br>
    9 Now try drawing a chart. Delete the "194" text in the match box, open the "Charts" menu and select  "Line...".  Click on the "+ Line" to add a line and select one of the columns in the list that appears, say "Jan".  Click the "Try It" button and you will have a chart:
   10 <br>
   11 <br>
   12 <img align="center" src="welcome_files/line2.png">
   13 <br><br>
   14 Now run a SQL query.  Click the "New" button on the tool bar and type
   15 in the test "SELECT Jan FROM cpi_orig;", then click the "Run" button and you will see something like this:
   16 <br>
   17 <br>
   18 <img align="center" src="welcome_files/results2.png">
   19 <br><br>
   20 The cool thing for SQL developers is that Entrance lets you make any SELECT statement into a chart.  For example, to make this SELECT statement:
   21 <br><br>
   22 <pre>
   23     SELECT Year, Jan FROM cpi_orig;
   24 </pre>
   25 <br><br>
   26 into a chart, you add two lines, click "Run" and you have a chart:
   27 <pre>
   28     PLOT
   29       AXISLABELS, LINE
   30     SELECT Year, Jan FROM cpi_orig;
   31 </pre>
   32 <br><br>
   33 <img align="center" src="welcome_files/chart2.png">
   34 <br><br>
   35 
   36 More Sample Data:<br>
   37 <a href="import:http://earthquake.usgs.gov/eqcenter/catalogs/eqs7day-M1.txt">Recent Eartquakes</a>
   38 <br><br>
   39 WORK IN PROGRESS!
   40 THIS IS ONLY A TEST.  HAD THIS BEEN A REAL EMERGENCY
   41 <br>
   42 This is the file welcome.html from the Entrance system directory<br>
   43 (On Macs:  the system directory is ~/Library/Application Support/Entrance, ond
   44 on other systems it is  ~/.entrance)
   45 
   46 <br><br>
   47 We want to use a file like this to get our usrs past the "clunk moment" when they have first installed Entrance, and have no data or scripts.<br><br>
   48 
   49 HTML anchors can be used to open other HTML files in this Entrance pane:
   50 <a href="welcome2.html">welcome2</a><br>
   51 <br><br>
   52 Anchors that start with "browse:" will be opened with the system browser:
   53 <a href="browse:http://dbentrance.com/">welcome2</a><br>
   54 <br><br>
   55 Anchors that start with "import:" open the Import Dialog, with the named file selected:
   56 <a href="import:http://earthquake.usgs.gov/eqcenter/catalogs/eqs7day-M1.txt">Import eqrthquake data now</a>
   57 <br><br>
   58 Anchors that start with "sql:"  open a SQL file:
   59 <a href="sql:Color_Wheel.sql">open color wheel example</a> <br>
   60 <br><br>
   61 Anchoors that start with "plot:" open and run a SQL file:
   62 <a href="plot:Color_Wheel.sql">plot color wheel example</a> <br>
   63 <br><br>
   64 Anchors that start with "table:" open a table (provided it is on the current DB tree):
   65 <a href="table:test:::test:::ACCESS_LOCIDS">open table ACCESS_LOCIDS</a>
   66 <br><br>
   67 Anchors that start with "tool:"  run an EntranceTool
   68 <a href="tool:entrance.tools.HelloSwing">Run Hello Swing (requires entrancex.jar)</a>
   69 <br><br>
   70 
   71 
   72 </td>
   73 <td>
   74 </td>
   75 </tr>
   76 </table>
   77