Category Archives: VISIBILITY

Phil 8.20.12

8:00 – 4:30 ESSO

  • Backups and such
  • Did some updating as well, or more specifically looked into why updating wasn’t(?) straightforward.
  • Working from home as I wait for the AC guy.
  • Installing FB4.5
    • Main install complete
    • Getting subversion
    • rebuilding my local maven repo
    • Could not get the projects to build. Need to see what’s going on at the Mill, maybe burn the entire workspace and compare.
  • Installing MSVC 2010
    • Done – downloading FP project to verify everything’s working
    • Had to re-point to the same projects (in the *exact* same places, mind you). But all is compiling.
    • The texture and shader folders were not up-to-date. Had to do some scrambling.

Phil 8.17.12

8:00 – 2:30 ESSO

2:30 – 4:00 FP

  • 3:15 Meeting with Dr. Kuber to discuss research opportunities for the interface device

Dong Shin 08.17.2012

  • working at home
  • removed all logins in projects to use relation tables (_projects_…. tables)
    • DBUpdateSQLs08172012.sql
  • changing PPM code to reflect the above
    • save/update projects
    • modified Monthly Financial Data to include the first PM and Admin
    • modified SelectProjectWindow to include the new schema
    • modified PA to work with new table structures

Dong Shin 08.16.2012

  • working at home
  • query to get projects that has same value in previous months
    • SELECT p.project_number, p.title, p.proj_mgr_login,
      c.uid, c.center_number, c.center_name, c.appropriation,
      a.year, a.amount,
      o.*
      FROM projects p,
      budget_centers c,budget_amounts a,obligations_outlays o
      WHERE p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND o.project_id = p.uid AND c.uid = o.funding_id AND o.year_count = a.year
      AND ((o.month_1 = o.month_2 AND NOT ISNULL(o.month_1))
      OR (o.month_2 = o.month_3 AND NOT ISNULL(o.month_2))
      OR (o.month_3 = o.month_4 AND NOT ISNULL(o.month_3))
      OR (o.month_4 = o.month_5 AND NOT ISNULL(o.month_4))
      OR (o.month_5 = o.month_6 AND NOT ISNULL(o.month_5))
      OR (o.month_6 = o.month_7 AND NOT ISNULL(o.month_6))
      OR (o.month_7 = o.month_8 AND NOT ISNULL(o.month_7))
      OR (o.month_8 = o.month_9 AND NOT ISNULL(o.month_8))
      OR (o.month_9 = o.month_10 AND NOT ISNULL(o.month_9))
      OR (o.month_10 = o.month_11 AND NOT ISNULL(o.month_10))
      OR (o.month_11 = o.month_12 AND NOT ISNULL(o.month_11)))
  • no 10:30 meeting
  • created script to generate project data that has same value as previous months – src/main/java/resources/scripts/EqualMonths.py
    • working on passover years
  • need to clean up associated managers in projects, move all the managers to separate table and remove the fields in the projects table

Phil 8.16.12

8:00 – 4:00 ESSO

  • Testing new VSS and server code
  • Need to deploy AccountManager.swf
  • 10:30 Meeting. Deploy VSS after? Nope – still need to change the code so that the entire published list isn’t brought down. Code’s written, but not tested. Waiting until after the meeting
  • Printing out a copy of Dong’s query.
  • Finished fixing PublishedDataPage. Much faster.
  • Burned a copy of the VISIBILITY suite workspace to keep on site.

Phil 8.15.12

8:00 – 4:00 ESSO

  • Added FMPs to the CurrentStatus.py script
  • Backups
  • Uploaded but did not install the most recent versions of software onto the shared disk. Test on Integration, then deploy to Test
  • Updated the FY reports now that the PM Actuals are in
  • Added some slides to Col. Dukes’ presentation

3:00 – 4:00 FP

  • Made some changes to KFVirtualHand to make things a bit more intuitive.

