Author Archives: pgfeldman

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

Phil 8.30.12

8:30 – 2:30 ESSO

  • Built and burned new PPM with fixes and scripts
  • 10:30 Meeting
  • Finish up MavenAssist today? Should just be a matter of seeing why the standalone and the plugin don’t work quite the same way…

2:30 – 4:30 FP

  • Qualitative methods, and started thinking about the iRevolution App as my thesis.

Phil 8.29.12

8:30 –  4:30 ESSO

  • Meeting with Jessica – here’s the bug list
    • Make the the month before the current month before the current month highlight in the monthly financial data data grids
    • Make a project past due if it is not entered by the 14th of each month (should be a variable in the DB, setupXML or properties)
    • Invoices pop up even if the PM actual is zero (PPM data entry screen)
    • Allow editing of start year after creation of the project, and for the backwards editing of end years
    • Sub-project incomplete status is not calculating correctly for the (parent?) project. A set of sub-projects apparently entered completely over a period of days flag as incomplete.
    • Add Document number (Found in Funding Request-> Finance Data Tab->Document Number field) amount column to Funding Requests table (Projects->Funding Requests->Modify Funding Request). Column replaces Funding type, and should be the second column.
  • Plus, there was a DB error ‘Unknown column ‘projects.uid’. It strikes me that we could use an Alert that puts the text into a scrollable panel, where we can ask the user to cut-and-paste into an email.

