Category Archives: VISIBILITY

Phil 3.12.13

8:00 – 4:00 ESSO

  • Regular backups.
  • Helped Chris get on the servers, since it looks like he’s taking over management of them
  • The move went well yesterday. I got all my stuff set up, but no connection to the internet yet.
  • Probably will spend time looking at the DbRemoteObject code. Need a way of sending the desired database name, and also see what’s causing the creation of two tables in the current system.

Phil 3.11.13

8:00 – 1:30 ESSO

  • Backed up everything
  • Installed new Java and verifies that everything is working
  • 10:30 Meeting with Chris B, Denise P, and Bill A. to discuss who has the responsibility to run the server/it infrastructure.

Phil 3.8.13

8:00 – 4:00 Esso

  • Backed up everything
  • Deployed the new version of PA with the concatination fix.
  • Long discussion with Lenny about mapping between Req’s and $$. Our thought was that the contract would be the best way to determine how to distribute money in the case where multiple projects shared a MIPR, but it might turn out to be the Budget Center/Sub Budget Center.
  • And we still need to add a check on the version of the software that’s being run. In case it’s not written down anywhere else, it’s as follows:
    • When the software loads up for the first time, it reaches out to the DB and asks what the date of the client code is. The table has the app name (PPM, PA, VSS, DataViz, etc), and a date.
    • If the client’s date is later than the stored date, then the date on the server is updated.
    • If the client’s date is older, a dialog comes up that tells the user to remove any cached data from their browser and reload the client.
  • Going to see if my DbObject code can be used for the version check dialog. Getting reacquainted with the code.
  • Got the example (written M 2011) running. Nothing in the server class folder but libraries. Kinda cool.

Dong Shin 03.07.2013

  • VizTool meeting cancelled
  • Weird PA problem. SQL error I saw at the Mill happened on-site, couldn’t figure out how it was able run before…. restored to 02.04 version
  • removed the Status “(UNFUNDED)” from the PA – ProjectStatusItemRenderer
  • built PA for deployment tomorrow
  • working on ProjectManager
    • created vendors, contracts_cognos tables
    • added sample data from Excel spreadsheets to the tables
    • query to generate contracts data
      • SELECT c.budget_center, c.appropriation_year, c.po_reference, c.acr, v.vendor_name, v.address_line_1, v.city, v.postal_code, c.committed_date, c.committed_amount, c.obligation_date, c.obligated_amount, c.expensed_date, c.expensed_amount, v.vendor_id, v.vendor_abbr, c.po_start_date, c.po_end_date, c.contract_type, c.po_type_code, c.contract_no
        FROM contracts_cognos c
        LEFT OUTER JOIN vendors AS v ON c.vendor_id = v.vendor_id

Phil 3.7.13

7:30 – 3:30 ESSO

  • Had to bounce the server for some reason. The publisher servlet was not working correctly…
  • Turned off the Alert* scripts by setting the time to null in the DB. The VSS app isn’t working for this.
  • Rolled the PA back to the version compiled of Feb 4, due to an incomplete SQL being sent to the server.
  • Wrote up status report for Feb
  • Sent meeting notes to PIT crew.
  • Back to YUI and JavaScript. Webstorm came out with a new version (6.0), which is quite pretty:
    Back to the Future?

    Back to the Future?

     

  • Finished Chapter 3 UI Effects and Interactions. It mostly made sense.

Dong Shin 03.05.2013

  • VizTool meeting – went over the features of PPM 2.0(?), details at Phil’s blog
  • my workspace for the Flex projects gone! manually restoring one by one.
  • checked out PPM code to create a new project to support the new features and checked into SVN – ProjectManager

Phil 3.5.13

7:30 – 3:30 – ESSO

  • Good meeting with most of ISR-PMO, it seemed about PPM 2.0 (Beyte) The features are roughly as folows
  • Main panel
    • Global search (includes ad-hoc columns for things like searches for ACRN#)
    • Project selection dialog
    • User management
    • Appropriation Management
    • Project Mapping
      • Left Panel (project)
        • Project info. Move all the common elements from budget centers, etc to project info
      • Middle Panel (Req’s)
        • Funding by MIPR/EA
        • Date requested from service
        • Date received from service
        • Date submitted to BA/BF
        • Accept date
        • Funded budget (equals committed – autofilled)
        • Total budget
        • S.O.W. (affords keyword search)
      • Right Panel (Contracts)
        • D&D between bottom and top panels
        • Columns can have all of the COGNOS data. Columns may be ad hoc, and should be selectaple, with stored preferences
        • Top Panel(mapped)
          • Tracking of contract-specific requests (i.e. “awaiting response for xxx”)
          • Sub funded budget amounts (for EA). If a mapped line item does not have all the funded budget amount, then the contract remains in the unclaimed section with the remaining $$ amount
          • May have a “placeholder” contract number that an unclaimed or automatically mapped contract can override (via D&D)
        • Bottom Panel (unclaimed)

 

Phil 3.1.13

7:30 – 3:30 ESSO

  • Need to write up monthy status
  • Meeting to discuss contract relationships with PIT crew. We are starting to think that we can pull all this from Cognos and then correlate in a query script.
  • PPM Prototype Design

    PPM Prototype Design

Dong Shin 02.28.2013

Phil 2.26.13

8:00 – 4:00 ESSO

  • Went to burn a disk this morning but my “deploy” directory on Google Drive had not updated the vis2 swf. Dong’s zip files were there, And the assets directory had been touched. Odd. This could be from the new workspace install.
    • Verified that the files had been written into the right place. They’re just not updating. Somehow the files aren’t getting marked…
  • Deployed new PPM and PA
  • Checked out the Town Hall venue and made sure that the Data Visualizer would show up well.
  • Need to be by 7:30 tomorrow to support Town Hall
  • Burned a disk with new versions of PPM and Vis2
  • Lots of fun JavaScript today. YUI is nice and solid. The “plugin” components are particularly nice. Here’s a draggable, resizable square:
<style> #demo {     width: 100px; height: 100px; border: 1px #000 solid; background: #d72;     position: relative; } </style>
<div id="demo"></div>
<script src='http://yui.yahooapis.com/3.5.0/build/yui/yui-min.js'></script> 
<script> 
    YUI().use('dd-drag', 'dd-proxy', 'resize', 'resize-constrain', function (Y) {     
        var resize = new Y.Resize({ node: '#demo' });
        resize.plug(Y.Plugin.ResizeConstrained, {minWidth: 50, maxWidth: 200});
        var dd = new Y.DD.Drag({ node: '#demo' });     
        dd.plug(Y.Plugin.DDProxy); }); 
</script>

Phil 2.25.13

7:30 – 3:30 ESSO

  • No response from Dimitri WRT Webstorm request – Ping’d him – he’s going to do something?
  • Created slideshow for Chris. Still need budget info
  • Deployed a new Vis2 with tooltip zoom. It goes way too far. Scaling back to 1 – 4 is more than enough.
  • Two bugs
    • PPM – Data is not rolling up correctly in all fields, seems to only take the first project. The example to test against is ACC – AGS O&M (174596). It’s a real bug. Printed out some screen
    • The obligated amounts are not showing up on the charts. It looks like when we changed the tables we forgot to change the query. Fixed

Dong Shin 02.25.2013

  • Fixed PA showing invisible types (admins only) – Outlay $ (Reported in FACTS)
  • moved buttons to the top in PPM – ProjectMgmtPanel, CreateProjectPanel, UserRolesManagementPanel
  • added filter to Funding Request
  • Obligations weren’t showing in the FY13 summary charts – forgot to update quest when it was changed to Reported FACTS Obligated $: