Horizon user import into Pharos
Posted by Matthew Ryan, Last modified by Matthew Ryan on 04 January 2013 07:00 PM
Pharos 8.2 required fields for Horizon export / import to Pharos
*See attached PDF for download
<last name>,<first name>,<logon id>,<billing option>,<group>,<password>,<access level>, <credit>,<address>,<phone>,<comment>,<rate schedule>,<card ID>,<middle initial>,<alias>
Sample Import text
Smith, John, X1234567890,Advance,Public,1234,User,,,,,,,,X1234567890
Variable text is exported from Horizon
Fixed text must be present in the CSV file prior to Pharos import
The fields may contain single quotes and spaces. If a field contains commas, it must be enclosed in double quotes. If a field contains double quotes, they must be doubled up (i.e. each double quote must be replaced with two double quotes). Items that are longer than the specified maximum length are automatically truncated. The import file should have a TXT extension.
Command line import options
The batch loader (userload.exe) can be run from within the Pharos Administrator or standalone from the command line or a script file. When run from the command line, the following options can be specified. The parameters for the command-line batch loader are case sensitive. If the short option of command line options is used, options must be in uppercase. If the long version is used, options must be in lowercase. Userload.exe is found in the .\program Files\Pharos\Bin folder.
-FN Filename to load
-PD Delete User
-PU Update User
-PS Add or Update User
-GS Assign all users to group specified
-IG Insert group if not exist
Command line example
userload -PS -FN c:\temp\users.txt -CL admin
Function: Add/Update users in the Pharos Database from a file users.txt. The Cashier user performing the operation is admin (a Cashier must always be specified when batch loading from a file).
Userload.exe /? [Lists help]