Skip to main content

Printing Wire Labels on a Rhino Printer

A
Written by Ashok P
Updated over 3 months ago

This article explains how to print wire labels on a Rhino printer.

This article was written specifically for the Rhino 6000 or 6500 printer, which allows you to import a data file to the printer via a USB cable. These instructions can be modified for any label printer that can accept a data file.

Export Wire Labels from SI

Use the Export Wire Connections feature to export an Excel file with your chosen columns.

Once you click Export, here is how you can choose the columns.

Here is the exported file.

output.png

Prep the File for Rhino Printer

Rhino printers only read the first column of data in a spreadsheet. So, you will need to modify the Excel file you downloaded from SI and make it compatible for importing into a Rhino label printer.

Here are the steps to prep the file.

1/ In the spreadsheet, click on the first available column in the second row and enter a formula similar to the one below to concatenate all your fields into one field.

=A2&CHAR(10)&B2&CHAR(10)&C2.

excel formula.png

The &CHAR(10)& adds a carriage return between your fields. Of course, you would continue this until all your columns are accounted for.

2/ Copy down that formula for all valid rows of your spreadsheet.

copy down column.png

3/ Copy all of your concatenated cells.

copy cells.png

4/ Open a blank new workbook and in cell A1, do a Paste Special Values Only.

paste special.png

5/ Save the workbook in a CSV file.

save as csv.png

6/ Import the file into your Rhino Connect Software to build your wire label file.

rhino import data button.png

7/ Make sure you uncheck the Skip the first row of imported data.

import data form.png

Below is an example of the imported data. You can then transfer the wire data to your Rhino printer.

imported data.png
Did this answer your question?