{execute xeq("utmore.wbb",morehidden$,%cgi$,"!,headerrow,csvfile","",morehidden$)} {if $message > ""}{end} {if $ext = "1"} {end}
[$message]
This function will import {if $ext = "0"}internal{end}{if $ext = "1"}external{end} user records into the UnForm user database. Any matching user ID's will be overwritten, and any new user ID's will be added. The format of the uploaded file must be Comma Separated Values (CSV), as generated by many reporting tools as well as Microsoft® Excel's Save As CSV. The order of fields, and the format, matches that of the Export users function.

The fields must be in this order:

[$impflds]

Not all fields are required, but positions must be filled for any fields included. Missing fields should be set as null (""). Any null field will not be updated.

If all fields other than UserID are null, then the user will be deleted.

Before running this import, be sure to backup the user database. The backup was last done on [$baktime].

Header Row: First row is a header row, and should be ignored
CSV File: Select file to upload
User ID Prefix:
A prefix is added to user ID's to help distinguish types of users. For example, if you will import both customers and vendors using their account numbers as user ID's, you may wish to add a C prefix to customers and a V prefix to vendors avoid conflicts.