For the fastest possible Harvest workflow in Canix, we recommend using the Canix Harvest Importer. To use the uploader, you'll scan tags and record weights directly from your scale into the Canix Harvest Import Template and then upload this file into Canix.
The advantages to this approach are:
- Capturing tags and weights without needing to type on a keyboard (depending on hardware setup)
- Allowing for multi-strain harvesting (Canix will automatically split the upload into separate harvests by strain)
What you'll need:
- A laptop or tablet that runs MacOS or Windows
- A barcode scanner with Bluetooth connection or USB cable
- A scale with Bluetooth connection, a Bluetooth dongle, or a Serial RS232 to USB output cable (HID format)
- Microsoft Excel
In this article we'll cover:
Keep reading or watch this video to learn more:
Scale Connection
Connecting both your scanner and scale allows for recording tags and weights without typing. See these guidelines for connecting your scanner and scale.
-
USB Connection: If your scale is not Bluetooth enabled, you can connect directly to your laptop using a USB Interface kit. For example, this RS232 to Serial Connector which is compatible with the Ohaus Ranger 3000.
- *this exact kit may not work with your scale, please verify before purchasing.
Scale Settings
Your scale may need to be set to send weights manually instead of continuously. If you're seeing a stream of data and weights typing into SerialMagic or your spreadsheet, you'll need to change your scale settings to send weights manually.
For the Ohaus Ranger 3000, please follow the steps below:
1. Under the scale there is a red "legal for trade" switch. Move this to the off, or unlocked position.
2. Hold the menu button. You should see "CAL". If you do not see "CAL" your legal trade switch is still on (see step 1).
3. Use the "Print" key to navigate the menu until you see "Print". Press "Yes".
4. Use the "Print" key to navigate until you see "A.PRINT". Press "Yes".
5. Use the "Print" key to navigate until you see "ACCEPT". Press "Yes".
6. Press the "exit" key until you've returned to the weight reading, ie. "0000 g".
7. Place your cursor into Excel and press the "Print" key, you should see the weight populating in your spreadsheet!
If you're still having trouble with the connection, continue with the following steps:
1. Hold the "Menu" button. You should see "CAL".
2. Use the "Print" key to navigate the menu until you see "COM". Press "Yes".
3. Use the "Print" key to navigate until you see "BAUD". Press "Yes".
4. Use "Print" to navigate until you see "9600". Press "Yes".
5. Use "Print" to navigate until you see "Parity". Press "Yes".
6. Use "Print" to navigate until you see "8 None". Press "Yes".
7. Use "Print" to navigate until you see "STOP". Press "Yes".
8. Use "Print" to navigate until you see "1". Press "Yes".
9. Use "Print" to navigate until you see "HANDSH". Press "Yes".
10. Use "Print" to navigate until you see "None". Press "Yes".
11. Use "Print" to navigate until you see "alt.com". Press "Yes".
12. Press "Menu" to return to the weigh screen.
13. Place your cursor into Excel and press the "Print" key, you should see the weight populating in your spreadsheet! If you do not see the expected results please reach out to support - Submit a Support Ticket.
Is your scale connection working, but you're seeing "1550 g" instead of just the numeric value "1550"?
1. Hold "Menu" for 3 seconds.
2. Use "Print" to navigate until you see "Print". Press "Yes".
3. Use "Print" to navigate until you see "Content". Press "Yes".
4. Use "Print" to navigate until you see "Unit". Press "Yes".
5. Use "Print" to navigate until you see "Off". Press "Yes".
6. Press "Menu" to return to the weight screen.
For other scales please find the scale manual by searching the model online and search for "Manual" or "Continuous" to find the relevant settings:
Recording Tags & Weights in the Harvest Template
Once both scanner and scale are connected, download the Canix Import Template.
- Do not open the template with Google Sheets! Use this link to download the .xlsm file provided by the link.
1. To record weights start with your cursor in cell B2 and scan the first plant tag for your harvest. You'll see the cursor automatically move to the right, to the "weight" column after scanning.
Once your scale settles press "Enter" on the scale to record the weight and your cursor will automatically move to the next row, ready for the next tag to be scanned.
Repeat this process until all of your plants have been weighed!
Units will be set to grams be default, but you can over-write these units by editing the formula in Excel and updating "grams" to read "kilograms", "pounds", or "ounces".
Template Import
Once all plants have been weighed you can import the file into Canix to create your harvests.
1. Convert your file to a CSV by navigating to File > Save As and specifying the file format as CSV.
2. Navigate to the "Flowering (Tracked)" view on the Plants table, or the "Active" view on the Harvests table.
3. Select "Import Harvest" from the actions menu.
- Canix will automatically create separate Harvests for each strain with the corresponding plant tags
4. Select "Review All Harvests" to confirm the Harvest Name and Location and the weights for each harvest.
5. "Save as Draft" to save the information and submit later, or select "Submit Harvest" to create and submit the harvest.
Frequently Asked Questions:
Can I add plants from separate facilities to the import template?
- Yes, when harvesting plants from multiple facilities/licenses you can record weights in a single import template. In Canix you'll need to upload this template for each facility, we'll recognize the plants that are in that facility only.