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

Phil 10.16.13

8:00 – 4:00 SR

  • Obligation and Commitments from FACTS are cumulative. Actuals are non-cumulative. Remove all the calculations summing up obligations and commitments by monthly and store monthly values from Cognos.
  • IE7 works with YUI!
  • Need to add search to “View Financial Data”. Rather than showing all the subelements, clicking on a row in Requisition Information (top grid) will show the associated detailed financial view. We should also add a search to Req Info.   The summary always shows.
  • Create historical record Cognos data table. We can use scripts later to integrate data into our reports…
  • Finished chapter 2, starting on chapter 3. Also got timers working from the gallery. One search, one bug, one additional search.

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.

Phil 10.15.13

Phil 8:00 – 3:30  SR

  • The dialog for versions has a broken “dismiss” button.
  • Unlock project is unlocking multiple projects locked by the same user(?)
  • Trying out YUI on the integration server…. Success! Take that, IE7! Ok, maybe not. Just realized that I only ran the testes using the browser that’s on the server, which is FF. Need to try running on a client box with IE tomorrow. The most important example to run will probably be add_capability.html.
  • Working my way through the YUI cookbook. In the element_classes example (Recipe 2.2), there is a call to Y.log(). It turns out that there is support for a logger window. I found this by Googling “yui Y.log” The top result was http://yuilibrary.com/yui/docs/console/.  Which was pretty much what I needed. Using the documentation as a guide, I was able to integrate it, including giving it a global scope.  And then, after a few more minutes, I was able to add draggable behavior by adding “dd-plugin” to the YUI().use() arguments and them to the Y.Console.plug() arguments. For future reference, here’s the total code required for the console, with three lines of test code (bracket the code with <body class = “yui3-skin-sam”>):
YUI().use('console', 'overlay', "console-filters", "dd-plugin", function (Y) {
    // Console has no required configuration
    // In fact, you often don't even need to store the instance
    var cons = new Y.Console({ logSource: Y.Global })
            .plug(Y.Plugin.Drag, { handles: ['.yui3-console-hd'] })
            .plug(Y.Plugin.ConsoleFilters);
    cons.render();
    Y.log("Console info message", "info", "element_classes");
    Y.log("Console warn message", "warn", "element_classes");
    Y.log("Console error message", "error", "element_classes");
});
  • Skedaddled a bit early to get in some good weather

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

Phil 10.11.13

8:00 – 4:00 SR

  • Backups
  • Meeting with Lenny
  • Deployed a new version of FA that fixed the comboboxes but broke other things. Also, it looks like the QuieryBuilder config isn’t up to date.
  • Installing JetBrains 7.0
  • Back to Javascript. I think a good goal is to produce a suite of tests to run on IE7 and see how that goes.
  • It should actually go pretty well, assuming this compatibility chart is correct:
  • Also, there seems to be a conference coming up.
  • Getting back into the hang of YUI. Still cool. And about a third caught up.