Populating a UserValidation Table

For more information on SQL Data Types please see Microsoft Developer Network Transact-SQL Data Types https://msdn.microsoft.com/en-us/library/ms187752.aspx.

Create a delimited text file containing the following fields in the exact order displayed with nulls only in fields allowing nulls and following all other rules for ILLiad field contents such as specific values allowed and password requirements as noted:

FieldDataTypeNulls Allowed?Note/Special Instructions
UserNamenvarchar(100)No Nulls Allowed

REQUIRED IN THIS FILE - Primary Key–This field ** must be unique ** across the entire database. If your list of users to import as duplicate entries, you will get errors trying to import those users into the UserValidation table.

UserValidationTypenvarchar(4)No Nulls Allowed

REQUIRED IN THIS FILE - The UserValidationType column has been added to the UserValidation table. Two values can be used in UserValidationType: Auth (default) or Load.Auth indicates that the User record will be used to authenticate a user. If a user successfully authenticates and their User record does not already exist, a User record will be created with information from the UserValidation data. Load is only applicable when using a WebAuthType of LDAP or when RemoteAuthSupport is enabled. If so, the default WebAuthType will be used and the UserValidation data is only used to populate a newly created User record after a user successfully authenticates.

LastNamenvarchar(40)No Nulls AllowedREQUIRED IN THIS FILE
FirstNamenvarchar(40)No Nulls AllowedREQUIRED IN THIS FILE
SSNnvarchar(20)Yes Nulls Allowed 
Statusnvarchar(15)Yes Nulls Allowed

If you plan to use either the ILLiad web reports based on status or use status specific web pages, you will need to populate this field either in user validation or on NewAuthRegistration by hidden value or user input.

EMailAddressnvarchar(100)Yes Nulls Allowed 
Phonenvarchar(15)Yes Nulls Allowed 
MobilePhonenvarchar(15)Yes Nulls Allowed 
Departmentnvarchar(255)Yes Nulls Allowed

If you plan to use the ILLiad web reports based on department, you will need to populate this field either in user validation or on NewAuthRegistration by hidden value or user input.

NVTGCnvarchar(20)Yes Nulls Allowed

*REQUIRED in User record for ILLiad to function correctly.  Must be populated either by UserValidation or by NewAuthRegistration hidden field or user input.

Passwordnvarchar(64)Yes Nulls Allowed

Please see Usernames and Passwords section for further information here.

 

NotificationMethodnvarchar(10)Yes Nulls Allowed

* REQUIRED in User record for ILLiad to function correctly.  Must be populated either by UserValidation or by NewAuthRegistration hidden field or user input. Valid values are E-Mail, Phone, or Mail.

DeliveryMethodnvarchar(25)Yes Nulls Allowed

* REQUIRED in User record for ILLiad to function correctly.  Must be populated either by UserValidation or by NewAuthRegistration hidden field or user input. Valid Values are Hold for Pickup, Mail to Address.

LoanDeliveryMethodnvarchar(25)Yes Nulls Allowed

* REQUIRED in User record for ILLiad to function correctly. Must be populated either by UserValidation or by NewAuthRegistration hidden field or user input. Valid Values are Hold for Pickup, Mail to Address.

AuthorizedUsersnvarchar(255)Yes Nulls Allowed 
Webnvarchar(3)Yes Nulls Allowed

* REQUIRED in User record for ILLiad to function correctly.  Must be populated either by UserValidation or by NewAuthRegistration hidden field or user input. Valid Values are Yes, No.

 Addressnvarchar(40)Yes Nulls Allowed 
 Address2nvarchar(40)Yes Nulls Allowed 
 Citynvarchar(30)Yes Nulls Allowed 
 Statenvarchar(2)Yes Nulls Allowed 
 Zipnvarchar(10)Yes Nulls Allowed 
 Sitenvarchar(40)Yes Nulls Allowed  
 Numbernvarchar(20)Yes Nulls Allowed  
Organizationnvarchar(50)Yes Nulls Allowed 
Faxnvarchar(15)Yes Nulls Allowed 
ArticleBillingCategorynvarchar(50)Yes Nulls Allowed 
LoanBillingCategorynvarchar(50)Yes Nulls Allowed 
Countrynvarchar(50)Yes Nulls Allowed 
SAddressnvarchar(40)Yes Nulls Allowed 
SAddress2nvarchar(40)Yes Nulls Allowed 
SCitynvarchar(30)Yes Nulls Allowed 
SStatenvarchar(2)Yes Nulls Allowed 
SZipnvarchar(10)Yes Nulls Allowed 
PasswordHintnvarchar(50)Yes Nulls Allowed 
SCountrynvarchar(50)Yes Nulls Allowed 
Blockednvarchar(3)Yes Nulls Allowed 
PlainTextPasswordnvarchar(250)Yes Nulls Allowed

Please see Usernames and Passwords section for further information here.

 

UserRequestLimitnvarchar(5)Yes Nulls Allowed 
UserInfo1nvarchar(255)Yes Nulls Allowed 
UserInfo2nvarchar(255)Yes Nulls Allowed 
UserInfo3nvarchar(255)Yes Nulls Allowed 
UserInfo4nvarchar(255)Yes Nulls Allowed 
UserInfo5nvarchar(255)Yes Nulls Allowed 

 

Tips & Best Practices:

  • Verify that your WebValidation table supports the fields and values that you are specifying in UserValidation and NewAuthRegistration/ChangeUserInformation web pages.  Learn more about WebValidation at https://prometheus.atlas-sys.com/display/illiad/Changing+Required+Fields
  • Any fields that you want populated with defaults without user intervention that you do not supply via UserValidation you must specify as hidden fields on the NewAuthRegistration web page.  You will also need to comment out the matching non-hidden fields in the web page to defer to hidden values specified and prevent registrants from selecting values that overwrite your uservalidation or hidden entries.  Learn more about hidden fields at https://prometheus.atlas-sys.com/display/illiad/Required+Fields
  • If you would like to display to the registrant the value supplied by UserValidation for registration but not allow them to modify it, you will need to make it readonly in the web page display.  Ex. 

    <label for="EMailAddress">

                                    <span class="field">

                                        <span class="req">*</span>                                                                                

                                        <span class="<#ERROR name="ERROREMailAddress">"><strong>Email Address</strong></span>

                                    </span>

                                    <input readonly id="EMailAddress" name="EMailAddress" type="text" size="40" class="f-name" value="<#PARAM name="EMailAddress">"><br>                                                                                          

                                </label>

  • If you are an EZProxy user supplying ALL values that you want to collect in the user record with UserValidation entries and hidden fields, you will want to remove all webvalidation entries except for FirstName validated with .* and add error message of “Issue with User Record.  Please contact ILL Staff at 555-555-5555.”  This prevents EZProxy users who are authenticated but not in UserValidation table from registering without contacting ILL staff to inform of missing record.