Category Archives: VISIBILITY

Kristi 07.08.2011

Continuing Visibility 2 documentation

Running into the following error – not consistent – but frequent:

Projects – Projects – Enter Monthly Status Data – After selecting contract –

Gets hung up on message (highlighted in blue wave pattern – as if it is processing) – “Project selected… creating data panels”

Showed to Dong – Thanks!

Phil 7.7.11

8:00 – 4:00 VISIBILITY

  • Remembered my SF-86 stuff, so more paperwork today
  • And when I’m done with that, work on the web IDE paper
  • OK, I brought in the wrong (well, incomplete) forms. Working on the paper instead.
  • According to Vernon, The firewall request I had submitted was never going to get processed because it was associated with the wrong type of ticket. He created a new ticket, which I have now associated the request with. This is the most fun ever!

Phil 7.6.11

8:00 – 4:00

  • It looks like the webIDE concept is going to require a server that supports VMs in hardware. At this point, it’s no longer something that I can do on my own, so I’m going to write a whitepaper for FGM specifying what’s needed and punt.
  • Prepping the hand for a demo. Have forgotten how to calibrate the sensors, which have drifted. Oh. No power supply == no sensors. That’s whatr those two wires were for…
  • Well this is cool: http://tv.adobe.com/watch/adc-presents/control-the-desktop-with-your-mobile-device/
  • Also good: http://www.paultrani.com/blog/index.php/category/flashactionscript/
  • In the ongoing saga of our problem child server, Vernon sent out an email that he had addressed all concerns. I responded that port 443 was still closed and attached screenshots of everything working fine inside the firewall and blocked outside. Gee, I wonder if there will be any progress tomorrow?
  • Made some progress on my SF86, but forgot to bring in my old form.

Dong Shin 07.05.11

  • projects under budget – https://localhost/VisibilityScriptingServer/Publisher/projectsUnderBudget.xml
  • query to find projects and data that doesn’t meet the goal
    • SELECT p.uid as ‘project_id’, p.project_number, b.uid as ‘budget_center_id’, b.center_number, b.appropriation, a.year as ‘budget_year’,
      REPLACE (FORMAT(a.amount,2),’,’,”) as amount, o.uid as ‘obligation_outlay_id’, o.year_count, o.year as ‘obligation_outlay_year’, o.type,
      REPLACE (FORMAT(o.month_1, 2),’,’,”) as month_1,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100), 2),’,’,”) as goal_month_1,
      IF (o.month_1 < IF (o.type like ‘%Outlay%’, (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_1,
      REPLACE (FORMAT(o.month_2, 2),’,’,”) as month_2,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_2 * a.amount / 100), (g.obligation_month_2 * a.amount) / 100), 2),’,’,”) as goal_month_2,
      IF (o.month_2 < IF (o.type like ‘%Outlay%’, (g.outlay_month_2 * a.amount / 100), (g.obligation_month_2 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_2,
      REPLACE (FORMAT(o.month_3, 2),’,’,”) as month_3,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_3 * a.amount / 100), (g.obligation_month_3 * a.amount) / 100), 2),’,’,”) as goal_month_3,
      IF (o.month_3 < IF (o.type like ‘%Outlay%’, (g.outlay_month_3 * a.amount / 100), (g.obligation_month_3 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_3,
      REPLACE (FORMAT(o.month_4, 2),’,’,”) as month_4,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_4 * a.amount / 100), (g.obligation_month_4 * a.amount) / 100), 2),’,’,”) as goal_month_4,
      IF (o.month_4 < IF (o.type like ‘%Outlay%’, (g.outlay_month_4 * a.amount / 100), (g.obligation_month_4 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_4,
      REPLACE (FORMAT(o.month_5, 2),’,’,”) as month_5,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_5 * a.amount / 100), (g.obligation_month_5 * a.amount) / 100), 2),’,’,”) as goal_month_1,
      IF (o.month_5 < IF (o.type like ‘%Outlay%’, (g.outlay_month_5 * a.amount / 100), (g.obligation_month_5 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_5,
      REPLACE (FORMAT(o.month_6, 2),’,’,”) as month_6,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_6 * a.amount / 100), (g.obligation_month_6 * a.amount) / 100), 2),’,’,”) as goal_month_6,
      IF (o.month_6 < IF (o.type like ‘%Outlay%’, (g.outlay_month_6 * a.amount / 100), (g.obligation_month_6 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_6,
      REPLACE (FORMAT(o.month_7, 2),’,’,”) as month_7,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_7 * a.amount / 100), (g.obligation_month_7 * a.amount) / 100), 2),’,’,”) as goal_month_7,
      IF (o.month_7 < IF (o.type like ‘%Outlay%’, (g.outlay_month_7 * a.amount / 100), (g.obligation_month_7 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_7,
      REPLACE (FORMAT(o.month_8, 2),’,’,”) as month_8,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_8 * a.amount / 100), (g.obligation_month_8 * a.amount) / 100), 2),’,’,”) as goal_month_8,
      IF (o.month_8 < IF (o.type like ‘%Outlay%’, (g.outlay_month_8 * a.amount / 100), (g.obligation_month_8 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_8,
      REPLACE (FORMAT(o.month_9, 2),’,’,”) as month_9,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_9 * a.amount / 100), (g.obligation_month_9 * a.amount) / 100), 2),’,’,”) as goal_month_9,
      IF (o.month_9 < IF (o.type like ‘%Outlay%’, (g.outlay_month_9 * a.amount / 100), (g.obligation_month_9 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_9,
      REPLACE (FORMAT(o.month_10, 2),’,’,”) as month_10,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_10 * a.amount / 100), (g.obligation_month_10 * a.amount) / 100), 2),’,’,”) as goal_month_10,
      IF (o.month_10 < IF (o.type like ‘%Outlay%’, (g.outlay_month_10 * a.amount / 100), (g.obligation_month_10 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_10,
      REPLACE (FORMAT(o.month_11, 2),’,’,”) as month_11,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_11 * a.amount / 100), (g.obligation_month_11 * a.amount) / 100), 2),’,’,”) as goal_month_11,
      IF (o.month_11 < IF (o.type like ‘%Outlay%’, (g.outlay_month_11 * a.amount / 100), (g.obligation_month_11 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_11,
      REPLACE (FORMAT(o.month_12, 2),’,’,”) as month_12,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_12 * a.amount / 100), (g.obligation_month_12 * a.amount) / 100), 2),’,’,”) as goal_month_12,
      IF (o.month_12 < IF (o.type like ‘%Outlay%’, (g.outlay_month_12 * a.amount / 100), (g.obligation_month_12 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_12
      FROM project_portfolio.projects p, project_portfolio.budget_centers b, project_portfolio.budget_amounts a, project_portfolio.obligations_outlays o, project_portfolio.obligations_outlays_goals g
      WHERE p.uid = b.project_id AND b.uid = a.budget_center_id AND b.uid = o.funding_id AND b.appropriation = g.appropriation
      AND g.year = year_count AND a.year = g.year
      AND (
      o.month_1 < IF (o.type like ‘%Outlay%’, (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100) OR
      o.month_2 < IF (o.type like ‘%Outlay%’, (g.outlay_month_2 * a.amount / 100), (g.obligation_month_2 * a.amount) / 100) OR
      o.month_3 < IF (o.type like ‘%Outlay%’, (g.outlay_month_3 * a.amount / 100), (g.obligation_month_3 * a.amount) / 100) OR
      o.month_4 < IF (o.type like ‘%Outlay%’, (g.outlay_month_4 * a.amount / 100), (g.obligation_month_4 * a.amount) / 100) OR
      o.month_5 < IF (o.type like ‘%Outlay%’, (g.outlay_month_5 * a.amount / 100), (g.obligation_month_5 * a.amount) / 100) OR
      o.month_6 < IF (o.type like ‘%Outlay%’, (g.outlay_month_6 * a.amount / 100), (g.obligation_month_6 * a.amount) / 100) OR
      o.month_7 < IF (o.type like ‘%Outlay%’, (g.outlay_month_7 * a.amount / 100), (g.obligation_month_7 * a.amount) / 100) OR
      o.month_8 < IF (o.type like ‘%Outlay%’, (g.outlay_month_8 * a.amount / 100), (g.obligation_month_8 * a.amount) / 100) OR
      o.month_9 < IF (o.type like ‘%Outlay%’, (g.outlay_month_9 * a.amount / 100), (g.obligation_month_9 * a.amount) / 100) OR
      o.month_10 < IF (o.type like ‘%Outlay%’, (g.outlay_month_10 * a.amount / 100), (g.obligation_month_10 * a.amount) / 100) OR
      o.month_11 < IF (o.type like ‘%Outlay%’, (g.outlay_month_11 * a.amount / 100), (g.obligation_month_11 * a.amount) / 100) OR
      o.month_12 < IF (o.type like ‘%Outlay%’, (g.outlay_month_12 * a.amount / 100), (g.obligation_month_12 * a.amount) / 100)
      )
      ORDER BY b.uid, a.year, o.year

Phil 7.5.11

7:30 – 3:30VISIBILITY

  • OK, where was I? Let’s see – the server is still up and the compiler is still working. The choice is either to a) see how it runs on the actual Internet or b) start working on virtualization.
  • Looking at virtualization first.
    • Ubuntu has a script-driven system called vm-builder, but it’s at version 0.12. Here is some documentation.
    • IBM paper describing the process. It’s for Red Hat, but a good start
    • Hmmm. You need hardware support for VMs. If you run “grep -E ‘vmx|svm’ /proc/cpuinfo” and get a non-null result, you’ve got it. My server does not. fgmedev does, but it’s a vm already, so what does that mean?
  • Gave Jeff all the information I think he needs to get the paperwerk approved for his server. I gave him a followup call to verify that the information was what he needed and he seemed to think so. That being said, he was going to give the info to someone else to enter, so thay may have questions later as they get into the details
  • Started on my SF86 update

Dong Shin 06.30.11

  • Find projects that have less than goal in the first month query
    • SELECT p.uid as ‘project_id’, p.project_number, b.uid as ‘budget_center_id’, b.center_number, b.appropriation, a.year as ‘budget_year’,
      REPLACE (FORMAT(a.amount,2),’,’,”) as amount, o.uid as ‘obligation_outlay_id’,
      o.year_count,
      o.year as ‘obligation_outlay_year’,
      o.type,
      REPLACE (FORMAT(o.month_1, 2),’,’,”) as month_1,
      REPLACE (FORMAT(IF (o.type like ‘%Outlay%’, (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100), 2),’,’,”) as goal_month_1,
      IF (o.month_1 < IF (o.type like ‘%Outlay%’, (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100), ‘FLAG’, ‘OK’) as flag_month_1
      FROM project_portfolio.projects p, project_portfolio.budget_centers b, project_portfolio.budget_amounts a, project_portfolio.obligations_outlays o, project_portfolio.obligations_outlays_goals g
      WHERE p.uid = b.project_id AND b.uid = a.budget_center_id AND b.uid = o.funding_id AND b.appropriation = g.appropriation AND g.year = year_count AND a.year = g.year
      AND o.month_1 < IF (o.type like ‘%Outlay%’, (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100)
      GROUP BY project_id
      ORDER BY b.uid, a.year, o.year

Dong Shin 06.29.11

  • thought the save problem in Visibility Scripting had gone away magically…
  • found a bug in storeScript method in ScriptObject.java in VisibilityScriptingServer
    • added try – catch for Integer.parseInt
    • updated sqlStr for intervalMinutes

Dong Shin 06.28.2011

  • revisiting Scripting
  • projects_under_budget.py can now be saved…. no more errors
  • questions
    • What projects are under #% under budget?
    • What managers/Financial people have project > 10%?
    • What projects are overdue?
  • reworking project_under_budget.py to retrieve the data

    Phil 6.23.11

    7:30 – 5:00 VISIBILITY

    • I’ve reinstalled Ubuntu 10.10 after all of yesterday’s (failed) efforts. Trying FreeNX, following the directions here.
      • Installed openSSH
      • apt-get install freenx took *forever*. I think it installs gnome…
      • Might need this later – we’ll see.
      • KDE didn’t work, but GNOME did! Looks nice, and the server required no addition of the desktop outside of the basic install. However, it seems to have limited functionality. For example, I can’t launch a terminal window and the ‘Accessories’ menu is not there.
      • Going to try installing the standard ubuntu desktop (i.e. apt-get install ubuntu_desktop. Well, another long install, but things work quite nicely now.
      • Installed Eclipse (New version – Indigo!). Needs Java
      • Installed Java
    • Worked on the server some more. Sent Jeff an email with a link to a page that show how to set up the interface.
    • Talked to Vernon about my login problems. He thinks that it’s the result of a reorg they are going through. Still no luck with my SSL port.Testing the new PPM. It appears to still be missing the capability of setting it so that a user with a particular role is only able to see projects that they are associated with (as a Program Manager, Financial Analyst or POC(?). Added as bug 6097.

    Phil 6.22.11

    8:00 – 7:00 VISIBILITY

    Dong Shin 06.21.2011

    • PPM bugs found by Phil
      • Available Balance in Financial Status not correct – fixed
      • Remote Objet Fault on Register – fixed
      • Change Password and Hint – added check for empty field
      • Roles not working properly after changing password – fixed
    • uploaded the new PPM