Author Archives: gvr4wd

Unknown's avatar

About gvr4wd

...hmmm

Dong Shin 05.29.2014

  • on-site support (2 hours)
    • deployed FA/Reqonciler – fixed percentages and pre-processing
    • found some obligations are put in a month behind?
    • double counting outlays with ACR field
    • show previous month PM Actuals in Query Builder
  • working on other (5 hours)
    • added PM Actuals % to Query Builder
    • PM Actuals show previous month (month label added)

Dong Shin 05.28.2014

  • working on *other* stuff
    • added ignore previously reviewed… filtering out previously viewed data
    • fixed incorrect percent values for obligated/oulays in Query Builder
    • added queries to remove duplicate obligations and outlays in pre-processing according to the rules.
    • adding PM Actuals Percentages….

Dong Shin 05.27.2014

  • deployed FA/RA with new filterable combo boxes (2 hours)
    • works well, but needs tweaking on Hierarchical data in Project Mgmt
  • working on Reqonciler Pre-Processing (6 hours)
    • removing duplicate rows query sample
      • DELETE n1 FROM test n1, test n2 WHERE n1.uid > n2.uid AND n1.name = n2.name
        AND n1.name2 = n2.name2

Dong Shin 05.19.2014

  • went over FA and Reqonciler with Lenny ( 2 hours)
    • The first month in the second year not calculating correctly
    • verified fixes
      • duplicating Outlays problem
      • rolling months for Planned Outlays, Planned Obligations, PM Actuals for non-admins
      • show all rows in Financial Data
  • working on Filterable Columns for DataGrid (6 hours)

Dong Shin 05.14.2014

  • self-assessment for annual review
  • Add Update Button to Req Info in Query Builder – done (2 hours)
  • working lockdown rows  (5 hours)
    • added configuration table entry to configutaion table – not used yet
    • added lockdown entry in itemRenderer
    • added isLockdown method in FinancialData class

Dong Shin 05.12.2014

  • deployed new Reqonciler and db update – pre-processing works! (3 hours)
  • found some of the obligations are not set correctly (second year?), all the summary data and relations are there. (1 hour)
    • have not corrected setting to NULL when obligations/outlays are cleared! it should set to 0, not null because 0+ null = null!
  • working on VizTool Priority List #1 – adding save to budget/req info (4 hours)

Dong Shin 05.09.2014

  • deployed new Reqonciler and the ingest works magically!
  • fixed post processing queries by removing Appropriations
  • pre-processing ignore is broken
    • added target table name column
      • ALTER TABLE `_reqonciler_processing` ADD `target_table_name` VARCHAR(50) NULL ;
      • set appropriate table names per query

Dong Shin 05.08.2014

  • found that the new obligations not are saved to budget_center_contracts table
    • post processing query that saves not working correctly?
    • tried to replicate it with test data, but no luck, need to compare the queries word by word
  • added Query Editor to Reqonciler so that editing can easily be done on the app

Dong Shin 05.05.2014

  • ran the Java in command line with no problems, but still the same problem through Reqonciler…. ingested COGNOS data (FY13 and FY14) thru command line
  • pre-processing ran fine, but errors on post-processing. missing views
    • created views and sent it off to Bill/Phil for deployment tomorrow
    • instruction-  There are four views need to be updated/added to the database.
      1. Bring up a command line window and login to mysql database
      2. create views one at a time by copy and paste into mysql command prompt and ensure there is no errors
      3. Login into Reqonciler and run post processing, ensure there is no errors
      4. ask Lenny to verify Obligations/Outlays data!
  • off to Philadelphia!

Dong Shin 05.02.2014

  • having problems with new Reqonciler jar files…. The process would just stop right after reading prop files.
  • created a runnable jar files with necessary files
  • packaged up mostly everything from webapp directory for debugging/testing, more than 25MB (limit of gmail?). broke up and sent it off to Bill.