Category Archives: VISIBILITY

Dong Shin 09.24.2013

  • working on Query Builder
    • added ProgressBar to the Query Builder Panel
    • added req totals view
      • CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `__view_req_totals` AS select `budget_centers`.`req_id` AS `req_id`,sum(`budget_centers`.`funded_budget`) AS `req_id_total` from `budget_centers` group by `budget_centers`.`req_id`;
    • added % values to the queries…
      • capability, bcc.budget_center_name AS ‘Budget Center Name’, bcc.budget_center AS ‘Budget Center’, req_id AS ‘Req ID’, vrt.req_id_total AS ‘Total’,
        CONCAT(obligation_month_12,’%’) AS ‘Obligation Goal Percent’,
        CONCAT(IF(o.type = ‘Reported FACTS Obligated $:’,month_12/vrt.req_id_total*100,0),’%’) AS ‘Obligated Value Percent’
        WHERE capability = ‘ACC’
        GROUP BY bcc.budget_center, req_id
  • Sub Projects are back!
    • reworked Project Editor panel to show Sub Project

Phil 0.24.13

8:00 – 11:00 SR

  • Big wreck on 95 this morning meant back roads coming in. Actually very pleasant commute 🙂
  • Backups
  • Continuing my server paperwork saga.
  • Subprojects are back!
    • Add “SubProject” to project information titlebar
    • Copy info from parent (Project Budget info, etc)
    • It might be possible to calculate some budget components. Not sure if needed.

11:00 – FP

  • Got dispensation to drop the headset paper. Working on the Phantom paper.

Dong Shin 09.23.2013

  • working on Query Builder
    • working on query to retrieve Obligation/Outlay % values
    • corrected joining tables to get unique obligation/outlay entries…
      • SELECT * FROM
        obligations_outlays o
        LEFT JOIN budget_centers AS bc ON o.funding_id = bc.uid
        LEFT JOIN projects AS p ON o.project_id = p.uid
        LEFT JOIN obligations_outlays_goals g ON g.appropriation = p.appropriation AND g.year = o.year_count
        LEFT JOIN __view_project_totals AS t ON t.project_id = p.uid
        LEFT JOIN __view_budget_center_totals AS t3 ON t3.budget_center = p.center_name
        LEFT JOIN __view_sub_budget_center_totals AS t2 ON t2.sub_budget_center_number = bc.sub_budget_center_number
        LEFT JOIN
        ( SELECT budget_center_id, sub_budget_center, sub_budget_center_name, executing_budget_center, ebc_name, appropriation_year, requisition_id,
        po_reference, acr, MAX(committed_date), SUM(committed_amount), MAX(obligation_date), SUM(obligated_amount), MAX(expensed_date),
        SUM(expensed_amount), MAX(po_start_date), MAX(po_end_date), GROUP_CONCAT(DISTINCT contract_type), GROUP_CONCAT(DISTINCT po_type_code),
        GROUP_CONCAT(contract_no), GROUP_CONCAT(DISTINCT vendor_id) FROM budget_center_contracts GROUP BY budget_center_id ) AS bcc ON bcc.budget_center_id = bc.uid
    • fixed queries using the new joining tables

Dong Shin 09.20.2013

  • 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`;

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

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.