Author Archives: gvr4wd

Unknown's avatar

About gvr4wd

...hmmm

Dong Shin 04.10.2013

  • finished FA server coding of checking for duplicates of COGNOS contracts data….
    • a SQL PrepareStatement trick to check for null values by binding NULL
      • (? IS NULL AND budget_center IS NULL) OR (budget_center = ?)
  • tested ingesting 7500 rows at a time… no isssues running on localhost…
  • added contracts_cognos_history table to database to keep track of upload history
  • added last uploaded info label to Project Editor
  • integrated the new VersionTracker to PA!!!

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.27.2013

  • prep for Col. Duke’s presentation
  • deployed ProjectManager, looks good
  • working on VSS
    • changed variables_values from TEXT to BLOB
      • ALTER TABLE `table_queries` CHANGE `variables_values` `variables_values` BLOB NULL DEFAULT NULL
    • changed variables_values to macros
      • ALTER TABLE `table_queries` CHANGE `variables_values` `macros` BLOB NULL DEFAULT NULL
    • changed all references to variable/variables to macro/macros
    • modified ScriptFacades to use BLOB – convert String to BLOB to store, BLOB to String to retrieve
    • Using Matcher.quoteReplacement(variableValue) to avoid illegal group errors caused by reserved RegEx characters

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.15.2013

  • cleaned up menus in the main panel and ProjectMgmtPanel
  • saving database modifications to ProjectManager/src/main/resources/database/DBUpdateEnhancements.sql
  • created a copy of ProjPortfolioMgr webapp – ProjectManager – to use test database, project_portfolio_enh
  • created budget_center_contracts – store unique contracts from contracts_cognos table
    • additional column, budget_center_id, to map budget_centers to contracts
    • query to add 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

  • add columns to projects table
    • ALTER TABLE `projects` ADD `center_name` VARCHAR( 50 ) NULL ,
      ADD `center_number` VARCHAR( 50 ) NULL ,
      ADD `appropriation` VARCHAR( 30 ) NULL ,
      ADD `type` VARCHAR( 50 ) NULL ,
      ADD `capability` VARCHAR( 50 ) NULL ,
      ADD `expenditure_center` VARCHAR( 50 ) NULL ,
      ADD `investment_portfolio` VARCHAR( 50 ) NULL ,
      ADD `program_element` VARCHAR( 50 ) NULL ,
      ADD `facts_pe` VARCHAR( 50 ) NULL