How to download and run SAT

Warning
This version of SAT is quite immature and barely tested. Try it at your own risk and keep a parallel record keeping facility so that you can fall back to it in case of bugs.

Step 1 - install necessary tools
Read Tools Used section of the implementation document, it describes a lot of useful stuff you can use to make running the SAT easier.

You don't need to install all of the tools if you just want to run the app.

The bare minimum required to run SAT is;

.net runtime support

a mysql engine

Download and install the SAT software itself which is available here

Step 1.5 - run SAT
Run the setup.exe if you downloaded the installer or

If you downloaded the source rather than the installer you need to navigate to the debug submenu and run the SchoolAssetTracker.exe application directly.

Step 2 - create database
From the Database functions menu choose Select Default Database

Enter your root password for mysql and hit Update Default Values

Then select Add a Database and enter a name for your database (using lower case only)

Now from the Database Menu choose select default database and select the DB that you just created and hit Update Default Values.

Step 3 - Create csv seeding files or import RMU csv extract files
SAT now has facilities to read in the raw files from RMU extracts.

For your RMU exports, from the Student tab slect Show Screen Options and ensure that Show student details is selected as Yes, then search and export as normal. (This will be your Clients file)

On the RMU Device tab ensure none of the Show Screen Options are Selected. i.e. Show MAC Addresses :  Show Write Offs :  Show Upgrade Flag : are NOT selected, then search and export as normal. (This will be your Assets file)

1. Start SAT and under the menu option Import Data Files select IMPORT Import RMU Assets

2 under the menu option Import Data Files select IMPORT Import RMU Clients

IMPORTANT import the LAPTOP/Assets file BEFORE the STUDENT/Clients file.
If you have other assets not covered by RMU read on....

In order to bulk load data into the files we need to extract information from RMU (or your favourite excel spreadsheet), format it into CSV files and the import it into the database via the import data file menu options in the SAT application.

Head over to the page that descibes the CSV files.

Take the import option from the SAT menu and go from there.