Category Archives: Dong Shin

Dong Shin 01.13.2011

  • PPM Changes
    • added more sqls to DBUpdateSQLs.sql… tested.
    • fixed a bug on User Management not saving First and Last names correctly.
    • backed up project_portfolio to project_portfolio_01132011 working
    • renaming of a table caused client to choke. removed from the script
    • found that auto scroll of panels doesn’t work properly when panels are changing too fast?
      • changed EdgeUtils to support force scrollToIndex()

Dong Shin 01.12.2011

  • working on testing script for database upgradability….
    • created test script to see if there are any missing relations, DBSelectTest.sql
    • added force delete of missing relations to DBUpdateSQLs.sql
  • meeting with Heather Hundt for Non-profit org.

Dong Shin 01.11.2011

  • PPM Changes
    • the current month didn’t get highlighted properly – changed the logic, works now.
    • added method to record when user modifies previous month’s data
      • doesn’t record when initial data is entered (when the cell is NaN)
      • added created_time to track dates and times separately
      • user changed data from 2502 to 2502.3 in Project ID – 104 Year: 2011 Month: 3 Row: Reported Actual Obligated $:

    • working on database check up for upgrade

Dong Shin 01.10.2011

  • PPM Database Update Procedures with the script,  DBUpdateSQLs.sql
    • backup the database using following command from command line
      • mysqldump -d -u root -p project_portfolio > project_portfolio_backup.sql
    • login to database from command line at the directory where the DBUpdateSQLs.sql is located
      • mysql -u root -p
    • select database to modify at the mysql prompt
      • use project_portfolio;
    • run the script from the mysql prompt
      • source DBUpdateSQLs.sql;
    • if anything goes wrong, you can revert to old database by restoring the database from the backed up file
      • mysql -u root -p to get mysql prompt from command line
      • drop database project_portfolio; in mysql prompt
      • create database project_portfolio; in mysql prompt
      • source project_portfolio_backup.sql; in mysql prompt
  • PPM Changes
    • changing code to work with new DB structure….
    • 1 Year projects support added
    • complete database schema created, but not implemented on the current database

Dong Shin 01.07.2011

  • PPM changes
    • thinking of using tables’ comments field for editable/non-editable indicator
      • ALTER TABLE tablename COMMENT = 'editble';
    • fixed itemRenderer issue by setting icon at set data method, not at creationComplete method
    • changed all the tables to have InnoDB engine
    • backed up database to project_portfolio
    • set editable tables by ALTER TABLE <table name> COMMENT = ‘editable’;
      • budget_center_names (budget_centers)
      • budget_center_number (budget_centers)
      • capabilities (budget_centers)
      • expenditure_centers (budget_centers)
      • funding_transaction_names (budget_centers)
      • funding_transaction_numbers (budget_centers)
      • funding_transaction_types (budget_centers)
      • investment_portfolios (budget_centers)
      • users
    • setting relationiships for foreign keys in the database
      • projects and users done.
      • budget_centers related tables done (budget_center_names, budget_center_number, capabilities, expenditure_centers, funding_transaction_names, funding_transaction_numbers, funding_transaction_types, investment_portfolios)
    • added warning dialog – cancel closes the panel
    • added dataToolTips for the datagrid

Dong Shin 01.6.2011

  • PPM Enhancement
    • DB Mgmt
      • added icons for editable/non-editable tables in the tables list
      • added Record numbers text
      • Begin, Prev, Next, End buttons working
      • mx:Label for AdvancedDataGridItemRenderer is too slow for large sets of data?, tried to extend AdvancedDataGridItemRenderer. no success. changed Label to Text component, it’s a lot faster now
      • added toolTips
      • added Key information on the DataGrid column header

Dong Shin 01.04.2010

  • PPM Changes
    • fixed Save Confirmation – set flag to false before Query execution so that it forces state to saved
    • unable to duplicate Project Names disappearing from Create Project Panel….
    • dump current database schema and data to ProjPortfolioMgr server – webapp/scripts/project_portfolio_01042011.sql
    • copied project_portfolio database to project_portfolio_01042011
    • working on DBMgmtUtils….
  • forcing foreign key updates
    • ALTER TABLE table1 ADD
      CONSTRAINT fk_keyfield
      FOREIGN KEY(keyfield)
      REFERENCES table2(keyfield)
      ON DELETE REJECT
      ON UPDATE CASCADE

Dong Shin 01.03.2011

  • PPM Changes
    • fixed a bug not updating Summary Data for Year 2, 3, so on when editing Financial Data
    • added formatter for invoice amounts
      • InvoiceSelectWindow
      • InvoiceFormWindow
    • allow negative values for invoice amounts
      • red for negative amounts
    • bigger comments area for invoices
    • added comments indicator – number of comments and last updated (tooltip)

