 
 <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<200
+		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

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);

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

---->
<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'>
