8 Replies Latest reply on Oct 6, 2017 1:43 AM by Daniel Johns

    Adding new users with initial balance and leave the existing

    Ahmed Mahrous Wayfarer

      Hi everyone,

      while i am trying to use userload commands i tried to find a command which helps me to add new users to pharos database with initial balance and leaving the current users balance as it is without touching it.

       

      can anyone help me to find what i am looking for. BR, Ahmed...

        • Re: Adding new users with initial balance and leave the existing
          Mark Brown Newbie

          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,

          Mark
          Vanderbilt University

           

          C:\Program Files (x86)\Pharos\Bin>userload
          -?, --help               Show Help
               --nohelp            (default)
          -FN, --file <file>       Load users from file specified
          -NT, --server <server>   Load users from NT via Domain Controller specifed
          -PD, --delete            Delete users
               --nodelete          (default)
          -PU, --update            Update users
               --noupdate          (default)
          -PS, --addupdate         Add or Update users
               --noaddupdate       (default)
          -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
               --nogroupcmt        (default)
          -OC, --comment           Keep the old the comment field
          -IG, --groupinsert       Insert group if not already existing
               --nogroupinsert     (default)
          -BO, --billing <option>  Billing option (default: Advance)
          -SB, --skipblankname     Skip users with blank fullname (else use id)
               --noskipblankname   (default)
          -PO, --userpwd <pwd>     Set user password to phrase specified
          -PI, --idpassword        Set user password to id
               --noidpassword      (default)
          -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
          ified

          -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.
                                    Pre-requisite -PS
                  -nodeleteonsync (default).
          -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 information:
                                        purse;action;amount[;purse;action;amount[;...]]
                                        purse is the purse id:
                                            1 = First Purse (Technology Grant)
                                            2 = Second Purse (Tuition Fees)
                                            3 = Third Purse (User Pays)
                                        action is:
                                            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
          ready in

            • Re: Adding new users with initial balance and leave the existing
              Ahmed Mahrous Wayfarer

              Hi Mark,

               

              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".

               

              Thank you.

                • Re: Adding new users with initial balance and leave the existing
                  Daniel Johns Tracker

                  Hi Ahmed,

                   

                  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.

              • Re: Adding new users with initial balance and leave the existing
                Mike Dorris Tracker

                Is there a setting in there for Offline Balance?

                  • Re: Adding new users with initial balance and leave the existing
                    Daniel Johns Tracker

                    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.