Category Archives: Projects

Dong Shin 03.18.2013

  • working on Budget Center to save to database…..
  • add required columns to budget_centers table
    • ALTER TABLE `budget_centers` ADD `funded_budget` DECIMAL( 10, 2 ) NULL , ADD `date_submitted_to_services` DATE NULL , ADD `date_received_from_services` DATE NULL , ADD `date_submitted_to_babf` DATE NULL , ADD `acceptance_date` DATE NULL , ADD `sow` TEXT NULL
  • modified SQL to insert budget_center_contacts data – need sum of all amounts
    • INSERT INTO budget_center_contracts( budget_center, appropriation_year, requisition_id, po_reference, acr, committed_date, committed_amount, obligation_date, obligated_amount, expensed_date, expensed_amount, po_start_date, po_end_date, contract_type, po_type_code, contract_no, vendor_id ) SELECT budget_center, appropriation_year, requisition_id, po_reference, acr, committed_date, SUM(committed_amount), obligation_date, SUM(obligated_amount), expensed_date, SUM(expensed_amount), po_start_date, po_end_date, contract_type, po_type_code, contract_no, vendor_id FROM contracts_cognos GROUP BY requisition_id, po_reference

Dong Shin 03.14.2013

  • VizTool status meeting – notes at the requirements page
  • still no network connection at the office
  • continue working on Project Editor
    • separated into two tabs; Project Information and Budget Information
    • added column filter for contracts – defaults to Contract Number, ACRN, Commited Amount, Obligation Amount, Expensed Amount, PM Actuals
    • added Remove, Remove All, Add, Add All contracts between claimed and unclaimed

Dong Shin 03.13.2013

  • working at home due to no Internet at the Columbia office
  • continue re-factoring Project Editor
    • added Project Budget Info Grid
    • added Edit button that shows Add Budget Information dialog to edit data utilizing the AddableListCB
    • added more information to the Budget Center dataGrid to show required fields, removed the unnecessary fields
    • modified Add Budget Center Window to reflect the changes to the Budget Center dataGrid
    • created ProjectContract class to reflect the COGNOS contract data
    • added claimed and un-claimed contracts dataGrid
    • drag-and-drop added to the claimed/un-claimed contracts dataGrid
    • the dataGrids are somewhat crowded, may need to use tabs…

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