Setting Up AppTrac
From Humanitarian FOSS Summer Institute 2009
Back to AppTrac page
Downloading/Installing App-Trac
[jar file etc...? when we get this all set up.]
Now that you have AppTrac, there are a number of things you'll need to do before being able to use it to its full functionality. One, you are going to need a database on a server of some sort. This will contain all the database information and all necessary tables. The following is what you are going to need in terms of SQL query. SQL is short for Structured Query Language, and essentially 'talks' to the database, telling it what it needs.
Now, you have all the tables that App-Trac needs.
Adding Applications
Now for one of the most important aspects of App-Trac: application loading and tracking.
In the database, click on the 'at_core_application' table. There are three fields in the table: id (which you don't need to worry about - it's auto-incrementing, as you'll see), name, and path. The name refers to the name of the application as you'd like it to appear. The path refers to the path to the executable file of the application. IMPORTANT: The path needs to be the same on each networked computer in order for this to work. If your database has a nice user interface, you'll see a link to 'Insert'. This provides a form to insert new information into the table. What you need to worry about is the 'Value', nothing else. In the field for the 'name' value, type in the name of the application. In the 'path' value, type (or copy and paste!) the exact path to the application. Not the shortcut, if it is on the Desktop, but the path to the application itself. Next, click 'Go' or 'Insert'. In this way, you can add as many applications as you need.
Here are some examples of typical Windows paths: C:\WINNT\system32\calc.exe refers to the path to the Calculator that comes with most Windows operating systems. C:/LexiaLearningSystems/LexiaStrategiesWin.exe refers to the Lexia literacy application. NOTE: These are examples and are not to be used as database information. You will need to get the paths to your applications on your own computers.
If, however, you do NOT have an easy-to-use interface similar the one above, here is the SQL query you'll need:
INSERT INTO 'at_core_application' ( 'id', 'name', 'path') VALUES
(1, 'application name', 'application path'),
(2, 'application2 name, 'application2 path');
etc.
Back to AppTrac page
