Category Archives: Dong Shin

Dong Shin 02.28.2013

Dong Shin 02.25.2013

  • Fixed PA showing invisible types (admins only) – Outlay $ (Reported in FACTS)
  • moved buttons to the top in PPM – ProjectMgmtPanel, CreateProjectPanel, UserRolesManagementPanel
  • added filter to Funding Request
  • Obligations weren’t showing in the FY13 summary charts – forgot to update quest when it was changed to Reported FACTS Obligated $: 

Dong Shin 02.21.2013

  • deployed new PA and went over with Chris B., few notes
    • need to be able to link a project to multiple MIPRs and a MIPR to multiple projects
    • Remove ability for user at the lab to adjust the FACTS outlay cell
    • Update the planned obligation/outlay pop up – if the planned obligated amounts is less than the funded budget amount the pop up needs ton continue until it matches or is more than the funded amount
    • verify totals in the project mgmt screens are adding up
    • MIPR 172356 not setting funded budget in PA from committed in funding request
    • Add search feature to “project to create funding request”, (Actually, all dialogs in PPM)
    • Need a better way to navigate large lists in “Add New Item” ComboBox
  • tried to duplicate the Funded Budget problem….. will debug on site tomorrow
  • All Hands at WCC

Dong Shin 02.15.2013

  • deployed new PPM and PA – didn’t go well,
    • PA’s Project list behaving weird, graying out all projects.
    • Refresh need after Planned Values update
    • SQL Errors. Test with multiple funding requests – happens when more than one MIPR in a funding request
  • Annoying Adobe support not giving the license for Flash Builder 4.7
  • re-installing Flash Builder 4.6
  • PA changes
    • removed itemRenderer for the project list, keep status itemRenderer
    • add “(NOT FUNDED)” to status for the projects that has no budget
    • enabled Admins to edit NOT FUNDED projects

Dong Shin 02.14.2013

  • FGM Mail down? can’t get to the web mail either….
  • added Budget Center DropdownList to the status view, added event handler to change data
  • added a flag to keep track of Funded Budget (Commit in the Funding Request table) in the database – done!
    • ALTER TABLE `funding_requests` ADD `commit_flag` TINYINT NOT NULL DEFAULT '0' AFTER `commit`
    • UPDATE funding_requests SET commit_flag = 1 WHERE COMMIT > 0
    • DBUpdateSQLs02142013.sql
    • query to update commit_flag
      • UPDATE funding_requests SET commit_flag = 1 WHERE funding_requests.uid IN
        (SELECT funding_request_id FROM _funding_requests_budget_centers
        WHERE budget_center_id = 18)
  • changed PPM to keep track of the funded budget flag in the funding requests
  • disabled projects in PA that has $0 budgeted amount in funding requests
  • trouble shooting 4.7 install issues…. no luck, java crashes in memory dump found in the installation directory. uninstalling and re-install 4.6

Dong Shin 02.13.2013

  • VizTool status meeting at Fort
  • Changed Reported Actual Obligated to Reported FACTS Obligated, no need to update database as of today.
  • continue working on Planned Obligation/Outlay Editor
    • got edit to work – saves to database!
  • moved buttons to the top
  • resized the Financial Data Navigator window
  • added DropDownList to Status view to filter MIPRs
    • still needs filtering
  • managed to corrupt the workspace I was using Flash Builder 4.7 with… and couldn’t get 4.7 to start! removed and re-installed, but no luck. going back to 4.6

Dong Shin 02.11.2013

  • bugs
    • Replace “next incomplete record” tooltip with “next record”
    • Add text following “x of y” at the bottom left to indicate what is being stepped through
    • Take a look at users table cascading problem
    • Create a script that deletes all contracts that are not being used
      • RemoveUnusedContracts.sql in PPM
  • Flash Builder 4.6 has been crapping out on me past months continuously giving me various run time errors, ugh! – downloading 4.7 (1GB!) – working better but waiting for a license from Adobe (free upgrade from 4.5, 4.6)
  • working on queries to retrieve committed (Funded Budget) for PA
    • SELECT bc.*, (SELECT commit
      FROM _funding_requests_budget_centers frbc, funding_requests fr, budget_centers bc
      WHERE frbc.funding_request_id = fr.uid
      AND frbc.budget_center_id = bc.uid AND bc.uid = 18)
      FROM budget_centers bc
      WHERE bc.uid = 18
  • working on queries to retrieve contracts for PA
    • SELECT GROUP_CONCAT(c.contract_number)
      FROM _funding_requests_contracts frc, funding_requests fr, contracts c, projects p
      WHERE frc.funding_request_id = fr.uid
      AND c.uid = frc.contract_id
      AND fr.project_id = p.uid
      AND p.uid = 193
      GROUP BY fr.uid

Dong Shin 02.08.2013

  • PPM
    • select contract from funding request data instead of projects data in PPM for the Invoice
    • removed from Financial Data Navigator in both status and line item view
      • Expenditure Center
      • Investment Portfolio
      • Program Element
      • FACTS PE
    • changed Identifier to use MIPR (center_name) in Yearly View
    • Reported FACTS Obligated is disabled
    • added BETA image to PA

Dong Shin 02.04.2013

  • phpMyAdmin has been really slow since I upgraded XAMPP to 1.8.0 which contains a Tomcat instance. Upgrading pmyMyAdmin to the latest (3.5.6) didn’t resolve it.
    • Adding $cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’; to config.inc.php (careful with the single quotest!) as suggested at http://ellislab.com/forums/viewthread/224775/ did the trick!
  • Changed PPM to require FMP’s on only Obligations and Outlays

Dong Shin 02.01.2013

  • cleaned up sql scripts – fixes errors when running stored procedures with temporary/in-memory tables
  • figured out how to back up stored procedures, is turned off by default
    • mysqldump –routines outputfile
    • need to add this to the backup script on site
  • working on PPM to have only Obligations and Outlays require FMP’s