ADD INTERNET SERVICE

• The page "Active services" has been rewritten to new framework interface.
• Billing information now also includes field "Invoicing day" where it is possible to fill in the date for invoicing of client service. This information will be used (when Invoicing part is rewritten to framework) to invoice client for whatever time period needed (e.g. from 15th of November to 14th of December). It is not applied yet.
• Individual fields are now organized in a logical order for adding new internet service.
• Fields "Access point" and "Switch" now provides also search option to fill in the name and find out search results faster.
• Displaying of client IP address and IP of client's end device is now switched.
• While filling in IP address it is now possible to define which will be used for NAT (mentioned above in article IP NAT POOLS) by clicking on a checkbox "Client NAT".

RADIUS POZASTAVENÍ KLIENTŮ

• Suspension of clients which are authenticated via RADIUS has been customized. In the past when a client was suspended (e.g. because unpaid invoice) system refused authentication via RADIUS but there was a problem that client did not know if their service was suspended or disconnected due to some technical problems on provider's site.
• Now it is customized and every suspended client persist authenticated via RADIUS but system forward them to a special info page where they can find information why their service is not available. So it means the same process as it is at standard Internet service without authentication via RADIUS.

ROUTERS - NEW SUPPORT

• Added support of UBNT Edge Router.
• Added support of Cambium ePMP 1000.
• Content filtering option has been also customized, so it is now possible to select "Router type" from pop-up menu and choose type "Ubiquiti Edge Router" or "Cambium".
• When access details are filled in the system will start to retrieve interface list from routers (approx. in 5 minutes) and also will start to draw transfer graphs, signal graphs of connected clients (if available) and CPU graph.

IP NAT POOLS

• In the tab "Settings / IP Pools" there is a new tab "NAT Pools".
• There is possible to define public IP addresses used for NAT of clients.
• While adding NAT pool there it is possible to define range of IP addresses (network number / mask) and also router which is that range defined on.
• While adding Internet service in a client card there is now possible to defined IP address (on which NAT is provided) from pre-defined range. System provides NAT on particular router automatically (if enabled) for private IP address of the client.
• To enable applying of NAT address on router, it is necessary to set up key "mikrotik_nat_for_end_user" to value "1" in the tab "Settings / Syst. settings / Mikrotik". In other case (value "0") NAT will not be applied to Mikrotik.
• If enabled, every client will have applied another rules "dstnat" and "srcnat".
  • /ip firewall nat add action=netmap chain=ispadmin_first_dstnat comment=ispadmin_NAT_1.2.3.4_10.10.0.100 dst-address=1.2.3.4 to-addresses=10.10.0.100
  • /ip firewall nat add action=netmap chain=ispadmin_last_srcnat comment=ispadmin_NAT_10.10.0.100_1.2.3.4 to-addresses=1.2.3.4 src-address=10.10.0.100

MIKROTIK

• While adding DHCP lease for particular MAC address the system checks if the MAC address has assigned any IP address dynamically. If yes, dynamic record is removed at first. In the past dynamic record was not removed but it caused (in the case of assigned IP address from dynamic pool) that IP address was assigned after timeout of previous assigned IP address.

RADIUS

• Customized RADIUS to better identify disconnected clients. In some previous cases (e.g. link failure) RADIUS was not able to detect these disconnected clients properly and after re-connection clients still looked like disconnected.

INVOICING

• Fixed bug in export of Direct debit file where was necessary to customize data structure for CZ post office.
• Slovakia ČSOB bank has changed payment notification format. The format has been customized to accept payment notifications for ČSOB.
• In a tab "Invoicing / Invoices" there were displayed icons with additional options at each row with generated invoices. Now there is a pop-up menu which includes all available option better organized behind one icon.

INVOICING - ACCOUNTING CODES

• Completely rewritten setting of accounting codes for invoicing.
• In the tab "Invocing / Settings / Accounting / Accounting" there it is possible to set up own accounting codes. Ïn the case system will offer from a table only those pre-defined accounting codes.
• In the tab "Invocing / Settings / Accounting / Services" there it is possible to set up accounting codes for services Internet, VoIP, General etc.
• In the tab "Invocing / Settings / Accounting / System" there it is possible to set up accounting codes for system items used for invoices generating like fee for sending invoices by post.
• In the tab "Settings / Tariff" there it is possible to define accounting codes for services INTERNET, CATV, DVBC, VOIP, IPTV. Now it is possible to set up acconting code for whole service but also for individual tariffs. If any accounting code for tariff is defined here, system will use it as default before application of accounting code for whole service. If there is no specific accounting code for particular tariff system will use accounting code for whole service as default.
• In the tab "Invoicing / Overviews / Invoicing" there it is possible to display statistics by accounting codes and also export accounting codes to accounting system.

INVOICING

• In the tab "Invoicing / Cash box" there is a new dividing of invoicing groups and years. While exporting payments in the tab "Cash box - Sent payments" there it is now possible to export CSV or different format from a context menu.
• New rewritten pages also now displays line numbering.
• In the tab "Invoicing / Overviews / Payments" there is now also total overview at bottom of the list.
• Now it is also possible to create "Credit note" even for item with Reverse charge (CZ only - as we know).

INVOICING - TIME PERIODS

• In the tab "Invoicing / Invoices / Time period" there is now possible to export statement for defined time period to PDF (by clicking on a particular icon).
• The statement includes information about invoices which belongs to a particular month.
• Detail of particular month includes detailed preview of invoices for time period (by clicling on a PDF icon at each line).

INVOICING

• In the client card (the tab "Invoicing" there are now displayed all client's payments (at bottom of the page) which has been accepted in particular year. By clicking on the loupe icon it is possible to display detail of payment.
• The tab "Invoicing / Overviews / Payments" there is a new button "Excluded payments". By clicking on this button the list of unmatched payments. Next to that button it is possible to display list of the same in PDF format.

SCHEDULING

• Fixed some reported bugs.
• In a task calendar it is possible to display list of unspecified tasks. Sorted by long-term tasks at first and below them are displayed other unspecified tasks for particular day sorted by insert day.
• Now it is possible to re-open even already closed task if there is correct authorization for scheduling part assigned to a particular administrator / technician. Editing task is saved to a history log.

CLIENT PORTAL

• In client portal it is now possible to display also a contract in PDF format. To display contract in PDF format it is necessary to mark contract in the client card for displaying in the client portal by clicking on the particular icon.

GOOGLE MAPS - COORDINATES

• If in the client card are incorrect coordinates for displaying location on Google maps, the system runs internal script (once per day) which will set up correct coordinates at those clients. Google API has limited number of attempts for location corrections (one-hundred times per day), so when the daily limit is exceeded script will be ran next day to continue.

PHOTOGALLERY - EXIF INFORMATION

• Adding of photos to client card now also includes EXIF information which are displayed below photo preview. Currently system save information about taken date, device model and GPS coordinates of photo taken location (if available). If coordinates are retrieved system will display also "Earth" icon below the photo preview to display location on Google maps by clicking on the icon.
• By clicking on the photo to display it in larger window there are also displayed EXIF information, if available.
• Retrieving of EXIF information is available for new uploaded photos only.

AUTHORIZATION SETTINGS

• The tab Settings / Administrators / Administrators) has been completely rewritten to the new interface with customized authorization settings for Scheduling module. Newly there are no assigned in global authorization rules for "Masteradmin" and "Main Admin" administrators but it is necessary to apply individual rules for all administrators for scheduling. Scheduling module can be visible for all administrators which have marked checkbox "Use scheduling". If the checkbox is not marked administrator has no option to see, add or customize tasks to scheduling.
• There are new 3 basic types of authorization rules for administrators for scheduling:
• 1) Administrator - Full rights. It means Administrator can see all tasks with full option to customize them, make a new scheduling plans, etc.
• 2) Leader - Full rights but only for particular group of technicians. In this case Leader is able to see all tasks with full option to customize them, make a new scheduling plans, etc. but only for particular group, so they are not able to see tasks of another leaders or their groups.
• 3) Technician - Can see only those tasks which has been assigned to them but cannot see tasks of another technician in the same or different group. In the case of enabled authorization Technician it is possible to individually customize additional authorization like add, change or delete tasks.
• Authorization for sending of e-mails with assigned in tasks or requests from Client portal can be enabled individually.
• By this update all authorization rules has been replaced from older version to the new one but it is recommended to check validity of this authorization rules because not all authorization rules can be replaced automatically.
• Authorization "Allowed Invoicing groups" - If a new invoicig group is added to the system, it will not be visible for all administrators automatically (except "Master Admin" authorization level) but it is necessary to allow visibility of the new group for particular administrator of the system.

