Thanks Jinji, I was not aware of the difference between "to have" a data source and "to implement" a data source, so there is my trouble.
I dont have access to the server (its my client's server) so I will stick to the JS way. I will let you know how it goes. On 5 set, 08:41, Jinji <[email protected]> wrote: > google.visualization.Query is to query servers that implement a "data > source", which is not your case. You can read the XML file using regular > JavaScript ways, and write some JS code that would build the DataTable from > the XML content. > > Alternatively you could build a server that will > implement<http://code.google.com/apis/visualization/documentation/dev/implement...>a > data source. It's more complicated, but it gives you more power (which > may > or may not be relevant in your case). > > On Sun, Sep 5, 2010 at 3:54 AM, João Paulo Alquéres <[email protected]> wrote: > > > > > Jinji and Vladimir, > > > The method using SPServices seems to me too much for something that > > could be done via QueryObjects (http://code.google.com/intl/pt-BR/apis/ > > visualization/documentation/reference.html#queryobjects). > > > I could query the SharepointList's RSS (a plain XML file) via > > sendMethod='xhr' and send the response to a DataTable: > > There is a sample in the Code Playground (http://code.google.com/apis/ > > ajax/playground/?type=visualization#using_the_query_language) but only > > for GoogleSpreedsheets. > > > I was trying to find out how this would look if i was using a XML file > > instead. > > Everything I tryed resulted in a blank screen. > > > function drawVisualization() { > > var query = new google.visualization.Query('https://<mydomain>/ > > <my_xml_file>.xml', {sendMethod:'xhr'}); > > query.send(handleQueryResponse); > > } > > > function handleQueryResponse(response) { > > var data = response.getDataTable(); > > visualization = new > > google.visualization.LineChart(document.getElementById('visualization')); > > visualization.draw(data, {legend: 'bottom'}); > > } > > > Can someone give an insight? > > > Thanks a lot. > > > On 4 set, 17:26, Jinji <[email protected]> wrote: > > > I'm not really familiar with Sharepoint, but I can say that Google > > > Visualization API has no native support for it. You'll have to read the > > data > > > from Sharepoint using whatever methods Sharepoint provides for reading > > the > > > data (or other tools, such as the suggested SPServices library), and then > > > build a DataTable< > >http://code.google.com/apis/visualization/documentation/reference.htm.. > > .>from > > > it yourself. > > > > On Fri, Sep 3, 2010 at 10:34 PM, João Paulo Alquéres <[email protected]> > > wrote: > > > > > Hi, > > > > > I would like to know if it is possilbe to natively load a Sharepoint > > > > custom list in a GoogleVizApi DataTable to be used later to draw a > > > > chart. > > > > > Something like: > > > > > var dt = new > > > google.visualization.DataTable.FetchData("SharepointList";"SharepointView") > > > > > where FetchData would be a native method to catch the Sharepoint List > > > > and put it into a DataTable using Columns and Rows as values. > > > > > A workaround would be to use Sharepoint's native support for RSS (a > > > > standard xml file). > > > > Every list in sharepoint has a specific RSS file that could be used to > > > > load the data like: > > > > > var dt = new > > > > google.visualization.DataTable.FetchXML("SharePointList.xml") > > > > > I dont know if either one of the data sources (sharepoint/xml) are > > > > natively supported by the Google Visualization API, so I would > > > > appreciate your help. > > > > > Best regards, > > > > Paulo. > > > > > -- > > > > 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]<google-visualization-api%[email protected]><google-visualization- > > api%[email protected] <api%[email protected]>> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/google-visualization-api?hl=en. > > > -- > > 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]<google-visualization-api%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/google-visualization-api?hl=en.- Ocultar > >texto das mensagens anteriores - > > - Mostrar texto das mensagens anteriores - -- 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.
