NEWS: OSTicket 1.7 RC1 released

Yesterday OSTicket 1.7 Release Candidate 1 (RC1) became available. OSTicket is a popular [free] open source trouble ticketing system built on MySQL/PHP.

Here is a list of new features and such since 1.6 ST:

  • Upgrade support for osTicket 1.6-rc1 and later
  • Multi-file upload support — more than one file (configurable) can be
    uploaded with new messages, replies, and internal notes via the web
    interface
  • Department/Group access feature allowing members of a group access to a
    department. Staff members are members of a (primary) group, and that
    group can be granted access to one or more departments, granting the
    associated staff access to departments other than their primary
    department.
  • Email filters can specify a canned auto-response
  • Support inline attachments for fetched email
  • Dashboard reports for ticket system activity and statistics
  • PDF print / export for tickets (staff pages only)
  • Advanced search on tickets page
  • Ticket thread — revised ticket message storage model for greater
    flexability
  • New database upgrade system allowing for continuous updates to the
    database model. This will greatly simplify the process of making
    modifications to the osTicket database.
  • Autocomplete for ticket search box (emails and ticket numbers typeahead)
  • Redesigned staff login page
  • Warning when leaving unsaved changes in admin and staff settings pages
  • Auto change admin settings pages when selecting a new page from the
    drop-down list
  • Create a ticket in one click from the staff panel
  • Preview ticket from the search results
  • Export tickets to CSV file
  • New Email Filters – allow for matching incoming email in the subject line and message body. For matching emails, the administrator has the ability to automatically route
    tickets a number of ways. (To a specific department, staff member, and/or team; Automatically assign ticket priority and/or service-level-agreement; Disable ticket auto-responses; Send automatic canned responses)
  • Canned Attachments – Attach files to your canned responses. These attachments are automatically attached to the ticket thread along with the canned response. The attachments are not duplicated in the database and therefore use virtually no space.
  • Service Level Agreements – Service level agreements allow for a configurable grace period based on the department or help topic associated with the ticket. A default SLA is
    provided, and a due date can be set to override the grace period of the SLA for a ticket.
  • Client-side Knowledgebase – Manage a searchable help document portal for your users
  • Dashboard Reports – Flashy reports of ticket system activiy as well as exportable ticket system statistics, allowing for easy report generation from office spreadsheet applications.
  • Ticket Export – Convert the ticket thread to a printed format for long term storage.
  • New API – Interface with osTicket via HTTP requests. Starting with version 1.7,
    tickets are createable by submitting an HTTP POST request to either /api/tickets.xml or /api/tickets.json

You can get the latest RC version over at Github. As a reminder this version is for developers and enthusiasts only and should never be used for a production environment.

source: OSTicket.com Forums

One month of MyFitnessPal a review

I do not usually post about things that I consider too personal, but I’ve achieved something personal that I found I just had to share. I’m not the healthiest person in the world, and I know I eat too much because at heart I’m a “fat kid” and love food. My daughter came to visit this summer and we started hitting the gym together almost every day. After about three weeks of doing this I noticed that my belt that fit perfectly before was now too loose. It still worked as a belt but barely.

On June 23rd I broke down and decided to try an app that my wife had been using for a while and started getting other people to use it also called My Fitness Pal. You can download it for Android, iPhone, iPad, Blackberry, or Windows Phone 7. You can also access the site online in any web browser at www.myfitnesspal.com. Since that day I have nearly religiously [My wife says I obsess about it.] entered everything that I have eaten. I do some “guesstimation”, but generally try to err on the higher side. I also enter most of my actual exercise and try to err on the lower side.

I‘m quite happy to say that since that day just over a month ago, I have lost 20 pounds! Just writing that sounds incredible to me. I try my best to get to the gym twice a week, and if I do not I make sure that I do activity things [such as making large props for the LARP I play in (carpentry), practice combat (like fencing), and/or go for a walk]. My roommates got a huge kick out of watching me walk in circles around my parking lot at home for 15 minutes one night.

