Thanks Daniel. So I'm working on https://tree.j2-m172.info/pf5197/ to bring to the current version (49). Before the spreadsheet URL was loaded like this: var dataSourceUrl = 'https://spreadsheets.google.com/tq?key=0AtajLqik04ZAdE80a21aR2doOGZYZ2dBdlR2V1J4d0E&gid=0&transpose=0&headers=1'; With looking into Inspect > Console and at the Google Spreadsheet Link + https://developers.google.com/chart/interactive/docs/spreadsheets I edited to this which worked together: google.charts.load('current', {packages:["orgchart"]}); var dataSourceUrl = 'https://docs.google.com/spreadsheets/d/15MWR7QGH86UzXsNKXW4COFzxiAC0BNWuaXZlaVYRs8Y/gviz/tq?gid=0&headers=1&transpose=0';
On Saturday, August 8, 2020 at 7:45:43 PM UTC+2 Daniel LaLiberte wrote: > Hi Chris, > > The problem is most likely that your spreadsheet URL is redirected to a > new URL that you should use instead. You should be able to see the > redirect in your browser's debugger, when using Google Charts version 49. > Unfortunately, the redirect loses security information that is now relied > upon. Earlier versions of Google Charts still work with the older > spreadsheet URLs, for now, but we may eventually phase them out due to > these same security concerns, and they will probably fail with MS Edge as > well. > > The next release of Google Charts will have a workaround for these older > URLs so it works in most browsers, but again, users of MS Edge will still > not be supported. > > On Sat, Aug 8, 2020 at 4:33 AM Chris Rot <[email protected]> wrote: > >> I'm using Google orgchart since late 2013 and it worked fine to display a >> hierarchical spreadsheet in orgchart/tree format until maybe 2 weeks ago. >> Here the html/css/js how it originally worked: >> https://tree.j2-m172.info/pf5197/ or the older code with more comments >> and links: https://tree.j2-m172.info/ with the line: >> google.load('visualization', '1', {'packages' : ['orgchart']}); >> >> I tried here https://codepen.io/ChrisRgen/pen/MWyYdjy to switch to the >> seemingly new loading as explained on >> https://developers.google.com/chart/interactive/docs/gallery/orgchart >> google.charts.load('current', {packages:["orgchart"]}); >> then changed to 48 and 47 and booth seem to work so far >> google.charts.load('48', {packages:["orgchart"]}); >> >> Please mind that I can not code JS or any script/programming language by >> myself. I was just able to change and adjust online samples code so that it >> worked ;-) >> So is the solution to stick to loading v48? >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google Visualization API" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/google-visualization-api/59688d5f-0890-450a-b66b-13c2bbec4a33n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/google-visualization-api/59688d5f-0890-450a-b66b-13c2bbec4a33n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> > [email protected] Cambridge MA > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/a660eaa8-1a9e-4703-981c-b9bd30476c58n%40googlegroups.com.
