Author Archives: gvr4wd

About gvr4wd

...hmmm

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

working on Reqonciler
- added configurable preProcessingTable, postProcessingTable, queryName to seupModel.xml with Reqonciler namespace
- added matching value objects
- finished PreProcessing

decided not to deploy new FA due to the data inconsistency that may occur
updated queries and scripts to update obligations/outlays
decided that a separate application would be suitable for FACTS data ingestion and processing
working on Reqonciler
- requirements

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;

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

deployed new FA, queries.. BusyBar still doesn’t work…
went over the queries with Lenny
changed Percent values to round up
correctly set widths for the query result datagrid
Flash Builder gave me weird errors and crashed constantly, created new workspace and the problems seem gone.

deployed new FA, project totals not coming up…. hard to believe that the BusyBar PopUp broke the events handling….
- created two separate FA’s – FinancialAssistant.cursor.swf and FinancialAssistant.localbusybar.swf to try next week.
went over the details on how to build queries on Query Builder with Lenny
found that the queryBuilderConfig.xml was a older version running on site…. verified that the PM Actuals rolls up correctly with the new config.
created a query for Lenny – QueryBuilderQueries.sql

viztool meeting
fixed AddableListComboBox showing 1st element list
fixed height of the datagrid to fixed size
added ProgressBar for the database query
- tried to separate into utils project, exception thrown….
COGNOS data ingest take long time… looking into it.

discussed next gen FA applications with Phil – write up to come…
continue working on integrating RA with FA
- fixed all dynamic class loader references to the new package names
- changed change logs files to RA and FA
- testing done!
prepping for deployment as people are getting back to work.

since we are moving away from maven, it would be good to combine FinancialAssistant and RequisitionAssistant into a single project
working on combining FA and RA
- committed FA and RA
- created new project based on FA – FinancialAssistant4
  - moving RA stuff to FA4
- moved database specific stuff from RA to MySQLIf4
- compiled and ran, checked in as FinancialAssistant4

keeping track of what to deploy at https://viztales.wordpress.com/to-deploy-whenever-they-are-ready/
working on script to update Obligations/Outlays for EA’s
- created and ingested test data – Contracts Example.xlsx
- set up projects for EA’s
- query to get contracts data mapped to EA’s
  - SELECT *
    FROM budget_centers bc
    LEFT JOIN budget_center_contracts AS bcc ON bc.uid = bcc.budget_center_id
    LEFT JOIN contracts_cognos AS cc ON cc.sub_budget_center = bcc.sub_budget_center
    AND SUBSTRING(cc.requisition_id, 5) = bcc.requisition_id
    WHERE bc.req_type = ‘EA’
- updated obligation_outlays_queries.sql
- updating update_obligations_outlays.py to update!
- fixed get_cognos_outlays query to use expensed_date, not committed_date

working on Query Builder
- modifying Obligation/Outlay update scripts to update EA Req’s
added Database Management Panel to FA
- added database name to the setUpModel.xml – was using hardcoded project_portfolio
fixed Capability not showing in ReqAssistant

deployed new FA and SQL Query to update obligations/outlays
- Sub Projects working, list of projects shown
- update query works!
cleaned up tables that uses AddableListCombo – with Lenny’s input
- set defaults for some comboboxes…. table with table name, default value, and editable?