wiseomran / ala

Automatically exported from code.google.com/p/ala
0 stars 0 forks source link

Create a set of example Macros to use within Excel to access ALA web services #149

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Original Issue reported by Project Member Reported by john.t...@austmus.gov.au, 
Jun 27, 2013 - https://code.google.com/p/ala-bie/issues/detail?id=389

Project Member Reported by john.tann@austmus.gov.au, Jun 27, 2013 
Web service suggestion for ALA

I have just run a web service on WoRMS to check the validity of some mollusc 
names. This service ran as a function from within my Excel spreadsheet, and at 
a first pass gave good answers.

Suggestion: create a set of example Macros to use within Excel to access ALA 
web services

Details
WoRMS has a web page about their web services and it includes some sample 
implementations
http://www.marinespecies.org/aphia.php?p=webservice

I followed the step-by-step instructions for Microsoft Excel, which were able 
to guide me how to install their function code. Having never run a spreadsheet 
function before, I found this dumbing down of the process very useful. The 
spreadsheet with embedded macro is attached.

Currently ALA has a very broad range of web services, however these are 
targeted towards developers and those who understand the technical operation of 
web activity. I am suggesting making something extra that could be readily 
dropped into an Excel spreadsheet, without the user having a deep technical 
understanding.

 Today (12 hours ago) Project Member #1 moyesyside@gmail.com 
(No comment was entered for this change.)
 Labels: Type-Enhancement Priority-Medium

Original issue reported on code.google.com by moyesyside on 8 Aug 2013 at 11:56

GoogleCodeExporter commented 9 years ago
August 2013: still wanted

Original comment by johntan...@gmail.com on 12 Aug 2013 at 8:25