Dong Shin 07.25.2012

  • added total budgets for project and sub projects in separate datagrids
    • budget is entered in only one datagrid
    • total, allocated, available calculated separate
    • working on retrieving individual budgets from sub projects

Phil 7.24.12

8:00 – 2:30 ESSO

  • Backups on site
  • Tried the Flex 3.5B version of the code. Neither vis2 or AccountManagers worked. I find that particulalry vexing since AM was compiled entirely with 3.5B.
  • Dong got XP up and running with the proper versions of IE7 and Flash player. Of course, the code works just fine. Sigh
  • Trying Mike’s workspace. Was able to compile, though maven errors will have to be dealt with in the future if this works
  • Added the datavisualization swc to the 3.5B version of vis2 build path. THis was probably the reason that the version yesterday would crash here. Dong has built a 3.5B and 3.6 version of AccountManagers to try as well.

2:30 – 6:00 FP

  • PAD Meeting
  • Wired up new mouse, and found a laser USB mouse that can be sacrificed

Dong Shin 07.24.2012

  • finished installing XP no Phil’s box – after several failed attempts
    • IE 7 7.0.5730.13
    • Flash Player 11.2.202.228
  • tried various versions (3.5, 3.6 compiles, SWFs that we tried at Fort) – Everythings loads fine!
  • reworking query for sub-projects to return yearly totals for parent projects

Phil 7.23.12

8:00 – 4:00 ESSO

  • Backups on site. No fires to deal with.
  • Started to put XP on the Sony laptop. No luck – XP couldn’t recognize the drives. And, the serial number for the CD was *only* in the email that Microsoft sent me, which was at home.  So I went home, got my car from the shop, and brought back one of my old desk side units. Dong is in the process of installing XP on it, since he has all the spare monitors on his desk.
  • Copying my Eclipse workspace over so that I can change compilers without having to worry about unforeseen consequences.
  • Compiling everything with 3.5B results in runtime errors with AdvancedDataGrid, and you can’t compile FlexiChart with anything less than 3.6. Trying to compile just EdgeUtils and Management Utils with 3.5B. Vis2 is compiled with 3.6, while I’m compiling AccountManager with 3.5B. Will test on site tomorrow to see how that works.

Phil 7.20.12

8:00 – 4:00 ESSO

  • Ran Dong’s test SWFs, and the culprit appears to be the settings.
  • Deployed the new PPM and PA
  • Working on adding in the Label Field for numeric plots. Done
  • Adding _labelFieldColumnName to xml save and restore. Done
  • Added a tool tip to the combobox, which is not coming up. Odd. Checked in anyway. Something for Monday.
  • Looks like the compiler is the culprit. Downloaded Flex 3.5 and added it to my SDK list, but didn’t install it while I was working on the labeling.

Dong Shin 07.19.2012

  • got bug list from Jessica
  • fixed sub projects not showing up for the PMs
  • building several different version of Visibility to trouble-shoot IE7 problem per Phil’s recommendation
    • had to fix some hard-coded paths and project settings

Phil 7.19.12

8:00 – 4:00 ESSO

  • Bringing in many combinations of vis2. Let’s see if any fix the IE7  problem!
  • Well, my build didn’t work, so that means that it’s probably not Maven. Dong’s going to make copy the workspace on Mike’s machine and try the following:
    • Workspace 1: Change the project settings only.
    • Workspace 2: Update the code, but not the project settings
    • Workspace 3: Update everything
    • I may also try building in his workspace to see if my version will run.
  • Then I’ll try running those on the test server and see if there is any pattern.
  • Looking at a way to label the _plotAccordian charts using text from another column. pieLabelFunction2 in WidgetBase should be able to look at a given column. The name of that column will have to be stored out in the xml as well.
    • looks like I can use the nameField attribute (as shown here).
  • Burned a new disk of Dong’s updates for tomorrow.

Phil 7.18.12

