Usm nodeny EN
 |
This function is one of the possibilities |
usm_nodeny - module to organise the import of data from the NoDeny billing system into ERP UserSide
This module is a replacement for the deprecated us_nodeny module - See: Migrating from us nodeny to usm nodeny
Module Language: PHP
Current version: See the page: Modules
Module Status: Paid
For more information and a list of imported data, see the page: NoDeny
Information on installing the module
Make sure that the php_mysqli library is present on the system where the module will run
The usm_nodeny.zip archive contains the files
usm_nodeny.php usm_nodeny.conf.php-example
1. On any server (no difference - billing server, userside or third machine) allocate a separate (arbitrary) directory for the module and place these files in it
2. Allocate a separate directory for the module logs. Give write permissions to this directory
3. Rename the sample configuration file usm_nodeny.conf.php-example to usm_nodeny.conf.php and make the required changes (the list of parameters is given below) in it
4. Run the module manually several times (*) with the command
php usm_nodeny.php
It should work without error and return the data:
usm_nodeny ==================================== Start module at 2015-11-22 17:32:03 Finish module at 2015-11-22 17:32:14 ====================================
* - At the first run - many objects will be pre-created only. The more objects the module imports - the longer it will take. The second and subsequent runs will reconcile the changed data and only these will be updated. The second run will also take a long time, because after the first run the newly created objects do not contain any data. But the third and subsequent runs will run much faster.
5. Visually verify the completeness of the imported data in the ERP "UserSide"
6. When it is clear that the module works stably - add it to the system cron for periodic operation (specify the necessary paths)
*/10 * * * * php usm_nodeny.php
Parameters
The module is configured in the usm_nodeny.conf.php file
You can also use the default parameters from the usm_billing module
$usersideUrl - URL to the ERP "UserSide" $usersideApiKey - API-key of ERP "UserSide" $billingId - Billing number in ERP "UserSide" ("Settings - Billings") $logPath - Path for logging $isSilence - Silence Mode flag (hide the output of information messages from the module to the console) $billingDBHost - address of the billing server $billingDBUser - user name for access to the billing database $billingDBPassword - password for access to the billing database $billingDBName - billing database name $billingCodePage - encoding of the billing database $billingDBPort - billing database port number $confListIgnoreImportCustomerState - list of users (users.cstate) statuses with which they should not be imported (default: 9,14)' $confIsDisableImportAlias - flag - do not import child records (aliases) $confPasswordAESDecryptString - code string for AES encryption of password in billing $confIdGroupDeleteCustomers - index of additional group of users, which is reserved for "deleted users". Users of this group are not imported $confIdGroupCustomersOnPause - index of additional group of users, which is allocated for "pause" $confIsSavePasswordToComment - flag - save user's password to the authorizer/statistician in the "additional data" field $confImportCustomerExpr - additional string for importing users (used AFTER where) $confIsSwapTrafCounter - flag - replace input/output traffic values by users with each other $confIsImportPaidCodeInComment - flag - import "personal payment code" in comments by user $confFieldDateConnect - import the date of user's connection to UserSide (you should specify the id of the additional field) $confAddFieldIdCity - code of the field "Settlement" - if present. 0 - if not used $confAddFieldIdStreet - code of additional field "Street" in dopfields.id $confAddFieldIdHouseNumber - code of additional field "House" in dopfields.id $confAddFieldIdHouseBlock - code of additional field "Block" in dopfields.id $confAddFieldIdEntrance - code of additional field "Entrance" in dopfields.id $confAddFieldIdFloor - code of "Floor" field in dopfields.id $confAddFieldIdApartment - code of additional field "Apartment" in dopfields.id $confAddFieldIdMac - code of additional field "Mac-address" in dopfields.id $confAddFieldIdPhone - code of additional field "Phone" in dopfields.id $confAddFieldIdPhone2 - code of additional field "Home phone (Phone 2)" in dopfields.id $confAddFieldIdEMail - code of additional field "E-mail" in dopfields.id $confAddFieldIdRealIp - code of additional field "Real IP address" in dopfields.id