Category Archives: VISIBILITY

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

Dong Shin 07.12.2012

  • new version of PPM and PA deployed
    • need a way to tell the version of database install/configuration (new table?)
    • some issues
  • weekly status meeting
  • Tangie was having problem finding funding requests that she put in… Need some filtering
  • worked on queries for Jessica

Phil 7.12.12

7:30 – 3:30 ESSO

  • Getting up-to-date versions of VISIBILITY suite on disk
  • Installed and updated test and production server. Interesting note, the ‘all databases’ argument to mySqldump was saving off an old(?) version of project_portfolio. Changing it so that the db was explicitly named fixed that.
  • The new version of PPM went over very well.
  • Regular Thursday meeting. Some rumor about the IG wanting to look at VISIBILITY?
  • Upped the size of the mySql max_allowed_packet to 100M so that scripts could get published to the DB
  • Upped the production server Xmx to 1024M and Xms to 512. Still getting out of memory errors on big pulls
  • Set up a query that shows the amount of 2011 data still unset. Need to make the following changes:
    • Month numbers should become month names
    • Budget Center id needs to be BC name.
    • There should only be 3 results by month (NULL or ‘Nothing Entered’), 0.0, or ‘non-zero’
  • Managed to kill WordPress for a minute by hitting the ‘back’ button, which inadvertently restarted a plugin update. This page fixed it nicely
  • Started back on FlexiCharts

Dong Shin 07.11.2012

  • bugs – not deleting Funding Requests when a project is deleted
    • sounds like database set up is not up-to-date, will check on-site tomorrow
  • PPM
    • corrected all database scripts to use project_portfolio
  • PA
    • configurable columns display – done
    • database update – added visible column in obligation_outlay_types table, FACTS set to invisible
      • ALTER TABLE `obligation_outlay_types` ADD `visible` BOOLEAN NULL DEFAULT NULL;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =1;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =2;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =3;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =4;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =5;
        UPDATE `obligation_outlay_types` SET `visible` = ‘0’ WHERE `obligation_outlay_types`.`uid` =6;

Phil 7.11.12

8:00 – 5:00  ESSO

  • Backups
  • Walked through the duplicating funding request bug with Jessica until it made sense
  • Working on finishing the spreadsheet generator – done.
  • Starting on Flexichart refinement again
  • Deploy new stuff tomorrow while waiting for meeting.