8:00 – 5:00 ESSO

  • Spent all day on site
  • Dong’s
  • Did a presentation of the Project Assistant and PPM to the project PMs
  • Spent the rest of the day working on ingesting Cognos data and processing it into Flexichart-able tables
    •  Need to make the layout_xml blob larger
    • Need to fix the ‘manual’ desktop xml loading (from pasting) so that it can save
    • IE version of code still hanging on remote object access, even for Dong’s code. Ingest Manager works though, which points to a possible library issue.

Dong Shin 07.18.2012

  • spent most of the day on site with Phil prepping demo for Col. Duke
  • few bugs noticed – should be the Jessica’s list of bugs/enhancements
    • sub projects are not shown to the PMs in Project Management panel
    • add a budget summary panel to parent projects
  • burned Mike’s Visiblity SWF’s from his laptop to a CD

Dong Shin 07.17.2012

  • space between month and year causing Ingest Manager to fail, but works fine here… changed all the scripts to have month_year
  • scripts created
    • to retrieve FY Goals – FY12Goals.py
    • to retrieve PPM tool usages for the users – PPMUsersUsages.py
    •  to retrieve FMPs for 2012 – FY12FMPs.py, need clarification on how to do rates/goals
    • to calculate monthly status (actual / (goal * budget amount)) -FY12MonthlyStatus.py
  • query to retrieve tool usages
    • SELECT
      user, date, MAX(timestamp) as start_time, MIN(timestamp) as end_time, (UNIX_TIMESTAMP(MAX(timestamp)) – UNIX_TIMESTAMP(MIN(timestamp))) as duration_seconds
      FROM query_logs
      GROUP BY date
  • query to retrieve all obligation/outlay goals
    • SELECT
      appropriation, ‘obligation’ as type,
      SUM(IF(year=1, obligation_month_1, NULL)) as ‘Oct 2011’,
      SUM(IF(year=1, obligation_month_2, NULL)) as ‘Nov 2011’,
      SUM(IF(year=1, obligation_month_3, NULL)) as ‘Dec 2011’,
      SUM(IF(year=1, obligation_month_4, NULL)) as ‘Jan 2012’,
      SUM(IF(year=1, obligation_month_5, NULL)) as ‘Feb 2012’,
      SUM(IF(year=1, obligation_month_6, NULL)) as ‘Mar 2012’,
      SUM(IF(year=1, obligation_month_7, NULL)) as ‘Apr 2012’,
      SUM(IF(year=1, obligation_month_8, NULL)) as ‘May 2012’,
      SUM(IF(year=1, obligation_month_9, NULL)) as ‘Jun 2012’,
      SUM(IF(year=1, obligation_month_10, NULL)) as ‘Jul 2012’,
      SUM(IF(year=1, obligation_month_11, NULL)) as ‘Aug 2012’,
      SUM(IF(year=1, obligation_month_12, NULL)) as ‘Sep 2012’,
      SUM(IF(year=2, obligation_month_1, NULL)) as ‘Oct 2012’,
      SUM(IF(year=2, obligation_month_2, NULL)) as ‘Nov 2012’,
      SUM(IF(year=2, obligation_month_3, NULL)) as ‘Dec 2012’,
      SUM(IF(year=2, obligation_month_4, NULL)) as ‘Jan 2013’,
      SUM(IF(year=2, obligation_month_5, NULL)) as ‘Feb 2013’,
      SUM(IF(year=2, obligation_month_6, NULL)) as ‘Mar 2013’,
      SUM(IF(year=2, obligation_month_7, NULL)) as ‘Apr 2013’,
      SUM(IF(year=2, obligation_month_8, NULL)) as ‘May 2013’,
      SUM(IF(year=2, obligation_month_9, NULL)) as ‘Jun 2013’,
      SUM(IF(year=2, obligation_month_10, NULL)) as ‘Jul 2013’,
      SUM(IF(year=2, obligation_month_11, NULL)) as ‘Aug 2013’,
      SUM(IF(year=2, obligation_month_12, NULL)) as ‘Sep 2013’,
      SUM(IF(year=3, obligation_month_1, NULL)) as ‘Oct 2013’,
      SUM(IF(year=3, obligation_month_2, NULL)) as ‘Nov 2013’,
      SUM(IF(year=3, obligation_month_3, NULL)) as ‘Dec 2013’,
      SUM(IF(year=3, obligation_month_4, NULL)) as ‘Jan 2014’,
      SUM(IF(year=3, obligation_month_5, NULL)) as ‘Feb 2014’,
      SUM(IF(year=3, obligation_month_6, NULL)) as ‘Mar 2014’,
      SUM(IF(year=3, obligation_month_7, NULL)) as ‘Apr 2014’,
      SUM(IF(year=3, obligation_month_8, NULL)) as ‘May 2014’,
      SUM(IF(year=3, obligation_month_9, NULL)) as ‘Jun 2014’,
      SUM(IF(year=3, obligation_month_10, NULL)) as ‘Jul 2014’,
      SUM(IF(year=3, obligation_month_11, NULL)) as ‘Aug 2014’,
      SUM(IF(year=3, obligation_month_12, NULL)) as ‘Sep 2014’,
      SUM(IF(year=4, obligation_month_1, NULL)) as ‘Oct 2014’,
      SUM(IF(year=4, obligation_month_2, NULL)) as ‘Nov 2014’,
      SUM(IF(year=4, obligation_month_3, NULL)) as ‘Dec 2014’,
      SUM(IF(year=4, obligation_month_4, NULL)) as ‘Jan 2015’,
      SUM(IF(year=4, obligation_month_5, NULL)) as ‘Feb 2015’,
      SUM(IF(year=4, obligation_month_6, NULL)) as ‘Mar 2015’,
      SUM(IF(year=4, obligation_month_7, NULL)) as ‘Apr 2015’,
      SUM(IF(year=4, obligation_month_8, NULL)) as ‘May 2015’,
      SUM(IF(year=4, obligation_month_9, NULL)) as ‘Jun 2015’,
      SUM(IF(year=4, obligation_month_10, NULL)) as ‘Jul 2015’,
      SUM(IF(year=4, obligation_month_11, NULL)) as ‘Aug 2015’,
      SUM(IF(year=4, obligation_month_12, NULL)) as ‘Sep 2015’
      FROM obligations_outlays_goals
      GROUP BY appropriation
      UNION
      SELECT
      appropriation, ‘outlay’ as type,
      SUM(IF(year=1, outlay_month_1, NULL)) as ‘Oct 2011’,
      SUM(IF(year=1, outlay_month_2, NULL)) as ‘Nov 2011’,
      SUM(IF(year=1, outlay_month_3, NULL)) as ‘Dec 2011’,
      SUM(IF(year=1, outlay_month_4, NULL)) as ‘Jan 2012’,
      SUM(IF(year=1, outlay_month_5, NULL)) as ‘Feb 2012’,
      SUM(IF(year=1, outlay_month_6, NULL)) as ‘Mar 2012’,
      SUM(IF(year=1, outlay_month_7, NULL)) as ‘Apr 2012’,
      SUM(IF(year=1, outlay_month_8, NULL)) as ‘May 2012’,
      SUM(IF(year=1, outlay_month_9, NULL)) as ‘Jun 2012’,
      SUM(IF(year=1, outlay_month_10, NULL)) as ‘Jul 2012’,
      SUM(IF(year=1, outlay_month_11, NULL)) as ‘Aug 2012’,
      SUM(IF(year=1, outlay_month_12, NULL)) as ‘Sep 2012’,
      SUM(IF(year=2, outlay_month_1, NULL)) as ‘Oct 2012’,
      SUM(IF(year=2, outlay_month_2, NULL)) as ‘Nov 2012’,
      SUM(IF(year=2, outlay_month_3, NULL)) as ‘Dec 2012’,
      SUM(IF(year=2, outlay_month_4, NULL)) as ‘Jan 2013’,
      SUM(IF(year=2, outlay_month_5, NULL)) as ‘Feb 2013’,
      SUM(IF(year=2, outlay_month_6, NULL)) as ‘Mar 2013’,
      SUM(IF(year=2, outlay_month_7, NULL)) as ‘Apr 2013’,
      SUM(IF(year=2, outlay_month_8, NULL)) as ‘May 2013’,
      SUM(IF(year=2, outlay_month_9, NULL)) as ‘Jun 2013’,
      SUM(IF(year=2, outlay_month_10, NULL)) as ‘Jul 2013’,
      SUM(IF(year=2, outlay_month_11, NULL)) as ‘Aug 2013’,
      SUM(IF(year=2, outlay_month_12, NULL)) as ‘Sep 2013’,
      SUM(IF(year=3, outlay_month_1, NULL)) as ‘Oct 2013’,
      SUM(IF(year=3, outlay_month_2, NULL)) as ‘Nov 2013’,
      SUM(IF(year=3, outlay_month_3, NULL)) as ‘Dec 2013’,
      SUM(IF(year=3, outlay_month_4, NULL)) as ‘Jan 2014’,
      SUM(IF(year=3, outlay_month_5, NULL)) as ‘Feb 2014’,
      SUM(IF(year=3, outlay_month_6, NULL)) as ‘Mar 2014’,
      SUM(IF(year=3, outlay_month_7, NULL)) as ‘Apr 2014’,
      SUM(IF(year=3, outlay_month_8, NULL)) as ‘May 2014’,
      SUM(IF(year=3, outlay_month_9, NULL)) as ‘Jun 2014’,
      SUM(IF(year=3, outlay_month_10, NULL)) as ‘Jul 2014’,
      SUM(IF(year=3, outlay_month_11, NULL)) as ‘Aug 2014’,
      SUM(IF(year=3, outlay_month_12, NULL)) as ‘Sep 2014’,
      SUM(IF(year=4, outlay_month_1, NULL)) as ‘Oct 2014’,
      SUM(IF(year=4, outlay_month_2, NULL)) as ‘Nov 2014’,
      SUM(IF(year=4, outlay_month_3, NULL)) as ‘Dec 2014’,
      SUM(IF(year=4, outlay_month_4, NULL)) as ‘Jan 2015’,
      SUM(IF(year=4, outlay_month_5, NULL)) as ‘Feb 2015’,
      SUM(IF(year=4, outlay_month_6, NULL)) as ‘Mar 2015’,
      SUM(IF(year=4, outlay_month_7, NULL)) as ‘Apr 2015’,
      SUM(IF(year=4, outlay_month_8, NULL)) as ‘May 2015’,
      SUM(IF(year=4, outlay_month_9, NULL)) as ‘Jun 2015’,
      SUM(IF(year=4, outlay_month_10, NULL)) as ‘Jul 2015’,
      SUM(IF(year=4, outlay_month_11, NULL)) as ‘Aug 2015’,
      SUM(IF(year=4, outlay_month_12, NULL)) as ‘Sep 2015’
      FROM obligations_outlays_goals
      GROUP BY appropriation
  • query to retrieve Financial Mitigation Plans for 2012
    • SELECT p.uid as project_uid, p.project_number, c.appropriation, c.center_number, c.center_name,
      CASE fmp.month WHEN 1 THEN ‘Oct 2011’ WHEN 2 THEN ‘Nov 2011’ WHEN 3 THEN ‘Dec 2011’ WHEN 4 THEN ‘Jan 2012’ WHEN 5 THEN ‘Feb 2012’ WHEN 6 THEN ‘Mar 2012’ WHEN 7 THEN ‘Apr 2012’ WHEN 8 THEN ‘May 2012’ WHEN 9 THEN ‘Jun 2012’ WHEN 10 THEN ‘Jul 2012’ WHEN 11 THEN ‘Aug 2012’ WHEN 12 THEN ‘Sep 2012’ END as month_year,
      o.type, a.amount,
      CASE fmp.month WHEN 1 THEN o.month_1 WHEN 2 THEN o.month_2 WHEN 3 THEN o.month_3 WHEN 4 THEN o.month_4 WHEN 5 THEN o.month_5 WHEN 6 THEN o.month_6 WHEN 7 THEN o.month_7 WHEN 8 THEN o.month_8 WHEN 9 THEN o.month_9 WHEN 10 THEN o.month_10 WHEN 11 THEN o.month_11 WHEN 12 THEN o.month_12 END as month_value,
      IF(o.type LIKE ‘%Obligat%’,
      CASE fmp.month WHEN 1 THEN g.obligation_month_1 * a.amount / 100 WHEN 2 THEN g.obligation_month_2 * a.amount / 100 WHEN 3 THEN g.obligation_month_3 * a.amount / 100 WHEN 4 THEN g.obligation_month_4 * a.amount / 100 WHEN 5 THEN g.obligation_month_5 * a.amount / 100 WHEN 6 THEN g.obligation_month_6 * a.amount / 100 WHEN 7 THEN g.obligation_month_7 * a.amount / 100 WHEN 8 THEN g.obligation_month_8 * a.amount / 100 WHEN 9 THEN g.obligation_month_9 * a.amount / 100 WHEN 10 THEN g.obligation_month_10 * a.amount / 100 WHEN 11 THEN g.obligation_month_11 * a.amount / 100 WHEN 12 THEN g.obligation_month_12 * a.amount / 100 END,
      CASE fmp.month WHEN 1 THEN g.outlay_month_1 * a.amount / 100 WHEN 2 THEN g.outlay_month_2 * a.amount / 100 WHEN 3 THEN g.outlay_month_3 * a.amount / 100 WHEN 4 THEN g.outlay_month_4 * a.amount / 100 WHEN 5 THEN g.outlay_month_5 * a.amount / 100 WHEN 6 THEN g.outlay_month_6 * a.amount / 100 WHEN 7 THEN g.outlay_month_7 * a.amount / 100 WHEN 8 THEN g.outlay_month_8 * a.amount / 100 WHEN 9 THEN g.outlay_month_9 * a.amount / 100 WHEN 10 THEN g.outlay_month_10 * a.amount / 100 WHEN 11 THEN g.outlay_month_11 * a.amount / 100 WHEN 12 THEN g.outlay_month_12 * a.amount / 100 END) as month_goal
      FROM project_portfolio.financial_mitigation_plans fmp,
      project_portfolio.obligations_outlays o,
      project_portfolio.projects p,
      project_portfolio.budget_centers c,
      project_portfolio.budget_amounts a,
      project_portfolio.obligations_outlays_goals g
      WHERE fmp.obligation_outlay_uid = o.uid
      AND o.project_id = p.uid
      AND p.uid = c.project_id
      AND o.funding_id = c.uid
      AND o.year = 2012
      AND o.year_count = 1
      AND a.budget_center_id = c.uid
      AND a.year = 2012 – p.begin_year + 1
      AND g.appropriation = c.appropriation
      AND g.year = 1
  • query to calculate goals reached for 2012
    • SELECT p.uid, p.project_number, p.proj_mgr_login, services, p.begin_year,
      c.uid, c.center_number, c.center_name, c.appropriation,
      a.amount,
      o.uid, o.type,
      FORMAT((o.month_1 / (g.obligation_month_1 * a.amount / 100)) * 100, 2) as ‘Oct 2011’,
      FORMAT((o.month_2 / (g.obligation_month_2 * a.amount / 100)) * 100, 2) as ‘Nov 2011’,
      FORMAT((o.month_3 / (g.obligation_month_3 * a.amount / 100)) * 100, 2) as ‘Dec 2011’,
      FORMAT((o.month_4 / (g.obligation_month_4 * a.amount / 100)) * 100, 2) as ‘Jan 2012’,
      FORMAT((o.month_5 / (g.obligation_month_5 * a.amount / 100)) * 100, 2) as ‘Feb 2012’,
      FORMAT((o.month_6 / (g.obligation_month_6 * a.amount / 100)) * 100, 2) as ‘Mar 2012’,
      FORMAT((o.month_7 / (g.obligation_month_7 * a.amount / 100)) * 100, 2) as ‘Apr 2012’,
      FORMAT((o.month_8 / (g.obligation_month_8 * a.amount / 100)) * 100, 2) as ‘May 2012’,
      FORMAT((o.month_9 / (g.obligation_month_9 * a.amount / 100)) * 100, 2) as ‘Jun 2012’,
      FORMAT((o.month_10 / (g.obligation_month_10 * a.amount / 100)) * 100, 2) as ‘Jul 2012’,
      FORMAT((o.month_11 / (g.obligation_month_11 * a.amount / 100)) * 100, 2) as ‘Aug 2012’,
      FORMAT((o.month_12 / (g.obligation_month_12 * a.amount / 100)) * 100, 2) as ‘Sep 2012’FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o,
      obligations_outlays_goals g
      WHERE p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year – 1 = 2012
      AND p.uid = o.project_id
      AND o.year = 2012
      AND o.year_count = 1
      AND o.funding_id = c.uid
      AND g.appropriation = c.appropriation
      AND g.year = 1

