Category Archives: VISIBILITY

Dong Shin 06.20.2012

  • fixed a bug not copying Financial Mitigation Plans properly on Duplicate Projects
    • server code changed
    • DBUpdateSQLs06202012.sql for database update
  • changed Copy Project to Copy Project Config to eliminate confusion with Duplicate Project
  • added Duplicate Project menu item to the main menu
  • changed FundingRequest selection to AdvancedDataGrid to have multiple columns sorting capability
  • working on filtering Funding Request

Mike 6.19.2012

  • Server backups at site
  • Scanned and deployed an update to PPM that added the duplicate copy feature
  • Tested the feature on the integration machine before moving to the test server
  • Demonstrated to Carla, Lenni, and Jessica how it works
  • Emailed a few or Carla’s users who were having problems, apparently they have not been granted network access which I cannot fix
  • Exported a list of all existing funding requests per Jessica’s request
  • Tried to deploy the auto-login PKI feature of visibility to the integration server but there were too many mismatches between the database, the server code, and the client, need a fresh complete version.  I’ll deploy this at the same time as the chart updates
  • Tested the chart updates some more, seem ready to go in
  • Worked with Dong to produce a few queries that will be used in visibility scripting to make some reports
  • Building and burning to a CD copies of visibility and visibilityScripting

Dong Shin 06.18.2012

  • added copyProject to PPM Server that copies complete set of project data
  • added Duplicate Project to PPM client to support the copyProject functionality
    • tested and checked in
    • ready for deployment
    • database updates – DBUpdateSQLs06152012.sql

Mike 6.18.2012

  • Server backups at site
  • Compiled and tested the pki auto login functionality on the integration server.  It worked for me and Jessica. I could theoretically move it to the ‘production’ server whenever.  I don’t THINK it would lock anyone out.
  • Moved the charting package code from a sandbox project to maven flex library then compiled and deployed it.
  • I had to make some changes because it was compiling with Flex 4 and now Flex 3 to be compatible with Visibility.
    • This resulted in a few bugs and binding problems.  I think I have most of them worked out but want to test some more.

Mike 6.15.2012

  • Scan and deployed a new version of PPM:
    • fix to copy project foreign key problem
    • fix to log in / out problem
    • fix to comments now showing up when the user who made them was deleted
  • Server backups
  • Came up with a planned solution for the copy project problem, Dong is working on it
  • Installed tomcat at my new desk inside
  • Started work on the internal PKI library for the auto log in feature
  • More work on Charts:
    • The drag and drop thing was a pain but I have it working now, just minimal effort left on the package itself, then integration work to do

Dong Shin 06.15.2012

  • Copy Project capability wouldn’t quite do the jobs users wanted to do because it doesn’t copy of the monthly financial data. We proposed that another functionality to copy/duplicate entire project data.
  • working on duplicating project data
  • changing database structure and logging in to DBUpdateSQLs06152012.sql
  • copy a project
    • INSERT INTO projects (
      project_number, title, exec_summary, description, location, begin_year, end_year,
      total_budget, proj_mgr_login, proj_admin_login, portfolio_mgr_login, portfolio_admin_login,
      priority, services, TRL_start, TRL_current, TRL_end, TCL_start, TCL_current, TCL_end,
      TP_start, TP_current, TP_end)
      SELECT project_number, title, exec_summary, description, location, begin_year, end_year,
      total_budget, proj_mgr_login, proj_admin_login, portfolio_mgr_login, portfolio_admin_login,
      priority, services, TRL_start, TRL_current, TRL_end, TCL_start, TCL_current, TCL_end,
      TP_start, TP_current, TP_end
      FROM projects
      WHERE uid=0

Mike 6.14.2012

  • Scan and deployed updates
    • Security banners
    • various fixes by Dong
    • Login screen password change fix
  • Server backups
  • Dumped a project user list for James Murphy
  • Sorted out an issue with Christine G. not being able to see projects in PA
  • Weekly status meeting
  • Moved pki web filter project inside
  • Fixed an issue that was preventing people from being able to log back in to PPM after logging out
  • More work on charting package:

Dong Shin 06.14.2012

  • weekly status meeting @ Fort
  • trouble-shooting
    • cascade problem – caused by new fields added (funding_type, org, location)
    • Comments not showing – deleted user
  • bug fixes
    • Copy Projects
    • View Comments to show all the comments