Dong Shin 08.29.2012

  • Bug Fixes
    • enabled Start FY editing on existing projects
    • added SQL Error panel to capture SQL errors for better trouble-shooting
    • disabled Invoice Pop-up when PM Actual is 0
    • set cut-off day of the month is 14th in setupModel.xml
    • fixed SQL error for non-admins on Project Mgmt
  • reinstalled Eclipse Juno and plug-ins – Subclipse 1.8 is not compatible with OS X
  • minor tweaks to VisibilityScripting4
    • made all debug panel always on top
    • sorted published names in PublishedDataPanel
    • expanded publishedFullNameCombo
  • created scripts under src/main/resources/scripts/ in VS4 project
    • to get Current Year Procurement data – Procurement_Data_Current_Year.py
    • to get Current Year RDT&E data – RDT&E_Data_Current_Year.py
    • to get Current Year O&M data – O&M_Data_Current_Year.py
    • to get 2012 O&M data – O&M_Data_2012.py
  • query to get O&M(FY10) data with Obligation/Outlay goals
    • SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      o.type as type,
      IF(o.year_count = 1, month_1, 0) as Oct_2011,
      IF(o.year_count = 1, month_2, 0) as Nov_2011,
      IF(o.year_count = 1, month_3, 0) as Dec_2011,
      IF(o.year_count = 1, month_4, 0) as Jan_2012,
      IF(o.year_count = 1, month_5, 0) as Feb_2012,
      IF(o.year_count = 1, month_6, 0) as Mar_2012,
      IF(o.year_count = 1, month_7, 0) as Apr_2012,
      IF(o.year_count = 1, month_8, 0) as May_2012,
      IF(o.year_count = 1, month_9, 0) as Jun_2012,
      IF(o.year_count = 1, month_10, 0) as Jul_2012,
      IF(o.year_count = 1, month_11, 0) as Aug_2012,
      IF(o.year_count = 1, month_12, 0) as Sep_2012,
      IF(o.year_count = 2, month_1, 0) as Oct_2012,
      IF(o.year_count = 2, month_2, 0) as Nov_2012,
      IF(o.year_count = 2, month_3, 0) as Dec_2012,
      IF(o.year_count = 2, month_4, 0) as Jan_2013,
      IF(o.year_count = 2, month_5, 0) as Feb_2013,
      IF(o.year_count = 2, month_6, 0) as Mar_2013,
      IF(o.year_count = 2, month_7, 0) as Apr_2013,
      IF(o.year_count = 2, month_8, 0) as May_2013,
      IF(o.year_count = 2, month_9, 0) as Jun_2013,
      IF(o.year_count = 2, month_10, 0) as Jul_2013,
      IF(o.year_count = 2, month_11, 0) as Aug_2013,
      IF(o.year_count = 2, month_12, 0) as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays o
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND c.uid = o.funding_id
      AND o.year = 2012
      AND c.appropriation IN (SELECT type FROM appropriations WHERE duration = 2)
      GROUP BY o.type, c.uid
      UNION
      SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      ‘Obligation Goal’ as type,
      a.amount * SUM(IF(g.year = 1, obligation_month_1, 0)) / 100 as Oct_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_2, 0)) / 100 as Nov_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_3, 0)) / 100 as Dec_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_4, 0)) / 100 as Jan_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_5, 0)) / 100 as Feb_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_6, 0)) / 100 as Mar_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_7, 0)) / 100 as Apr_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_8, 0)) / 100 as May_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_9, 0)) / 100 as Jun_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_10, 0)) / 100 as Jul_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_11, 0)) / 100 as Aug_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_12, 0)) / 100 as Sep_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_1, 0)) / 100 as Oct_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_2, 0)) / 100 as Nov_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_3, 0)) / 100 as Dec_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_4, 0)) / 100 as Jan_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_5, 0)) / 100 as Feb_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_6, 0)) / 100 as Mar_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_7, 0)) / 100 as Apr_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_8, 0)) / 100 as May_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_9, 0)) / 100 as Jun_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_10, 0)) / 100 as Jul_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_11, 0)) / 100 as Aug_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_12, 0)) / 100 as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays_goals g
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND g.appropriation = c.appropriation
      AND c.appropriation = ‘O&M (FY10)’
      GROUP BY c.uid
      UNION
      SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      ‘Outlay Goal’ as type,
      a.amount * SUM(IF(g.year = 1, outlay_month_1, 0)) / 100 as Oct_2011,
      a.amount * SUM(IF(g.year = 1, outlay_month_2, 0)) / 100 as Nov_2011,
      a.amount * SUM(IF(g.year = 1, outlay_month_3, 0)) / 100 as Dec_2011,
      a.amount * SUM(IF(g.year = 1, outlay_month_4, 0)) / 100 as Jan_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_5, 0)) / 100 as Feb_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_6, 0)) / 100 as Mar_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_7, 0)) / 100 as Apr_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_8, 0)) / 100 as May_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_9, 0)) / 100 as Jun_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_10, 0)) / 100 as Jul_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_11, 0)) / 100 as Aug_2012,
      a.amount * SUM(IF(g.year = 1, outlay_month_12, 0)) / 100 as Sep_2012,
      a.amount * SUM(IF(g.year = 2, outlay_month_1, 0)) / 100 as Oct_2012,
      a.amount * SUM(IF(g.year = 2, outlay_month_2, 0)) / 100 as Nov_2012,
      a.amount * SUM(IF(g.year = 2, outlay_month_3, 0)) / 100 as Dec_2012,
      a.amount * SUM(IF(g.year = 2, outlay_month_4, 0)) / 100 as Jan_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_5, 0)) / 100 as Feb_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_6, 0)) / 100 as Mar_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_7, 0)) / 100 as Apr_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_8, 0)) / 100 as May_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_9, 0)) / 100 as Jun_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_10, 0)) / 100 as Jul_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_11, 0)) / 100 as Aug_2013,
      a.amount * SUM(IF(g.year = 2, outlay_month_12, 0)) / 100 as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays_goals g
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND g.appropriation = c.appropriation
      AND c.appropriation = ‘O&M (FY10)’
      GROUP BY c.uid

Phil 8.28.12

8:30 – 4:30 ESSO

  • Database backups. I could add a script that walks through the directory listing and deletes all files with similar names that are the same size?
  • Added the login/password restriction to the ProjPortfolioMgrPreFY13 folder. The information on how to login is on the ROOT/index.html page. At this point, you have to really *want* to use the old db. It’s almost impossible to access by accident.
  • Adding browser and manual artifact loading to RepoNav. Browsers are in and load as a sort of failover if the tree can’t load any children. Need to be able to add a text artifact to the dependency tree next. Also I want to be able to show the dependency that’s been selected.
  • Looks like this is done using DependencyComponents.setElement() on line 574. I think we can just make a dummy Dom4j Element and then print it to the Text area.