Dong Shin 08.15.2012

  • new query to get the latest FMP’s
    • SELECT o.uid, p.uid, o.project_id, max(fmp.uid) as maxid,
      (SELECT fmp2.financial_mitigation_plan FROM financial_mitigation_plans fmp2 WHERE fmp2.uid = max(fmp.uid) ORDER BY fmp.uid DESC LIMIT 1),
      fmp.obligation_outlay_uid
      FROM obligations_outlays AS o
      LEFT OUTER JOIN financial_mitigation_plans AS fmp ON o.uid = fmp.obligation_outlay_uid
      LEFT JOIN projects AS p ON p.uid = o.project_id
      GROUP BY o.uid
  • new bugs
    • Delete Table in IngestManager deleted Auto Ingest Config?
    • Run Now in IngestManager not working
    • Server Logs in VSS not showing up in the front
  • query to get goals for RDT&E
    • SELECT appropriation,
      SUM(IF(year = 1, obligation_month_1, 0)) as Oct_2012,
      SUM(IF(year = 1, obligation_month_2, 0)) as Nov_2012,
      SUM(IF(year = 1, obligation_month_3, 0)) as Dec_2012,
      SUM(IF(year = 1, obligation_month_4, 0)) as Jan_2013,
      SUM(IF(year = 1, obligation_month_5, 0)) as Feb_2013,
      SUM(IF(year = 1, obligation_month_6, 0)) as Mar_2013,
      SUM(IF(year = 1, obligation_month_7, 0)) as Apr_2013,
      SUM(IF(year = 1, obligation_month_8, 0)) as May_2013,
      SUM(IF(year = 1, obligation_month_9, 0)) as Jun_2013,
      SUM(IF(year = 1, obligation_month_10, 0)) as Jul_2013,
      SUM(IF(year = 1, obligation_month_11, 0)) as Aug_2013,
      SUM(IF(year = 1, obligation_month_12, 0)) as Sep_2013,
      SUM(IF(year = 2, obligation_month_1, 0)) as Oct_2013,
      SUM(IF(year = 2, obligation_month_2, 0)) as Nov_2013,
      SUM(IF(year = 2, obligation_month_3, 0)) as Dec_2013,
      SUM(IF(year = 2, obligation_month_4, 0)) as Jan_2014,
      SUM(IF(year = 2, obligation_month_5, 0)) as Feb_2014,
      SUM(IF(year = 2, obligation_month_6, 0)) as Mar_2014,
      SUM(IF(year = 2, obligation_month_7, 0)) as Apr_2014,
      SUM(IF(year = 2, obligation_month_8, 0)) as May_2014,
      SUM(IF(year = 2, obligation_month_9, 0)) as Jun_2014,
      SUM(IF(year = 2, obligation_month_10, 0)) as Jul_2014,
      SUM(IF(year = 2, obligation_month_11, 0)) as Aug_2014,
      SUM(IF(year = 2, obligation_month_12, 0)) as Sep_2014,
      SUM(IF(year = 3, obligation_month_1, 0)) as Oct_2014,
      SUM(IF(year = 3, obligation_month_2, 0)) as Nov_2014,
      SUM(IF(year = 3, obligation_month_3, 0)) as Dec_2014,
      SUM(IF(year = 3, obligation_month_4, 0)) as Jan_2015,
      SUM(IF(year = 3, obligation_month_5, 0)) as Feb_2015,
      SUM(IF(year = 3, obligation_month_6, 0)) as Mar_2015,
      SUM(IF(year = 3, obligation_month_7, 0)) as Apr_2015,
      SUM(IF(year = 3, obligation_month_8, 0)) as May_2015,
      SUM(IF(year = 3, obligation_month_9, 0)) as Jun_2015,
      SUM(IF(year = 3, obligation_month_10, 0)) as Jul_2015,
      SUM(IF(year = 3, obligation_month_11, 0)) as Aug_2015,
      SUM(IF(year = 3, obligation_month_12, 0)) as Sep_2015
      FROM `obligations_outlays_goals`
      WHERE  appropriation LIKE ‘RDT&E%’
      GROUP BY appropriation

Dong Shin 08.14.2012

  • spent some time at Fort preparing for Col. Duke’s presentation
    • alerts when a PM Actuals have stayed the same from one month to the next
    • alerts when COGNOS data (for a specific PFR or grouping of funding (budget centers)) has stayed the same from one month to next
    • add FMP to CurrentStatus.py
      • add this query to
      • SELECT o.uid, fmp.uid, fmp.obligation_outlay_uid
        FROM obligations_outlays as o
        LEFT OUTER JOIN financial_mitigation_plans as fmp ON o.uid = fmp.obligation_outlay_uid
        GROUP BY o.uid
  • VisibilityScripting bugs
    • scripts are not deleted by delete button
    • scripts persists after they are delete in the DB
  • checked in the latest VSS code that had delete script support

Phil 8.13.12

8:00 – 4:30 ESSO

  • Put in the cleaned-up scripting client. Much faster. It’s still slow when it downloads published data. Need to look into that.
  • Need to add a warning dialog to AccountManager that warns to rebuild roles when roles are deleted. Had a fright with that today.
    • Working on getting the Alert listener to behave…
  • Put together slide show with Jessica. Need to add some scripts tomorrow to fill out presentation

Phil 7.9.12

8:00 – 5:00 ESSO

  • Dong says that the problem was that ‘courier’ isn’t available of windows. You have to use ‘courier_new’. That does explain why everything was working, yet not working…
  • Weekly meeting
  • Jessica and I have XACTA accounts now, but with read only roles. Denise is going to work on this.
  • One more training down, about three to go.
  • Writing up a justification for more than one FTE after October 1. Instead of doing FTE work.
  • Burning a new copy of VSS4 now that the font problem has been licked.
  • Wrote up a screed on VISIBILITY staffing for Jim Griffie