Dong Shin 06.13.2012

  • issues at the site
    • using sub projects to limit what users can see
    • copy project generates error – some cascading error, but can’t duplicate it on mine.
    • users having problems viewing projects assigned to – fixed
  • getting error when logged out and try to log back in… and the login screen locks up
    • Error logggin in!
      [FaultEvent fault=[RPC Fault faultString=”[MessagingError message=’Destination ‘PPMUserService’ either does not exist or the destination has no channels defined (and the application does not define any default channels.)’]” faultCode=”InvokeFailed” faultDetail=”Couldn’t establish a connection to ‘PPMUserService'”] messageId=”C6D2C3B1-E087-9059-0A89-E669D5CDC239″ type=”fault” bubbles=false cancelable=true eventPhase=2]
  • fixed projects not showing for users in PPM
    • SELECT projects.*, projects.uid as ID, projects.project_number as ‘Project ID’, projects.title as ‘Project Name’, begin_year as ‘Start FY’, end_year as ‘End FY’, begin_year as startYear, IF(ISNULL(lock_id), if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), IF (lock_id=’dongshin’, if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), ‘LOCKED’)) as Status, (end_year – begin_year) as duration, CONCAT(o.first_name, ‘ ‘, o.last_name) AS ‘Project Mgr’, CONCAT(a.first_name, ‘ ‘, a.last_name) AS ‘Portfolio Admin’,  CONCAT(o.first_name, ‘ ‘, o.last_name) AS projMgrName, CONCAT(b.first_name, ‘ ‘, b.last_name) AS ‘Project Admin’, CONCAT(c.first_name, ‘ ‘, c.last_name) AS ‘Portfolio Mgr’, services, o.unclass_phone as projMgrPhone, o.unclass_phone_ext as projMgrPhoneExt, o.JWICS_email as projMgrJWICSemail, o.SIPR_email as projSIPRemail, o.unclass_email as projUnClassEmail, CONCAT(c.first_name, ‘ ‘, c.last_name) AS projSupervisorName,  c.unclass_phone as projSupervisorPhone, c.unclass_phone_ext as projSupervisorPhoneExt, c.JWICS_email as projSupervisorJWICSemail, c.SIPR_email as projSupervisorSIPRemail, c.unclass_email as projSupervisorUnClassEmail, projects.total_budget as ‘Total Budget’, sub.project_id as parent_project_id, sub.sub_project_id FROM projects
      LEFT JOIN _project_sub_projects as sub ON uid = sub_project_id
      LEFT JOIN users AS o ON projects.proj_mgr_login = o.login
      LEFT JOIN users AS a ON portfolio_mgr_login = a.login
      LEFT JOIN users AS b ON proj_admin_login = b.login
      LEFT JOIN users AS c ON portfolio_admin_login = c.login
      WHERE (projects.proj_mgr_login = ‘dongshin’ OR projects.portfolio_mgr_login = ‘dongshin’ OR projects.proj_admin_login = ‘dongshin’ OR projects.portfolio_admin_login = ‘dongshin’)
      OR (projects.uid in (SELECT project_id FROM _projects_portfolio_mgrs WHERE login = ‘dongshin’))
      OR (projects.uid in (SELECT project_id FROM _projects_portfolio_admins WHERE login = ‘dongshin’))
      OR (projects.uid in (SELECT project_id FROM _projects_service_finance_pocs WHERE login = ‘dongshin’))
      OR (projects.uid in (SELECT project_id FROM _projects_service_project_mgrs WHERE login = ‘dongshin’))
  • fixed View Comments button not enabling after adding comments

Mike 6.12.2012

  • Server backups
  • Got another request on how to hide select budget centers from finance POCs while letting them see others, unfortunately the system was not designed that way so the only answer still seems to be sub-projects
  • Sent an email out the other 3 users having issues:
    • One responded that it was working now and he can also help someone else he works with
    • no response yet from the 3rd
  • Tested copying a project to create a sub-project, got a database error
  • Need to add some kind of banner or block to prevent users from getting on the test server since the URLs are so similar
  • More work on the charting package:
    • All the series specific configs are done
    • Just need a drag and drop interface for managing sets and z-order or series

Mike 6.11.12

  • Scanned and deployed the latest version of the PPM documentation
  • Server backups
  • There was an issue with users assigned as ‘Service Finance POC (site)’ not being able to see projects in PA.  Changing them to ‘Project Managers (site)’ resolved the issue
  • Drafted a simple retro-active requirements list.  Jessica and Bill are going to revise them and hopefully we can come to a list to agree on.
  • added security banners to ppm and pa, loaded from config file
  • More work on the charting stuff:
    •  the chart itself is done, it can read in an xml config and write one out.
    • The basic chart config options are done
    • Adding/removing series are all done
    • The only series where you can choose specific options (color, shape, etc.) is LineSeries
    • Need to finish specific config options for other series
    • Need to create a drag/drop tree for configuring series sets (stacked columns, areas, etc.)  Also allows the user to pick z order of the series

Dong Shin 06.11.2012

  • fixed ProjectManagement panel messing up projects grid when filter is applied; AdvancedDataGrid requires IHierarchicalCollectionView
  • investing Comments now showing up properly – working properly, need to check at the site.
  • looking at adding status/progress bar to panels