Have implemented according to instructions. CSV contains text and
numbers. My page is below, but first, if it helps, this is how
the .csv renders into JSON (but I'm not using JSON in external csv
file example). Thanks in advance for help.
[{"C":"C","Morning Report":"Report for 12\/7\/2011"},{"C":"C","Morning
Report":"Report Generated 12\/07\/2011 13:18:10 GMT"},
{"C":"H","Morning Report":"DESCRIPTION"},{"C":"H","Morning Report":""},
{"C":"G","Morning Report":"Report Type"},{"C":"D","Morning
Report":"Morning Report"},{"C":"H","Morning Report":"DATE","":"TIME"},
{"C":"H","Morning Report":"","":""},{"C":"G","Morning Report":"1.
Report Date"},{"C":"D","Morning Report":"Wednesday, Dec 7
2011","":"08:18:10 EST"},{"C":"H","Morning
Report":"DESCRIPTION","":"VALUE"},{"C":"H","Morning
Report":"","":"(MW)"},{"C":"G","Morning Report":"2. Peak Load"},
{"C":"D","Morning Report":"Tuesday, Dec 6 2011 hour ending
18","":"17755"},{"C":"G","Morning Report":"3. Operable Capacity
Analysis"},{"C":"D","Morning Report":"A. Capacity Supply Obligation
(CSO)","":"30957"},{"C":"D","Morning Report":"B. Capacity Additions
EcoMax Bid > CSO","":"2272"},{"C":"D","Morning Report":"C. Pre-OP4
Dispatchable Loads","":"0"},{"C":"D","Morning Report":"D. Generation
Outages and Reductions","":"4474"},{"C":"D","Morning Report":"E.
Uncommitted Available Generation (non fast start)","":"9070"},
{"C":"G","Morning Report":"F. Capacity Deliveries: Net Purchases = (-)
Net Sales = (+)"},{"C":"D","Morning Report":"NYISO AC Ties","":"167"},
{"C":"D","Morning Report":"NYISO NNC","":"200"},{"C":"D","Morning
Report":"NYISO CSC","":"330"},{"C":"D","Morning Report":"NB","":"222"},
{"C":"D","Morning Report":"Phase 2","":"-1225"},{"C":"D","Morning
Report":"Highgate","":"-218"},{"C":"D","Morning Report":"Net
Deliveries","":"-524"},{"C":"D","Morning Report":"G. Total Available
Capacity (A+B+C-D-E-F)","":"20209"},{"C":"D","Morning Report":"H. Peak
Load Forecast For Hour 18","":"17900"},{"C":"D","Morning Report":"I.
Total Operating Reserve Requirement","":"1863"},{"C":"D","Morning
Report":"J. Capacity Required","":"19763"},{"C":"D","Morning
Report":"K. Surplus = (+) Deficiency = (-) (G - J)","":"446"},
{"C":"D","Morning Report":"L. Replacement Reserve Requirement","":"0"},
{"C":"D","Morning Report":"M. Excess Commitment Surplus = (+)
Deficiency = (-) (K - L)","":"446"},{"C":"G","Morning Report":"4.
Largest First Contingency"},{"C":"D","Morning
Report":"____","":"1245"},{"C":"G","Morning Report":"5. Annual
Maintenance Schedule (A.M.S)"},{"C":"D","Morning Report":"Peak Load
Exposure","":"20393"},{"C":"G","Morning Report":"6. Reserve Summary"},
{"C":"D","Morning Report":"Ten Minute Reserve Requirement:","":"1245"},
{"C":"D","Morning Report":"Ten Minute Reserve Estimate:","":"1245"},
{"C":"D","Morning Report":"Thirty Minute Reserve
Requirement:","":"618"},{"C":"D","Morning Report":"Thirty Minute
Reserve Estimate:","":"1064"},{"C":"D","Morning Report":"Expected ICU
Operation","":"0"},{"C":"D","Morning Report":"Expected Actions of OP
4:","":"0"},{"C":"D","Morning Report":"Additional Capacity Available
from OP 4 Actions:","":"0"},{"C":"H","Morning
Report":"DESCRIPTION","":"SCHEDULED CONTRACT"},{"C":"H","Morning
Report":"(MW)","":"(MW)"},{"C":"G","Morning Report":"7. Interchange
Summary"},{"C":"D","Morning Report":"NYISO AC Ties","":"167"},
{"C":"D","Morning Report":"NYISO NNC","":"200"},{"C":"D","Morning
Report":"NYISO CSC","":"330"},{"C":"D","Morning Report":"NB","":"222"},
{"C":"D","Morning Report":"Phase 2","":"-1225"},{"C":"D","Morning
Report":"Highgate","":"-218"},{"C":"H","Morning
Report":"CITY","":"HIGH TEMP"},{"C":"H","Morning Report":"","":"(F)"},
{"C":"G","Morning Report":"8. Weather Forecast Summary for the Peak
Hour"},{"C":"D","Morning Report":"Boston","":"45"},{"C":"D","Morning
Report":"Hartford","":"46"},{"C":"H","Morning
Report":"DESCRIPTION","":"VALUE"},{"C":"H","Morning Report":"","":""},
{"C":"G","Morning Report":"9. SAR Available"},{"C":"D","Morning
Report":"NYISO","":"Yes"},{"C":"H","Morning
Report":"DESCRIPTION","":"VALUE"},{"C":"H","Morning
Report":"","":"(MW)"},{"C":"G","Morning Report":"10. Capacity of Non-
Commercial Units"},{"C":"D","Morning Report":"Total Available","":"0"},
{"C":"G","Morning Report":"11. Units Committed to Meet Minimum
Operating Reserve and Replacement Reserve Requirements"},
{"C":"D","Morning Report":"0 Units","":"0"},{"C":"H","Morning
Report":"DESCRIPTION","":"VALUE"},{"C":"H","Morning Report":"","":""},
{"C":"G","Morning Report":"12. Solar Magnetic Disturbance Activity"},
{"C":"D","Morning Report":"Forecast:","":""},{"C":"D","Morning
Report":"Alert:","":""},{"C":"D","Morning Report":"Intensity:","":""},
{"C":"D","Morning Report":"Observed Activity:","":""},
{"C":"D","Morning Report":"Actions Taken or Planned by ISO-NE:","":""},
{"C":"D","Morning Report":"Actions Taken or Planned by Other Control
Areas:","":""},{"C":"T","Morning Report":"44 Lines"}]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<head>
<!--Load the AJAX API-->
<script type="text/javascript" src="https://www.google.com/
jsapi"></script>
<script type="text/javascript" src="jquery-1.7.1.min.js"></script>
<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is
loaded.
google.setOnLoadCallback(drawChart);
query = new google.visualization.Query('csv?url=http://www.iso-ne.com/
sys_ops/csvdocs/morning_report2011-12-07-08-18.csv');
var chart = new
google.visualization.OrgChart(document.getElementById('csv_div'));
</script>
</head>
<body>
<script type="text/javascript">
public class CsvDataSourceServlet extends DataSourceServlet {
/**
* Log.
*/
private static final Log log =
LogFactory.getLog(CsvDataSourceServlet.class.getName());
/**
* The name of the parameter that contains the url of the CSV to
load.
*/
private static final String URL_PARAM_NAME = "http://www.iso-ne.com/
sys_ops/csvdocs/morning_report2011-12-07-08-18.csv";
/**
* Generates the data table.
* This servlet assumes a special parameter that contains the CSV
URL from which to load
* the data.
*/
@Override
public DataTable generateDataTable(Query query, HttpServletRequest
request)
throws DataSourceException {
String url = request.getParameter(URL_PARAM_NAME);
if (StringUtils.isEmpty(url)) {
log.error("url parameter not provided.");
throw new DataSourceException(ReasonType.INVALID_REQUEST, "url
parameter not provided");
}
Reader reader;
try {
reader = new BufferedReader(new InputStreamReader(new
URL(url).openStream()));
} catch (MalformedURLException e) {
log.error("url is malformed: " + url);
throw new DataSourceException(ReasonType.INVALID_REQUEST, "url
is malformed: " + url);
} catch (IOException e) {
log.error("Couldn't read from url: " + url, e);
throw new DataSourceException(ReasonType.INVALID_REQUEST,
"Couldn't read from url: " + url);
}
DataTable dataTable = null;
ULocale requestLocale =
DataSourceHelper.getLocaleFromRequest(request);
try {
// Note: We assume that all the columns in the CSV file are text
columns. In cases where the
// column types are known in advance, this behavior can be
overridden by passing a list of
// ColumnDescription objects specifying the column types. See
CsvDataSourceHelper.read() for
// more details.
dataTable = CsvDataSourceHelper.read(reader, null, true,
requestLocale);
} catch (IOException e) {
log.error("Couldn't read from url: " + url, e);
throw new DataSourceException(ReasonType.INVALID_REQUEST,
"Couldn't read from url: " + url);
}
return dataTable;
}
}
</script>
<!--Div that will hold the pie chart-->
<div id="csv_div"></div>
</body>
</html>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