Phil 7.8.12

8:30 – 4:30 ESSO

  • The contractors punched a hole in my roof today. Got to see the neighborhood from waaay up high. Pretty cool.
  • Backups
  • Denise is going to put Jessica and I in for xacta(?) accounts
  • Made progress through the yearly training. Funny thing, after I started, I could hear someone else doing theirs as well. Need to bring in earphones though – it’s a noisy office.
  • Need to burn some images for Brian.
  • Need to fix the VISIBILITY website. People are interacting with the links wrong, so I’m going to change the links to make the pages match the actions. I’m installing Adobe Creative Suite so that I can use the project. I wonder if Coldfusion can check out from subversion? Nope.
  • Checked out Visibility from Documentation. Going to try DreamWeaver on it.
  • I think I opened the correct project, but it does have some Ipsum Lorem in it…
  • Highlighted fields for PPM and PA should reflect that users are entering data for the previous month. “Past Due” should reflect the 10th day (possibly the 17th) in PA
  • Working on VSS4, trying to figure out why the fon’t isn’t courier. It comes in OK, just is never set in PrettyTextEditor.as. Wondering if ApplyFormatOperation is the culprit? I think I may need to build a small sandbox project to try out.

Dong Shin 08.08.2012

  • changed VisibilityScripting4 to embed AS3Dictionary.xml and SmartEditor.css
  • fixed FlexUtils not showing Compilation Date correctly
  • working on users’ project status script…
    • query to return all project mgrs with overdue data
      • created CurrentMonthOverdueUsers.py – in VS4 resources/scripts directory
      • SELECT m.login as user_login, p.project_number, p.description, a.amount, o.uid, o.type, o.year, o.year_count,
        o.month_11 as ‘Aug’
        FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o, _projects_service_project_mgrs m
        WHERE p.uid = c.project_id
        AND a.budget_center_id = c.uid
        AND a.year = 2012 – p.begin_year + 1
        AND o.project_id = p.uid
        AND o.funding_id = c.uid
        AND o.year + o.year_count – 1 = 2012
        AND o.year_count = 1
        AND ISNULL(o.month_11)
        AND p.uid = m.project_id
        UNION
        SELECT p.proj_mgr_login as user_login, p.project_number, p.description, a.amount, o.uid, o.type, o.year, o.year_count,
        o.month_11 as ‘Aug’
        FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o
        WHERE p.uid = c.project_id
        AND a.budget_center_id = c.uid
        AND a.year = 2012 – p.begin_year + 1
        AND o.project_id = p.uid
        AND o.funding_id = c.uid
        AND o.year + o.year_count – 1 = 2012
        AND o.year_count = 1
        AND ISNULL(o.month_11)
        AND NOT ISNULL(p.proj_mgr_login)

Phil 8.7.12

8:00 – 2:00 ESSO

  • Made backups
  • Looks like the test plan is good enough for Vern. Jessica is sending it off to Denise
  • New data uploads on Friday. We’ll see how the reports look
  • Finished with scroll bars in SeriesConfigBase.
  • Wrote up monthly status report

2:00 – 6:00 FP

  • Bringing the prototype to PAD meeting
  • Demo went well – Shawn thinks that the “sensorator(?)” “haptor(?)” (sensor/actuator) might be the best thing to build the paper out of. The trick would be to show a bunch of uses and focus more on the driver(s).

Dong Shin 08.07.2012

  • added “No Email” for the users with no email address when generating Financial Data Request
  • removed EdgeUtils from VisibilityScripting4
  • working on query to generate user, project, description, status, and month (for the last 4 months maybe?) as rows
    • query to extract current year and fiscal month
      • SELECT DATE_FORMAT(CURRENT_DATE(), ‘%Y’) as year,
        IF(DATE_FORMAT(CURRENT_DATE(), ‘%m’) – 9 < 1,
        DATE_FORMAT(CURRENT_DATE(), ‘%m’) + 3, DATE_FORMAT(CURRENT_DATE(), ‘%m’) – 9 ) as month
    • query to find missing August entries
      • SELECT p.begin_year, a.*, o.uid, o.type, o.year, o.year_count,
        o.month_11 as ‘Aug’
        FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o
        WHERE p.uid = c.project_id
        AND a.budget_center_id = c.uid
        AND a.year = 2012 – p.begin_year + 1
        AND o.project_id = p.uid
        AND o.funding_id = c.uid
        AND o.year + o.year_count – 1 = 2012
        AND o.year_count = 1
        AND ISNULL(o.month_11)
        AND p.uid = 99