Google Spreadsheets Scraper

Bug #509358 reported by Tim McNamara
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Sahana-Eden
Undecided
Unassigned

Bug Description

Be great if we could be given a URL of a Google Spreadsheet with contacts information & insert that into Sahana.

Demo data

http://spreadsheets.google.com/ccc?key=0Ai4sPX0Iqn_vdFV3UWVEc18wejBUNm9tb1k0cDhZdlE&hl=en_GB

Revision history for this message
pamela fox (pamela-fox) wrote :

You can reference these Python scripts to build this:

Retrieves a JSON feed:
http://pamelafox-samplecode.googlecode.com/svn/trunk/learninggames/learninggames.py

Uses client library to retrieve a list feed + convert to a list of dict:
http://pamelafox-samplecode.googlecode.com/svn/trunk/spreadsheetscraper/spreadsheetscraper.py

Both of those assume a public sheet. You can publish a sheet by clicking "Share > Publish> Publish when changes are made".

You could build in authentication to second technique if desired.

Revision history for this message
Fran Boon (flavour) wrote :

Feature Request not a Bug

Work developing here:
http://eden.sahanafoundation.org/wiki/SpreadsheetImporter

Changed in sahana-eden:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers