Category Archives: VISIBILITY

Phil 2.10.11

7:30 – 5:30 VISIBILITY

  • Downloaded Dong’s update on my home machine, but my CD drive just died, and I can’t burn the thing.
  • Good meeting with Trish and Lea(?). The bug fixes appear to be working. We spend some time on small features, and how the email generation should work. Dong has my notes right now, but I’ll add detail later.
  • Meeting with Anne and the CMM folks. Went very well. We’re going to get together again to discuss in more dtail. The possibility appears to be that CMM would like to incorporate VISIBILITY, possibly by sending a RESTful request to the server containing the table to display. We, on the other hand would like to run a set of queries against the CMM data to have more data for VISIBILITY reports. I think we can have both, which might maker everyone very happy.
  • Generalizing the data input, and adding another test to the statistics package. As an aside, CMM is attempting to develop confidence intervals on the data they provide to their users. Hmmm.

Phil 2.9.11

7:30 – 6:30 VISIBILITY

  • Installed new version of PPM. Everything seems to be working, though the meeting to walk through was postponed until tomorrow. The Combobutton is still in
  • Worked on actionscript statistics classes.
    • Completed the Randomized Test
    • Updated the data sources to take user data as well as generating random

Dong Shin 02.08.2011

  • PPM Changes
    • created SelectContractWindow that has filtering/searching capabilities, mapped to Funding Request
    • consolidated many buttons in ProjectMgmtPanel into PopUpButton
      • disabled click, works like ComboBox
    • added support to view Project Status from Main menu
    • fixed Start / End date validation
  • FGMDEV backup
    • dump files still not getting to the server
    • created and configured second script to transfer that runs one hour after the first one – check tomorrow.

Phil 2.8.11

7:30 – 5:30 VISIBILITY

  • Mike Cowan leaves S2F this Friday.
  • Got a few more screenshots from Trish and Christie. Fortunately they have nothing new in them. Dong is still on track for a disk by COB
  • Working on getting RemoteObjectTestbed2 working. This one has no java code in it and has logging. Got both working. Next, projects.
  • Taking a detour into building a few statistics actionscript classes.

Phil 2.7.11

7:30 – 5:00 VISIBILITY

  • Meeting with Trish, Christie, and someone new who I can’t remember right now.
    • Bugs – several, all hopefully having to deal with DB configuration. I gave Dong the screenshots
      • Also, add two more lines under mailing address in funding request
      • Funding request warning dialog has “financial” misspelled as “fianancial”.
      • Add “RTAs” to funding type under “detailed Information” tab
      • Selecting names seems to offer up only 20 or so names. What is the selection criteria? The same list appears for all selection buttons
      • Add check so that no start date be saved that is after an end date
      • The “Add Funding” dialog needs a sortable list for contract number – it’s a very long list. It’s also too narrow – there are some very long contract numbers. Panel is too small as well.
    • Next highest priority is the “email generator” This will produce messages to copy and paste into messages to the Financial and technical POCs
      • Create an email like the one in Funding Request for each POC that has the current financial data that they have to fill in, and the associated forms if they are not on goal
      • Have a list of all projects that the user can move through to create all emails in and easy way
      • List should have a dropdown that lets the user select the year and reporting period. Selecting a time period (FY/Quarter?) will bring up the list of POCs and the status
      • Users should be able to indicate the state of the contact:
        • Nothing done
        • Email sent out
        • Response back
        • Response entered – incomplete (if a goal has not been met and there is no justification, this should be flagged automatically. There may be an additional button if this is the case that asks the POCs for justifications
        • Response entered – complete
    • Status panel notes:
      • PPM calculated outlay should be a “checksum” of numbers. The true PM Actual Outlay needs to be entered by hand
      • Available balance is the percentage of the “last remaining to distribute” divided by the total budget
      • Goals are calculated as the total budget times the “out year” in the appropriation
  • Worked on migrating DbObject classes out of the sandbox and into the utils jars/swcs

Phil 2.4.11

12:00 – 6:00VISIBILITY

  • GREs this morning
  • Working on InfoObjectManager.as
  • Got an overview of the new PPM capability from Dong so that I can talk intelligently to Christie and Trish on Monday
  • Interview at 4:00
  • More InfoObjectManager.as. I think I have the actionscript side working.

Dong Shin 02.08.2011

  • FGMDEV backup
    • still missing database dump files….
    • modified the script to tar up the dump files and transfer, check tomorrow
  • PPM Changes
    • FinancialStatusDataGrid acting weird… Could not select anything other than last one. Turned out the uid field in the class causing it. Had same uid’s populated on the data. Changed it to dataUid, works now….
    • Errors reported on the latest deployed version
      • changed Create Project to set program_element and FACTS_PE fields to NULL for existing data
      • updated server code to remove INSERTs
    • Fixing bugs
      • Funding request warning dialog has “financial” misspelled as “fianancial”.
      • Removed limit of data in Names list  – had 100 entries
      • Increased width of Contract Number in Direct Cite Window
      • added RTAs to Funding Type
      • check for Start Date and End Date, also disables dates based on selection
      • working on SelectContractWindow

Dong Shin 02.04.2011

  • FGMDEV backup…
    • mysql dump files missing again…. runs fine on command line. capturing output of cron job.
    • adjusted the script a bit, check again tomorrow.
  • Assisted Christine with Maven and Flex projects
    • went thru AccountManagers, EdgeUtils2, and IngestMananger
    • old projects use flexmojos-maven-plugin 3.2.0, we are using 3.8 now. 3.2.0 is not available at sonatype.org, we just have local server copy at fgmdev.com
    • old projects have duplicate entries for com.adobe.flex:license:3.2.0.3958 causing MavenAssist to crash
    • Maven generating different Flex project settings for Mac and Windows?
    • -locale flag in Compiler settings needs to be empty to compile in Flash Builder/Eclipse? It works fine on Mac, but Windows complains.
  • PPM Changes
    • added Tooltips to show contractor name and location on Contract Number ComboBoxes, both AddDirectCiteWindow and FundingRequest
    • mapping Funding Request Data to Financial Status
      • Submit Date (bf_submit_date) to Submitted To BA/BF
      • Certified Date (certified_date) to Certified Date
      • Acceptance Date (acceptance_date) to Acceptance
      • obligation_deadline_date to Funding must be obligated by
      • start_period_performance to Period of Performance
      • Missing Received Contract, Monthly Tech Report, Acceptance Received, MIPR/FAD Requested and Received Dates? dummy for now.
  • list of questions to ask…
    1. General flow of showing Financial Status
    2. Missing fields from Funding Request, if these are stored in Funding Request, where would you be entering data from? Just the Financial Status or Funding Request or both? If in Funding Request, where would it go?
      1. MIPR/FAD Requested from Service
      2. MIPR/FAD Request Received
      3. Date Acceptance Received
      4. Received Contract
      5. Initiate/Commit
      6. Monthly Tech Report
    3. Which are the editable fields in the financial status data form?
      1. PM Actual Outlay is calculated = obligation – outlay
      2. Remaining to Distribute = gradually subtract amount from total
    4. How are the summary data calculated?
      1. Available Balance
      2. Where would the goals come from?
    5. Reimbursable and Direct Cite mutually exclusive, can we control this like letting users enter data to only one place, not both?

Phil 2.3.11

7:30 – 4:30VISIBILITY

  • Deployed the new PPM and while testing it, found that there was some odd behavior in the comments. Took a screenshot and gave it to Dong, who was also perplexed.
  • Adding table updates (adding and deleting columns) and drop table capability to infoObjectManager.java – done
  • Need to add the same capability to InfoObjectManager.as.
  • It looks like we might need to write a tool that lets folks create update files that can then be emailed back to the financial folks for upload into the PPM database. Going to a meeting to discuss same
  • Added generic query to infoObjectManager.java.
  • Added check for “NULL” values when doing conversions from objects to sqlInfoObjects

Dong Shin 02.03.2011

  • FGMDEV backup not working properly.
    • found that sql dump files not transferred to philfeldman.com. The script works fine manually… will check again tomorrow
    • added output to the cronjob – /exchange/backups
  • PPM Changes
    • got many duplicate comments entries in View Comments??? looked at the database and code…. nothing.
    • fixed Date field in View Comments showing same Date…
    • currently deployed database – project_portfolio_02032011
    • saving database update sql – DBUpdateSQLs02032011.sql
    • fixed Funding Request updating type incorrectly
    • removed all additional fields from budget_amounts table – some fields go into funding_requests table
      • ALTER TABLE `budget_amounts` DROP `MIPR_requested_date` ,
        DROP `MIPR_request_received_date` ,
        DROP `submitted_to_BABF` ,
        DROP `document_number` ,
        DROP `certified_date` ,
        DROP `received_contract_date` ,
        DROP `initiate_commit` ,
        DROP `obligation` ,
        DROP `outlay` ,
        DROP `pm_actual_outlay` ,
        DROP `monthly_tech_report_date` ,
        DROP `comments` ;

Dong Shin 02.02.2011

  • PPM Changes
    • fixed a bug Funding Request not updating project_id
    • Remaining to Distribute calculation – keep subtracting Amount from FY BUDGET
    • add outlay to Reimbursable and Direct Cites
      • ALTER TABLE `funding_requests` ADD `outlay_amount` DOUBLE NULL AFTER `reimbursable_amount`
      • ALTER TABLE `direct_cites` ADD `outlay_amount` DOUBLE NULL AFTER `obligation_amount`
    • add contract info for Reimbursable in funding_request
      • ALTER TABLE `funding_requests` ADD `contract_id` INT NULL ,
        ADD INDEX ( `contract_id` )
      • ALTER TABLE `funding_requests` ADD FOREIGN KEY ( `contract_id` ) REFERENCES `project_portfolio`.`contracts` (
        `uid`) ON DELETE SET NULL ON UPDATE CASCADE ;

  • backing up FGMDEV
    • created a shell script and added to crontab – /exchange/backups/backup.sh
      • runs at 1AM everyday, keep last 3 days of data
      • ftp information (vizncon@philfeldman.com to backups directory)
      • ~4GB of data, 90 minutes package and transfer……
    • SVN – svnadmin dump /path/to/reponame > /tmp/reponame.dump ;
    • Nexus Maven Repo
      • zip up /opt/sonatype-work
    • Blog
      • zip up /opt/lampp/htdocs/blogs and /opt/lampp/SCT-Blog
      • back up MySQL Database; fgmdev_blog and sct_blog
        • /opt/lampp/bin/mysqldump -u root –password=edge fgmdev_blog > /exchange/backups/fgmdev_blog.dump

Phil 2.2.11

8:00 – 4:00 VISIBILITY

  • Hey! No ice!
  • Described the new FGM development incentive structure do Dong. Also, he’s going to start regular backups of fgmdev just in case VA forgets to pay the bill.
  • Statistics class
  • Working on tying the server side code back to the flex side for generic table retrieval. First pass is done! Login is now handled in the new system.
  • Burned a disk of new PPM swf

Dong Shin 02.01.2011

  • PPM Changes
    • fixed User Management TextInputs and set User object not updating Save button
    • adding Financial Status information to budget_centers table
      • back up – budget_amounts_org
      • ALTER TABLE `budget_amounts` ADD `MIPR_requested_date` DATE NULL DEFAULT NULL ,
        ADD `MIPR_request_received_date` DATE NULL DEFAULT NULL ,
        ADD `submitted_to_BABF` DATE NULL DEFAULT NULL ,
        ADD `document_number` VARCHAR( 255 ) NULL DEFAULT NULL ,
        ADD `certified_date` DATE NULL DEFAULT NULL ,
        ADD `received_contract_date` DATE NULL DEFAULT NULL ,
        ADD `initiate_commit` DOUBLE NULL DEFAULT NULL ,
        ADD `obligation` DOUBLE NULL DEFAULT NULL ,
        ADD `outlay` DOUBLE NULL DEFAULT NULL ,
        ADD `pm_actual_outlay` DOUBLE NULL DEFAULT NULL ,
        ADD `monthly_tech_report_date` DATE NULL DEFAULT NULL ,
        ADD `comments` TEXT NULL DEFAULT NULL
      • grabbing data from all related tables…
      • SELECT r.funding_type, r.description, r.funding_amount, r.document_number, c.contract_number, c.name as contractor_name, c.location as contractor_location, b.center_number, a.amount
        FROM funding_requests r
        LEFT JOIN direct_cites d ON r.uid = d.funding_request_id
        LEFT JOIN contracts c ON d.contract_id = c.uid
        LEFT JOIN budget_centers b on r.project_id = b.project_id
        LEFT JOIN budget_amounts a on b.uid = a.budget_center_id
        WHERE b.project_id = 96
    • working on saving Financial Status Data from the Form Entry

Phil 2.1.11

7:30 – 3:30 VISIBILITY

  • Working from home today. When the roads melt, I’ll see if I can go install the PPM update from yesterday
  • Installing xampp – done. Worked the first time. Sooooooooooooooooooooo nice.
  • Working on a version of DbTable that tries to match a java data type to the sql data type. Done, at least for the types that Flex likes.
  • Walked through the concept of views into infinite data with Mike.
  • Installed the new PPM. When I updated the DB, I got some errors:
    • On the 10th item (UPDATE direct_cites SET contract_id = [SELECT uid FROM contracts WHERE direct_cites.contract_number = contracts.contract_number )], and the 13th item (UPDATE funding_requests SET project_id = [SELECT uid FROM projects WHERE funding_requests.project_number = projects.project_number )] I got the following error:
    • ERROR 1242 (21000): Subquery returns more than 1 row
    • I left it as is since things appeared to be working. Worst case I can roll it back to just before I made the change.