Category: export

MantisHubs Sweet Filter Updates!

FilterUpdate

I don’t know about you but, I spend a lot of my time in the MantisHub ‘View Issues’ page when I want to find the issue or issues I need. ‘My View’ dashboard is great for showing me what I need to prioritize and what’s going on at the moment. But when it comes to getting the whole picture, the background, requirements and other related information, I jump onto the View Issues page. I’ve added custom fields to my projects and set them to appear in my filter as a search field. I extensively used tags to help me find what I need. And my saved filters are invaluable. I have a very special relationship with my MantisHub filter so I was super excited to see the new improvements.

The latest MantisBT updates provide a more streamlined look, improved UI as well as providing some added functionality. I love that I can now collapse my filter and get a shortcut to my usual go-to’s, my free text search, filter reset or my saved filters. It gives a little more room for my list of issues and looks that little bit leaner.

FilterUpCollapse

Other handy recent additions include:

  • checking and unchecking multiple issues using my shift key so I can narrow down my filtered list even further for printing or exporting.
  • setting my temporary filters and permalinks as persistent. That means if I navigate away from that filter it doesn’t disappear on me. I can always bring it up again just by pressing the back button.

But my favourite new feature by far is that I can now run Summary reports and Issue trends on my filtered issues!! Yay!! (MantisBT nerd alert!).

If you head directly to the Summary tab you get a great range of data and statistics. You can also install the Graphs plugin to get graphic representations of your data. Graphs are presented by a variety of variables (developer, status, priority etc) and are great for pasting into your reports. However, the statistics in the Summary page are applied to all your issues within your MantisHub, filterable only by your project selector to limit results to a single project if needed.

With these new updates, you can now run these stats on your specific filter results! So, sort your issues down to a category, reporter, a sub-set of projects, date created or updated… version information, custom field values or any combination of these AND run reports and graphs on only that information!! Are you excited yet!!??

FilterSumm
filterGraph

Well, if that didn’t do it for you I don’t know what will. For me, this has made things that much more efficient when evaluating various aspects of my MantisHub issues. I can get answers to all sorts of questions like what is the average resolution time for a specific category? OR for tickets created in this week, who has worked on the most tickets? OR which of our non-resolved issues created last month has been open the longest? You can always export to Excel or CSV to play even more with your issue data or utilize our API to integrate with a dedicated reporting tool but this might save you a step or two.

If you aren’t as yet familiar with your Mantis filter you should absolutely become acquainted. Check out these video tutorials on using your MantisHub filter and on saving and sharing your filters. And you can always read up on the KB articles or search the support page and documentation for any other questions you have.

Enjoy your new, buff filter! Don’t forget to follow this blog and follow @mantishub on twitter for all the latest MantisHub updates. Til next time!

 

 

Exporting User Information and Access

blogexport

If you’re already a MantisHub customer you know that having Mantis hosted rather than running it all yourself is a huge plus. Instant setup, no upgrade, maintenance or backups overhead and access from anywhere! You also get access to their excellent support team who can help out and listen to all your feedback.

One more bonus is extra features, like the ability to import your users into your system via CSV. Currently exclusive to MantisHub, it’s a huge time saver when setting up your MantisHub if you have a large number of users to add at once. No longer do you need to perform the repetitive task of adding them one at a time. And bulk updates are easy too!

So for a while, you’ve been able to import, so, acting on your feedback, we figured it was time to give him a wife and you can now export users as well! The wedding was beautiful ;).

Our customers asked for this feature to help them track and audit user accounts. Making sure users that need to, have the right access AND those users that no longer need it, don’t. So it’s a plus for security too!

The feature is on by default so you’ll see 2 buttons at the bottom of your ‘Manage users’ page. One to export user information across all projects and one for the specific project set in your project selector. And this is the tricky part <insert sarcasm here> Just click it!

export_users

So easy and you have all the info you need including their name, email, global access, project access level and their last login. Check out the details in the support article.

Always exciting getting to deliver those features that make customers happy (and their lives a little easier). Make sure to follow this blog and follow @mantishub on twitter to keep across all the goodies that are rolling out to MantisHub.

Your MantisHub Data at your fingertips

exportdata

The beauty of hosting with MantisHub is that you will never need to worry about the retention, accessibility or integrity of the data stored in your MantisHub issue tracking system.

All the advantages of cloud hosting are at your fingertips. Like logging into your system from any place or any machine securely.  No need to worry about the security of your servers or disaster recovery. MantisHub hosting is robust, reliable, and secure, with daily backups of your data.

With all this convenience, you still have access to export and extract your data in several ways. Whether you need to integrate it into another system, play around with some numbers, produce reports or simply for peace of mind, you’re covered with these features.

Download all MantisHub data

Any administrators within the system can access the backup option from the Manage page. From here they can generate a full backup of your MantisHub to get a snapshot of the database at any point in time. When you generate a backup, two zip files will be available for download :

  1. database and configuration” file which contains a MySQL dump of your database and your configuration files.
  2. attachments” file containing all attachments uploaded to your system.

You can upload the db.sql file to a local MySQL service for verification and access it from your favorite database viewer and analytics tools.

With the attachments, extract the zip files to get access to the attachment files.  The attachment file names will be encoded and will have to be correlated with the database to get the file meta-data.

Here’s the KB article for more information on generating and downloading backups.

As MantisHub already create a full daily backup of your data you will probably never need to use it but it may be what you need to tick some boxes on your corporate policies checklist for security or data retention.

Printing Reports

The filters within the My View page can allow you to display a specific set or subset or your issues. If you’re not yet familiar with how to use filters, check out this article and get to it as it will save you a heap of time trying to find the information you need.

Once you have grabbed the issues you are interested in, you have the option to Print Reports.

print reports

To print it, just click the button. You can print all the listed issues or further cull the list and just display those selected. There are two options to print to; to a Microsoft Word document or HTML and it will include the Issues Details view of your issues.

Step by step instructions can be found in this KB article.

Exporting to CSV or Excel

There is also the option provided to export issue details to CSV or Microsoft Excel also from the View Issues page. This means you can do a whole lot more with your data because you can plug these into other systems to manipulate how you want. For example, MantisHub has some in-built reporting but if you’re looking for specific statistics on your issues this option can allow you to generate graphs and tables using Excel or some other application that allows CSV import.

It’s important to note that you have to define what issue fields and information you want to be included in the export. This needs to be configured in the Managing Columns section. This can be configured at a project level by the administrator [Manage – Manage Configuration – Manage Columns] but users can override this within their personal preferences [My Account – Manage Columns]. All fields that can be exported (including your custom created fields) are listed in the All Available section. Have a read about it in the Managing Columns KB article. And help with exporting can be found in this article :).

If you have Mantis Time Tracking feature turned on, you can also export this information to Excel or CSV to get some statistics on time your team spent working on issues. This is available through the Time Tracking page that is added to the menu when you enable Mantis time tracking.

API

For the technically savvy you can access information from your MantisHub through our API. This does require programming knowledge and can be a super powerful tool for pulling specific information from your system and manipulating it as needed. You can retrieve details of your projects, configuration, users, issues and filters. And the API is continually expanding so keep an eye out. To read more about MantisHub API options check out this KB article.

So if you’re looking for that flexibility while still getting the convenience of secure, reliable service, there’s your data on a silver platter :).