Category Archives: Dong Shin

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?

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

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

Dong Shin 01.31.2011

  • found a way to use the M2_REPO environment variable for Flex Projects so that the Build Path no longer requires the absolute path. Maven Assist should have this…. Updated MavenAssist, now V1.9.2.10
    • <configuration>
      <enableM2e>true</enableM2e>
      <useM2Repo>true</useM2Repo>
      </configuration>
    • cannot get to SourceForge FTP server – connection refused?
  • PPM Changes
    • fixed Financial Data saving problem
    • creating database upgrade scripts for Financial Status
      • DBUpdateSQLs01312011.sql

Dong Shin 01.28.2011

  • PPM Changes
    • continue working on Funding Request work with new tables….
      • Direct Cites/Contracts working
    • Multiple Direct Cites results in many same entries in Financial Status….
    • funding_request table missing project ID!!!
      • ALTER TABLE `funding_requests` ADD `project_id` INT NULL AFTER `statement_of_work` , ADD INDEX ( `project_id` )
      • ALTER TABLE `funding_requests` CHANGE `project_number` `project_number` VARCHAR( 256 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
      • UPDATE funding_requests SET project_id = ( SELECT uid
        FROM projects
        WHERE funding_requests.project_number = projects.project_number )
      • ALTER TABLE `direct_cites` DROP `contract_number`
    • modified Funding Request to store Project ID
    • mapping Funding Request data fields to Financial Status

Dong Shin 01.27.2011

  • Snow!
  • PPM Changes
    • Modifying Funding Request for Project Status
      • direct_citest table changes to set up relationship with contracts table, update existing data
        • ALTER TABLE `direct_cites` ADD `contract_id` INT NULL AFTER `funding_request_id` , ADD INDEX ( `contract_id` )
        • ALTER TABLE `direct_cites` ADD FOREIGN KEY ( `contract_id` ) REFERENCES `project_portfolio`.`contracts` (
          `uid`) ON DELETE SET NULL ON UPDATE CASCADE ;

        • UPDATE direct_cites SET contract_id = ( SELECT uid
          FROM contracts
          WHERE direct_cites.contract_number = contracts.contract_number )
    • working on Funding Request for the database changes…

Dong Shin 01.26.2011

  • PPM Changes
    • all necessary project data passed onto Financial Status Panel
    • added Program Element and FACTS PE to Create Project Panel
    • disabled changed check on Financial Data – wasn’t really needed because data save is automatic
    • new tables to support Financial Status
      • program_elements
        • CREATE TABLE `project_portfolio`.`program_elements` (
          `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,PRIMARY KEY ( `name` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

      • facts_pe
        • CREATE TABLE `project_portfolio`.`facts_pe` (
          `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,PRIMARY KEY ( `name` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

    • added program_elements and facts_pe fields to budget_centers and set relationships
      • ALTER TABLE `budget_centers` ADD `program_element` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
        ADD `facts_pe` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL
      • ALTER TABLE `budget_centers` ADD INDEX ( `program_element` )
      • ALTER TABLE `budget_centers` ADD INDEX ( `facts_pe` )
      • ALTER TABLE `budget_centers` ADD FOREIGN KEY ( `program_element` ) REFERENCES `project_portfolio`.`program_elements` (
        `name`) ON DELETE SET NULL ON UPDATE CASCADE ;

      • ALTER TABLE `budget_centers` ADD FOREIGN KEY ( `facts_pe` ) REFERENCES `project_portfolio`.`facts_pe` (
        `name`) ON DELETE SET NULL ON UPDATE CASCADE ;


Dong Shin 01.25.2011

  • PPM changes
    • fixed DateFields not working properly – null out when editing is done
      • default parseFunction fails on labelFunction – set parseFunction to null
    • Server filters out SELECT SQL statements – too many statements
    • working on Project and Budget selection for FinancialStatus

Dong Shin 01.24.2011

  • working at home
  • PPM Changes
    • setting up project_portfolio database for Financial Status Data
    • additional fields to Funding Requests
    • fixed data editing errors in CurrencyTextInput
    • send changed data back to FinancialStatusDataDataGrid from FinancialStatusDataFromWindow for update
  • need to look at why Financial Data Save Confirmation not working properly……

Dong Shin 01.20.2011

  • PPM Changes
    • continue working on Financial Status
      • added Summary to FinancialStatusDataGrid
      • added FinancialStatusData.as
      • added DateItemRenderer – use dateFormat string to format, currently DD-MMM-YY and MMM-YY
      • modified CurrencyItemRenderer to handle Summary Data
      • layout is almost finished

Dong Shin 01.14.2011

  • PPM Changes
    • changed the way Create New User window comes up. It now comes from PPM Main instead of UserManagementPanel
    • working on EdiableTableDataGrid….
    • created TableDataDataGrid for editing, removed old datagrid
  • checked in DataManager to svn://fgmdev.com/trunk/Sandbox_folders/DONG_SANDBOX/DataManager
    • DataManager – parent pom
    • DataManagerClient – Flex client
    • DataManagerServer – Java Server