Databases
StackOverflow2013
Postsdbo
POGoogle Spreadsheet does not return data to Google Chart if user is not logged in
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGoogle Spreadsheet does not return data to Google Chart if user is not logged in
    primarykey
    data
    text
    <p><a href="http://sgratrace.appspot.com/" rel="nofollow noreferrer">My charts</a> work perfectly on Chrome and Firefox but breaks on IE10. The IE10 console reports the following error:</p> <blockquote> <p>SEC7112: Script from <a href="https://accounts.google.com/ServiceLogin?service=wise&amp;passive=1209600&amp;continue=https://docs.google.com/spreadsheet/tq?key%3D0ArgBv2Jut0VxdERtWEU4UE5BbFd2TnZzVW8yTlB5eFE%26headers%3D1%26gid%3D0%26pub%3D1%26tq%3Dselect%2BL,%2BA,%2BH,%2BB,%2BI,%2BC,%2BF,%2BE,%2BG%2Bwhere%2BJ%2B%253D%2B" rel="nofollow noreferrer">https://accounts.google.com/ServiceLogin?service=wise&amp;passive=1209600&amp;continue=https://docs.google.com/spreadsheet/tq?key%3D0ArgBv2Jut0VxdERtWEU4UE5BbFd2TnZzVW8yTlB5eFE%26headers%3D1%26gid%3D0%26pub%3D1%26tq%3Dselect%2BL,%2BA,%2BH,%2BB,%2BI,%2BC,%2BF,%2BE,%2BG%2Bwhere%2BJ%2B%253D%2B</a>... <strong>DreqId:0 was blocked due to mime type mismatch</strong> sgratrace.appspot.com</p> </blockquote> <p>Code for querying the spreadsheet:</p> <pre><code>Rats.Viz.GraduateEmploymentSurvey.Overview.query = function() { var query = new google.visualization.Query( Rats.Viz.GraduateEmploymentSurvey.Overview.dataSourceUrl); // Group by IHL and Post NS status // Pivot by year query.setQuery("select H, sum(D), sum(E) group by H pivot A " + "label sum(D) '', sum(E) '' " + "format sum(D) '$#,###', sum(E) '##.#%' "); query.send(Rats.Viz.GraduateEmploymentSurvey.Overview.dashboard); }; </code></pre> <p>Full code here: <a href="https://github.com/seahrh/sgratrace/blob/master/war/js/rats.js" rel="nofollow noreferrer">https://github.com/seahrh/sgratrace/blob/master/war/js/rats.js</a></p> <p>Unfortunately IE10 also refuses to play well with <a href="https://developers.google.com/chart/interactive/docs/spreadsheets" rel="nofollow noreferrer">Google API Playground</a> so I can't check whether the documentation code examples work on IE10.</p> <p>EDIT: The charts work on IE9 (build 9.0.8112.16421) but not IE10 (build 10.0.9200.16635). </p> <p>I think probably Chart Tools is returning a javascript file without the javascript MIME type and this is causing IE a great deal of discomfort: <a href="https://stackoverflow.com/questions/5986772/ie9-script-response-blocked-due-to-mime-type-mismatch">IE9 script response blocked due to mime type mismatch</a></p> <p><strong>EDIT2</strong></p> <p>Found more info on this issue in this <a href="https://groups.google.com/d/msg/google-visualization-api/o2Okyr5vK3E/Vj0oeX7--ZAJ" rel="nofollow noreferrer">forum thread</a>. The error seems to arise from <strong>Google Spreadsheet</strong> instead of Visualization API. IE and Chrome force user to login before Google spreadsheet returns data to chart. See ticket #1281 lodged with Visualization API: <a href="https://code.google.com/p/google-visualization-api-issues/issues/detail?id=1281" rel="nofollow noreferrer">https://code.google.com/p/google-visualization-api-issues/issues/detail?id=1281</a></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USruhong
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POGoogle Spreadsheet does not return data to Google Chart if user is not logged in
      1. USruhong
      1. VTFavorite
    2. VO
      singulars
      1. POGoogle Spreadsheet does not return data to Google Chart if user is not logged in
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POGoogle Spreadsheet does not return data to Google Chart if user is not logged in
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI made a simple test case using your data source URL and query, and it works fine in IE 8-11: http://jsfiddle.net/asgallant/x2Hsg/. Try reducing your code to the simplest form that doesn't work, and debug that.
      singulars
      1. POGoogle Spreadsheet does not return data to Google Chart if user is not logged in
      1. USasgallant
    2. CO@asgallant Thank you for your quick reply. Unfortunately the fiddle that you shared with me doesn't work on my IE. The console reports the same error SEC7112: something was blocked due to mime type mismatch. There was also a pop-up that says request timed out. > My IE build number is 10.0.9200.16635 and Update Versions as at 10.0.7 (KB2846071). I even tried lowering the security setting to Medium but that didn't work. I'm pulling my hair out here because everything works on Chrome, FF and Opera.
      singulars
      1. POGoogle Spreadsheet does not return data to Google Chart if user is not logged in
      1. USruhong
    3. COHmmm...my simplified example works fine for me, but when using your code it breaks. I shall have to think on this some more.
      singulars
      1. POGoogle Spreadsheet does not return data to Google Chart if user is not logged in
      1. USasgallant
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload