Working With Tables

Most of the data collected in the field with Burnside Mobile is accessible through the tables tab on the office version of the software. Maintenance items, patrol logs, journal entries, and weather condition information are all available through these views. For example you can use the table view to:

It is recommended that a minimum 21” monitor be used for working with the Maintenance Table. This will allow you to see most of the text in the columns displayed.

Accessing the Table View

On the Main Menu, select the Table tab.
T_Tab

When you click on this tab, the view will change to show the Maintenance table. When the maintenance table opens, it will open with the default columns showing.
T_Maint

Customizing the Table View

You can sort by any of the columns by selecting the column heading. Select Sort Ascending or Descending to sort the table. A small triangle pointing up or down indicates the column that the table is sorted by and whether it is ascending (up arrow) or descending (down arrow). You can only sort one column at a time.

T_SortTable

You can customize your table and select the columns you would like to view by selecting the + symbol in the top right corner of the table and then selecting the check box beside the column name.

T_AddColumns

Saving Column Views

After you have modified the column layout you can save it for later use. Saving column layouts allows you to save multiple column layouts per table filter. This means that you can save layouts for Assigned, and Closed work orders if you want to see different columns for each type.

  1. Set the table to include the columns you wan to save. Follow the instructions above.
  2. Click on the Views fly-out button and select Save.
    T_SaveColumns
  3. Enter a name for the view. Since the views are saved by the table they are associated with. It's a good idea to preface the name of the view with the table name for Example (Closed_NoRegion, and Assigned_NoRegion). T_ViewName
  4. Click Save

Loading Column Views

  1. Click on the Views fly-out button and select Views
  2. From the Show Custom Grid View Dialog, select the view name that you want to use
    T_ShowView
  3. Click OK

Filtering the Table

Use the filters found at the top of the table to populate the maintenance table with a subset of open deficiencies. Select an item from any of the dropdown lists and the maintenance table will be repopulated with deficiencies related to a specific Category,Type, Inspector, Status, Work Order or Severity. The image below shows deficiencies in the Barrier Systems category.
T_FilterView

Note that the top of the table is now displayed in a shade of yellow to notify the user that the table is being filtered.
Click Clear to remove the filter from the grid.

Other Data Tables

Burnside Mobile lets you access other data tables in the system. To open these tables, Click on the Button On the Data tables toolbar.

T_AllTools.png

Data Table
Road Section Table T_RoadSec.png Click the Road Section table Button to open the Road Section Table to show the details of the road sections in the system.
Patrol Logs T_PatrolLogs.png Click the Patrol Logs table Button to open the patrol logs table to show a list of all of the patrol logs in the system.
Journal Entries Table T_Journal.png Click the Journal table Button to open the journal table to show a list of all of the journal entries in the system.
Weather Entries Table T_Weather.png Click the Weather table Button to open the Weather table to show a list of all of the Weather entries in the system.
Opening Tables By Date Range T_DateRange.png Click on the By Date Range Button, then enter a From and To date Range. Select the table type from the drop down.

Selecting and Exporting from Table

Burnside Mobile provides the Supervisor and Administrator with the ability to select and export table information to a CSV file, which can then be used in Excel.
T_SelectALL

Select Tools
Once the data in the table is filtered to all the records you want to view, click on the Select All button to highlight all the records
To export the selected records to a CSV file click on the Export Selected button
To clear the selected records click on the Clear Selected button.

Interacting with Tables

Once you have opened a table, you can double click on an Item to see its details. The form that opens will vary based on the table type. For example, opening a maintenance item will show the maintenance item form, and opening a road section, will enter the road section details form, and so on.

You can also interact with the table by right clicking on rows. This will open a context menu which will show you valid operations you can perform with the record. For example, right clicking on a closed maintenance item will allow you to re-open it. Right clicking on a patrol log , will either open the details form for the patrol log, or allow you to open the log in the map view.

Using The Show Toolbar

T_ShowToolbar

You can switch to the Map View or open the Details of a Selected row in the table by clicking on the Map or Show Details buttons on the Show Toolbar.