Category Archives: Dong Shin

Dong Shin 04.05.2013

  • continue working on Contracts Parser
    • cellIterator cannot be used to get NULL cells, ugh!
    • copied ProjPortfolioMgr to FinancialAssistant project
    • server side looks complete
    • created ContractsParserWindow for reviewing the data
    • saving contracts and vendors work!
  • add following code snippet to enable log4j in java applications…
    • Properties logProperties = new Properties();try {logProperties.load(new fileInputStream(“src/main/webapp/WEB-INF/classes/log4j.properties”));PropertyConfigurator.configure(logProperties);

      } catch (IOException e) {

      throw new RuntimeException(“Unable to load logging property”);

      }

Dong Shin 04.04.2013

  • went to Fort, no meeting…..
  • continue working on XLSX uploader – done
  • working on XLSX parser (Server) for contracts

Dong Shin 04.03.2013

  • wrapped up changes to Budget Info
  • started importing xlsx files
    • as3xls supports only xls files
    • as3-xlsx-reader looks promising – https://github.com/childoftv/as3-xlsx-reader
      • requires fzip – https://github.com/claus/fzip
      • got example to work
      • modifying the example to read the Contracts data
    • created example contracts xlsx file – Contracts Example.xlsx
    • working on File Uploader – http://biemond.blogspot.com/2008/08/flex-upload-and-download-with-blazeds.html
      • got the example to work – both server/client

Dong Shin 04.01.2013

  • working on changes requested for FinancialAssistant (changed from ProjectManager)
    • adding more info to Budget Info Grid
      • add sub budget center number and namel; database tables, addable CB list.
      • keeping DB changes to DBUpdateEnhancements.sql

Dong Shin 03.26.2013

  • prepping for Col. Duke’s presentation
  • burned a CD for Project Manager dated 03.19
  • trouble-shooting FlexiChart
  • continue working on VSS
    • problem with saving variables xml with sql string – fixed by adding a parameter, xml
    • problem with quotes and single quotes in xml….

Dong Shin 03.25.2013

  • projects in my Flex workspace have disappeared again, ugh!
  • working on variables for VSS’s SQL
    • created a column to store variables in visiblity_scripting.table_queries
      • ALTER TABLE `table_queries` ADD `variables_values` TEXT NULL
    • modified ScriptFacades.dbStoredQuery to look for stored variables and replace with the values stored
    • added ScriptFacades.saveVariables(String, HashMap) to save the variable/value pairs
    • added ScriptFacades.saveVariablesXML(String, String) to save the xml string
    • added new methods to VSS server
    • added variables window in VSS client to view, edit, and save the variables xml string

Dong Shin 03.21.2013

  • experimented with MySQL’s stored procedure to create 6 month of data for the presentation
    • too complicated and long
  • created a complex python script to generate a SQL that generates FY13 data. After discussing with Phil, it would be better to have SQL Editor/Runner with replaceable variables within the SQL
    • saved off the Python script to 6monthsTest.py

Dong Shin 03.20.2013

  • need to modify presentation scripts/queries to show 6 months of data instead of full 24 months
    • looked at the queries and scripts, need to get working scripts/queries from site.
  • screen resolution of the monitor in the ISR PMO conference is 1280×1024
  • continue working on ProjectManager
    • working on filtering contracts data
    • created procedure to import contracts_cognos to budget_center_contracts –  import_cognos_contracts
      • CREATE DEFINER=`root`@`localhost` PROCEDURE `import_cognos_contracts`()
        NO SQL
        BEGIN
        TRUNCATE budget_center_contracts;
        INSERT INTO budget_center_contracts(budget_center,appropriation_year,requisition_id,po_reference,acr,
        committed_date,committed_amount,obligation_date,obligated_amount,expensed_date,expensed_amount,
        po_start_date,po_end_date,contract_type,po_type_code,contract_no,vendor_id)
        SELECT budget_center, appropriation_year, requisition_id, po_reference, acr, committed_date, committed_amount, obligation_date, obligated_amount, expensed_date, expensed_amount, po_start_date, po_end_date, contract_type, po_type_code, contract_no, vendor_id
        FROM contracts_cognos
        GROUP BY requisition_id, po_reference;
        END

