I’m Shaun Rasmusen, summer 2016 intern at FlowJo, LLC, and I worked on developing the LIMS/Database Integrator Plugin. The purpose of this plugin is to provide an easy way to log information to a database about a workspace, its users, and the open/save times of the workspace. The design of the plugin makes it easy for a user to create databases and tables with a range of logging parameters for their specific needs or, if an existing database is already set up, they can integrate the plugin with that existing database directly. This plugin also provides an easy way to recover the information logged to the database through a download window that can pull information from varying distances back in time into either a CSV or log file.
The development process began with the requirements and functional specifications. While these documents had some minor changes throughout the process, the design mostly stayed true to the initial draft. Once actual code development began, I referred to the FlowJo Plugin Developer’s Guide for how to interface with FlowJo® for the data needed to log user activity in a workspace. There were a few pain points along the way, particularly with linking external JARs for the database driver, but in the end these were all resolved.