some more analysis:

I adapted the CSV-URL from your example by expanding the sheet ID with the parameters and the URL prefixes in the screen shots. And then it worked (although it didn't use the pie chart but just the very first table): https://docs.google.com/spreadsheet/pub?key=10JQZob-lWt0GSWcOvKgw9JwZbvkGGlXn3dq2sUEQUBU&single=true&gid=1&output=csv

BUT (and this is more important): We can't get this to work with the new google tables. The reason is, Google obviously changed its URL format for CSV sharing. Now the sharing URL for CSV output looks like

https://docs.google.com/spreadsheets/d/e/2PACX-1vR3HjEvTe8oqS1gmLfigr7LFHRTtuYk3OauRcgXlrWhxkVsEpMPK-Pviibg33So-yD73y1N_3PBPZHt/pub?gid=0&single=true&output=csv (not working sample URL).

If I copy one of those new share links into your module I get the error "JA_GOOGLE_CHART_MISSING_DATA_INPUT" in the frontend.

So it seems like it is all about updating the module (and the documentation, please) to comply with the new Google API requirements.

What do you think, how fast can this be done?

Thank you!

    Hi seppali

    Yes, the URL seems to be changed but when I published, the URL should be:

    https://docs.google.com/spreadsheets/d/e/2PACX-1vRQQwvOawbzDCbwc4JgCZavEf1iW5iXPXabdGIWvoKLfhoVcZ5ds5F6aAlIArPA4sJar61klHGkxpN9/pub?gid=5&single=true&output=csv

    I add this URL to 'TEST Chart (2)' module on your site and try to assign it to 'content-top' position and it shows fine: https://prnt.sc/pivxfw (I temporarily disabled this module, you can enable again to see the same)

        saguaros

        Hi, this works indeed with your link and your table, but not with mine (which actually is quite important):

        https://docs.google.com/spreadsheets/d/e/2PACX-1vR3HjEvTe8oqS1gmLfigr7LFHRTtuYk3OauRcgXlrWhxkWsEpMPK-Pviibg33So-yD73y1N_3PBPZHt/pub?gid=0&single=true&output=csv

        Strangely, my link works like your new one (csv file is downloaded, even in a private windows, so it's no permissions issue). It must be something with the (new) spreadsheet, then. And as I mentioned several times, the Google spreadsheet web publish dialog is no more looking (working?) as in your documentation.

        Thanks for your ongoing support.

        S.

            Hi seppali

            Could you share screenshot highlighting the dialog you're mentioning? I followed our documentation and applied the same for my above link.

              Hi, yes of course!

              Here you are

              anything else we can do for you? Maybe share the table with your Google-Account (please let us know your G Suite Gmail address).

              Thank you, S.

                seppali
                I don't understand the issue here, this dialog is from Google and yes, it changed recently but the link should still work and I did the same steps with above link.

                  so you managed to display a chart with my link?

                  What if you create a complete new Google table and try with it (I'd bet, it won't work either).

                  What can we do (we desperately need this feature as soon as possible)?

                  thank you.

                    seppali

                    With the option of importing data from CSV file, it works but somehow it doesn't with URL of your docs, let me check and will get back to you.

                      I tested again with several cases and confirmed with the developer that there is issue here, I've reported the bug also to the dev team for fixing it.

                      At this moment, you can try to remove the comma under AB column in your docs so the chart can work.

                      Updated:

                      You can backup your site and install this updated package

                      mod-jagooglechart-2.zip
                      653kB
                      5 days later

                      great, thanks a lot for your efforts! I'll check this immediately and let you know about the result.

                      thanks again!

                      Hi saguaros

                      I can confirm it works with the updated module: I can import the charta data now (again) from Google tables.

                      BUT (and maybe I didn't understand the feature well), it does not automatically update: When I change the date in Google tables, the chart is not automatically updated.

                      Is this feature even provided? And if not, is it a big thing to include this feature?

                      The second question is about taking control of the elements of the chart. Is it possible to persistantly display the tooltips (with the name and the values)? Can we influence the format of the legend (display on two lines instead of the scrolling feature with the blue arrows)?

                      thank you!

                        Hi seppali

                        It does automatically updates the new data, the process of exporting CSV from Google sheets is delayed so you will need to wait a bit to see the update.

                            saguaros

                            great, good to know! thank you!

                            what about my other question?

                            The second question is about taking control of the elements of the chart. Is it possible to persistantly display the tooltips (with the name and the values)? Can we influence the format of the legend (display on two lines instead of the scrolling feature with the blue arrows)?

                            thanks!

                                seppali
                                Let me see if it can be done

                                Can we influence the format of the legend (display on two lines instead of the scrolling feature with the blue arrows)?

                                I don't get your point here, could you share some screenshots of how you want it should be?

                                  Hi saguaros

                                  Yes, this (http://jsfiddle.net/uxr1qbt0/) is exactly what I'm talking about. Right now, this tooltip only shows up, when I hover the segments of the pie chart (what is - of course - the purpose of a tooltip).

                                  But we would like to show this info permanently, not only on hover (because we need it also in "print" / PDF). So if there would be a checkbox "show tooltips permanently" (or option field: tooltips: "on hover" | "permanently"), this would be absolutely great.

                                  Do you know what I mean?

                                  Thanks!

                                    You need to Login to view replies.