AppTrac Presentation

Here is the set of presentation slides used during the 04/29/08 presentation: D3_AppTracPresentation_1.0.ppt

Things to be added to AppTrac

General:
- Possibly store user images and application icons on ftp or on a central computer (where the database resides).
- Put double slashes in application paths or read paths and add them on the fly if necessary.
- Database path, login and password should be stored in registry or config file, and read from there on launch.
- Log users out automatically after configurable inactivity period (stored in registry or config file) with an audiovisual message like “Are you still there?” dialog box and voice file.

Database:
- Get rid of application access field?
- Should user_active in apptracuser be nullable?
- Add some sample URLs to apptracapplication table.
- Ideally, the table should only store the URLs, and AppTrac should pick the default browser to launch them.

Exceptions:
- Get rid of any remaining dummy exceptions.
- Make sure all exceptions have messages.

Reports:
- Add Student Users Report: a list of all registered students, including ID, name and contact information.
- Add Student Activity Report: A list of all active students and a summary of their activity for a given time period.
- Add Application Utilization Report: Summary of overall time spent broken down by application.
- Add ability to send queries to database and display reports in lower pane (possibly replace lower pane with a table).
- Add abilities to save queries and reports.

Interface:
- AppTrac must remain in the front at all times (over Windows taskbar).
- When new application is launched, it should always be on top of AppTrac.
- Remove AppTrac from application selection and control lists.
- Exit button should only be available to admins after they login.
- When a list is shown, have first element selected by default.
- Remove “jdbc:mysql://” from connection string in database login screen.
- Make Password text box in database login screen a true password box (characters should appear as dots).
- Add checkbox to remember database password.
- Add checkbox to start with Windows.
- Display a list of available queries in ReportGeneratorGUI.
- Remove text area from ApplicationControlGUI.
- Add Browse button to ApplicationControlGUI to browse for application path (filter executables).
- Make Zip and State text boxes shorter and City longer in UserControlGUI.
- Add dropdown box for user_active field in UserControlGUI.
- Phones and zip code in UserControlGUI must have leading zeroes.
- When a field is blank in UserControlGUI, display empty field instead of a zero (possibly treat them as strings in the application and possibly in the database).
- Password text box should not appear in LoginScreenGUI by default (when no user is selected).
- Add dynamic search to LoginScreenGUI and UserControlGUI.
- Add avatars to user selection boxes in LoginScreenGUI and UserControlGUI.
- Add application icons to application selection boxes in ApplicationSelectorGUI and ApplicationControlGUI.
- Interface should adapt to resolution more easily, especially UserControlGUI.
- Expand controls to take up more space in some screens.
- Admin interface should be windowed and not full screen.
- Decrease font size, especially in admin interfaces.
- Log Off button should be in same absolute location on each screen.
- Database login screen should be same as other screens in its layout.
- Maybe use a different, more variable resolution-friendly layout.
- Add special key blocking.
- Add status bar and display various status messages there.

Check back often and expect this list to change.

Gentlemen, We have Liftoff … (continued)

Here is a cleaner self-contained zipped NetBeans 6.1 project, containing the source code and a compiled distribution:
apptracbeta11_src_dist.zip
If you are not using NetBeans [6.1] IDE, add the three JARs from apptracbeta11_src_dist.zip/AppTrac/dist/lib/ to project libraries.

And here is the zipped ready-2-run distribution:
apptracbeta11_dist.zip
Once you unzip it, run ../AppTrac_dist/AppTrac.jar.

You will need JRE6 to run AppTrac. We recommend downloading the latest JRE update (Update 6 at the time of writing).

Victor.

Gentlemen, We have Liftoff …

Well, after careful review, we seem to have a functional version of App-Trac!  User Adding, Application Adding, Application Loading all works.  Even better, time tracking now is in place.  Here is a simple query i wrote for the database to get some nice results:

select u.user_id UserID,
u.user_fname FirstName,
u.user_lname LastName,
ul1.log_timestamp TimeIn,
ul2.log_timestamp TimeOut,
a.application_name AppName
from   (select * from apptraclog where activity_id = 1) as ul1
inner join (select * from apptraclog where activity_id = 2) as ul2
on ul1.log_sessionid = ul2.log_sessionid AND ul1.log_id <> ul2.log_id
inner join apptracuser u
on u.user_id = ul1.user_id
inner join apptracapplication a
on a.application_id = ul1.application_id

also, i am uploading the code here:

app-tracbeta10

rename to .zip to extract.

Some minor issues to address:

-Loading applications will load an application twice

-Some of the interface screens do not take up the whole screen (which would be nice)

-status bar should be added (to let the user know that app trac is logging in)

-exit button needs to be moved

-report generation still needs to be done

-anyone up for avatars? it would be nice to have this

-application restricted access (no matter how hard i tried, i just couldnt get this down)

-exception handling structure all screwed up (easy fix, not too complicated)

Nice job to all =)  We have the requirements done…Next Phase, look and feel =D

Myles

Meeting Minutes for 4/24/08

Date: 4/24/08
Time: 2:00pm – 3:30pm
Present: Myles, Chris, Victor
Recorder: Chris

This is a general update for what we have been doing thus far. Most of our time has been spent on implementing App-Trac. Myles worked on the models and controls. Victor worked on the database control. Chris worked on the view (interface). After the model view and control was complete, we combined the three together and debugged issues that arose. We are currently in the final steps of the implementation process and will be complete in time for our presentation this coming Tuesday, 4/29/08.

Workspaces

Workspace that doesn’t work: workspace1
And the one that works: workspace
And the missing report generator: reportgeneratorgui1

Rename the first two to .zip, and the third one to .java after downloading.

Interface/GUI Update

Here is my updated code for the GUI. It adds the interface for the user control panel. There is still no “generate reports” panel.

http://uhaweb.hartford.edu/padilla/d3/AppTrac-GUI-4-21-08.zip

Interface/GUI

I have been hard at work on the interface and this is what I have thus far:

http://uhaweb.hartford.edu/padilla/d3/AppTrac-GUI.zip

It is in no way complete. I also have altered some of the methods and have some general questions when we meet again. Take a look at it and let me know what you think.

Coding and UML Diagram

I started coding and realized a few discrepancies within the UML.  Dont mind them, they will be fixed soon.  Im trying to get all the coding done (at the bare least a skeleton of all the code, so the rest is just easy fill in), hows everything going with the interface you guys?

Complete UML Diagram

Okay, i went back and just combined everything to make it a little less hard to find: