 				</form>
 			</li>
 			<li>
+				Attriubtes: when null, for each (not-null) attribute, update....
+				<br>(remove suggestion to do nothing)
+				<form name="atdflt" method="post" action="pre_bulkloader.cfm">
+					<input type="hidden" name="action" value="setNullDefaultsAttribute">
+					<label for="attribute_determiner_n">attribute_determiner_n=</label>
+					<input type="text" name="attribute_determiner_n" value="unknown">,
+					<label for="attribute_date_n">attribute_date_n=</label>
+					<input type="text" name="attribute_date_n" value="#dateformat(now(),'yyyy-mm-dd')#">,
+					<br><input type="submit" value="make all changes">
+				</form>
+			</li>
+			<li>
 				<a name="tysql"></a>
 				<form name="pdflt" method="post" action="pre_bulkloader.cfm">
 					<input type="hidden" name="action" value="execSQL">

			<cfdump var=#myQueryResult#>
		</p>
		<p>
			Use your back button or <a href="pre_bulkloader.cfm?action=nothing##tysql">continue</a>
		</p>
	</cfif>

	<!------------------------------------------------------->
	<cfif action is "setNullDefaultsParts">
		<cfif len(PART_CONDITION_n) gt 0>
			<cfloop from="1" to="10" index="i">
				<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
					update
						pre_bulkloader

		</cfquery>
		<cflocation url="pre_bulkloader.cfm" addtoken="false">
	</cfif>
	<!------------------------------------------------------->
	<cfif action is "instobulk">
		<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#" result="myQueryResult">
			UPDATE pre_bulkloader SET collection_object_id=bulkloader_pkey.nextval WHERE collection_object_id is null
		</cfquery>
		<p>
			collection_object_id updated.
			<a href="pre_bulkloader.cfm?action=setLoadedForLoad">click here to proceed to the next step</a>.
		</p>

	</cfif>
	<!------------------------------------------------------->
	<cfif action is "setLoadedForLoad">
		<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#" result="myQueryResult">
			UPDATE pre_bulkloader SET loaded='pushed_from_prebulk'
		</cfquery>
		<p>
			LOADED updated to pushed_from_prebulk.
			<a href="pre_bulkloader.cfm?action=pushToBL">click here to proceed to the next step</a>.
		</p>

	</cfif>
	<!------------------------------------------------------->
	<cfif action is "pushToBL">
		<cfquery name="c" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#" result="myQueryResult">
			select * from pre_bulkloader where 1=2
		</cfquery>
		<cfset cl=c.columnList>
		<cfset cl=listdeleteat(cl,listfindnocase(cl,'collection_cde'))>
		<cfquery name="ibl" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#" result="myQueryResult">
			insert into bulkloader (#cl#) (select #cl# from pre_bulkloader)
		</cfquery>
		<p>
			Inserted to bulkloader.
			<a href="pre_bulkloader.cfm?action=pushToBL_SUCCESS">click here to avoid confusing yourself</a>.
		</p>
	</cfif>
	<cfif action is "pushToBL_SUCCESS">
		<cfquery name="uppc" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#" result="myQueryResult">
			UPDATE pre_bulkloader SET loaded='pushed to BULKLOADER #dateformat(now(),"yyyy-mm-dd")# by #session.username#'
		</cfquery>
		<p>
			You're all done here.
			<a href="pre_bulkloader.cfm?action=deleteAll">DELETE EVERYTHING from the pre-bulkloader</a> or

			<a href="/Bulkloader/browseBulk.cfm">continue on to the specimen bulkloader</a>.
		</p>

	</cfif>

</cfoutput>
<cfinclude template="/includes/_footer.cfm">
