Phil 2.8.13

8:00 – 4:00 ESSO

  • Backups.
  • There is an issue where an item that is showing up in the Line Item View in PA and the Financial Data Entry view in PPM is not showing up in the Status View in PA. I’ve taken screenshots on what I think all the relavent pages are.
    • Turns out that’s a feature. That particular project is complete, and does not remain to fill out. Dong will verify on Mondy, but we’re betting that’s the case.
  • Javascript.

Phil 2.7.12

8:00 – 4:00 ESSO

  • Backups
  • Got comments from Chris and Carla. Handed off to Dong
  • Lunch with Diane
  • More JavaScript
    • Looking at how to implement the Data Dictionary
  • Leave promptly at 4:00! Class!

Phil 2.6.13

8:00 – 4:00 ESSO

  • Meeting with Chris, Thom, Carla, Lenny and Dong. The notes are here.
  • Some cleanup for Diane’s visit tomorrow. Also asked Dimitri for permission to charge overhead for the real move to WCC
  • Went through the design of FA with Dong, which is all here.

Phil 2.5.13

8:00 – 4:00 ESSO

  • Deployed new Vis2, PPM and PA. Mostly went well, except for one hiccup with the financial_remediation_plans table, that took about an hour of beating on before it submitted to our will
  • Walked through the potential architecture for FA with Dong. Now we need to write it up here.

Dong Shin 02.04.2013

  • phpMyAdmin has been really slow since I upgraded XAMPP to 1.8.0 which contains a Tomcat instance. Upgrading pmyMyAdmin to the latest (3.5.6) didn’t resolve it.
    • Adding $cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’; to config.inc.php (careful with the single quotest!) as suggested at http://ellislab.com/forums/viewthread/224775/ did the trick!
  • Changed PPM to require FMP’s on only Obligations and Outlays

Dong Shin 02.01.2013

  • cleaned up sql scripts – fixes errors when running stored procedures with temporary/in-memory tables
  • figured out how to back up stored procedures, is turned off by default
    • mysqldump –routines outputfile
    • need to add this to the backup script on site
  • working on PPM to have only Obligations and Outlays require FMP’s

Phil 2.1.12

Spent the morning doing PhD stuff

1:30 – 5:30 ESSO

  • Working on making larger fonts in tooltips. Done. Just wound up setting the gloab ToolTip and DataTips styles in the vis2.onSliderChanged() method.
  • Need to set the default _labelFieldColumnName to the zeroth, column. So that code was there in WidgetBase.listColumnsHandler() for a reason. It was just being too aggressive…

Dong Shin 01.31.2013

  • presentation for Col. Duke – went pretty well!
  • finished up adding FMP View button – a new window and lots of back communications
  • FMPs are now required for only Reported Actual Obligated and Outlay $ Reported in FACTS, others are ignored.

Phil 1.31.13

7:30 – 3:30 ESSO

  • Brought in a new version of vis2, but the colors still don’t work quite right for a three-element chart
  • Making larger text looks as straightforward as setting up the magnification and sizing appropriate to the conference room screen.
  • Tooltips will still be a problem. Need to get the magnification value passed to them.
  • Need to include the name of the Label Column when loading from XML. Fixed. For some reason I was forcing the _labelColumnField to the name of the 0th column in WidgetBase.setColumns. Dunno why.

Phil 1.30.13

8:00 – 4:30 ESSO

  • Presentation prep
    • Need to add the ability to sum across rows in the value views. This might be doable in advanced queries. Need to check further.
  • Fixed the color mapping functions to have more variation so that colorblind users can see the pie charts.

Dong Shin 01.30.2013

  • prep for Col Duke’s presentation
    • latest data generation (script) and ingest – set to run every morning
    • alerts ingested – need to fix the script that contains the Stored Procedure
      • temporary and memory
    • went over the charts with Chris
  • FMP’s should only be Obligations and Outlays – tabled for discussion later
  • continue working on FMPs for PA

Phil 1.29.13

8:00 – 4:00 ESSO

  • Worked on getting all the data in the data visualizer for Col Dukes’ presentation on Thursday. 
    • Cleaned out a lot of old code, files and cruft in general.
    • Had problems getting the ingestor to swallow alerts. Diagnosing this lead to a problem with Projects Under Budget. We’re about halfway through the fix for all that.
    • Loaded up the latest COGNOS data
    • Integrated Comitted with the rest of the FY13 data
  • Javascript
    • Chapter 6, or how to do OO when there is no such thing as a class in JavaScript.
    • JavaScript prototypes are most peculiar.

Dong Shin 01.29.2013

  • spent most of the morning working on queries and reports
    • got Committed ingested for FY13
    • cleaned up Ingest Manager data, Scripting
    • ingested FY12 data
  • working on adding FMP to PA
    • modify table – financial_mitigation_plans
      • ALTER TABLE `financial_mitigation_plans` CHANGE `type` `type` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Obligation'