Monthly Archives: March 2013

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.15.2013

  • cleaned up menus in the main panel and ProjectMgmtPanel
  • saving database modifications to ProjectManager/src/main/resources/database/DBUpdateEnhancements.sql
  • created a copy of ProjPortfolioMgr webapp – ProjectManager – to use test database, project_portfolio_enh
  • created budget_center_contracts – store unique contracts from contracts_cognos table
    • additional column, budget_center_id, to map budget_centers to contracts
    • query to add contracts
      • 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, 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
        FROM contracts_cognos
        GROUP BY requisition_id, po_reference

  • add columns to projects table
    • ALTER TABLE `projects` ADD `center_name` VARCHAR( 50 ) NULL ,
      ADD `center_number` VARCHAR( 50 ) NULL ,
      ADD `appropriation` VARCHAR( 30 ) NULL ,
      ADD `type` VARCHAR( 50 ) NULL ,
      ADD `capability` VARCHAR( 50 ) NULL ,
      ADD `expenditure_center` VARCHAR( 50 ) NULL ,
      ADD `investment_portfolio` VARCHAR( 50 ) NULL ,
      ADD `program_element` VARCHAR( 50 ) NULL ,
      ADD `facts_pe` VARCHAR( 50 ) NULL

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.4.13

7:30 – 3:30 OP_GEN_OPS

  • Well, it’s been a hell of a weekend. Last Friday, at 3:55 pm, I get an email from Facilities that we need to be ready to move out of the Mill at 9:00 AM on Monday. I say that we need a bit more time and that we are in the middle of some particularly intense work with the customer. They say, sorry, but you’re moving. I escalate up to the exec VP level and finally sanity returns and we have some time. It’s not quite done yet, as I need to get a letter from Mill management saying that we don’t have to return the spaces to their original condition, since that would require putting the old walls back up and covering them with mismatched paint.
  • But that’s not all. On Saturday, Dong and I get a stop work order from WCC: “The Government has directed that all contractors that they may not nor are they authorized to work outside of the current period of performance and funding.  No work may be done at risk.” aside from the somewhat incoherent grammar, my impression was that our contract had been a victim of sequestration. But when I swing by to discuss this with our customer, all the other contractors are there, and everyone swears that we have funding. We take this information to our management, who says, not, that’s wrong. Anyway, we get to spend at least one day charging overhead unable to do work. Grrr.

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