Asset data can be displayed in data tables with one row per asset, and one data item per column. When asset data are shown in tables, you see a combination of master data along with the most recent updates - e.g. the latest recorded mileage, condition, or the most recent location in which the asset is housed. Complete the following steps to navigate to a table of assets:
- From the Main Menu, click the Inventory icon.
- Hover over the desired asset type to show the available asset subtypes and click the desired subtype. You will be directed to a table listing all the assets of the selected type/subtype.
- Alternatively, from the Inventory icon, you can hover over the Manufacturers drop-down and click on a desired manufacturer. You will be directed to a table listing all the assets of the selected manufacturer.
Note: You can generate different table views throughout TransAM. All table views have the same general layout - one row per item, and one data item per column - and you can perform the same actions in each table.
Once in a table view, there are several controls allowing you to manipulate and export the table:
- Click column headers to sort the table based on a given attribute (ascending: up arrow or descending: down arrow)
- At the bottom left of the table, select how many rows you want to display in your table per page. Options for rows per page range from 5 to 200. This setting will "stick" if you subsequently navigate to additional asset tables.
- In the bottom right of the table, you can navigate between previous and next pages in your table or jump to a specific page.
- In the upper right corner of the table are three buttons. From left to right:
- Hide/Show Pagination: Clicking this button will hide your pagination and display all assets in your selection. This feature becomes useful if you want to export more than 200 records. Note: It will take a minute for the system to load the table depending on the size of your view.
- Columns: Scroll through and toggle certain data attributes on or off in the table view.
- Export: You can export your current table view into either a CSV, TXT, or Excel XLS file. Since TransAM exports your current view, you must set the columns and number of records you want to display before exporting.