Every graph requires the data to be plotted. The graphing software has been designed to take the data directly from the source and dynamically produce the graph image in real time. The graphing software can be configured to read the data from a variety of sources including:-
( Note: further data access methods may have been added since this documentation was written, as such please also check the online documentation here » )
The graphing software provides two direct methods by which data can be read from databases:-
Custom Data Function
This method allows a custom data function to be constructed. At runtime the graphing software will dynamically include this function
and run it to produce the data.
If you need to dynamically construct the SQL Queries (e.g. depending on the value of SESSION or REQUEST variables) or you need to process the query results before plotting (e.g. averaging a data set) then this is the method to use.
more »
Database Information File
With this method the database information file will contain the necessary information for the graphng software to connect to your database and the queries to run for each data series.
At runtime the graphing software will read this file, connect to the database and execute each of the queries. It will then automatically extract the data from the result set(s) for plotting on the graph.
more »
Further information and examples can found in the Online Tutorials here »
If the data is fairly static then you may wish to place the data in a flat file. In this case the graphing software is configured to read the data from that file.
To set the graph to read the data from file simply add the "data"
parameter to the URL string of the <IMG> tag. For example if the data file is "graphdata.txt"
then your <IMG> tag would become:-
Data Format
Within the file the data should follow this format:-
dataNseriesM: [value]where
The graph data can be set to call another server process and request the data. This can be a script in any language and does not necessarily have to reside on the same server. The only stipulation is that the process is accessible via a URL.
The script or process can be written to perform any processing required including connecting to any database system. For example if your data is held in MS SQL Server or Oracle then an ASP script would be written to extract the data from the database
and output in the format required for the graph. At runtime the graphing software will call the script which in turn will read the data from the database and output the data back to the graphing software where it is plotted directly on the graph.
To set the graph to read the data from another server side process (ie. PHP, ASP, JSP etc) simply add the "data" parameter to the URL string of the <IMG> tag.
For example if the data script is "graphdata.php" then your
<IMG> tag would become:-
Data Format
The data script should be written such that it outputs the data in the following format:-
dataNseriesM: [value]where
Further information and examples can found in the Online Tutorials here »