From ISP admin

Contents 1 3.41 - 16.3.2010 1.1 BUGS 1.2 NEWS 1.3 LOCALIZATION 1.4 WIKIPEDIA 1.5 EVIDENCE OF WIFI ANTENNAS 1.6 MIKROTIK 1.7 RADIUS 1.8 GOOGLE MAPS 1.9 INVOICING 1.10 INVOICING - price calculation 1.11 Invoicing of reminders 1.12 SCHEDULING 1.13 CATV 1.14 MASS DOCUMENT GENERATION

3.41 - 16.3.2010

BUGS

• fixed some reported bugs

• Contract templates now have 3 new variables $ADRESA_POSKYTOVATEL$ (Provider's address), $PSC_POSKYTOVATEL$ (Provider's ZIP code) and $MESTO_POSKYTOVATEL$ (Provider's city/town). All variables are available in the Tab "Settings / Contracts".

• History in the client card has new item "Stopping user"

• System now can send SMS to more phone numbers when it is filled in client card in the field "Mobile phone". These numbers must be separated by semicolon.

• When the service has set "Invoicing period" as "Don't invoice" system now display price "0" in the summary of services "Customers / Internet", "Customers / VoIP". In the past system has shown service common price there (not on invoice) and in the summary it wasn't clear which service has set "Don't invoice".

• Fixed bug when adding VoIP service system didn't save phone number and it was saved only after editing.

NEWS

• In the tab "Statistics / Logger" Pop-up menu "Sign on users - Administrators" there is the Earth icon and by clicking on this icon system will display details about IP address which was used for logining-in. For this function the system use http://www.geoiptool.com .

• When sending email from client card or by mass sending there is followed order for sender email addresses:

  1. Email of technician who is actually logged-in the system, 
  2. Email added for Invoice group, 
  3. Administrator email filled in the settings as "admin_email".

• In the tab "Statistics / Logger" there is new item "History of deleted clients" with information which technician has delete client and when.

• SMS (longer then 160 characters) will be separated to more messages and marked with number (e.g. 1/3, 2/3, 3/3).

• In the client card there is the tab "History" and it contains complete history of changes at the client.

LOCALIZATION

• Polish localization has been completed. Our local distributor for Poland is company "RAXEL Telekomunikacja Mazowiecka".

WIKIPEDIA

• On-line manual has been released at the address http://wiki.ispadmin.eu
• Very useful is the new section FAQ (frequently asked questions) at the address http://wiki.ispadmin.eu/index.php/FAQ . This section is updated recently. Please read carefully this section before you contact us. Common answers are there right now.

• Icon with link to this Wikipedia is displayed on the top of the page when you are logged in your system
• If you will have any ideas or wishes how we can improve this documentation please contact us wiki@ispadmin.eu

EVIDENCE OF WIFI ANTENNAS

• fixed some reported bugs
• for each antenna there is option to set if it has vertical or horizontal polarization. Anntena types can be specified in the Tab "Settings / Codebooks / Antennas".

MIKROTIK

• fixed bug about saving of MK routers binary backups. There was a problem (in some MK versions) with connecting and saving via SSH and it was neccessary to fill "Yes" manualy after first login to the system. Now it is automatic.

• In the Tab "Others / Backups / Mikrotik" there is new column "HW" with information about HW with Mikrotik (e.g. RB333).

• Fixed bug about duplicate entries (in some MK versions) after changing Client's MAC address.

• Fixed bug about non-complete applying QT in the some of the newest MK.

  e.g. Mikrotik sent value 100k in place of 100000. It is right but system can't recognize it because it is new in the last 
  versions of Mikrotik ( they didn't say anything ;)

RADIUS

• In the Tab "Customers / Internet". Fulltext search now accept item "User name RADIUS" as well.

• In the "Client card / Radius" there are now informations about all activated RADIUS services and also table of group attributes.

• When the client is stopped the system will disconnect him and block access.

• Each change of RADIUS attribute is immediately synchronized with Radius server and active.

• Attribute synchronization with Radius server

• Item "Mikrotik-Rate-Limit" isn't applicated for each client. The attribute "Mikrotik-Rate-Limit" must be set at tariffs' attributes. If the value isn't set so ISPadmin generate this value from tariff settings in the Tab "Settings / Tariffs / Radius". If this value is set manually in this case ISPadmin apply value as special attribute at the client

• Fixed bugs after update of some parameters

• When the checkbox "Lock user" isn't check in this case system won't apply attribute "NAS-IP-Address"

• Radius server can confirm user by name and password but when it is filled MAC address (as a name) system provides confirmation by MAC address and no password is needed. In this case there must be allowed Client confirmation by MAC address in the system in the Tab "Radius / General / item Wireless.

GOOGLE MAPS

• Layers are generated to the KML file which are smaller and faster for loading.

• Layers are generated considering requests via AJAX

• Range of antennas is possible to set even with decimal places

INVOICING

• In the Tab "Billing / Summaries / Claims" there it is possible to search invoices by date (from / to)

• Added CSV import of "GE Money Bank" bank statement. This is possible to choose in the Tab "Billing / Bank"

• In the Tab "Billing / Bank" there it is possible to print "List of disparated payments for defined period". This link is located on the right side of the page above table with list of imported payments. Period for defined period (month / whole year) can be displayed in PDF format and printed.

• In the Tab "Billing / Summaries / Accounting" there are two new columns "Price with VAT, Price without VAT"

INVOICING - price calculation

• Modification in the price calculation with VAT. System now calculated invoices with and without VAT in different ways (correct way according to accounting systems). Option to set with or without VAT can be fond int the Tab "Billing / Settings" the Item "cena_dph_typ".

If this item is set to "0" value so system create invoices without VAT. Value "1" means price with VAT.

• • procedure of price calculation for cena_dph_typ = 0, VAT rate = 20%

service has set price without VAT ( e.g. VAT 20% )

price 5000 CZK

calculation: 5000*1.20 = 6000 CZK, VAT = 1000 CZK

• procedure of price calculation for cena_dph_typ = 1, VAT rate = 20%

service has set price with VAT = 6000 CZK ( most common )

6000 * 0.1667 = 4999.80, VAT = 1000.20

• coefficient is calculated: 1- ( 1/ 1,20 ) = -0,1666666666666667

Czech accounting system use 4 decimal places (e.g. 0,1667)

price is calculated according to actual VAT what is set in the Tab "Billing / Settings", the item "VAT"

• Because of this modification it is neccessary to check created invoices !!!

Invoicing of reminders

• To generate collective reminders ( Billing / Reminders) there is possibility to do it by the SMS. The Icon for it is next to the icon for sending reminders by email. All sent reminders are saved in the client's card.

• Standalone reminder can be send in the client's card. This option is located in detail of an invoice which isn't paid and after due date. Email contains text and the invoice as attachment. All non-paid invoices could be attached to the reminder and set up a fee for it before sending.

• Additional email address for copies of sent reminders can be set in the Tab "Billing / Settings / Universal". All reminders sent to clients are in the same time sent to this address as a copy.

SCHEDULING

• In the Scheduling Tab (Daily, Weekly) there is new item "Total number of undischarged tasks till this day". By clicking on the displayed number system show summary of undischarged tasks.

CATV

• system automatically generates configuration files for DOCSIS 2.0 modems with all options what DOCSIS 2.0 has. In the past it was possible to set "use DOCSIS 2.0" only for headend ARRIS C3. Now the system check these possibilities and set configuration file automatically

• added 2 new items into DOCSIS 2.0 configuration files:

SnmpMibObject enterprises.1429.77.1.3.2.0 Integer 2 ;

SnmpMibObject enterprises.1429.77.1.4.2.0 Integer 0 ;

• system now supports headend ARRIS C4

MASS DOCUMENT GENERATION

• In the Tab "Settings / Contracts"
• Document generation has been repaired for opening documents in MS Word
• Added a new menu Tab "Others / Mass document / History". There it is possible to display history of document generation
• Each single generated documents are saved in client card in the Tab "Contracts"