Category Archives: Dong Shin

Dong Shin 05.23.2011

  • VisibilityScriptingServer
    • changed content field in visibility_scripting.table_publish to LONGBLOB to handle large amount of data
    • modified com.fgm.javaUtils.database.DbTable.java to handle LONGBLOB
    • tweaking query to generate the data in right format….

Dong Shin 05.20.2011

  • ran a query to retrieve Financial Data, got empty data. Noticed that the server reports, ERROR [TP-Processor2] (PublishSupportObject.java:130) – Packet for query is too large (4052025 > 1048576). You can change this value on the server by setting the max_allowed_packet’ variable. Tracked it down and found my.cnf needed more than 1M of max_allowed_packet…. set it to 50M and no more error messages
  • XML data shows up in Script Editor, but not published. Got ERROR [TP-Processor3] (PublishSupportObject.java:130) – Data truncation: Data too long for column ‘content’ at row 1 on the server. Trying to track it down….

Dong Shin 05.19.2011

  • revisiting VisibilityScripting for PPM reports, trying to remember where I left off….
    • crashing at PublishedDataPanel/showSelectedData()[/Users/dongshin/Projects/workspace.fgmdev.flex/VisibilityScripting/src/main/flex/PublishedDataPanel.mxml:35]
  • updating SF86 for my clearance. a lot more stuff!

Dong Shin 05.17.2011

  • PPM Changes
    • added more fields to save from Financial Status Form
    • looks like the contract info should *NOT* be editable in Financial Status Form
    • trying to generate better error messages from server. Java side works, but Flex side throws fault exception?
  • Installed Flash Builder 4.5 – had to uninstall previous beta one (Flash Builder Burrito)

Dong Shin 05.16.2011

  • PPM Changes
    • some fields returning “null” string instead of null for Financial Status ??? – explicitly set it to null is AS class
    • added ItemRenderer to highlight totals compared with Total Budget
    • added percentages for the totals
    • Totals in Financial Status compared against the budget total
      • Green if at or above the total
      • Yellow if between 100-95%
      • Red if below 95%

Dong Shin 05.13.2011

  • PPM Changes
    • minor typo changes per Kristi’s findings
    • went over the questions Kristi had for 05.12
    • considering incorporating com.edgeti.visibility2.layout.controls.ColorSchemePicker from vis2 project for text customization
    • added ComboBoxes for Appropriation and Appropriation Types to Financial Status Panel – retrieves data on CreationComplete from tables, appropriations and obligation_outlay_types
    • totals of Initiate/Commit’s and PM Actual Outlays added
    • removed Remaining To Distribute from Financial Status Data Form
  • Flash Player 10.3 released – download

Dong Shin 05.12.2011

  • PPM Changes
    • Display format of MIPR Requested Date, MIPR Request Received Date, Initiate/Commit weren’t right. The date format function failure returns weird errors (Array index out of range?). Adjusted the query to change the format. May have to look at the server code to return some meaningful error messages.
    • added project_source to funding_request table – ALTER TABLE `funding_requests` ADD `project_source` VARCHAR( 255 ) NULL DEFAULT NULL
    • Project Source Radio buttons (OISR-PMO and OISR-TF) added to Funding Request
    • Last Updated date added to Financial Status – saves the current date if date field is not changed, saves the changed date otherwise.
    • Changed Description to TextArea from TextInput
    • Changed Acceptance and Received Contract in FinancialStatusDataFormWindow to ComboBox
    • Changed Funding Request table fields – ALTER TABLE `funding_requests` CHANGE `acceptance_received` `acceptance_received_date` DATE NULL DEFAULT NULL ,
      CHANGE `received_contract` `received_contract_date` DATE NULL DEFAULT NULL
    • Additional fields added to Funding Request table – ALTER TABLE `funding_requests` ADD `acceptance_received` VARCHAR( 20 ) NULL DEFAULT NULL ,
      ADD `received_contract` VARCHAR( 20 ) NULL DEFAULT NULL

Dong Shin 05.11.2011

  • gone over the list of questions that Kristi has had….
  • PPM Changes requested by Trish
    • added last_updated (DATE) to budget_amount – ALTER TABLE `budget_amounts` ADD `last_updated` DATE NULL DEFAULT NULL
    • MIPR/FAD dates and Initiate/Commit fields added to Funding Request Form and saves to database.

Dong Shin 05.10.2011

  • new PPM for depolyment
    • db changes for Funding Request – DBUpdateSQLs05102011.sql
    • set width of Project Name, Project Number, Program and Project Info label
    • added tooltips for the TextInputs and Project Info
    • fixed Project Number from Project not showing correctly
    • /exchange/PPM_051011
  • Going down the list from Trish
    • Deleted ‘Financial Status‘ selection from Projects menu
    • verified that the FY Budget is shown correct in Project Status

Dong Shin 05.09.2011

  • got my M-Class license!!!
  • went over the changes/fixes requested by Trish
  • database bug caused by inconsistent database versions. I shouldn’t have put the 0506 version in fgmdev
  • went over the Excel spreadsheet ingestion and new architect to support Brian and Christina
  • cannot login to Visibility on fgmdev.com – Firefox problem.
  • ingested Christina’s candidate spreadsheet – (needed to convert to xls)
  • PPM Changes
    • Changed ‘Financial Data Request‘ to ‘Monthly Status Request‘
    • Changed ‘Enter Financial Data‘ to ‘Enter Monthly Status Data‘
    • Change ‘Financial Data‘ to ‘Enter Monthly Status Data‘ in ProjectMgmtPanel
    • Removed UID and Project ID from Funding Request Selection Dialog
    • MIPR/FAD Requested from Service and MIPR/FAD Request Received added to Funding Request

Dong Shin 05.04.2011

  • Continue working on Financial Status….
  • saving Financial Status works!
  • Multiple Direct Cites causing duplicate rows in Financial Status – How do we handle this? Summary ?
  • created MySQLUtils in MySQLIf package to handle some conversions (Date, String)