VOIP SERVICE - BULK IMPORT OF PHONE NUMBERS

• In the case of active VOIP service for client, there is an button "Another IP phones" to assign anothe phone numbers for this service. To assign new phone numbers as bulk there is now also possible to "Add range of IP phone numbers" by clicking on particular button.

NAT ADDRESSES

• New tab added "Settings / IP Pools / IP Pools NAT". There it is possible to define ranges of IP addresses which are used to NAT private IP addresses of clients. Each NAT pool has option to assign in a router which is provided NAT on and also to define used IP addresses which will not be offered to clients in the system.

NEW SYSTEM VARIABLES

• $DVBC_PACKAGES$
• $DVBC_PACKAGES_PRICE_WITH_VAT$
• $DVBC_PACKAGES_PRICE_WITHOUT_VAT$

• $IPTV_DISCOUNT$
• $IPTV_FLAT_RATE$
• $IPTV_FLAT_RATE_NOTE$
• $IPTV_DEPOSIT$
• $IPTV_CONTRACT_RENEWAL$

• Further details about system variables are available under the tab "Settings / Contracts / Own templates".

FIXES

• Fixed some minor bugs reported by providers
• Fixed some bugs while adding the Internet service.
• When adding a new contact the system no longer shows from pop-up menu those invoicing groups which are marked as inactive in a tab "Invoicing / Settings / Inv. groups"

REWRITTEN PAGES

• Invoicing / Settings / Payment types
• Invoicing / Settings / Settlements

FIXES

• Fixed some minor bugs reported by providers
• Fixed some bugs while adding the Internet service.
• When adding a new contact the system no longer shows from pop-up menu those invoicing groups which are marked as inactive in a tab "Invoicing / Settings / Inv. groups"

REWRITTEN PAGES

• Invoicing / Settings / Payment types
• Invoicing / Settings / Settlements

FIXES

• Fixed some minor bugs reported by providers.

REWRITTEN PAGES

• Invoicing / Cancel / Invoices
• Invoicing / Cancel / Cash

INVOICING

• Fixed bug in export of Direct debit file where was necessary to customize data structure for CZ post office.
• Slovakia ČSOB bank has changed payment notification format. The format has been customized to accept payment notifications for ČSOB.
• In a tab "Invoicing / Invoices" there were displayed icons with additional options at each row with generated invoices. Now there is a pop-up menu which includes all available option better organized behind one icon.

INVOICING - ACCOUNTING CODES

• Completely rewritten setting of accounting codes for invoicing.
• In the tab "Invocing / Settings / Accounting / Accounting" there it is possible to set up own accounting codes. Ïn the case system will offer from a table only those pre-defined accounting codes.
• In the tab "Invocing / Settings / Accounting / Services" there it is possible to set up accounting codes for services Internet, VoIP, General etc.
• In the tab "Invocing / Settings / Accounting / System" there it is possible to set up accounting codes for system items used for invoices generating like fee for sending invoices by post.
• In the tab "Settings / Tariff" there it is possible to define accounting codes for services INTERNET, CATV, DVBC, VOIP, IPTV. Now it is possible to set up acconting code for whole service but also for individual tariffs. If any accounting code for tariff is defined here, system will use it as default before application of accounting code for whole service. If there is no specific accounting code for particular tariff system will use accounting code for whole service as default.
• In the tab "Invoicing / Overviews / Invoicing" there it is possible to display statistics by accounting codes and also export accounting codes to accounting system.

GOOGLE MAPS - COORDINATES

• If in the client card are incorrect coordinates for displaying location on Google maps, the system runs internal script (once per day) which will set up correct coordinates at those clients. Google API has limited number of attempts for location corrections (one-hundred times per day), so when the daily limit is exceeded script will be ran next day to continue.

PHOTOGALLERY - EXIF INFORMATION

• Adding of photos to client card now also includes EXIF information which are displayed below photo preview. Currently system save information about taken date, device model and GPS coordinates of photo taken location (if available). If coordinates are retrieved system will display also "Earth" icon below the photo preview to display location on Google maps by clicking on the icon.
• By clicking on the photo to display it in larger window there are also displayed EXIF information, if available.
• Retrieving of EXIF information is available for new uploaded photos only.

FIXES

• Fixed some minor bugs reported by providers.

REWRITTEN PAGES

• Invoicing / Cancel / Invoices
• Invoicing / Cancel / Cash

FIXES

• Fixed some minor bugs reported by providers.

NEWS

• New router types supported Cambium, Radwin a Edge. (Available in the tab "Nagios").
• Fulltext searching now includes also notes for search results in the tab "Clients / Contacts".

REWRITTEN PAGES

• Scheduling / Overview
• Invoicing / Settlements / History
• Invoicing / Cancel / E-Payments

SCHEDULING

• Fixed some reported bugs.
• In a task calendar it is possible to display list of unspecified tasks. Sorted by long-term tasks at first and below them are displayed other unspecified tasks for particular day sorted by insert day.
• Now it is possible to re-open even already closed task if there is correct authorization for scheduling part assigned to a particular administrator / technician. Editing task is saved to a history log.

INVOICING

• In the tab "Invoicing / Cash box" there is a new dividing of invoicing groups and years. While exporting payments in the tab "Cash box - Sent payments" there it is now possible to export CSV or different format from a context menu.
• New rewritten pages also now displays line numbering.
• In the tab "Invoicing / Overviews / Payments" there is now also total overview at bottom of the list.
• Now it is also possible to create "Credit note" even for item with Reverse charge (CZ only - as we know).

INVOICING - TIME PERIODS

• In the tab "Invoicing / Invoices / Time period" there is now possible to export statement for defined time period to PDF (by clicking on a particular icon).
• The statement includes information about invoices which belongs to a particular month.
• Detail of particular month includes detailed preview of invoices for time period (by clicling on a PDF icon at each line).

ROUTERS - NEW SUPPORT

• Added support of UBNT Edge Router.
• Added support of Cambium ePMP 1000.
• Content filtering option has been also customized, so it is now possible to select "Router type" from pop-up menu and choose type "Ubiquiti Edge Router" or "Cambium".
• When access details are filled in the system will start to retrieve interface list from routers (approx. in 5 minutes) and also will start to draw transfer graphs, signal graphs of connected clients (if available) and CPU graph.

IP NAT POOLS

• In the tab "Settings / IP Pools" there is a new tab "NAT Pools".
• There is possible to define public IP addresses used for NAT of clients.
• While adding NAT pool there it is possible to define range of IP addresses (network number / mask) and also router which is that range defined on.
• While adding Internet service in a client card there is now possible to defined IP address (on which NAT is provided) from pre-defined range. System provides NAT on particular router automatically (if enabled) for private IP address of the client.
• To enable applying of NAT address on router, it is necessary to set up key "mikrotik_nat_for_end_user" to value "1" in the tab "Settings / Syst. settings / Mikrotik". In other case (value "0") NAT will not be applied to Mikrotik.
• If enabled, every client will have applied another rules "dstnat" and "srcnat".
  • /ip firewall nat add action=netmap chain=ispadmin_first_dstnat comment=ispadmin_NAT_1.2.3.4_10.10.0.100 dst-address=1.2.3.4 to-addresses=10.10.0.100
  • /ip firewall nat add action=netmap chain=ispadmin_last_srcnat comment=ispadmin_NAT_10.10.0.100_1.2.3.4 to-addresses=1.2.3.4 src-address=10.10.0.100

