Items
Here’s a list of the file types you can upload in AssetSonar:
Image formats:
JPEG
JPE
JPG
X-PNG
TIFF
GIF
BMP
vnd.adobe.photoshop
vnd.microsoft.icon
Sheet formats:
vnd.openxmlformats-officedocument.spreadsheetml.sheet
vnd.oasis.opendocument.spreadsheet
vnd.ms-excel
Excel
Doc formats:
vnd.openxmlformats-officedocument.wordprocessingml.document
vnd.oasis.opendocument.text
MSWord
PDF
Video formats:
QuickTime
MP4
3GPP
AVI
Executable formats:
EXE
You can now customize the Low Stock Alert page as per your requirements. For example, users can track which vendor is responsible for restocking particular items.
To customize the page, access it from the bell icon in the top-right corner and click on ‘Low Stock’.
This takes you to the Low Stock Alert page. Once there, click on the ‘Edit’ icon as shown below to customize the columns displayed on the page.
To add a new column, click on the ‘Add Column’ button. The new column, in this case, is named ‘Column #8’. To name the column, select from the list of options available in the dropdown menu. Don’t forget to hit the ‘Save this view’ button so all your settings are applied successfully.
You can also add filters to narrow your results by choosing from the filters dropdown:
Item labels can only be generated if an item exists in our system. If you need the labels printed beforehand, an easy workaround is to create Placeholder Assets.
For QR-Coded labels:
- Add an Asset titled ‘Placeholder’. Then, clone it to make more copies of the placeholder Asset.
Note: You can only make 25 copies in one go.
OR
- Use AssetSonar’s Excel import wizard.
To import as many as 1000 placeholder Assets at a time, use an Excel sheet and fill a column that just says Placeholder. Here is an Excel file that you can use for 100 placeholders. You can drag a row in excel to create more.
Placeholder Assets (Excel sheet).
For Barcoded labels:
Record the BIOS Serial Numbers of IT Assets and Serial Numbers of non-IT Assets beforehand into an Excel sheet. Import the Excel sheet and map values as follows:
- For IT Assets: Map BIOS Serial Numbers onto the BIOS Serial Number fields.
- For non-IT Assets: Map serial number onto the AIN fields.
Placeholder Excel sheet example, using barcodes.
If you want Placeholder Assets to be hidden from your users, you can retire them. When attaching the label to an item in the future, unretire/reactivate the Placeholder Assets by following the pathway: Actions → Activate from the Asset Listings or Asset Details page.
Further information:
See how to export data for commercial printing
How to import items into AssetSonar using Excel?
QR-Code vs. Barcode – Issues, Practices, and Recommendations
You can apply filters to get the desired results for items.
To do this, go to the Navigation menu → Items → Asset/Asset stock/Inventory → Apply Filter → Search.
Now let’s suppose that you want to search for Available Assets. You can choose this filter, apply it and all the Available Assets will appear on the page.
You can also choose multiple filters at a time to search for relevant Assets. For instance, below we have filtered the Assets by ‘Available Laptops’.