Category Archives: Projects

Phil 11.18.13

8:00 – 4:00 SR

  • This has been the craziest two weeks ever:
    • Dad has heart attack while I’m leaving for a conference
    • Conference, plus the most delayed flight I’ve ever been on, arriving at 1:30 am…
    • Comprehensive exam and portfolio
    • Final paper for 760 – 6 pages in 3 days
    • And, wait for it – I get hit by a car while out riding on Saturday.
    • Looking forward to a nice, slow week.
  • Backups
  • Fake Cognos

Phil 11.15.13

8:00 – 12:30 SR

  • Add appropriation name as a column
  • Overdue
    • Additional query Timeline – don’t cull the less than 21, but keep the greater than 2000
    • Acceptance – For any item that has a filled date field, don’t show.
    • Obligations – Don’t show if 100% obligated
  • Committed amount is currently using Cognos data for committed amount. Need to change to Req. Funded. Keep the committed date.
  • Presentation ready by COB Nov 27
  • November 2014 queries does not show out year 2013  etc.
  • More Face Cognos data

Dong Shin 11.14.2013

  • deployed new FA, RA, FinancialAssistant.jar, and queries
    • Obligations/Outlays not meeting goals (95%) should be navigated thru month combobox
    • change the query to include all fiscal years for the selected FY
    • Excel export from Query Builder
    • FA missing Roles Management panel
    • modified Overdue Obligations/Outlay queries to ignore more than 2000 days….
  • working on FA
    • changed the query to return all the data for the selected FY
    • added UserRolesManagement panel from FA3
    • working on queries to navigate obligations/outlays not meeting goals by monthly

Phil 11.12.13

8:00 – 4:00 SR

  • Back from CA and YUI class. It was 72-76 and clear blue skies out there. Here it’s 40 with sprinkles and gloomy clouds. But our bad traffic is way better than their bad traffic.
  • Backups
  • Need to do status for Tangie. Done.
  • Composing email to Jenny Donnelly about YUI
  • Adding Typescript (Cool Typescript Playground)
  • Following directions on the JetBrains site
    • Downloading and installing node.js
    • added NODE_JS_HOME as a path variable
    • installed the typescript package. Note that it gets installed to the user directory, not the node dir: C:\Users\Phil\AppData\Roaming\npm

  • Pressed the “Configure” button, which downloaded sources
  • Poked at the “set scope” link, which doesn’t have an obvious effect.
  • Clicked on “Add Watcher” in the pop-up alert (shown below) that appeared when I tried to save “typescriptTest.ts”

watcher_prompt

  • Added the C:\Users\Phil\AppData\Roaming\npm\tsc.cmp path to the watcher config dialog and then clicked “OK”
  • Ok, so now Typescript works. However, integrating it looks to be a pain..? But at the same time, it looks like there is a GitHub project that has set up all the interfaces?
  • Ok, the typescript runs, the watcher converts it, and a small HTML file launches it.

TypeScript:

class Greeter {
    greeting: string;
    constructor(message: string) {
        this.greeting = message;
    }
    greet() {
        return "Hello, " + this.greeting;
    }
}

var greeter = new Greeter("typescript");

var button = document.createElement('button');
button.textContent = "Say Hello";
button.onclick = function() {
    alert(greeter.greet());
}

document.body.appendChild(button);

Transpiled JavaScript:

var Greeter = (function () {
    function Greeter(message) {
        this.greeting = message;
    }
    Greeter.prototype.greet = function () {
        return "Hello, " + this.greeting;
    };
    return Greeter;
})();

var greeter = new Greeter("typescript");

var button = document.createElement('button');
button.textContent = "Say Hello";
button.onclick = function () {
    alert(greeter.greet());
};

document.body.appendChild(button);
//# sourceMappingURL=typescriptTest.js.map

HTML (Calling JavaScript)

<!DOCTYPE html>
<html>
<title>TypeScript test</title>
<body>
<script type="text/javascript" src="typescriptTest.js">
</script>
</body>
</html>

Phil 11.1.13

8:00 – 4:00 SR

  • Backups
  • Deployed new versions of FA, RA, and Reqonciler
  • Debugged queries with Dong
  • Started to write a Cognos fake data generator. This will produce a .sql file containing a set of projects and a series of excel files that will mimic Cognos downloads. The excel files will have errors in them that mimic what we’re finding in the Cognos pulls that Lenny is doing. A text file will also be produced that lists the number and types of errors. THe goal is that Dong should be able to upload the sql files (which will truncate the project tables and reload them) and then ingest (probably 3) spreadsheets. If there are no errors and all the numbers add up correctly, then we have a bug free system. At this point the project and rough framework are done.

Dong Shin 11.01.2013

  • FA/RA fixes
    • added Project ID and Project Name to RA
    • fixed filtering/searching not working.
    • added currency to queryBuilderConfix.xml
  • deployed new FA/RA and queries to update obligations/outlays
    • cc.po_reference = bcc.po_reference needed for __view_monthly_obligations_outlays_by_contract

Dong Shin 10.30.2013

  • changed Numeric to Currency in queryBuilderConfig.xml, Numeric is now number, now $ values
  • working on Outlays query…
    • decided to update the outlays data similar to obligations, may not have to use python script at all.
    • created views to replace the views created yesterday!
      • __view_monthly_obligations_outlays_by_contract, to be used for both outlay and obligations
      • __view_monthly_obligations_outlays_by_req_id, to be used to update obligations_outlays table
    • two update queries
      • UPDATE obligations_outlays oo
        LEFT JOIN __view_monthly_obligations_outlays_by_req_id AS vv
        ON vv.bc_uid = oo.funding_id
        SET oo.month_1 = vv.month_1_obligated, oo.month_2 = vv.month_2_obligated, oo.month_3 = vv.month_3_obligated, oo.month_4 = vv.month_4_obligated,
        oo.month_5 = vv.month_5_obligated, oo.month_6 = vv.month_6_obligated, oo.month_7 = vv.month_7_obligated, oo.month_8 = vv.month_8_obligated,
        oo.month_9 = vv.month_9_obligated, oo.month_10 = vv.month_10_obligated, oo.month_11 = vv.month_11_obligated, oo.month_12 = vv.month_12_obligated
        WHERE type = ‘Reported FACTS Obligated $:’
        AND year=2013 AND year_count=1
      • UPDATE obligations_outlays oo
        LEFT JOIN __view_monthly_obligations_outlays_by_req_id AS vv
        ON vv.bc_uid = oo.funding_id
        SET oo.month_1 = vv.month_1_outlay, oo.month_2 = vv.month_2_outlay, oo.month_3 = vv.month_3_outlay, oo.month_4 = vv.month_4_outlay,
        oo.month_5 = vv.month_5_outlay, oo.month_6 = vv.month_6_outlay, oo.month_7 = vv.month_7_outlay, oo.month_8 = vv.month_8_outlay,
        oo.month_9 = vv.month_9_outlay, oo.month_10 = vv.month_10_outlay, oo.month_11 = vv.month_11_outlay, oo.month_12 = vv.month_12_outlay
        WHERE type = ‘Outlay $ (Reported in FACTS)’
        AND year=2013 AND year_count=1