ADD INTERNET SERVICE

• The page "Active services" has been rewritten to new framework interface.
• Billing information now also includes field "Invoicing day" where it is possible to fill in the date for invoicing of client service. This information will be used (when Invoicing part is rewritten to framework) to invoice client for whatever time period needed (e.g. from 15th of November to 14th of December). It is not applied yet.
• Individual fields are now organized in a logical order for adding new internet service.
• Fields "Access point" and "Switch" now provides also search option to fill in the name and find out search results faster.
• Displaying of client IP address and IP of client's end device is now switched.
• While filling in IP address it is now possible to define which will be used for NAT (mentioned above in article IP NAT POOLS) by clicking on a checkbox "Client NAT".

RADIUS POZASTAVENÍ KLIENTŮ

• Suspension of clients which are authenticated via RADIUS has been customized. In the past when a client was suspended (e.g. because unpaid invoice) system refused authentication via RADIUS but there was a problem that client did not know if their service was suspended or disconnected due to some technical problems on provider's site.
• Now it is customized and every suspended client persist authenticated via RADIUS but system forward them to a special info page where they can find information why their service is not available. So it means the same process as it is at standard Internet service without authentication via RADIUS.

FIXES

• Fixed some minor bugs reported by providers.

NEWS

• New router types supported Cambium, Radwin a Edge. (Available in the tab "Nagios").
• Fulltext searching now includes also notes for search results in the tab "Clients / Contacts".

REWRITTEN PAGES

• Scheduling / Overview
• Invoicing / Settlements / History
• Invoicing / Cancel / E-Payments

FIXES

• Router graphs are now displayed properly even if the traffic is larger than Gbit/s on interface. In the past graphs were cut off on max. value of traffic 2.1 Gbit/s.
• Mikrotik in version 6.18 and higher now returns API value about voltage on router (if supported) in new format to display this information correctly.
• Fixed bug in invoicing of VOIP service where in the case of credit used and generating invoice for more than one month, the system counted with credit for one month only and not for whole pre-defined period.

NEWS

• The tab Clients / Contacts now display row numbering for records in a table.
• The tab Clients / Contacts now includes also filter (pop-up menu) to display clients by location.
• In the client card (the tab Contracts) there is now possible to defined output format of sent contract from client card (PDF, RTF or DOCx). Default setting is PDF format.

REWRITTEN PAGES

• Invocing / Overpayments / Returned
• Invocing / Overpayments / Included - Export to XML
• Invocing / Overpayments / Overpayments - Export to PDF
• Invocing / Overpayments / Arrears - Export to PDF
• Invocing / Overviews / Platby - Excluded payments
• Client card / Statistics / Data transfer
• Client card / Scheduling
• Settings / Administrators / Administrators

INVOICING

