ILLiad Exclusive: Populating a UserValidation Table

Follow

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:

Field DataType Nulls Allowed? Note/Special Instructions
UserName nvarchar(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.

UserValidationType nvarchar(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.

LastName nvarchar(40) No Nulls Allowed REQUIRED IN THIS FILE
FirstName nvarchar(40) No Nulls Allowed REQUIRED IN THIS FILE
SSN nvarchar(20) Yes Nulls Allowed  
Status nvarchar(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.

EMailAddress nvarchar(100) Yes Nulls Allowed  
Phone nvarchar(15) Yes Nulls Allowed  
MobilePhone nvarchar(15) Yes Nulls Allowed  
Department nvarchar(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.

NVTGC nvarchar(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.

Password nvarchar(64) Yes Nulls Allowed

Please see Usernames and Passwords section for further information here.

 

NotificationMethod nvarchar(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.

DeliveryMethod nvarchar(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.

LoanDeliveryMethod nvarchar(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.

AuthorizedUsers nvarchar(255) Yes Nulls Allowed  
Web nvarchar(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.

 Address nvarchar(40) Yes Nulls Allowed  
 Address2 nvarchar(40) Yes Nulls Allowed  
 City nvarchar(30) Yes Nulls Allowed  
 State nvarchar(2) Yes Nulls Allowed  
 Zip nvarchar(10) Yes Nulls Allowed  
 Site nvarchar(40) Yes Nulls Allowed   
 Number nvarchar(20) Yes Nulls Allowed   
Organization nvarchar(50) Yes Nulls Allowed  
Fax nvarchar(15) Yes Nulls Allowed  
ArticleBillingCategory nvarchar(50) Yes Nulls Allowed  
LoanBillingCategory nvarchar(50) Yes Nulls Allowed  
Country nvarchar(50) Yes Nulls Allowed  
SAddress nvarchar(40) Yes Nulls Allowed  
SAddress2 nvarchar(40) Yes Nulls Allowed  
SCity nvarchar(30) Yes Nulls Allowed  
SState nvarchar(2) Yes Nulls Allowed  
SZip nvarchar(10) Yes Nulls Allowed  
PasswordHint nvarchar(50) Yes Nulls Allowed  
SCountry nvarchar(50) Yes Nulls Allowed  
Blocked nvarchar(3) Yes Nulls Allowed  
PlainTextPassword nvarchar(250) Yes Nulls Allowed

Please see Usernames and Passwords section for further information here.

 

UserRequestLimit nvarchar(5) Yes Nulls Allowed  
UserInfo1 nvarchar(255) Yes Nulls Allowed  
UserInfo2 nvarchar(255) Yes Nulls Allowed  
UserInfo3 nvarchar(255) Yes Nulls Allowed  
UserInfo4 nvarchar(255) Yes Nulls Allowed  
UserInfo5 nvarchar(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://support.atlas-sys.com/hc/en-us/articles/360011907573
  • Any fields that you want to be 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 refer to hidden values specified and prevent registrants from selecting values that overwrite your uservalidation or hidden entries.  Learn more about hidden fields at https://support.atlas-sys.com/hc/en-us/articles/360011807614
  • 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 read-only 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. 

 

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.