Dong Shin 10.25.2013

  • working on Reqonciler
    • added a method to the server to save the data on XLSX parse
    • changed Reqonciler to call the new method, importXLXSFile()
    • working on Post Processing queries
      • added three quries for post-processing, update summary to budget_center_contracts, add new summary, update vendor information
    • added searchTextInput to ReviewQueriesWindows and PreProcessingWindow

Dong Shin 10.24.2013

  • went over COGNOS data pull with Lenny –  disappeared commitments have appeared again….
  • asked Lenny to put list of data conflicts that should be reviewed
  • working on Reqonciler
    • pre and post processing done!
    • working on pre and post queries for FinancialAssitant!
    • working on server code to keep historical data
      • created class based on ContactsParser – ReqoncilerDataParser.java
      • added prop to FinancialAssistant.properties – reqonciler.tableName

Dong Shin 10.23.2013

  • deployed new FinancialAssistant.jar – solved the year problem
  • fixed obligations/outlays import queries to correct doubling/tripling committed amount and obligations
  • still problem on obligations with multiple req’s
  • meeting at NBP today at 1

Phil 10.23.13

8:00 – 4:00 SR

  • Backups
  • Worked with Dong to isolate and fix query math issues
  • Meeting with some Bee Folks. Went well. Their db is Access, hand rolled on a shared drive. God help us.
  • Moved training along a bit.
  • YUI – Ajax
    • Started up Apache Server and stopped Tomcat so I could serve PHP
    • created directory C:\xampp\htdocs\ajax and put the chapter 5 code in there
    • Connected Webstorm to that code.
    • Running everything nicely now. Working with error handling.

Dong Shin 10.22.2013

  • fixed queries to show correct Req Amount on site
  • found that Obligations/Outlays not calculating correctly when ingested, especially the date (12-31-2012 shows 12-31-2013)
    • changed formatter to use “yyyy” instead of “YYYY”
  • VSS mods
    • modified sql’s to return funded_budget
    • modified python scripts to ignore values greater than funded_budget
  • continue working on Reqonciler

Phil 10.22.13

8:00 – 4:00 SR

  • Need to set up a server and install/uninstall xampp, then install mysql and Tomcat, restore the db and see how that goes.
  • Backups
  • YUI. Finished chapter 4. Somewhat annoyed by the Editor support today. Codecomplete knows, for example that Y.on().xxx has a variety of valid options. Tooltip usage does not. Couldn’t find any way to make the tooltips more verbose either -1, Webstorm…

Dong Shin 10.17.2018

  • deployed new FA, queries, script to correct EA calculations, everything is well
  • talked Lenny about keeping historical COGNOS data to keep track of changes occurring, as well as reviewing and flagging duplicate rows
    • run a series of queries to show potential conflicting data
    • each query displays the data to be resolved
    • rows are marked to *IGNORE* to be included in reports and data imports
  • removed TRUNCATE contracts_cognos from ProjectMgmtPanel to keep all COGNOS data
  • working on COGNOS data processor
  • reset_obligations_outlays.sql to reset obligations and outlays data
  • database updates – DBUpdateEnhancements.sql
    • additional column in contracts_cognos
      • ALTER TABLE `contracts_cognos` ADD `hide_flag` TINYINT NOT NULL DEFAULT ‘0’;
    • remove trigger copy_contracts_cognos
      • DROP TRIGGER IF EXISTS `copy_contracts_cognos`
    • create queries table to process COGNOS data
      • CREATE TABLE IF NOT EXISTS `process_cognos_data_queries` (
        `uid` int(11) NOT NULL,
        `name` varchar(255) NOT NULL,
        `query` text NOT NULL,
        `description` text NOT NULL,
        PRIMARY KEY (`uid`)
        ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Dong Shin 10.16.2013

  • deployed new FA, everything seems well
  • went over Obligation and Outlay import calculations with Lenny and found that the only Outlay should be added with the previous month’s value (not cumulative).
  • fixed update_obligation_outlays.py script to fix incorrect calculation detailed above – do not add previous month’s value when type is not Outlay
  • disabled runPythonScript in FA until fix for slow running script is found….
  • updated EA cognos queries to correctly sum up obligations/outlays – obligation_outlay_queries.sql
  • created a table – contracts_cognos_all, to keep all historical data, also created a trigger to add contracts_cognos data to the table the new files get ingested  – DBUpdateEnhancements.sql