Freeside:1.7.3:Changelog

Note

This is the changelog for the 1.7.3 point release.

For additional changes since 1.5.x, see Freeside:1.7:Changelog

License

The licence has changed to the GNU Affero General Public License (AGPL). This is a free software license for web and network applications.

If you use Freeside internally for your own company, your obligations under the license remain basically unchanged.

If you sell or provide access to the Freeside back-office interface to parties outside your organization or company, please note your new obligations under the AGPL. Specifically, if you provide hosted access to modified Freeside versions, you are required to provide the corresponding source code. See the AGPL for details.

Backend database support

• MySQL (v4.1 or later, v5 recommended) is now supported as a backend database in addition to PostgreSQL. DBIx::DBSchema 0.35 or later is required for MySQL support.

Trouble ticketing

• Several RT addons have been incorporated: Statistics, ActivityReports, WebCronTool
• Added a link to a customer's resolved tickets to the ticket section of the customer view page
• Fixed custom priority field options
• Don't display ticket search box for installs without trouble ticketing.
• Prevent Text::Quoted from being used to format ticket display even if it is installed; it is slow, unreliable and can segfault.
• Fix CSS visual glitch on "Ticketing main"

Signup and customer self-service

• XML-RPC API for all signup and self-service functionality allows access to signup functions from PHP and other languages. A PHP class and examples are available in fs_selfservice/php/
• Huge speedup on signup page (cache signup data).
• Customers can now view their own data transferred in addition to time online.
• Restored "(none)" choice to first package select.
• Pass along the remote IP address from selfservice to the backend processing against the payment gateway
• Added "process_payment_order_pkg" method for one-step payment and package ordering, facilitating use of self-service API in a shopping cart environment.
• Fixed signup bug causing all advertising sources to show up when promotional codes are used in conjunction with a multiple-reseller install with reseller-specific advertising sources.
• In example HTML templates, fixed visual glitch in menu-bar border.
• Added a configuration option to change self-service session timeout; useful for self-service API usage.
• prevent BILL, DCRD, and DCHK customers from ordering new packages via selfservice while suspended

Reports

New reports

• New advanced customer report
• New package churn report and graph showing orders, suspensions and cancellations over time.

Updated reports

• Added Net vs Gross amount to all invoice reports; made the "Net sales" totals on Sales/Credit/Receipts graph/report clickable.
• Added options for listing customers without an outstanding balance on receivables report, and corrected the totals when pulling up an A/R report for a single agent.
• Added suspension and cancellation reasons to package report.

New features for all reports

• Add Excel and CSV download options for all graph reports.
• Add "printable copy" link on all reports for full results as printable HTML.
• Added command-line tool to automatically email any reports.

Bug fixes

• Fix remaining problems folks are having with IE downloading Excel files over HTTPS.
• Fixed status colors on customer reports / lists / edit.
• Fixed some problems with reports when selecting all agents on a multiple-agent install.
• Fixed 'column reference "fieldname"' is ambiguous error on advanced package reports.
• Fixed tax reports for some odd upgrade edge cases: when you have both taxclass and non-taxclass entries in cust_main_county for a single region (not correct setup in the first place), and non-null but empty values in taxname
• Fixed bulk invoice re-email/fax/print links to honor "most recent invoice for customer" and min/max options from invoice report.
• Fixed the date popups on advanced invoice report.

Billing

Price plans

• New "bulk" price plan for bulk charging per-service prorated over the billed period.

ACH processing

• Electronic check (ACH) processing: Added fields require by some gateways for driver's license, checking/savings account type and bank state.
• Added ability to trigger ACH batching from the customer view page, in addition to real-time processing.

Invoices

• Added customer number to default typeset and HTML invoices.
• Added options for postscript prefix and suffix for extra printer commands.
• Added option to remove service dates from invoices.

Credits

• Credit reasons changed from freetext to the new reason/reason type system like suspensions and cancellations.

Refunds

• Added refund deletion (with access control)
• Fixed refunds with eProcessingNetwork
• Pass CC expiration with real-time refunds for gateways which require it. Also allow manual entry for existing transactions being refunded.

Pre-printing

• Added "-n" option to freeside-daily, allowing pre-printing of invoices for future service periods, but now with the current date.
• Added quick "bill-for-nextmonth" and "bill-for-nextyear" scripts which use the new "-n" option.

Misc.

• Added "suspend later" for scheduling future cancellations.
• Added "disable_setup_suspended_pkgs" config option to disable the charging of the setup fee while a package is suspended.
• Added verbose error reporting for transactions which fail without an error message (useful when tracking down payment gateway problems).
• Even more reliable multiple-payment/double-click/concurrent-payment-form-different-employees/back button protection.
• Add a configuraiton option to control B:OP's new "email_customer" flag.

Usage tracking

• Added a separate "overlimit" status distinct from normal suspensions.
• Added the ability to change RADIUS groups upon reaching usage limits.
• All data usage fields can be specified with suffixes such as "kb", "mb, "gb", "G", etc.
• All data usage fields can be displayed with a desired number of significant digits and auto-prefix, or forced to megabytes.
• Trigger usage recharge from the backend as well as self-service
• Usage threshold warning emails now sent to invoice email address on file.
• Fixed bug manually editing usage data.
• Fixed bug where user could log in to RADIUS with an uppercase username and avoid bandwidth accounting (MySQL only)
• Data usage fields also now allow commas and validate input - they no longer fallback to putting literals in the database.
• Display negative time correctly.

Exports

• Added a section for additional config data to virtual hosting services, and export the entered config snippets to Apache.
• Made RADIUS groups available to shellcommands delete hook
• Fixed spurious user modification and export triggering.
• Added new exports: nas_wrapper, snmp and trango
• Some improvements to router export.
• Prizm export: queue most operations, better documentation, configurable siteName, attach SM's to default network, improved unsuspend & delete, option for BAM only or EMS.
• Fixed Communigate pro export to prevent harmless (but annoying) "failed: Can't logout of CGPro: No error" messages.
• Pretiffy export browse
• Added -n option to freeside-sqlradius-reset to supress deleting data

Misc

• Package changes after 1.7.3 upgrade now show change date, old package
• Added printed welcome letters, from a template.
• Per-user Vonage "click2call" integration
• Web tool added to import customer comments from CSV file
• Customer CSV import extended to include company name.
• Configuration option causing auto-generated passwords to be all capitals.
• Home directory field is now editable with appropriate ACL
• svc_www services now use common footer/header
• Added 3 day, 4 month and 4.5 month (137 day) frequencies
• Added a default cancellation subject so cancellation emails will work even if you didn't set a subject in the configuration.
• Added options to require phone and email address for new customers.
• Added better inline documentation explaining fields for customer CSV import.
• Display a list of any virtual hosts an account controls on that account's view page.
• Remove remaining "all white" error pages.
• Agent selection on package add/edit.
• Added a "payment receipts" feature to the web interface, to help folks who were relying upon emails from their gateway for payment confirmation.

Dialup POPs (Points of Presence)

• Added a quick command-line import tool
• Moved POP searching / listing to new common template.

Bug fixes

• Restored "(none)" choice to first package select.
• Made sure "emailinvoiceonly" option completely hides postal and fax options alltogether.
• Fixed bug re-emailing failed invoice email events.
• Removed deprecated "session" table causing problems on upgrade.
• Fixed slowness errors on change package and made it into a popup.
• Fixed package date editing strangeness if you get an error or are asked to confirm a date move into the past.
• Fixed "Error: Error inserting cust_pkg_reason: ERROR: value to long for type character varying(32)" errors when inserting reasons with a very long real name.
• Fixed unlikely edge case with new line-item application stuff which could cause 'Can't call method "part_pkg" on an undefined value at .../cust_bill.pm line 434' errors in some tax cases.
• Pruned any "dangling" cust_credit_refund records which may have been inserted by previous development code.
• Fixed the javascript warning for DNS entries with quotes (") in them, allowing them to be deleted.
• Fixed search by check#
• Fixed status color in small_custview
• When changing packages, don't set setup date unless old package has one.
• Fixed links to svc_broadband services from service definition browse.
• Fixed package date editing to prevent resetting fields on errors.
• Fixes to work with current DBIx::DBSchema