Phil 7.5.12

7:30 – 4:30 ESSO

  • Submitted request for Microsoft Baseline Security Analyzer
  • Spent some time with Jessica R. Going over charts for Col. Dukes. Tried to make sets, but D&D didn’t work. Behaves on my machine though.
  • Worked on adding fixes to FlexiChart. My version of Eclipse is locking up with creation complete periodically.
  • List of fixes
    • Data Field combobox needs to expand to fit longer names. Also adding tooltips
    • Need to update the documentation for FlexiChart
    • Only FACTS data should be hidden from non-admins
    • Desire to be able to promote/demote parents and children. It should be possible to promote a child to a parent and demote its parent to a child role
    • Need to see all parent/child budgets in project summary view
    • Change FACTS query so that spending lines continue rather than go to zero.
  • Wrote up progress report for June

Phil 7.3.12

8:00 – 2:30 ESSO

  • Got all of Mike’s dev stuff from his various flippsers
  • Changed the TestServlet so that it’s fired in Visibility3 rather than VisibilityScriptingServer. Added an html redirect file to the VisibilityScriptingServer directory (TestServlet/index.html), so that the documentation doesn’t have to be changed.
  • Deleted fgm-security-pki project from my workspace. It really didn’t want to go – I had to quit eclipse, delete the folders, then restart eclipse and delete the ghost of the project
  • Added fgm-security-pki back in from svn. This time, I disconnected the maven nature, ran eclipse:eclipse in mvnAssist, and not the project appears to work correctly.

2:30 – 4:00 FP

  • PAD meeting

Phil 7.2.12

8:00 – 4:00 ESSO

  • Had to redo my PKI again this morning. At least I’m getting good at it.
  • Rewrote the backup script so that it uses mvPlusDate.exe. It seems to be running OK
  • Talked to Mike about transferring the effort over. It looks straightforward to implment an acceptable security plan, and Bill D. seems to be taking lead on this. If not, then I can put together a matrix that references the documentation.
  • Reading the documentation
  • Downloaded the new FlexiChart but I haven’t tried it yet.
  • Asked Mike to document his maven artifact svn version number appender, which he has done and checked into his sandbox.

Dong Shin 07.02.2012

  • added Vis Tool Wish List to the PPM Requirememts page
  • PPM bug fixes
    • removed Close button and Cancel Button in Financial Mitigation Plan window (forces save so that it can be retrieved and added later)
    • invoices can be opened for PM Actuals Outlays onlye (double click)
    • disabled invalidHandler in FundingRequestForm
    • filter works in DBMgmtPanel
    • Project Comments returned in descending date_time order
    • set cascading for all _projects users tables

Mike 6.29.2012

  • SSP this morning at site, several things that will be required to move to production:
    • Run GPResult.exe on the server – this is already installed on the server
    • Run MBSR – controlled software from the depot
    • Make sure IAVAs are up to date
  • Put in a request to download MBSR
  • Daily backups
  • Ran GPResult, real easy, I will show Phil how next week
  • Finished up the FY11 summary report
  • Emailed some more info to Phil, a summary of recent events/people and the ‘wish list’
  • Back at the mill cleaning up my computer and desk

Dong Shin 06.29.2012

  • SSP meeting @ Fort
  • Bugs
    • all _projects* tables need to have cascade set – added to the bugs page
  • trouble shooting Yearly Totals DataGrid rendering problem….
    • Doh! can’t have uid in value objects!!!!! it’s reserved!!!!

Mike 6.28.2012

  • Weekly Vis tool status meeting
  • server backups at site
  • Deployed a new version of PPM and PA with improved data entry and searching functionality
  • Fixed a problem with VisibilityScripting by deploying a new version
  • Ingested the result of my FY11 SQL script and starting making the FY11 summary report
  • SSP meeting rescheduled for tomorrow at 0730.

Phil 6.28.12

8:00 – 4:00 ESSO

  • Got my PKI certs behaving correctly – maybe.
  • Meeting with Jessica, Mike and Dave W. Some discussions about priorities. Because of budget issues, the highest priority goal is to have everything running on the production server. This means that a test plan that (who?) will sign off on needs to be written and evaluated. This also means that some code that would be desired probably won’t get written.
  • My slightly re-coded version of VisibilityScriptingServer worked out of the box, no debugging required.
  • IngestManager couldn’t access the SSL xml exposed by the publisher servlet. We changed the Tomcat web.xml to open up http on port 80 so that the IngestManager wouldn’t have to use SSL. Since port 80 is only visible behind the firewall, this is probably kosher, if not optimal. May need to spend some time seriously grocking 2-way SSL. Either that or write a test plan.
  • PPM Bugs for today (full list is here)
    • Financial Mitigation Plans cannot be opened for previous entries when skipped
    • Invoices cannot be opened
    • filter not working in Database Mgmt panel
    • sometimes Funding Request Save button not enabled

Dong Shin 06.28.2012

  • Weekly status meeting at Fort
  • Deployed the latest PPM
    • last login not working – test with auto login disabled
  • Bugs
    • Financial Mitigation Plans cannot be opened for previous entries when skipped
    • Invoices cannot be opened
    • filter not working in Database Mgmt panel
    • sometimes Funding Request Save button not enabled
  • continue working on Total Budgets – done!
    • changed YearlyTotalDataGrid to AdvancedDataGrid for styleFunction
    • rearranged columns
      • budget gets stored in database
      • allocated calculated from total
      • available = budget – allocated
  • updated requirements/bugs page

Phil 6.27.12

8:30 – 4:30 ESSO

  • Bad traffic on 95 this morning.
  • The PublisherServlet isn’t working on site. Setting it up for non-server debugging
    • Done. The PublisherServlet now has a main that lists all published tables and then the contents of a default table or one defined on the command line.
    • Found one potential bug. The ending date comment was not explicitly converted using toString(). It’s possible that might have had an effect?
    • Testing the servlet in Tomcat. Looks like it’s working. Need to burn a disk.
  • Downloaded, de-mavenized and updated ProjPortfolioMgrClient and ProjectAssistant.
  • Updated PPM database

Mike 6.27.2012

  • Server backups at site
  • Looked more in to the vis scripting bug.  The error is not appearing in the database so it is somewhere in the servlet that hosts the xml.
  • Delivered the weekly status to Jessica.
  • Out this afternoon for a doctor’s appt.

Dong Shin 06.27.2012

  • continue working on Project Totals display
    • insert/update queries..
    • save / update / retrieve working
  • added filtering for Sub Project selection window
    • filter on Project ID and Project Name
    • adjusted sub project selection queries to find the start and end year that falls within the parent
      • SELECT uid, project_number as projectID, title as projectName, begin_year as startFY,
        end_year as endFY, total_budget as totalBudget, 0 as isSelected
        FROM projects
        WHERE uid NOT IN (SELECT project_id FROM _project_sub_projects)
        AND uid NOT IN (SELECT sub_project_id FROM _project_sub_projects)
        AND begin_year >= (SELECT begin_year FROM projects WHERE uid = 102)
        AND end_year <= (SELECT end_year FROM projects WHERE uid = 102)
        AND uid <> 102
  • helped Phil building PPM
    • need to change Flex Project settings…

Mike 6.26.2012

  • Investigating issue tracking software which could be useful for the visibility project or future projects: reasonable free options are trac and bugzilla
    • Bugzilla is apparently a pain to install but works well for very large projects with lots of user feedback
    • Trac is easier to install and maintain and has great svn integration
    • Jira is the best option but costs $1,400-$4,800 per server
  • Gave a demo to Robert A. over the whole vis suite
  • Meeting this afternoon about the SSP was cancelled
  • There seems to be a bug with the vis scripting publish feature, weird characters are being appended to the beginning of the xml.  Appears to only be occurring at site.

Dong Shin 06.26.2012

  • working on Project Totals display
    • need new table – yearly_totals
      • # create new table yearly_totals
        CREATE TABLE `yearly_totals` (
        `uid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
        `project_id` INT NOT NULL ,
        `fiscal_year` INT NOT NULL ,
        `allocated_amount` DOUBLE NOT NULL ,
        INDEX ( `project_id` )
        ) ENGINE = InnoDB;ALTER TABLE `yearly_totals` ADD FOREIGN KEY ( `project_id` ) REFERENCES `project_portfolio`.`projects` (
        `uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
    • created DataGrid to display the yearly totals