 alter table ds_temp_tax_validator add gni varchar2(255);
 alter table ds_temp_tax_validator add worms varchar2(255);
 alter table ds_temp_tax_validator add eol varchar2(255);
+alter table ds_temp_tax_validator add gbif varchar2(255);
 
 create or replace public synonym ds_temp_tax_validator for ds_temp_tax_validator;
 grant all on ds_temp_tax_validator to manage_taxonomy;
 
 
 -- google has diallowed useful API access to search results
--- http://api.gbif.org/v1/ returns SOMETHING (usually 'incertae sedis') for everything, is not useful
+
+
+-- reset for testing
+update ds_temp_tax_validator set gbif=null, eol=null,wiki=null,gni=null,worms=null;
+
+
+
+
 
 ---->
 <cfif action is 'gpd'>

	<cfoutput>
		<cfloop query="d">
			<br>#taxon_name#
			<cfhttp url="https://www.wikidata.org/w/api.php?action=wbsearchentities&search=#taxon_name#&language=en&format=json" method="get">
			<cfif cfhttp.filecontent contains '"search":[]'>
				<cfset w='not_found'>


<cfif action is "parse">
	<cfquery name="d" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
		select * from ds_temp_tax_validator where taxon_name is not null and wiki is null and rownum<50
	</cfquery>
	<cfif d.recordcount is 0>
		Nothing found - 	<a href="taxonNameValidator.cfm?action=showResults">showResults</a> or
