Monthly Archives: September 2013

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

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.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.

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

Phil 9.11.13

8:00 – 10:00 SR

  • Backups
  • One of Carla’s users thinks that they have found a bug in RA. They would also like an “Edit” button in addition to the “Remove” button
  • Pat is having some bugs with query builder where redundant information appears to be getting returned. She also ran into the missing where clause bug.
  • The “Create Req” panel needs tooltips and searchable comboboxes.

10:00 – 5:00 FP

  • gathering results

Dong Shin 09.09.2013

  • working on Query Builder
  • working on importing Obligations/Outlays from COGNOS
    • set up VisibilityScriptingServer
      • change project_portfolio to project_portfolio_enh in visibility.properties
      • updated pom.xml to generate VisibilityScriptingServer-1.0.jar
      • rebuilt with the latest code
    • created sample xlsx data for Obligated and Outlay data
    • saved following queries in VSS – get_cognos_outlays and get_cognos_obligations
    • query to get monthly outlay data – 59958230400 is for 1900-01-01 dates which should be ignored
      • SELECT sub_budget_center, requisition_id,
        MONTH(committed_date), YEAR(committed_date)
        committed_date, SUM(committed_amount)
        FROM `contracts_cognos`
        WHERE to_seconds(committed_date) > 59958230400
        GROUP BY sub_budget_center, requisition_id, MONTH(committed_date), YEAR(committed_date)
        ORDER BY sub_budget_center, requisition_id, YEAR(committed_date), MONTH(committed_date)
    • query to get monthly obligation data
      • SELECT sub_budget_center, requisition_id,
        MONTH(obligation_date), YEAR(obligation_date)
        committed_date, SUM(obligated_amount)
        FROM `contracts_cognos`
        WHERE to_seconds(obligation_date) > 59958230400
        GROUP BY sub_budget_center, requisition_id, MONTH(obligation_date), YEAR(obligation_date)
        ORDER BY sub_budget_center, requisition_id, YEAR(obligation_date), MONTH(obligation_date)

Phil 9.9.13

8:00 – 11:00 SR

  • Backups
  • Fixed the workforce db issue
  • Pat wants an appropriations column for Query Builder
  • Tangie and Carla are going to give demos to some customers later this week and need a walkthrough of Req Asst.

11:00 – 4:00 FP

  • Brought in my Mac Mini. Going to try for Boot Camp and win7.
  • Time to experiment on Dong.