Category Archives: Dong Shin

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

Dong Shin 10.15.2013

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.

Dong Shin 10.11.2013

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

Dong Shin 10.10.2013

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.

Dong Shin 10.08.2013

RA SQL errors from Lenny (Don Galbraith) – missing month string from sql… fixed
burned a cd for deployment tomorrow
un-mavenizing FinancialAssistant server project

Dong Shin 10.07.2013

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.

Dong Shin 10.04.2013

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

Dong Shin 10.03.2013

working on RA
- creating Invoice Viewer for Requisitions – done, need to discuss what additional functionalities are needed.
- Contract Number in Invoice Entry is TextInput now
- added support for typing in commas and decimals
- working on defaults table for AddableListCombo
  - addable_combobox_defaluts table
- found a way to put log4j server logs to mysql database
  - http://howtodoinjava.com/2013/04/08/how-to-create-logs-in-database-using-jdbcappender-in-log4j/
  - changed the message on SQLErrorWindow

Dong Shin 10.02.2013

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

Dong Shin 09.30.2013

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

Dong Shin 09.27.2013

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?

Dong Shin 09.26.2013

no meeting today….
Sub Project bugs
- ~~Requisition Data saves to the parent project~~ (not clearing?) – fixed
- Select Sub Project in Link Project shows empty list – cannot duplicate here….
added obligation/outlay goals and values percent for all months. This can be filtered by selecting month from the month combobox
working on updating Obligations/Outlays with maximum values in current and past months
- UPDATE obligations_outlays_test
  SET month_2 = GREATEST(IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_3 = GREATEST(IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_4 = GREATEST(IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_5 = GREATEST(IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_6 = GREATEST(IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_7 = GREATEST(IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_8 = GREATEST(IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_9 = GREATEST(IF(ISNULL(month_9), 0, month_9), IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_10 = GREATEST(IF(ISNULL(month_10), 0, month_10), IF(ISNULL(month_9), 0, month_9), IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_11 = GREATEST(IF(ISNULL(month_11), 0, month_11), IF(ISNULL(month_10), 0, month_10), IF(ISNULL(month_9), 0, month_9), IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1)),
  month_12 = GREATEST(IF(ISNULL(month_12), 0, month_12), IF(ISNULL(month_11), 0, month_11), IF(ISNULL(month_10), 0, month_10), IF(ISNULL(month_9), 0, month_9), IF(ISNULL(month_8), 0, month_8), IF(ISNULL(month_7), 0, month_7), IF(ISNULL(month_6), 0, month_6), IF(ISNULL(month_5), 0, month_5), IF(ISNULL(month_4), 0, month_4), IF(ISNULL(month_3), 0, month_3), IF(ISNULL(month_2), 0, month_2), IF(ISNULL(month_1), 0, month_1))
  WHERE type = ‘Reported FACTS Obligated $:’ OR type = ‘Outlay $ (Reported in FACTS)’

Dong Shin 09.25.2013

deployed new FA and database updates today – notes at Phil’s blog.
working on setting correct Obligation/Outlay values

Dong Shin 09.24.2013

working on Query Builder
- added ProgressBar to the Query Builder Panel
- added req totals view
  - CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `__view_req_totals` AS select `budget_centers`.`req_id` AS `req_id`,sum(`budget_centers`.`funded_budget`) AS `req_id_total` from `budget_centers` group by `budget_centers`.`req_id`;
- added % values to the queries…
  - capability, bcc.budget_center_name AS ‘Budget Center Name’, bcc.budget_center AS ‘Budget Center’, req_id AS ‘Req ID’, vrt.req_id_total AS ‘Total’,
    CONCAT(obligation_month_12,’%’) AS ‘Obligation Goal Percent’,
    CONCAT(IF(o.type = ‘Reported FACTS Obligated $:’,month_12/vrt.req_id_total*100,0),’%’) AS ‘Obligated Value Percent’
    WHERE capability = ‘ACC’
    GROUP BY bcc.budget_center, req_id
Sub Projects are back!
- reworked Project Editor panel to show Sub Project