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.

Dong Shin 09.06.2013

  • new FA4 deployed, more bugs
    • fixed Financial Data not showing for multiple Req’s
    • removed chart from Summary Data
    • wrap components in FinancialDataPanel with <s:Scroller /> to get all the components
    • resize datagrid to eliminate vertical scrollers
  • working on Query Builder
    • reworked __view_project_totals so that it includes all total_budgets from budget_centers table
    • created view __view_sub_budget_center_totals for TST
    • fixed WHERE and GROUP BY not parsed properly in Query Builder

Phil 9.6.13

8:00 – 12:00 SR

  • Backups
  • Deployed new FA4
    • Add “Close” to query save panel
    • Rows in req panel are too tall
    • Need search inside req panel
    • Sum the Req allocation by sub-budget center. GROUP BY dispersal after running, but is saved in the description?
    • Status should be “Due” between now and the 10th.
    • Obligation and outlay uploads still need to be enabled
  • Paperwork. Particularly need to fix the workforce location DB entries.

Dong Shin 09.05.2013

  • deployed new FA4, some bugs
  • fixed total_budget as Currency – TOTAL regex added
  • removed the charts from Financial Data Viewer – performance should be lot better
  • created ServerLogPanel and LocalLogPanel that are draggable and resizable and moved out of main canvas
  • changed references to budget_center.total_budget to t.total_budget in the Query Builder queries to correct obligations and outlays
  • added support for column names with spaces in Query Builder – wrap it with a single quote ‘

Phil 9.5.13

8:00 – 10:30SR

  • Backups
  • Meeting with Lenny
  • Deployed FA4 for testing. Bugs follow:
    • total_budget in query builder needs to be formatted as currency
    • Expand columns in total grid to accommodate $999,999,000.00
    • System hangs when loading financial data viewer
    • Can’t move the server log panel or local log panel
    • budget_center.total_budget -> t.total_budget

10:30 – 4:00 FP

  • Downloaded several wav files of sinewave tones, ranging from 100hz to 1,000hz. The files are created using this generator, and are 0.5 sec in length.
  • Glued the tactor actuators in place, since they kept on coming loose during the testing
  • Fixed the file output
    • Each test result is now ordered
    • Fixed a bug where the number of targets and the number of goals were not being recorded
    • Added a listing of the audio files used in the experiment.
  • Got some initial results based on my self-testing today: firstResults

 

Dong Shin 09.04.2013

  • deployed new FA (Flex 4.5!), found some bugs
    • fixed logout not clearing panels
    • fixed Total Allocated not showing
    • change the name of the Flex App – FinancialAssistant4
  • continue working on Query Builder
    • created a view to pre-set the project totals for the queries – __view_project_totals
    • fixed group by errors when loading saved queries…

Phil 9.4.13

8:30 – 11:30 SR

  • Backups
  • Deployed new FA
  • Clear login info
  • combobox left edge is not showing in columns
  • Column width should be smarter
  • Total budget in FA is orders of magnitude too high in the new query
  • Project allocated on the project page is zero.

11:30 – 4:30 FP

  • Got the electronics boxed up last night: IMG_2192
  • Need to add “practice mode that lets the user try a setup with a srand(date) and the ability to choose the feedback mode – done
  • Fixed my buggy  sensor

Dong Shin 08.30.2013

  • continue working on Query Builder (FA)

    • added support for the columns that don’t exist in the column config. This allows SQL functions and alias names using ‘AS’
    • added GROUP BY support
    • reworked WHERE configuration to work with GROUP BY
    • SparkResizableTitleWindow is now functional

Phil 8.30.2013

8:00 – 11:00 SR

  • Backups
  • Training. Possibly the worst interactive training I’ve ever taken. Please don’t waste my time trying to make training a game. Give me the info, test me on it,and let me move on. Fighting robots!? Sheesh.
  • Timesheet stuff.

11:00 – 5:00 FP

  • Saving output – done
  • Adding TargetSphere placement limits and size range – done
  • Adding GoalBox size – done
  • Setting up release build. Done, though it wasn’t easy. I had to turn off “cross project optimizing”. That worked, but I don’t know why.
  • Still need to enable the “Next” button on the first pass through the test.
  • Still need to box up all the components.