Just like in the past in providing best in the industry batch tracking, along with automated versions of the Colorado MMED reports, MJ Freeway remains committed to assisting you in any way we can meeting state compliance, so that you can focus on other aspects of your business. As such, MJ Freeway is committed to providing the greatest degree of integration with Colorado's MITS system that is possible, with the goal of streamlining your workflow and easing data entry burdens.
We have been working closely with Franwell, the company creating the MITS system, on integrating our software as best as possible.
Integration with Franwell will be allowed to happen happen in two phases:
Phase 1 of that integration will include an upload of daily sales data to the MITS system via a .csv file. We are expecting the specifications for that upload to be released any day and will begin work on them immediately.This will then allow you to export the .csv file from GramTracker, which can then be uploaded into MITS. This export is prepared and has been released!
This export, based on specifications we received will include package numbers, dates, and quantities, aggregated for the day.
This means that initially, you will need to convert or otherwise use your MITS package number for your packages in Grow and GramTracker.
As soon as we are able to do so, we will make this process easier.
We'll have more information on what additional information will be integrated in phase 2 after the first of the year. This should be, based on available resources, an API that allows systems such as ours to integrate with the system.
For further details beyond what is explored in this article, please check www.mymits.com, operated by Franwell to assist in the use of the MITS system.
MITS requires some setup, which is similar to some of the items you may have already configured in Gram or GrowTracker. As mentioned above, at the time of this writing, MITS does not allow imports from other software or spreadsheets. This guide is to help you find the data you need from MJ Freeways products to be easily able to enter your data into MITS.
Starting on page 6 of the MITS Quick Reference guide, you'll be asked to enter data about each of your facilities.
Facilities in MITS roughly equate to "Store Locations" in Gram and Growtracker, available from the dropdown at the top of the page, if your user has access.
Left: MJ Freeway Store Locations
Right: MITS Facilities
For item 4, you will need to add several different types of information:
These can be found under Admin > Manage Users. You can click on each user, then scroll down to the Employee Details section.
These can be found in GramTracker by navigating to Inventory > Batches > Strains or in GrowTracker by navigating to Grow > Setup > Strains. Depending on how your system is configured, you may instead be able to find your list of strains by navigating to Inventory > Bulk Inventory
For your list of products, you can navigate to Reports > Products > Product Listing in GramTracker
This can then be exported and sorted or checked off as you add items to MITS.
Rooms are analogous to Locations in Grow Tracker. These can be found in GrowTracker by navigating to Grow > Setup > Locations
Patients can be exported from GramTracker by any Administrator or Manager user.
Next, click the "Patients" button to return to the Patient Management page.
On the bottom right of the page, you will see a button titled "Export Patient Data". Clicking this will tell the system to retrieve your list of patients and prepare it for a .csv export. Depending on your number of patients, this may take a few seconds. When prompted, Save, do not Open your export.
Open the file, and sort by the active column, then delete all of the non-active patients.
Then, sort by the caregiver column, and delete all of the non- Denver Relief patients.
Then, sort by the Card expiration date, and delete anyone who’s expired or expiring before the first of the year.
Then delete all columns *except* for MMR, Card expiration date, and Caregiver designation date.
Next, insert a new column between MMR and Card expiration.
In that new field, give it a header (first row) of “card issue date”
In the next row down, use this formula to calculate a year before the expiration date (you’ll have to adjust your formula for your column designations) =Sum(whateverthecardexpirationcellis-365). Copy and paste that formula all the way down.
Now you’ll have an Excel spreadsheet so you can copy and paste your patient data over into MITS!
f. Order tags.
The MITS system will allow you to order RFID tags for your plants and packages.For more details please check the MITS site and documentation linked at the top of this article.
g. When tags arrive enter beginning plants and packages.
While Grow and GramTracker only print bar codes for plant and package IDs under 13 characters, it can accept a great deal more. In the future, as you add plants and packages to MITS, you should be able to add those plants and packages first to assign them their numbers per the RFID tags, then simply scan that tag number into Grow or GramTracker to use the same number. We will expand this section as the Industry's understanding of MITS develops.
h. Attachs tags to plants and batches within GramTracker and GrowTracker.
In an upcoming release, fields will be added to batches to allow tracking of multiple units of product from the same product (e.g. multiple types of edibles created from the same source batch of plant matter. This will assist in updating MITS without worrying about reconciling multiple package IDs to one tag number.
Likewise, users will be able to make use of an additional field within GrowTracker that will allow them to input a plant's MITS tag to ensure that all plants are associated correctly. These will be viewable in both View All Plants (and its export) and will be an optional, selectable column within GrowTracker's Plant Grid View.
The MITS Life Cycle Diagram translates into existing structures in the MED's rules and regulations, as such, you will notice similarities in Grow and GramTracker.
What may be confusing at first is that the MITS system simplifies the stages in the process for reporting to the State. Grow and GramTracker will allow you to meet these needs, while still tracking your vital Grow and store information.
The basic stages of the MITS system come "out of the box" in GrowTracker.
However during your use of the software, you may have added detailed life stages for your plants so that you can track individual details.
Since these stages are added as sub-stages, you can still track data as it relates to MITS, without losing any of your additional detail:
Above: Grow > Plants > Counts
Above: Grow > Plants > Forecast
This ability remains in your scheduling as well. You may continue to assign specific, time based schedules based on your stages and sub-stages.
Above: A schedule created in Grow > Setup > Schedule and its application to multiple clones.
MITS will require tracking of transfers of packages to your other locations, or "Facilities". This is something that will come naturally to those who have already been utilizing our GrowTracker and GramTracker software. Distributions will continue to allow you to transfer packages within MJ Freeways systems, and you will perform similar actions in the MITS.
When creating packages of product at your OPC, GramTracker allows you to specify the number of the package. As mentioned earlier in this article, while Grow and GramTracker only print bar codes for plant and package IDs under 13 characters, it can accept a great deal more. In the future, as you add plants and packages to MITS, you should be able to add those plants and packages first to assign them their numbers per the RFID tags, then simply scan that tag number into Grow or GramTracker to use the same number.
Above: Creating a package from product in a batch
Additionally, it is not known at this time if MITS will permit the inclusion of Ingredients or Chemical additives in the system.
GrowTracker will still attach that information to a batch as nutrients are applied, and tie that information all the way to the sale, printing those Ingredients as required by Colorado State regulations:
Above: Grow > Ingredients & Mixes > Manage Ingredients
Above : A plant history
Above: a sample package label including ingredients
Please let us know if you have any questions in your MITS setup, and we will be happy to assist in any way that we can.