• In the client card (the tab "Invoicing" there are now displayed all client's payments (at bottom of the page) which has been accepted in particular year. By clicking on the loupe icon it is possible to display detail of payment.
• The tab "Invoicing / Overviews / Payments" there is a new button "Excluded payments". By clicking on this button the list of unmatched payments. Next to that button it is possible to display list of the same in PDF format.

CLIENT PORTAL

• In client portal it is now possible to display also a contract in PDF format. To display contract in PDF format it is necessary to mark contract in the client card for displaying in the client portal by clicking on the particular icon.

AUTHORIZATION SETTINGS

• The tab Settings / Administrators / Administrators) has been completely rewritten to the new interface with customized authorization settings for Scheduling module. Newly there are no assigned in global authorization rules for "Masteradmin" and "Main Admin" administrators but it is necessary to apply individual rules for all administrators for scheduling. Scheduling module can be visible for all administrators which have marked checkbox "Use scheduling". If the checkbox is not marked administrator has no option to see, add or customize tasks to scheduling.
• There are new 3 basic types of authorization rules for administrators for scheduling:
• 1) Administrator - Full rights. It means Administrator can see all tasks with full option to customize them, make a new scheduling plans, etc.
• 2) Leader - Full rights but only for particular group of technicians. In this case Leader is able to see all tasks with full option to customize them, make a new scheduling plans, etc. but only for particular group, so they are not able to see tasks of another leaders or their groups.
• 3) Technician - Can see only those tasks which has been assigned to them but cannot see tasks of another technician in the same or different group. In the case of enabled authorization Technician it is possible to individually customize additional authorization like add, change or delete tasks.
• Authorization for sending of e-mails with assigned in tasks or requests from Client portal can be enabled individually.
• By this update all authorization rules has been replaced from older version to the new one but it is recommended to check validity of this authorization rules because not all authorization rules can be replaced automatically.
• Authorization "Allowed Invoicing groups" - If a new invoicig group is added to the system, it will not be visible for all administrators automatically (except "Master Admin" authorization level) but it is necessary to allow visibility of the new group for particular administrator of the system.

VOIP SERVICE - BULK IMPORT OF PHONE NUMBERS

• In the case of active VOIP service for client, there is an button "Another IP phones" to assign anothe phone numbers for this service. To assign new phone numbers as bulk there is now also possible to "Add range of IP phone numbers" by clicking on particular button.

NAT ADDRESSES

• New tab added "Settings / IP Pools / IP Pools NAT". There it is possible to define ranges of IP addresses which are used to NAT private IP addresses of clients. Each NAT pool has option to assign in a router which is provided NAT on and also to define used IP addresses which will not be offered to clients in the system.

NEW SYSTEM VARIABLES

• $DVBC_PACKAGES$
• $DVBC_PACKAGES_PRICE_WITH_VAT$
• $DVBC_PACKAGES_PRICE_WITHOUT_VAT$

• $IPTV_DISCOUNT$
• $IPTV_FLAT_RATE$
• $IPTV_FLAT_RATE_NOTE$
• $IPTV_DEPOSIT$
• $IPTV_CONTRACT_RENEWAL$

• Further details about system variables are available under the tab "Settings / Contracts / Own templates".

MIKROTIK

• While adding DHCP lease for particular MAC address the system checks if the MAC address has assigned any IP address dynamically. If yes, dynamic record is removed at first. In the past dynamic record was not removed but it caused (in the case of assigned IP address from dynamic pool) that IP address was assigned after timeout of previous assigned IP address.

RADIUS

• Customized RADIUS to better identify disconnected clients. In some previous cases (e.g. link failure) RADIUS was not able to detect these disconnected clients properly and after re-connection clients still looked like disconnected.

FIXES

• Router graphs are now displayed properly even if the traffic is larger than Gbit/s on interface. In the past graphs were cut off on max. value of traffic 2.1 Gbit/s.
• Mikrotik in version 6.18 and higher now returns API value about voltage on router (if supported) in new format to display this information correctly.
• Fixed bug in invoicing of VOIP service where in the case of credit used and generating invoice for more than one month, the system counted with credit for one month only and not for whole pre-defined period.

NEWS

• The tab Clients / Contacts now display row numbering for records in a table.
• The tab Clients / Contacts now includes also filter (pop-up menu) to display clients by location.
• In the client card (the tab Contracts) there is now possible to defined output format of sent contract from client card (PDF, RTF or DOCx). Default setting is PDF format.

REWRITTEN PAGES

• Invocing / Overpayments / Returned
• Invocing / Overpayments / Included - Export to XML
• Invocing / Overpayments / Overpayments - Export to PDF
• Invocing / Overpayments / Arrears - Export to PDF
• Invocing / Overviews / Platby - Excluded payments
• Client card / Statistics / Data transfer
• Client card / Scheduling
• Settings / Administrators / Administrators