The San Francisco VA Medical Center is currently testing the ability to update Fileman data from outside of Fileman using KB_SQL. The SQL2SQLI package has a routine you can run (D ^KBF1FB) to create a "filer" for a specific Fileman file. We ran this routine and created a filer for the New Person file and have successfully updated a users digital and voice pagers from the IntrAnet in our test account. Before we allow them to update their pager data, we first verify their VISTA Access and Verify Codes. Below is the KB_SQL function for verifying a users VISTA Access and Verify Codes:
The "code_string" input parameter is the semi-colon delimited VISTA Access;Verify Codes. The function returns the users DUZ if the Access/Verify codes entered were verified. The function returns a zero if the input was invalid or if the verify code has expired.
The avcode.asp asks the user for their VISTA Access and Verify codes. The avcode.asp calls the Active Server Page tbox.asp which prompts the user to enter their pager information. The tbox.asp then calls the update.asp page to update the pager information in VISTA. The update.asp calls the following Stored Procedure:
Note that the order in which the parameters are passed in must equal the order of question marks (?) in the SQL command.