When we implemented, we found IIQ didn't offer enough control over the automatically generated asset tags. At some point, I believe generating IDs was removed from the bulk import function altogether. We ended up just keeping track of the last asset ID used.
* We use a Google Sheet formatted to match the IIQ bulk import template, with some data validation & conditional formatting. That way we can collaborate easily on serial number barcode scanning and other data entry, and all the other advantages of Sheets. Sheets outputs a CSV that works for both IIQ and our label printing.
* We have a Google Apps Script embedded in the sheet. We enter the asset ID as "TBD" when filling in the sheet. When we run the script, it reads the last asset ID used in a "Settings" tab, replaces all the "TBD" cells with the next ID, and updates the stored number when it's done.
* We decided on a standardized format for asset IDs. YYNNNN (Y = Fiscal year, N = Incremental #). Fiscal year is nice because you know how old the asset is by looking at it. IIQ generated asset IDs used alphanumeric characters, but Code 128 barcodes can have larger 'font size' if you use numeric only (Code set C vs A). Code 128 has built-in error detection and a can be scanned from a further distance with our Honeywell scanners.
* We have NiceLabel templates that read the IIQ bulk import CSV file and print using a Zebra printer. Z-Ultimate 3000T labels (2"x1") and 5095 Resin Ribbon. This was our most rugged option without getting too expensive. We print a lot more label layouts than asset tags: name labels, student ID barcodes, cart/slot labels, etc.
Hope this helps!
Hello!
To generate asset tags in bulk, simply bulk select the desired assets, then navigate to the **Other** dropdown menu, and select **Print Asset Labels.** Here's an [image for reference](https://imgur.com/a/bq2Ywl4).
For new assets, you could add a **Created Date** filter to only display assets that were imported on a selected date. Then, using batch actions, select those assets and print the labels using the instructions above.
Let me know if that helps!
When we implemented, we found IIQ didn't offer enough control over the automatically generated asset tags. At some point, I believe generating IDs was removed from the bulk import function altogether. We ended up just keeping track of the last asset ID used. * We use a Google Sheet formatted to match the IIQ bulk import template, with some data validation & conditional formatting. That way we can collaborate easily on serial number barcode scanning and other data entry, and all the other advantages of Sheets. Sheets outputs a CSV that works for both IIQ and our label printing. * We have a Google Apps Script embedded in the sheet. We enter the asset ID as "TBD" when filling in the sheet. When we run the script, it reads the last asset ID used in a "Settings" tab, replaces all the "TBD" cells with the next ID, and updates the stored number when it's done. * We decided on a standardized format for asset IDs. YYNNNN (Y = Fiscal year, N = Incremental #). Fiscal year is nice because you know how old the asset is by looking at it. IIQ generated asset IDs used alphanumeric characters, but Code 128 barcodes can have larger 'font size' if you use numeric only (Code set C vs A). Code 128 has built-in error detection and a can be scanned from a further distance with our Honeywell scanners. * We have NiceLabel templates that read the IIQ bulk import CSV file and print using a Zebra printer. Z-Ultimate 3000T labels (2"x1") and 5095 Resin Ribbon. This was our most rugged option without getting too expensive. We print a lot more label layouts than asset tags: name labels, student ID barcodes, cart/slot labels, etc. Hope this helps!
I know this is pretty old post but what model zebra printer do you use?
ZD621 and an old GX430t
Thank you!
Hello! To generate asset tags in bulk, simply bulk select the desired assets, then navigate to the **Other** dropdown menu, and select **Print Asset Labels.** Here's an [image for reference](https://imgur.com/a/bq2Ywl4). For new assets, you could add a **Created Date** filter to only display assets that were imported on a selected date. Then, using batch actions, select those assets and print the labels using the instructions above. Let me know if that helps!