Phil 7.16.12

8:00 – 4:00 ESSO

  • Got all the scripts up and running on the production server
  • Added a backup batch file for VSS. Unable to copy files in the batch file, which is odd. The network was slow today, so that could have something to do with it. Since it’s exactly the same code (that looks at its own name for behavior), what works for move should work for copy.
  • Talked to JR about reports. In addition to what we have now, she’s like to be able to show the zero, non-zero, and null values on a chart. Dong’s going to look into making that query.
  • Still unable to get IE to open Data Navigator. I think I might have found the answer in LoginScreen. Mike had changed the call to usersAndRoles.getUserInfo(userName.text) so that there was a boolean that said to use the DN lookup. Set that to false. This makes sense, but now I’m confused why FF logged in. Burning a disk to bring in tomorrow. Will also add Dong’s scripts

Dong Shin 07.16.2012

  • continue working on scripts
  • VisibilityScripting still hangs on my Mac! using VisibilityScripting4
    • added sorting of scripts
    • added deleting of scripts
  • changed the VisbilityScriptingServer to refresh script list
  • created monthly progress report scripts for 2010, 2011, 2012
  • query to get current year info for the projects
    • SELECT p.uid, p.project_number, p.proj_mgr_login, services, p.begin_year,
      c.uid, c.center_number, c.center_name, c.appropriation,
      a.amount,
      o.uid, o.type, o.month_1,
      g.obligation_month_1
      FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o,
      obligations_outlays_goals g
      WHERE p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year – 1 = 2012
      AND p.uid = o.project_id
      AND o.year = 2012
      AND o.year_count = 1
      AND o.funding_id = c.uid
      AND g.appropriation = c.appropriation
      AND g.year = 1

Dong Shin 07.13.2012

  • worked with Phil on site generating Monthly Financial Data status for Jessica
  • got sample data generator from Phil , generated some data, ingested it
    • changed the code to remove spaces between commas that cause Ingest Manager to prepend ‘-‘
  • started working on queries for the briefing next week

Phil 7.13.12

8:00 – 3:30 ESSO

  • Meeting w/ col Dukes is now the 19th?
  • Made some scripts for Jessica which look cool, but vis2 is not logging in with ie
  • Snapshot and excel dump are pointing to [object, object]
  • Disabled the autologin and reactivated the alert that shows the endpoint if there is a connection fault.
  • Added in a local log for vis2 that’s enabled by a <vis:localLog> tag in the SetupXML.xml file. Took a while thrashing with why it wasn’t working until we figured out that it was IE hanging on tenaciously to some cache.
  • Burned new vis2 to disk