- VizTool meeting – notes @ requirements page
- working on Query Builder
- removed Query column from Load Saved Query window
- allow saving of query when no data returned
- added GROUP BY req_id to the queries
- updated the queries to use aliases
- added table aliases to queryBuilderConfig.xml so that the duplicate column names are not used
- working on replacing Obligation/Outlay goal $ with %
Phil 9.20.13
8:00 – 10:00SR
- Backups
- Talked to Carla, the presentation went well and the customer likes the new version. There is an email with issues that I don’t have yet, but what I’ve heard so far is
- No way to search for contracts
- Contract info isn’t populating in the invoice
- Meeting with Chris, Dong and Lenny. Notes on the Req’s page.
10:00 – 4:00 FP
- Incorporated the results from yesterday’s runs. And we now have significant results for task completion times and task errors. Pretty cool.
- Back to working on the paper.
Phil 9.19.13
8:00 – 11:00, 3:00 – 4:30 SR
- Backups
- Attempted to deploy, but for some reason an old SWF was on the disk
- Redeployed new version in the afternoon. Success!
11:00 – 2:00 FP
- Worked on paper. I think I have a concept that fits the data. It will be two parts. The first will focus on the pilot study and the hardware/software. The second will focus on a more complete test of how multimodal rendering systems (Visual, haptic, tactile, aural) can enhance/support interaction as the visual channel is attenuated.
- Ran two more tests through the system. Need to incorporate the data and rerun the statistics. I think I also want to run the fastst 50% raw times. It occurs to me that there should be a minimum time to achieve the task (20-ish seconds?), and those that are closest to that time are by definition experts. This also leads to a way of classifying the users in a more meaningful way along a continuum from novice to expert.
2:00 – 3:00 Leave
- Had to catch up on class readings before meeting at 6:00. Worried that the afternoon install might run long.
Dong Shin 09.19.2013
- tried deploying FA/RA… had old SWF’s in the CD. Put the old FA back and will try again
- redeployed in the afternoon
- created new CD with the whole FA webapp directory as well as the new files…
- Flex 4 auto sizes the row height of the datagrids messing up the display….. bug or feature? Set rowHeight=26 to fix
- continue working on Query Builder
- created a view, __budget_center_totals for Total Committed, Total Obligated and Total Expensed
- CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `__view_budget_center_totals` AS select `budget_center_contracts`.`budget_center` AS `budget_center`,sum(`budget_center_contracts`.`committed_amount`) AS `total_committed`,sum(`budget_center_contracts`.`obligated_amount`) AS `total_obligated`,sum(`budget_center_contracts`.`expensed_amount`) AS `total_expensed` from `budget_center_contracts` group by `budget_center_contracts`.`budget_center`;
- created a view, __budget_center_totals for Total Committed, Total Obligated and Total Expensed
Phil 9.18.13
8:00 – 10:00 SR
- Backups. And in case Dong is still wondering, the full backup takes about 60 seconds.
- Paperwork. Need to talk to Chris about potential server changes.
10:00 – 4:00 FP
- Continuing the ongoing saga of trying to get an application written in Visual Studio 2010 in MSVC to run on ANY OTHER WINDOWS SYSTEM than the dev system. Today, I should be finishing the update of the laptop from Vista to Win7. Maybe that will work. Sigh.
- Some progress. It seems you can’t use “Global” in the way specified in the Microsoft documentation about CreateFileMapping() unless you want to run everything as admin. See StackOverflow for more details.
- However now the code is crashing on initialization issues. Maybe something to do with OpenGL?
- It was! I needed to remove the drivers and install NVIDIA’s (earlier) versions. I’m not getting the text overlay, which is odd, but everything else is working. Sheesh.
- Start writing haptic paper. Targets are CHI, UIST, or HRI. Maybe even MIG?
- This is also pretty interesting… http://wintersim.org/. Either for iRevolution or ArTangibleSim
Dong Shin 09.18.2013
- working on Query Builder
- working on queries for Chris
- set up five queries organized by Capability
- double click on the results brings Project Editor or Project Select Window if there are more than one project associated
- added query name to the Query Builder title
- dumped user_queries table in resources directory for tomorrow
- working on queries for Chris
Dong Shin 09.17.2013
- adding ScriptIf to FA server and client – done!
- added runPythonScript(scriptName) to ScriptFacade
- added Remote Object interface
- added call in ContractsParser
- did get some JVM MaxPermSize errors, fixed by adding more memory in startup.sh
- fixed RA adding 1 to the month fields in the Invoices
Phil 9.17.13
8:00 – SR
- NDA
- Backups
- Looking into a way of timing scripts. DOS has the TIME command, but that takes a ridiculous amount of formatting to produce a useful answer. It might be better to write a small utility and use that instead.
10:00 – FP
- Try out Firewire cable on laptop.
Phil 9.16.13
8:00 – 11:00 SR
- Deployed new VSS
- Had to change “committed” to “expensed” in Dong’s Python and SQL scripts.
- Add a “Hide” marker to the unclaimed section
- Add “100%” to Cognos Data Management panel
11:00 – 4:00 Leave
- waiting for Verizon to fix my TV/Phone/Internet
Dong Shin 09.16.2013
- deployed new VSS and scripts/queries
- obligation/outlay imports work!
- few notes at Phil’s blog
- fixed Outlay, expensed not committed!
- working on Server to run python scripts
Dong Shin 09.13.2013
- finished up the script to update Obligation/Outlay from COGNOS, packing up for testing…
- obligations_outlay_queries.sql – should go into VSS Query Editor
- update_obligation_outlays.py – python script to update data
- packaged up VSS client and server stuff
Phil 9.13.13
8:00 – SR
- Backups
- Server maintenance
- Scheduled additional training with Carla for Monday.
- Found out about the Internet Census 2012. Wow.
FP
- Filter out “expert” users (Lowest average time to complete all tasks
- Add error count (goal failuers)
- Fix commas+space bug in headset and Phantom code
- Add “System will exit” Dialog and exit() to headset and Phantom code upon completion of csv file.
Dong Shin 09.12.2013
- VizTool meeting – notes at the requirements page
- working on VSS script for Obligation/Outlay import
- got Outlay update script to work!
- verifying……
Phil 9.12.13
8:00 – 11:30 SR
- Backups
- Deployed new RA
- Need to add a dialog that shows the amount of time estimated for the query (average? Min/max?)
- Need to be able to get budgets with respect to Capability, Reqs or Projects depending on the context
- Need to be able to click on a query result line and go to the project. If multiple projects fit the criteria, all are listed in a dialog and the desired can be selected from that
- Add tooltip to save/load query datagrid
- Queries by individual capability – underfunded
- Queries by individual appropriation – underfunded
- Add the name of the query to the QueryBuilder titlebar
- Incorrect total for committed. May be from COGNOS
- Add a Requisition Amount column
- Adding a column (Appropriation?) breaks the query
- Incorrect Obligation Outlay goal (Runs on the budget center total rather than the Req total)
11:30 – 6:00 FP
- Started to run analysis on the Phantom and Headset results. The Phantom results are promising, but not significant. I need to get more data and/or figure out a way of pulling off confounding data.
- The headset data is somewhat more straightforward, if not a little dull. It turns out that in the pilot study, the ability to determine location of voice or tone with a 4-speaker headset is not that accurate, and degrades pretty linearly as the number of source go up. Not exactly an earth-shattering result.
- Need to get the spaces out from the csv output. THe space causes the Open Office Calc to read in the data as a string and not a number.
- Need to cause the headset app and the Phantom app to exit after writing out the file. Restarting ensures that the recorded data will be clean. There was a bug where old data was being kept between sessions on the headset code that subsequently had to be filtered out by hand.
- Ran Dimitri through the Phantom for his second pass. Looking at how he handled the system makes me thing that there is an “expert” level of training that most of the other test subjects haven’t attained. I wonder if that makes the results more clean? Need to examine further.
Dong Shin 09.11.2013
- bugs from Carla for RA
- Date DFAS Paid for the invoice changes the month (adding by one)
- add “Edit” Invoice
- reworked FA for meeting tomorrow
- fixed some bugs not parsing queries correctly
- reworked the queries for Chris
- not sure if TST and non-TST’s should be separated for the overdue queries
- added appropriation
- working on Obligation/Outlay update script in VSS

You must be logged in to post a comment.