GoogleChart integration not working with JA Google Charts Module

seppali

We're trying to access a google spreadsheet for retrieving the data to build a chart with JA Google Chart. Unfortunately our link doesn't work.

We are trying to proceed according to your documentation. But, the Google "share sheet" does not look / work anymore as you describe it in your documentation. Can you confirm, that the "get data from url" feature ist still working with Google ?

And if yes, can you please help us to get the module working (we desperately need this functionality...)

thank you so much!

saguaros

seppali
Hi,

It should work fine, did you try with our sample data URL?

seppali

saguaros

Well, if you're talking about this sample data, I just can't: The web share feature isn't enabled, so I can't get the URL in CSV format. Or did you mean another data URL I maybe didn't see in the documentation?

And as I said: Your documentation seems to be outdated (yes, we all love this surprising "monthly improvement policy" of Google... ;-)). However, the Google tables share window doesn't look anymore as it is in your documentation.

The "live demo" button doesn't work neither (Chrome & Firefox on Mac), btw.

thank you.

seppali

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!

saguaros

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)

seppali

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.

saguaros

Hi seppali

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

seppali

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.

saguaros

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.

seppali

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.

saguaros

seppali
Let me try with your csv file and see how it goes.

seppali

saguaros

okay, thank you. what do you mean / need exactly?

Here we are with the table we actually need (you should have access)

https://docs.google.com/spreadsheets/d/1x8WFvcR1MkDhJNVyhL9MymQMw4sOK-uh5rR-j4RqRDk/edit?usp=sharing

Just to be clear, what we need. We want to integrate a link to this Google sheet (auto updating), not just a static download and upload of CSV file.

anything else we can provide you with?

thanks!

seppali

Hello, saguaros?

saguaros

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.

saguaros

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.

saguaros

Updated:

You can backup your site and install this updated package

mod-jagooglechart-2.zip

653kB

seppali

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

thanks again!

seppali

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!

saguaros

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.

seppali

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!

saguaros

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?

saguaros

seppali Is it possible to persistantly display the tooltips (with the name and the values)?

Google chart supports to show 1 tooltip only, like this: https://jsfiddle.net/svgcey72/

only pie chart can have: http://jsfiddle.net/uxr1qbt0/