Phil 3.21.13

8:00 – 4:00 ESSO

  • Flurries this morning. This is soo wrong.
  • Started a ticket for renewing certs for the integration and production servers.
  • Tested out the 6 month data , which everyone liked.
  • The “save” event for a slide doesn’t seem to be happening after the first save. Need to fix that
  • Set the horizontal axis item renderer to show (selectable month/day?) data in timeline views
  • Spent some time going over the mechanism for passing variables to a SQL query inside VSS
    • Add a column for the variables in the query table. This replaces the variables flag, and will store the variables as key/value pairs in XML. Note that this will always be <String>:<String>. Each query is allowed only one variable object.
    • The python script is able to use new facade methods to write the variables into the slot.
      • varClear() // clears the HashMap
      • varSet(key:String, val:String); // sets a key value pair
      • set(queryName:String); // finds the appropriate query in the query table.
    • The variable object must be set() before the sql is called.
    • When editing the SQL in the SQL editor, the “raw” query with the substitution tags is shown if the “variables” checkbox is FALSE. The state of the “submit” button tracks the variables checkbox. If the checkbox is TRUE, then the macro substition is run that the query can be submitted.
    • When running a scheduled query, there needs to be logic to perform macro substitution if the variable field is NOT NULL
    • Also, the list of facade methods needs to be made current.

2:00 – 2:30 Talked with Jeremy Fremin about R&D opportunities in Novetta

Dong Shin 03.20.2013

  • need to modify presentation scripts/queries to show 6 months of data instead of full 24 months
    • looked at the queries and scripts, need to get working scripts/queries from site.
  • screen resolution of the monitor in the ISR PMO conference is 1280×1024
  • continue working on ProjectManager
    • working on filtering contracts data
    • created procedure to import contracts_cognos to budget_center_contracts –  import_cognos_contracts
      • CREATE DEFINER=`root`@`localhost` PROCEDURE `import_cognos_contracts`()
        NO SQL
        BEGIN
        TRUNCATE budget_center_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;
        END

Phil 3.20.13

8:00 – 4:00 ESSO

  • First day of Spring! Brrr!
  • Meeting with Chris B. Lenny, Carla and Thom. Next meeting is on Thursday 28th. We should try to have some version of the new PM deployed for evaluation
  • Need to change the scripts for FY12 and FY13 to show only 6 months of history. Possible change to have only bar charts. Still a desire to have something in the horizontal axis that’s legible. Possibly just text.
  • Got the server up and running in eclipse. Most of the remaining problems involved getting jar files to pass through to the final application. In the end, jars used by JavaUtils had to be copied to the test program and exported.
  • Got the Flex code to connect with the debug java server and stepped through things. Found that the classloader was working fine, although it was important to actually copy over the properties files and stick them in the WEB-INF/classes directory in the Juno(Java) project. The classes from all the other sources were merged correctly. Yay.
  • Tomorrow, we create the Flex version component.

Phil 3.19.13

8:00 – 4:00 ESSO

  • Spent a good part of the morning trying to figure out Keystore again. I need to export a jks file?
  • Working on getting the Tomcat server to run inside of Eclipse.
  • Had to add flex jars and javaUtil classes to the Deployment Assembly dialog in Properties for RemoteObjectTestbed. Had to do it through the QuickFix mechanism in the Problems pane. Adding it directly didn’t seem to work. Also, tried to add the JavaUtils project rather than just the classes, but that didn’t seem to bring along the classes and added warnings about the jar files used to construct JavaUtils. Since they’re needed for logging and such, I’m going to add them?
  • Description Resource Path Location Type
    Classpath entry M2_REPO/junit/junit/3.8.1/junit-3.8.1.jar is marked for publish/export but is not exported on the project classpath. Classpath visibility within Eclipse and at runtime will differ. javaUtils P/javaUtils Classpath Dependency Validator Message
  • Things are working, but I still can’t get the eclipse server to work with the installed Tomcat location. It’s possible that this could be done using the VM arguments in the Arguments tab of Run Configurations, but I really don’t want to try that yet.

    Tomcat Run Configuration

    Tomcat Run Configuration

Phil 3.18.13

Phil 8:00 – 4:30 ESSO

  • On the whole, being back at work is much better than watching over your parents at the hospital.
  • Backups
  • Getting a new server cert for the integration machine. Many changes, dead links, etc, but the help is better, and makes more sense. Sent off, though I’m not sure if I go all the people right.
  • Working on getting the server to run in the debugger. So far I’ve had to download updates to all the web tools, and the JST adapters and JST adapter extensions.
  • Updated the HOW TO SET UP ECLIPSE FOR SERVER SIDE JAVA AND CLIENT SIDE FLEX pages to fix a lot of changes since Helios, but can’t seem to connect to the pages – just a bunch of 404s. Calling it a day.

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