But losing that much by dieting can’t be healthy can it? Well I’m not a nutritionist, or particularly well versed in this sort of thing… but I feel better then I have in a while. I’ve started taking multivitamins. The app lets you see what your getting for a number of different categories [Fat, Cholesterol, Sodium, Potassium, Carbs, Protein, Vitamin A and C, Calcium and Iron]. I also track my water intake. It also has a great little scan bar code feature that lets you quickly and easily add items to your “food diary”.

If you concerned with your weight, or convinced your metabolism has betrayed you, by all means check this great (and FREE as in beer) app [or site] out. I’ve been amazed at how well it’s worked for me.

As a closing thought, some good friends of mine that I turned on this free product also picked up a great little pedometer device called a “Fitbit Ultra Tracker” that tells them how far they have walked, how many flights of stairs they have gone up, etc. The reason that I mention this is because you can add your FitBit to your MyFitnessPal account and it will automatically import the data measured by your tracker. While I have yet to pick one up myself, they think its “great” and they have almost swayed my opinion on spending $100 on the device.

OST: MOD: Reports Module 5.0 — custom From address

How To Edit Scottro’s Reports Mod v5.0 to add custom
From address when emailing a report in 3 easy steps

So you’ve installed scottro’s Reports Mod 5.0 in your OSTicket implementation and noticed that when you email a report to someone the From: tag is populated with his email address. This is of course not the behavior you want from the mod so you want to change it. Then this is the mod to the mod for you!

There are two ways to change this behavior, you can go into the /scp/report_includes/emailReport.php and change the address manually in the source, or you can follow these simple instructions to implement the changes and have it be stored in the database.

Note: for the faint of heart, these and several other small changes that I have emailed scottro should be implemented in the next release [probably 5.1] shortly.

STEP 1

Update your ost_reports table to add the custom email FROM for emailing reports.

ALTER TABLE ost_reports ADD email VARCHAR(255) NOT NULL DEFAULT 'scottro@netins.com';

STEP 2

edit /scp/reports_admin.php

at line 27 add the following:

$email = $_POST['email'];

at line 29 replace

$update="UPDATE ".REPORTS_TABLE." SET 3d=$threeD,graphWidth=$graphWidth,graphHeight=
$graphHeight,resolution='$resolution',viewable='$viewable' WHERE 1";

with

$update="UPDATE ".REPORTS_TABLE." SET 3d=$threeD,graphWidth=$graphWidth,graphHeight=
$graphHeight,resolution='$resolution',viewable='$viewable',email='$email' WHERE 1";

at line 35 replace

$query = "SELECT 3d,graphWidth,graphHeight,resolution,viewable from ".REPORTS_TABLE." LIMIT 1";

with

$query = "SELECT 3d,graphWidth,graphHeight,resolution,viewable,email from ".REPORTS_TABLE." LIMIT 1";

at line 64 add the following:

<tr>
	 <th>Email From:</th><td><input type="text" name="email" value="<?=$row['email']?>"/></td>
	</tr>

STEP 3

edit /scp/reports_includes/emailReport.php

replace

$headers = "MIME-Version: 1.0\r\n";
 $headers .= "Content-Type: multipart/alternative;boundary=" . $boundary . "\r\n";
 $headers .= 'From: osTicket Reports <scottro@netins.com>';

with

// query ost_reports for email From address
 $query = "SELECT email FROM ".REPORTS_TABLE." LIMIT 1";
 $result = mysql_query($query) or die(mysql_error());
 $row = mysql_fetch_array($result);
 $email = $row['email'];
 
 $headers = "MIME-Version: 1.0\r\n";
 $headers .= "Content-Type: multipart/alternative;boundary=" . $boundary . "\r\n";
 $headers .= 'From: osTicket Reports <'.$email.'>';