Inventory Export

The Inventory Export is a complete listing of the tags within TIPWeb-IT respective to site and/or administrative views.  This file exports as a CSV (The comma-separated values (CSV) file format is used to store tabular data in which numbers and text are stored in plain-text form that can be easily written and read in a text editor. Traditionally, lines in the text file represent rows in a table, and commas separate the columns.) file.  It has detailed information regarding each item, including:

• Where each Tag is located:

• • Site & Site ID

  • Location & Location ID

  • Location Type

  • Destination

• What kind of item is being tracked:

• • Hardware Type

  • Product Name & Product ID

  • Product Description

  • Model

  • SKU

  • Manufacturer

  • 3 possible Product Custom Fields' information

  • Suggested Price

• Each items's specific information:

• • Tag Number

  • Active or Inactive

  • Allow Untagged (True or False)

  • RFID (Enabled or Not Enabled)

  • Asset Type (Standalone, Parent, or Component)

  • Status (In Use or Available)

  • Department Assigned

  • 4 possible Tag Custom Fields' information

  • Last Scan Date & by Whom

  • Projected Life

  • Expiration Date

  • Serial Number

  • Asset UID

• Each item's inventory & funding history:

• • Inventory Type (Initial or Order)

  • Order Number, if applicable

  • Funding Source

  • Account Code

  • Vendor, if applicable

  • Purchase Price & Purchase Date
    

Export the Inventory Export File

1. Click on Inventory Export, located in the Quick Links Tools menu.
2. When the message appears asking "Do you want to open or save InventoryExport.csv ...", click on Open.
3. The Inventory Export file will open within a spreadsheet program located on your computer (such as Microsoft Excel).  You may choose to search, filter, sort, delete, save, and/or close the file within your spreadsheet program using your spreadsheet program's controls.
   

NOTE:

If you are logged into a TIPWeb-IT site view, the Inventory Export will only provide you with tag information pertinent to that site.

If you are logged into a TIPWeb-IT administrative view, the Inventory Export will provide you with the tag information for the entire district.  As this report is much larger than a site view's Inventory Export, it may take several minutes to generate.  Refrain from clicking on anything else within TIPWeb-IT while the Inventory Export is generating.

Customers with the Departments Feature (Departments is an optional feature which must be purchased to enable it within TIPWeb-IT. This feature allows for the ability to assign Departments to users and tags. Those users assigned to a specific department(s) will only be able to access/view/modify tags assigned to the respective department. For more information about the Departments Feature, contact Customer Support at support@hayessoft.com or 800-495-5993.) installed, will also display a “Departments” field to the Tag Listing Report (admin view only) and the Inventory Export Report (site view and admin view).

Asset UID is available for customers with an asset integration setup (paid add-on to TIPWeb-IT) and displays the unique asset number brought into TIPWeb-IT from the district's integration files (usually sourced from the district's financial or fixed asset system).