Category Archives: VISIBILITY

Dong Shin 09.12.2012

  • deployed new PPM and updated the sub projects with $0 totals. Appears to be working fine, but refresh in Project Mgmt still misbehaves
  • continue setting up the desktop for development
  • organizing and checking in all sandbox projects to SVN
  • meeting w/ JR on Alerts
    • Alerts requested
      1. Mitigation Strategy doesn’t change from month to month
      2. Plan differs from actuals by certain %
      3. Data missing on certain month
      4. not obligated within certain #(30) days after acceptance
      5. not accepted within 30 days
    • JR will write up requirements

Phil 9.11.12

8:30 – 2:30 ESSO

  • Deployed new PPM
  • Backups
  • Fixed the problem with VSS’s testServlet. It was the lack of needed jars
  • Some back and forth with Denise P. We might have our production Server?
  • Jessica will probably come over tomorrow afternoon for alert discussions
  • Working on GWT.

2:30 – 4:30 FP

  • Qualitative methods

Dong Shin 09.11.2012

  • new bugs
    • totals for sub projects still not working
    • Total Budget in Project Management panel doubles for sub projects
    • incomplete (missing Budget Center/MIPR) sub projects don’t show in the parent project
    • Funding Request selection needs to be expandable/resizable
    • Funding Request needs save confirmation on window close
    • need search capability in Database Mgmt panel
  • fixed Total Budget not showing correctly
    • use following query to find and remove duplicates
    • SELECT GROUP_CONCAT(uid) as duplicates FROM `yearly_totals` WHERE 1
      GROUP BY project_id, fiscal_year
      HAVING count(*) > 1
  • updated ChangeLogPanel in EdgeUtils and FGMFlexUtils45 to have variableRowHeight for description column
  • Funding Request select window is now expanable/resizable
  • incomplete sub projects are red in Create Project panel
  • updated query to get sub projects to include incomplete projects
    • SELECT p1.project_number AS projectID, p1.title AS projectName, p2.sub_project_id as subProjectID, p1.begin_year AS startFY, p1.end_year AS endFY, p1.total_budget AS totalBudget, p2.*,
      SUM(IF(a.year=1, a.amount, NULL)) as year1Amount,
      SUM(IF(a.year=2, a.amount, NULL)) as year2Amount,
      SUM(IF(a.year=3, a.amount, NULL)) as year3Amount,
      SUM(IF(a.year=4, a.amount, NULL)) as year4Amount,
      SUM(IF(a.year=5, a.amount, NULL)) as year5Amount,
      SUM(IF(a.year=6, a.amount, NULL)) as year6Amount,
      SUM(IF(a.year=7, a.amount, NULL)) as year7Amount,
      SUM(IF(a.year=8, a.amount, NULL)) as year8Amount,
      SUM(IF(a.year=9, a.amount, NULL)) as year9Amount,
      SUM(IF(a.year=10, a.amount, NULL)) as year10Amount
      FROM projects p1, _project_sub_projects p2, budget_centers c, budget_amounts a
      WHERE p2.project_id = 177 AND p2.sub_project_id = p1.uid  AND c.project_id = p2.sub_project_id  AND c.uid = budget_center_id  GROUP BY c.project_id
      UNION
      SELECT p1.project_number AS projectID, p1.title AS projectName, p2.sub_project_id as subProjectID, p1.begin_year AS startFY, p1.end_year AS endFY, p1.total_budget AS totalBudget, p2.*,
      0 as year1Amount,
      0 as year2Amount,
      0 as year3Amount,
      0 as year4Amount,
      0 as year5Amount,
      0 as year6Amount,
      0 as year7Amount,
      0 as year8Amount,
      0 as year9Amount,
      0 as year10Amount
      FROM projects p1, _project_sub_projects p2
      WHERE p2.project_id = 177 AND p2.sub_project_id = p1.uid  AND p2.sub_project_id NOT IN
      (SELECT c.project_id FROM budget_centers c)

Phil 9.7.12

8:00 – 3:00 ESSO

  • Backups
  • Deployed new versions of PPM and PA. With bonus fixes – go, Dong!
  • Made a new script that produced a table of users for the pre FY13 data for visualization
  • Deployed test GWT code on the integration server. Works with Firefox and IE7 including server access, so we’re good.
  • Helped Jessica with her pursuit of various roles.

