 	agent_1_id number,
 	agent_2_id number
 );
+
+alter table cf_temp_id add guid varchar2(60);
+
 create public synonym cf_temp_id for cf_temp_id;
 grant select,insert,update,delete on cf_temp_id to manage_specimens;
 

	</cfform>
</cfif>
<!------------------------------------------------------->
<cfif action is "getFile">
<cfoutput>
	<!--- put this in a temp table --->

------>
<cfif action is "nothing">
	Upload a comma-delimited text file (csv).Include column headings, spelled exactly as below.
	<br><a hre="BulkloadIdentification?action=makeTemplate">get a template</a>


	<br><span class="likeLink" onclick="document.getElementById('template').style.display='block';">view template</span>
	<table border>
		<tr>
			<th>Field</th>
			<th>Required?</th>
			<th>Def.</th>
		</tr>
		<tr>
			<td>guid</td>
			<td>conditionally</td>
			<td>You must provide either GUID, or {guid_prefix,other_id_type,other_id_number}.</td>
		</tr>
		<tr>
			<td>guid_prefix</td>
			<td>conditionally</td>
			<td>You must provide either GUID, or {guid_prefix,other_id_type,other_id_number}.</td>
		</tr>
		<tr>
			<td>other_id_type</td>
			<td>conditionally</td>
			<td>
				"catalog number" or value from <a href="/info/ctDocumentation.cfm?table=CTCOLL_OTHER_ID_TYPE">CTCOLL_OTHER_ID_TYPE</a>.
				Must resolve to a single specimen.
			</td>
		</tr>
		<tr>
			<td>other_id_number</td>
			<td>conditionally</td>
			<td>Must resolve to a single specimen.</td>
		</tr>
		<tr>
			<td>scientific_name</td>
			<td>yes</td>
			<td>any valid ID</td>
		</tr>
		<tr>
			<td>nature_of_id</td>
			<td>yes</td>
			<td><a href="/info/ctDocumentation.cfm?table=CTNATURE_OF_ID">CTNATURE_OF_ID</a></td>
		</tr>
		<tr>
			<td>made_date</td>
			<td>no</td>
			<td>ISO8601</td>
		</tr>
		<tr>
			<td>accepted_fg</td>
			<td>yes</td>
			<td>1 (this will become the accepted ID) or 0 (this will not become the accepted ID)</td>
		</tr>
		<tr>
			<td>identification_remarks</td>
			<td>no</td>
			<td>remarkable things</td>
		</tr>
		<tr>
			<td>agent_1</td>
			<td>no</td>
			<td>any unique name</td>
		</tr>
		<tr>
			<td>agent_2</td>
			<td>no</td>
			<td>any unique name</td>
		</tr>
	</table>

	<cfform name="oids" method="post" enctype="multipart/form-data">
		<input type="hidden" name="Action" value="getFile">
		<input type="file"
