Category Archives: VISIBILITY

Phil 7.26.11

7:30 – 4:00 VISIBILITY

  • Adding the rest of the projects to Hudson. Figuring out what the best notification scheme should be. Added the following:
    • FGMFlexUtils45
    • RFlexClient
    • RFlexServer
    • FGMUtils
    • EdgeUtils (I spent quite a while on this, with it not working on my box. Mike tries it, no problems. So did Hudson. Odd.)
  • No progress on the server(s). Bill D. is working on setting up three rehersals for the demo, which is scheduled for the 17th.

Phil 7.25.11

7:30 – 4:30 VISIBILITY

  • Hudson is up and running here: http://10.13.1.37:8080
  • Installing Maven with “apt-get install maven2”
  • Installing subversion client with “apt-get install subversion”
  • Had to add settings.xml to /home/hudson/.m2 – make sure to use the default directory!
  • Hudson is now up on fgmdev. Two projects are happily compiling.

Phil 7.22.11

8:00 – VISIBILITY

  • Reading up on continuous integration tools. I think I’ll try it on the linux box to make an easier transition to fgmdev.
  • Going to try Apache Continuum, since it has nice maven integration
  • Updating OS first. Hmm. May not have been the brightest idea – gotta wait 30 minutes for the download.

Dong Shin 07.21.11

  • refined the projects_overdue query
    • SELECT 2011 AS currentYear, 10 as currentMonth,  p.uid as ‘project_id’, p.begin_year, p.project_number, b.uid as ‘budget_center_id’, b.center_number, b.appropriation, a.year as ‘budget_year’  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 (p.begin_year + a.year – 1) = 2011 AND ISNULL(o.month_10) ORDER BY b.uid, a.year, o.year

Phil 7.21.11

7:30 – 4:00 VISIBILITY

  • Finished testing Analytics. Need to deploy to fgmdev – done
  • Looking into how to manage multiple pom files within Eclipse
    • For the current project, when ‘build all’ is selected
      • Recursively look though all the dependencies, finding the following
        • <groupId>
        • <artifactId>
        • <packaging>
      • For each dependency, check each open project in Eclipse
      • If the project contains a pom file check the following:
        • <groupId>
        • <artifactId>
        • <packaging>
      • If the dependency and pom info match
        • Bring up a dialog that has the following buttons:
          • Update and compile
          • Compile only
          • Skip

Dong Shin 07.20.11

  • find overdue projects script done
    • projects_overdue.py
    • SELECT p.uid as ‘project_id’, p.begin_year, p.project_number, b.uid as ‘budget_center_id’, b.center_number, b.appropriation, a.year as ‘budget_year’  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 (p.begin_year + a.year – 1) = 2011 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.20.11

7:30 – 4:30 VISIBILITY

  • Burn a disk and bring in the following:
    • Dong’s db update
    • Webdesk components (new Data Navigator?)
  • More whitepaper – nope stopped. Brian doesn’t think it will help much.
  • Fixing Analytics. Done, I think. For the most part, the namespace and the value were reversed in a lot of the classes.

Phil 7.19.11

8:00 – 4:00 VISIBILITY

  • More whitepaper
  • Learned to use ctrl-alt-end instead of ctrl-alt-delete with remote desktop
  • Talked to Mike regarding issues of trust. And passwords. The upshot is that he’ll put in the config file if a particular swf is trusted. If it is, then the system will attempt to log in. Otherwise the user will have to log in separately.
  • Talked to Bill D. It looks like we are going to have a big demo in mid August. Hopefully we can have Trish’s input on whether we’ve implemented her changes correctly and if we are producing reasonable reports by the time for rehearsal.

Phil 7.18.2011

8:00 – 4:00 VISIBILITY

  • Whitepaper
    • Need to do some drawings. Installing Inkscape
    • Drawings are mostly finished. Got the current, minimal, and desired optins fleshed out.
  • Showed Dong the printout of the DB contents that I printed out on Friday. He’s going to see what updates I need to do.
  • Talked to Bill D. about the SP form. I believe that Brian got started on it and said that the two should coordinate before Bill goes off on a mission.

Phil 7.14.11

8:00 – 4:00 VISIBILITY

  • More whitepaper.
    • Finished Usage Model
    • Writing Current Work
  • Fire drill for PPM
    • Deployed new system
    • Deployed new documentation
    • Wrote up some justifications
    • Set up an account for Tangela and invited her over for some detailed walkthrough.

Dong Shin 07.13.11

  • having problems with FlashPlayer on my Mac….
    • ScriptEditor works on Windows fine, but it crashes on mine.
    • same happens on previous versions of FlashPlayer
    • stop by at Apple Store to see if any of their has the same symptom, either no Flash installed or didn’t have the latest OS (10.6.8)
  • Converting VisibilityScripting to Flex 4.5
    • Spark Form doesn’t like TextArea! it wouldn’t size it to 100% width/height!
    • got line numbers working, but it looks crap!
    • incorporated SmartEditor’s line number skin

Phil 7.13.11

7:30 – 4:30 VISIBILITY

  • Finishing up (hopefully) SF-86
  • Poked around Dong’s flash player problem. Set him up with an account on my Ubuntu server, so he can try that OS as well.
  • Back to Web IDE writeup
    • Finished abstract
    • Finished Concept
    • Finished Components
    • About halfway through Usage Model
  • Wrote up a status report for Bill D.
  • Jeff bailed on the SPF, so I sent out an email asking if Bill or Denise knew who could fill it out.
  • Brought Brian up to date on the whole agonizing process.
  • Tanji would like to try out the new version with documentation tomorrow.

Dong Shin 07.11.11

  • created script based on the query below – managers_under_budget.py
  • find managers/projects with under budget query

    • SELECT p.* 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)) GROUP BY p.uid ORDER BY b.uid, a.year, o.year