chart data from a CSV file provided by a CGI application using google charts or similar

Completado Publicado Jul 14, 2015 Pagado a la entrega
Completado Pagado a la entrega

Require google maps (or equiv) rendering of a dynamic CSV

Using the provided test URL: [url removed, login to view]

Requirements:

* render a chart as shown in screen1 using the provided URL as a source. I use google charts, but if you have a better free to use option please demonstrate.

* Example html page with 1 chart and a 2nd page with multiple charts.

* Export Chart as JPG/PNG

* fix attached form so date picker submits form once user selects a date.

Bonus Points:

Options for end user to change charts style on the fly: eg smoothed line, bar graph.

option for user to increase chart sizes dynamically.

Any further fancy stuff to impress end users ie visiluzations

-----------------------------------------------------------------------------------------------------------

Notes for testing url:

the date range is dynamic for end users but forced to a set range for the testing URL

results a limited to 500 rows, users have no limit.

Dates are sent in unix epoch format and converted to MSSQL datetime format by the backend perl code. I have done this to avoid the need for URI encoding.

Notes regarding CSV format

First line is the column names.

multiple value sets can be present, here is a URL with 2 value sets:

[url removed, login to view]

The chart must label the data sets correctly and set different colours as needed.

I dont expect any more than ~3 data sets to be shown at once.

The user request more data sets by requesting additional VN_COL's

Notes regarding data:

Data is always in a sorted time series.

Confidential !.

Values are always floating points.

data is pulled from a perl script which reads from a set of allowed MSSQL database tables.

Units is nearly always mg/L

Users will normally access the charts after submitting a form, but they will also want to direct link the data to other users hence data submission via URL and the avoidance of any characters that require URI encoding.

the perl script providing the CSV accepts the following CGI param's:

SDATE_EPOCH - start date in epoch seconds

FDATE_EPOCH - finish date in epoch seconds

TABLE - db table to read. the perl script has a list of allowed tables.

DATE_COL - the name of the tables date column

V1_COL - value column 1. the script supports unlimited number of Value columns. the param name must be V(\d+)_COL

TESTING - testing password, for unauthorized access for testing users.

JavaScript Diseño de sitios web

Nº del proyecto: #8068194

Sobre el proyecto

2 propuestas Proyecto remoto Activo Jul 14, 2015

Adjudicado a:

abdfahim

A proposal has not yet been provided

$29 AUD en 3 días
(4 comentarios)
4.0