WordPress.org

Forums

Visualizer: Charts and Graphs
[resolved] No option to choose csv format on Google Drive Publish to the web window (7 posts)

  1. brightestspark
    Member
    Posted 1 year ago #

    I created a Google spreadsheet in my Google Drive.

    I tried to follow your instructions here https://github.com/madpixelslabs/visualizer/wiki/How-can-I-populate-data-from-Google-Spreadsheet%3F

    But I don't have an option to choose csv as per step 4.

    Any ideas why?

    Here's my spreadsheet https://docs.google.com/spreadsheets/d/1OwLbLxAemWIjLo97GR3xggXkGwBFBpbGJie9eKj7gwk/pubhtml

    https://wordpress.org/plugins/visualizer/

  2. madpixels
    Member
    Plugin Author

    Posted 1 year ago #

    Looks like the Google has removed such ability to export spreadsheet in the csv format. A simple workaround could be to upload a csv file to your server and use it as a source for your chart. Could you try it?

  3. brightestspark
    Member
    Posted 1 year ago #

    Hi - no biggie - we wanted to use Google Drive so that non web peeps could populate and update the spreadsheets ongoing, but they are happy to just upload the csv through WordPress for initial and ongoing updates.

    Thanks

  4. philip.levine
    Member
    Posted 1 year ago #

    Step 1) Set share to anyone with link
    Step 2) Use the following URL replacing KEY with the Google Doc key - In your example it would be 1OwLbLxAemWIjLo97GR3xggXkGwBFBpbGJie9eKj7gwk
    https://docs.google.com/spreadsheets/d/KEY/export?gid=0&format=csv

    Perhaps there a feature could be added that just allows you to enter the KEY and the plugin would generate the rest of the URL

  5. webbrewers
    Member
    Posted 1 year ago #

    So if Google no longer supports publishing csv files, the interactivity no longer works and the plug in's documentation should be updated to reflect that, no?
    I tried the above and replaced "export" with "pubhtml" and neither work.
    https://docs.google.com/spreadsheets/d/1umbBAHYFVKEx7kE9NFjGf9yemiQ4WexKXAgEReWEXIo/pubhtml?gid=0&format=csv

  6. madpixels
    Member
    Plugin Author

    Posted 1 year ago #

    @webbrewers

    You don't have to use Google. Just upload your csv to your server, copy its link and use it as remote source. In this case you will be able to update csv files and your charts will be updated as well.

  7. webbrewers
    Member
    Posted 1 year ago #

    Right but the documentation says you can connect to a Google doc. The alternative is you have to replace the file when it changes (or find a way to open it from the server in Excel). Dynamic updates were a requirement in this case, so I ended up using RJ Quickcharts which provides an easy way to update via the dashboard so removes the need for a Google doc.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Visualizer: Charts and Graphs
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.