Scenario
Scenario
Let’s look at this common scenario of how and why you would want to do this.
Scenario: You are a stud sheep or beef farmer who has purchased matched EID and VID tags. You want to upload the tags file to your EID stick reader so that when you scan an animal EID, the VID tag number will display:
You can manually draft out animals which don’t have a VID, and attach the correct VID tag, as displayed on the stick reader.
|
|
With this in mind you:
Buy a matched set of EID and VID tags (e.g. 100) from Z Tags and the tags file is made available on the Z Tags website.
Download the tags file from the website and manipulate the data in MS Excel as required.
Upload the modified tags file onto your stick reader (via Data Link for PC/Animal Lifetime information).
Scan each animal in your herd with the stick reader and its VID/Birth Year is displayed on screen.
Manually draft animals not displaying a physical VID tag, but showing a VID on the stick reader when scanned.
Retrieve the animal’s physical VID tag from the bought supply and apply the new VID tag to the animal’s ear
Hardware/software you will need
Hardware/software you will need
 | A Windows PC with internet connection to access the Z Tags website. |
| Installed on the PC:
|
USB connecting cable for charging, and it is also used for connecting the stick reader to the PC. | 
|
You will need one of the following models of EID stick readers:
|
 |
|
 |
|
 |
|
 |
There are four distinct steps for transferring Z tags data to your stick reader:
1: Downloading a tags file from the Z Tags website
1: Downloading a tags file from the Z Tags website
Recording your Z Tags Order No.
When you purchased or arranged for your new delivery of tags you will have been given a Z Tags WEB Order. No.
If your ordered via LIC, you may also use the LIC Sales Order number.
Both numbers can be used as your Z Tags Order No.
You will enter this Z Tags Order No.number to access your tags file in the next step. | 
|
Downloading from the website
Download your Z Tags tags (or bucket file) from the Z Tags website:
Access ztags.com in your browser.
From the Z Tags (New Zealand) homepage click on DOWNLOAD YOUR RFID FILES.
From the Z Tags RFID Number Export screen enter your Z Tags Order no. and check the File Format and File Extension (are set as shown below).
Then click the Download button:
After a few seconds the file will download into your local Downloads folder and you will be prompted to save it:
Click Save and navigate to save it in a suitable folder on your PC.
📝 The files are named with a syntax of Date_Time_Z Tags Order No._Export.csv
2: Modifying the tags file ready for uploading
2: Modifying the tags file ready for uploading
Prior to uploading your Z Tags tags file to the stick reader, some manipulation within MS Excel is required to change the format so that the data displays as you want on the stick reader.
Navigate to the folder where you have saved the downloaded RFID file and double-click the file (to launch MS Excel) and load the file (if MS Excel is already open click Open to then load and edit the file):
With our scenario example:
Tags file as supplied from Z Tags
Column A = EID with prefix
Column B = VID
Column C = Birth Year of animal | Tags file modified, ready for uploading to the stick reader
|
 |  |
📝 By default, MS Excel will display a long number (e.g. EIDs) in scientific notation (e.g. 9.85152E+15):
This may cause issues when the file is transferred to the stick reader.
To change this, select the column containing EIDs, right-click, select Format Cells. In the Number tab, select Number and set Decimal Places to 0.
The EIDs will now display normally:
Combining the birth year and VID
In this scenario you want to see the VID/Birth Year on the stick reader screen and manipulate the tags file data into that format.
Click on cell D1 to select it.
Click on formula text box and enter =B1 & “/” & C1
📝 Apart from numbers and letters, only these characters can be used in data to be uploaded onto the stick reader:
Forward slash (/), full stop ( ), hyphen (-) and embedded spaces.
3. Press Enter to perform calculation in selected cell:
4. Click on cell D1 again to select it.
5. Hover mouse around cell till + appears:
6. Double-click on + to fill column with calculated results, but only down to the last row of data:
7. Right-click on calculated column D (column is selected with green border) and select Copy from the dropdown menu:
8. We need to paste the data on top of itself to turn it into “values”, so click
Home > Paste > Values & Source Formatting (E)
9. Drag your mouse over cells in Columns B and C to mark them as a selected set of cells.
10. Right-click and select Delete from the dropdown menu:
11. Click option button Entire column and OK to delete columns B and C:
Add a header row
Right-click on row 1 and select Insert… from the dropdown menu.
Click on option button Entire row and click OK
A blank row is inserted as a new row in the spreadsheet as the new row 1.
3. Enter EID as the header above the EID column, and VID above the new combined VID/Birth Year column:
4. Now your tags file is ready for upload to the stick reader and can be saved, ready for use (see next section).
Saving the modified CSV file with a different file name
You need to save your modified csv file with a different file name ready for uploading to the stick reader.
💡 When you save your modified Z Tags tags file it is recommended that you name it in a consistent manner, and retain the link to the supplied Z Tags tags file. When prompted to save the file, use the name of the original tags file and prefix it with something like UPLOAD in the filename. You can retain an archive of tags files for use later and easily sort on date/time and distinguish the modified ones.
In Microsoft Excel:
Click File > Save As (and the dialogue prompts with the existing filename and Downloads folder).
Enter a prefix (e.g. UPLOAD) in front of the filename to indicate this is the modified file.
Click Save to export and save the file as a new tags file, ready for upload to the stick reader:
📝 Should you wish to navigate to a different folder to store your modified tags file in, click the More options… link to do this.
3: Uploading modified tags file to the stick reader
3: Uploading modified tags file to the stick reader
Transfer your modified Z Tags tags file from the PC to the stick reader using Data Link PC software.
Connect the stick reader to a PC using the cable supplied.
Launch Data Link PC software on your PC.
Click
to transfer data from the PC to the stick reader.
Select option button Animal lifetime information and click Next.
Browse to find the modified Z Tags tags file, select it and click Open.
Data Link will confirm that the file has been successfully transferred to the stick reader.
Click OK.
📝 If animal lifetime information already exists on the stick reader, the information will be merged with the existing information
4: Using the tags file information on the stick reader
4: Using the tags file information on the stick reader
Now that you have uploaded the Z Tags file you can begin a scanning session with your stick reader:
1. Scan each animal in your herd with the stick reader and its VID/Birth Year will be displayed on screen.
During the scanning session, when an animal’s EID is scanned, the corresponding VID/Year will be displayed in large numbers, making it easier to identify the animal and then deal with it for retagging. | 
|
2. Manually draft animals not displaying a physical VID tag, but showing a VID on the stick reader when scanned.
3. Apply the new VID tag to the animal's ear.
Having trouble?
If you need help, click on the Live Chat bubble in the bottom right-hand corner of this screen or email sf-support@datamars.com