Dong Shin 09.07.2012

  • deployed new PPM and PA!
    • Len reported many incorrect/inconsistent Total Budget calculations between PA and PPM, but new PA fixed it!
  • tested GWTLoggerTest app on site. works in IE7, but need to convert it to GXT,, stay away from SmartGWT!
  • added more fields to BudgetCentersWindow in Financial Status, fixed Total
  • confirmed Total Allocated is correct in Project Mgmt panel.

Phil 9.6.12

8:30 – 2:30 ESSO

  • Backups
  • Found out the bug with the VSS facade. Some jar files were missing. Not tested yet, but I’ll try tomorrow morning
  • Looks like Alerts are next on the agenda of new code development. I’d like to do this in GWT, but we need to see if that will run on our servers
  • Working on GWT, with an eye towards making the Alert Manager
    • Creates scripts using drag and drop that are then run by the Scripting Engine
    • Created alerts are visible in PPM and PA
    • Hooks for email support. We can at least show that running off of fgmdev, and maybe the PROD machines will let us do that?

2:30 – 4:30 FP

Dong Shin 09.06.2012

  • fixed Project Mgmt panel refresh problem
    • added refresh to onPanelMaximize, removed refresh from Save event handler
  • fixed Role Mgmt for view_only_associated_data
    • DBUpdateSQLs09062012.sql
    • changed project list retrieval routines to use the field
    • pre-sorted Action field
  • working through the existing GWT projects
    • most fails to run! Ugh
    • GWTLoggerTest runs. packed it up as war, will try it on site tomorrow

Phil 9.5.12

8:30 – 4:40 ESSO

  • Backups,
  • Meeting about staffing.
  • Adding the test servlet and filter back to VSS. Something’s still not right. I need to check that the filter facade is behaving correctly.
  • Rebuilt the GWT intro app, but with the default code. That works, so the browser plugins are working too.

Dong Shin 09.05.2012

  • status/staffing meeting
  • bugs
    • add more info (Budget Center/MIPR) for Financial Status Data selection
    • the current year seems incorrect in Financial Status Data
    • % calculation seems incorrect
    • make sure Total Allocated in Project Management panel are correct
  • meeting with WOTI folks at NBP

Phil 9.4.12

8:30 – 2:30 ESSO

  • Backups and discussion of status with Jessica R.
  • Rediscovered how to connect to sourceforge to work with the update site, web pages, etc. This page in particular was really useful.
  • This screenshot might help too:
  • Ok, back to GWT…
  • Gah! Installing the web page editor took forever…
  • Server came up, but I didn’t get the “has been loaded” message in the IDE. Going to try the Firefox plugin tomorrow.

2:30 – 4:30 FP

Dong Shin 08.31.2012

  • added Document Number in Funding Request Select window
  • Two problems reported
    1. SQL Error from Chris Gawdun – old version error, newly deployed PPM has the fix
    2. Sub projects showing 0 for Total Allocated – unable to duplicate here.
  • sent updated bugs list that JR maintains – fixed
    • 4. Nothing show under Manage Contracts when you go to the Projects toolbar and then Manage Contracts
      5. There are a few typos in some of the mitigation questions under the OUSD(I) section
      8. Handle Sub__BC problem in BC and scripts
      13. You cannot exit the financial mitigation plans without saving. Someone may just want to cancel without saving
      15. Make the month before the current month highlight pink in the monthly financial data spreadsheet
      16. Make a project past due if data is not entered by the 14th of each month
      17. The invoice form pops up even if the PM actual is zero (in PM, data entry screen)
      18. Allow editing of start year after project creation
      21. Allow editing to end year after project creation
  • Trouble shooting Project Mgmt panel not updating correctly after Project save

Phil 8.31.12

8:30 – 4:30 ESSO

  • Finally got the new version of PPM deployed. I had put the CD in the wrong machine. Which kind of explains why the old one was showing up. D’oh!
  • Data saves.
  • Went to talk to Denise P., but she won’t be back until Wednesday.
  • New bugs:
    • PA has a SQL error when used by Christine G. I have a print out. It may be the same MySqlIF problem that PPM had. Need to check with Dong.
    • Subprojects are only showing 0.00 for Total Allocated. May have something to do with adding people to the project?
  • Adding new Java
  • Finished up and committed the fixed version of MavenAssist.

Dong Shin 08.30.2012

  • weekly status meeting
  • Funding Request save errors – caused by mailing_address_poc_id default set to NOT NULL
    • fixed it on site
    • ALTER TABLE `funding_requests` CHANGE `mailing_address_poc_id` `mailing_address_poc_id` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL
  • Monthly Financial Datagrid has current month set to 14th day of next month – configurable in setupModel.xml