Here is a list of all the userload commands - hopefully this should help. For detail of the file structure for the import, open help from within Pharos Adminsitrator and search for "Batch Load Technical Information".
Hope that helps,
C:\Program Files (x86)\Pharos\Bin>userload
-?, --help Show Help
-FN, --file <file> Load users from file specified
-NT, --server <server> Load users from NT via Domain Controller specifed
-PD, --delete Delete users
-PU, --update Update users
-PS, --addupdate Add or Update users
-AL, --archivelog <filename> Write archive log to file specified
-GS, --group <group> Assign all users to the group specified
-GC, --groupcmt Retrieve group from NT user description
-OC, --comment Keep the old the comment field
-IG, --groupinsert Insert group if not already existing
-BO, --billing <option> Billing option (default: Advance)
-SB, --skipblankname Skip users with blank fullname (else use id)
-PO, --userpwd <pwd> Set user password to phrase specified
-PI, --idpassword Set user password to id
-CA, --credit <amount> Credit users with initial amount specifed (default: 0)
-RS, --rate <rate> Assign the given rate specified
-CL, --cashier <cashier> Cashier who is performing credit
-DG, --domaingroup <NT Group name> Process the particular NT domain group spec
-NF, --nameformat <format> Define the name format to be extracted
<format> can be one of -
--fsl Full name field is in 'first last' format (default)
--lcf Full name field is in 'last, first' format
--lsf Full name field is in 'last first' format
-MD, --skip (default) When extracting the group from the NT
user description, skip user if description is blank
-MK, -assigntogroup <group> When extracting the group from
the NT description, and the description is missing
place the user in the specified group.
-RM, --deleteonsync Delete users which no longer exist on NT database.
-AU, --uid Generate alias from User ID
--auto (default) Auto generate
-CP, --purse <purseinfo> Credit, debit, or set purse balances to the values
specified in the ';' semi-colon separated list of
purse is the purse id:
1 = First Purse (Technology Grant)
2 = Second Purse (Tuition Fees)
3 = Third Purse (User Pays)
0 for do nothing
1 for crediting the purse
2 for setting the balance
amount is how much to credit or set the purse to
-RG, --retaingroup Leave alll existing users in the groups they are al
Thank you for you replay...
actually i saw i know these command but what i am looking for is specified. i
need to add new users to pharos with initial balance "ONLY for these new users
with out touching the current users balance".
How to use the Batch Loader to meet your requirement depends on what exactly you do want to do with user accounts already in the Uniprint database. If you want to leave them as they are and not touch them at all, then you can simply run the batch loader without any of the parameters that specify what kind of action to take (i.e. no -PU, -PS or -PD). Lacking such a parameter, the Batch Loader will default to "insert only", inserting the new users into the Uniprint database (and setting their balances) while taking no action for users already present in Uniprint database. This point is not obvious from reading the "Batch Load Technical Information" page of the Help.
If you do want to update name or address details for users already in the Uniprint database, but just don't want to change their balances, then the batch loader's -PS option does not support having one policy for balances of existing users and another for new users. The solution may be to run the batch loader twice, first to update existing users, then to insert new ones.
Regards, Daniel Johns.
So, Daniel Johns (I know this is already four years old, but it's the only reference to answer my query), you say "Lacking such a parameter, the Batch Loader will default to "Insert Only", inserting new users into the Uniprint database...while taking no action for users already present in the Uniprint database."
On that basis, if I have 10,000 users in my database, and do an "insert only" batch load of 3,000 new users and 8,500 existing users, the only changes made will be to insert the 3,000 new users, leaving the 8,500 existing users in the batch alone?
Just checking, because, as you say, "The point is not obvious from reading the "Batch Load Technical Information" page of the Help." Lindsay Lamb, you asked about documentation improvements in the iMFPs a couple months back, how about suggesting the Help file is updated with more particular information about what each of the Batch Load operations does?
Thanks Bill! That is great feedback. Appreciate you keeping that documentation improvement question at the top of mind!
Is there a setting in there for Offline Balance?
What, exactly, do you mean by "Offline Balance"? If you mean the External Billing Offline Amount (displayed in the "Billing" tab of the User Accounts context of Administrator), then that is not something that can be directly set and I don't see why anybody would want to. If you mean the External Billing Offline Limit property, that is not among the properties that the userload can set, because we never saw a need for doing so. If you mean one of the properties in the "Offline Mode" tab of the "System Settings" context, the fact that these are global settings, nor configurable for individual users, precludes their being set by the userload.