Category Archives: VISIBILITY

Dong Shin 10.07.2013

  • discussed next gen FA applications with Phil – write up to come…
  • continue working on integrating RA with FA
    • fixed all dynamic class loader references to the new package names
    • changed change logs files to RA and FA
    • testing done!
  • prepping for deployment as people are getting back to work.

Dong Shin 10.04.2013

  • since we are moving away from maven, it would be good to combine FinancialAssistant and RequisitionAssistant into a single project
  • working on combining FA and RA
    • committed FA and RA
    • created new project based on FA – FinancialAssistant4
      • moving RA stuff to FA4
    • moved database specific stuff from RA to MySQLIf4
    • compiled and ran, checked in as FinancialAssistant4

Phil 10.3.13

8:00 – 9:00 SR

  • Checking to see if Lenny can come over and help, since he’s stuck at home.
  • Doing some research into the new Flash applications

9:00 – 4:00 FP

Dong Shin 10.03.2013

  • working on RA
    • creating Invoice Viewer for Requisitions – done, need to discuss what additional functionalities are needed.
    • Contract Number in Invoice Entry is TextInput now
    • added support for typing in commas and decimals
    • working on defaults table for AddableListCombo
      • addable_combobox_defaluts table
    • found a way to put log4j server logs to mysql database

Dong Shin 10.02.2013

  • keeping track of what to deploy at https://viztales.wordpress.com/to-deploy-whenever-they-are-ready/
  • working on script to update Obligations/Outlays for EA’s 
    • created and ingested test data – Contracts Example.xlsx
    • set up projects for EA’s
    • query to get contracts data mapped to EA’s
      • SELECT *
        FROM budget_centers bc
        LEFT JOIN budget_center_contracts AS bcc ON bc.uid = bcc.budget_center_id
        LEFT JOIN contracts_cognos AS cc ON cc.sub_budget_center = bcc.sub_budget_center
        AND SUBSTRING(cc.requisition_id, 5) = bcc.requisition_id
        WHERE bc.req_type = ‘EA’
    • updated obligation_outlays_queries.sql
    • updating update_obligations_outlays.py to update!
    • fixed get_cognos_outlays query to use expensed_date, not committed_date

Phil 10.2.13

8:30 – 10:30 SR

  • Working out a plan with Dong about what to do with our time. I’m guessing that the shutdown will last until at least Oct 17. The following is for the rest of this week:
    • Fix Script to add EA Cognos data plus autofill  (Obligations_outlays)
    • enter Contract Number in Invoice Entry (RA)
    • allow commas, periods in data entry (RA)
    • add Invoice Viewer in RA for the selected Req
    • Get all code up and running on FGMDEV
    • Drop maven and go to eclipse-based projects
    • Default combobox capability.
    • Create an “table_errors” table that has the application, user, date, time, query and error message, and take out the “Mail to Admin note”
  • For next week, add #include for python module storage and assembly.

10:30 – 4:30 FP

  • Finished Annotated Bibliography. Experimental design is next.

Dong Shin 09.30.2013

  • working on Query Builder
    • modifying Obligation/Outlay update scripts to update EA Req’s
  • added Database Management Panel to FA
    • added database name to the setUpModel.xml – was using hardcoded project_portfolio
  • fixed Capability not showing in ReqAssistant

Dong Shin 09.27.2013

  • deployed new FA and SQL Query to update obligations/outlays
    • Sub Projects working, list of projects shown
    • update query works!
  • cleaned up tables that uses AddableListCombo – with Lenny’s input
    • set defaults for some comboboxes…. table with table name, default value, and editable?

Phil 9.27.13

8:00 – 11:30 SR

  • Parent projects can only be created if there are no REQ’s. If there are, pop up a dialog that says REQ’s must be eliminated. A parent project has no visible REQ tab.
  • Add table_combobox_defaults with 3 columns 1) Editable, 2) Default value, 3) Table name
  • Unresolved discussion about REQ tracking discussion with Lenny.
  • Timesheets.

11:30 – FP

  • More paper

Dong Shin 09.26.2013

  • no meeting today….
  • Sub Project bugs
    • Requisition Data saves to the parent project (not clearing?) – fixed
    • Select Sub Project in Link Project shows empty list – cannot duplicate here….
  • added obligation/outlay goals and values percent for all months. This can be filtered by selecting month from the month combobox
  • working on updating Obligations/Outlays with maximum values in current and past months
    • UPDATE obligations_outlays_test
      SET month_2 = GREATEST(IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_3 = GREATEST(IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_4 = GREATEST(IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_5 = GREATEST(IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_6 = GREATEST(IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_7 = GREATEST(IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_8 = GREATEST(IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_9 = GREATEST(IF(ISNULL(month_9), 0, month_9), IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_10 = GREATEST(IF(ISNULL(month_10), 0, month_10), IF(ISNULL(month_9), 0, month_9), IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_11 = GREATEST(IF(ISNULL(month_11), 0, month_11), IF(ISNULL(month_10), 0, month_10), IF(ISNULL(month_9), 0, month_9), IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
      month_12 = GREATEST(IF(ISNULL(month_12), 0, month_12), IF(ISNULL(month_11), 0, month_11), IF(ISNULL(month_10), 0, month_10), IF(ISNULL(month_9), 0, month_9), IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1))
      WHERE type = ‘Reported FACTS Obligated $:’ OR type = ‘Outlay $ (Reported in FACTS)’

Phil 9.25.13

8:00 – 1:00 SR

  • Backups
  • Got my permissions straightened out in Xacta!
  • Deploying new FA with DB changes today
  • Tangie needs status reports by next Tuesday
  • Create an “table_errors” table that has the application, user, date, time, query and error message, and take out the “Mail to Admin note”
  • Project Budget info has scroll bars. It needs tooltips instead
  • Budget info needs to be cumulative – i.e. add the current month to the previous month inside the Cognos script;