Dong Shin 03.18.2013

  • working on Budget Center to save to database…..
  • add required columns to budget_centers table
    • ALTER TABLE `budget_centers` ADD `funded_budget` DECIMAL( 10, 2 ) NULL , ADD `date_submitted_to_services` DATE NULL , ADD `date_received_from_services` DATE NULL , ADD `date_submitted_to_babf` DATE NULL , ADD `acceptance_date` DATE NULL , ADD `sow` TEXT NULL
  • modified SQL to insert budget_center_contacts data – need sum of all amounts
    • INSERT INTO budget_center_contracts( budget_center, appropriation_year, requisition_id, po_reference, acr, committed_date, committed_amount, obligation_date, obligated_amount, expensed_date, expensed_amount, po_start_date, po_end_date, contract_type, po_type_code, contract_no, vendor_id ) SELECT budget_center, appropriation_year, requisition_id, po_reference, acr, committed_date, SUM(committed_amount), obligation_date, SUM(obligated_amount), expensed_date, SUM(expensed_amount), po_start_date, po_end_date, contract_type, po_type_code, contract_no, vendor_id FROM contracts_cognos GROUP BY requisition_id, po_reference

Dong Shin 03.14.2013

  • VizTool status meeting – notes at the requirements page
  • still no network connection at the office
  • continue working on Project Editor
    • separated into two tabs; Project Information and Budget Information
    • added column filter for contracts – defaults to Contract Number, ACRN, Commited Amount, Obligation Amount, Expensed Amount, PM Actuals
    • added Remove, Remove All, Add, Add All contracts between claimed and unclaimed

Dong Shin 03.13.2013

  • working at home due to no Internet at the Columbia office
  • continue re-factoring Project Editor
    • added Project Budget Info Grid
    • added Edit button that shows Add Budget Information dialog to edit data utilizing the AddableListCB
    • added more information to the Budget Center dataGrid to show required fields, removed the unnecessary fields
    • modified Add Budget Center Window to reflect the changes to the Budget Center dataGrid
    • created ProjectContract class to reflect the COGNOS contract data
    • added claimed and un-claimed contracts dataGrid
    • drag-and-drop added to the claimed/un-claimed contracts dataGrid
    • the dataGrids are somewhat crowded, may need to use tabs…

Dong Shin 03.07.2013

  • VizTool meeting cancelled
  • Weird PA problem. SQL error I saw at the Mill happened on-site, couldn’t figure out how it was able run before…. restored to 02.04 version
  • removed the Status “(UNFUNDED)” from the PA – ProjectStatusItemRenderer
  • built PA for deployment tomorrow
  • working on ProjectManager
    • created vendors, contracts_cognos tables
    • added sample data from Excel spreadsheets to the tables
    • query to generate contracts data
      • SELECT c.budget_center, c.appropriation_year, c.po_reference, c.acr, v.vendor_name, v.address_line_1, v.city, v.postal_code, c.committed_date, c.committed_amount, c.obligation_date, c.obligated_amount, c.expensed_date, c.expensed_amount, v.vendor_id, v.vendor_abbr, c.po_start_date, c.po_end_date, c.contract_type, c.po_type_code, c.contract_no
        FROM contracts_cognos c
        LEFT OUTER JOIN vendors AS v ON c.vendor_id = v.vendor_id

Dong Shin 03.05.2013

  • VizTool meeting – went over the features of PPM 2.0(?), details at Phil’s blog
  • my workspace for the Flex projects gone! manually restoring one by one.
  • checked out PPM code to create a new project to support the new features and checked into SVN – ProjectManager