Dong Shin 12.29.10

  • PPM
    • copied PPM stuff for deployment at /exchange/PPM_122910
  • MavenAssist
    • modified CreateProject and UserSettings to use archetypeRepository
    • -DarchetypeRepository=http://repository.sonatype.org/content/groups/public
    • current version is 1.9.2.8
  • meeting with Trish and folks
    • lots of notes to come….
  • PPM Bugs
    • Summary not updating for year 2, 3, so on in Financial Data
    • Ability to create project with 1 year span
    • Save Confirmation pops up on Financial Data – not working properly
    • Add comments status indicator, possibly number of comments and/or last updated date
    • Add commas to invoice dollar amont
    • Update login not possible because it’s used as database key. Let users change it and use no case-sensitive joins for existing data?
    • Allow negative values for invoice amounts
    • Project Name in Create Project disappearing?
    • larger View Invoices Panel in Financial Data so that comments are visible
    • logs/alerts for changing previous months data
      • from <> to <> by user id?
    • add delete/modify capabilities to all tables that use single drop down list to add a string to projects, funding requests, etc.
  • PPM Enhancements to support Financial Statu Sheet
    • one to one relationship with project
    • most of the data comes from Project and Funding Requests
    • if Certified Data != null, Initiate/Commit needs to be filled
    • new fields in Project – added to the Budget Datagrid
      • Program Element
      • FACTS BE
    • new fields in Funding Request
      • Reference Number in Reimbursable Amount – uniqueness test/
      • Contractor Name and Location in Reimbursable Amount/Direct Cites
      • Outlay in Reimbursable and Direct Cites
    • PM Actual Outlay = obligation – outlay
    • Roles to support users to fall into FYs and Projects
    • Remaining to Distribute = total budget – distributions

Dong Shin 12.28.2010

  • working at home….
  • continue working on MySQLDataManager and MySQLDataObject
    • retrieves data in XML and add dynamic properties to each row (Object) of the data
    • dynamic object in DefaultDataObject may not be very usable…. need to change it to the properties of the Class itself
  • PPM Changes for adding phone extensions
    • DB changes
      • ALTER TABLE `users` ADD `unclass_phone_ext` VARCHAR( 4 ) NULL AFTER `unclass_phone`
      • ALTER TABLE `users` ADD `class_phone_ext` VARCHAR( 4 ) NULL AFTER `class_phone`
      • ALTER TABLE `funding_requests` CHANGE `financial_poc_phone` `financial_poc_phone` VARCHAR( 35 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL
      • ALTER TABLE `funding_requests` CHANGE `technical_poc_phone` `technical_poc_phone` VARCHAR( 35 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL
      • ALTER TABLE `funding_requests` CHANGE `nsa_poc_phone` `nsa_poc_phone` VARCHAR( 35 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL
    • Added extensions to AddUserForm
    • Add/Modify works
    • Added extensions to all contacts in Funding Request
    • Added extensions to SelectProjectWindow, ProjectMgmtPanel, ProjectViewerPanel sot that the extensions shown on Financial Data

Dong Shin 12.27.2010

  • helped Christine with Maven stuff
  • Nexus Maven Repo Server unstable?
    • 1.8 crashed after 20 mins.
    • back to 1.7 from 1.8, looks stable now….
  • Continue working on DataManager and DataObject
    • MySQLDataManager and MySQLDataObject extended from base class
    • base classes modified to support more variables/methods
    • testing DataManager and DataObject

Dong Shin 12.23.2010

  • upgraded Nexus Repo to 1.8.0.1, enabled security so that anonymous doesn’t have full auth anymore. It was also unstable going down without warning, will keep monitoring…
  • working on MySQLDataObject to extend DefaultDataObject

Dong shin 12.22.2010

  • display DB meta info in Tree format
  • created dynamic form based on table meta data
  • creating TableDataObject and TableColumnDataObject

    • <Row NAME=”test” SCHEMA_NAME=”test” TYPE=”DATABASE”>

    <Row DATABASE_NAME=”test” NAME=”doubletable” TYPE=”TABLE”>

    <Row COLUMN_DEFAULT=”” COLUMN_KEY=”” COLUMN_NAME=”value”

    COLUMN_TYPE=”double” DATABASE_NAME=”test” EXTRA=””

    NAME=”value” TYPE=”COLUMN”/>

    </Row>

Dong Shin 12.20.2010

  • refactored DataObject project to DataManager project
  • imported Phil’s DataManager code to new DataManager project
  • added basic information interface to the DataManagerServer
    • getInfo – list of databases
    • getDbInfo – list of tables
    • getTableInfo – table structure
  • added support for Solr XML format