Author Archives: pgfeldman

Dong Shin 10.16.2012

  • continue working on Alerts
  • query to alert users that have not been logged on for more than 30 days
    • SELECT
      NULL as porfolio_admins,
      NULL as portfolio_mgrs,
      NULL as service_finance_pocs,
      NULL as service_project_managers,
      ” as program,
      ” as MIPR,
      CONCAT(login, ‘ has not been logged in for more than 30 days ‘) as alert,
      ‘OPEN’ as status
      FROM `users`
      WHERE DATEDIFF(now(), last_login) > 30
    • script – UsersNotLoggedIn30Days.py and UsersNotLoggeIn30DaysSaveToTable.py
  • added TAB support for PrettyTextEditor in VSS4
    • protected function keyFocusChange(evt:FocusEvent) : void {
      evt.preventDefault();
      evt.currentTarget.insertText(”    “);
      }
  • created a script to return status of Alerts with days – AlertsStatus.py

Phil 10.15.12

Phil 8:30 – 4:30

  • Backups and such. All is quiet. Even fixed a typo or two.
  • Decided to put all the HSB code in  com.edgeti.EdgeUtils.color.HsbObject. Once that’s working, I’ll put it in FGMFlexUtils45, since it’s probably going to be pure Actionscript.
  • Well, I’ll be. It ran the first time!
  • Starting on adding formatted tooltips for numbers. Started to build a formattedDataTip function in AdvancedQueryWidget. Need to pull the name and value from the HitData, then check to see if the value is a number, and if so, add commas and decimal places. Still need to figure out where this is done in FlexiChart, but it will (should?) be the same code.

Phil 10.12.12

8:00 – 4:00 ESSO

  • Backups – all is well.
  • Farewell lunch for Jessica
  • Working on color recognizing code. Editor freaked out and gave warnings for items inherited from QueryWidgetBase and WidgetBase. Solved mysteriously after some flailing. Probably closing and re-opening the project fixed it.
  • Got the main piece of the color code working, but I can’t have a hybrid model that lets the default color scheme take over once I’ve run out of custom colors. So I’m converting the RGB of the two theme colors and calculating a family of colors in HSB space. This will be nicer anyway, since the theme will now be usable on the pie chart and will make the other charts look a little better.
  • Neat video on data visualization and ‘data foraging’: http://www.youtube.com/watch?v=_IbTZBMHiY4

Dong Shin 10.11.2012

  • Weekly status meeting
  • deployed new Visiblity and PA – Visibility and AccountManagers didn’t work
    • put the old ones back and works!
    • compiled new ones on my PC and it works
    • looks like we deployed old (really old) version from Maven repo that were packaged together by Visibility server project
  • working on overdue projects alerts
    • query to get overdue projects in ALERT format
    • SELECT GROUP_CONCAT(m.login) as service_project_managers,
      GROUP_CONCAT(ppa.login) as porfolio_admins,
      GROUP_CONCAT(ppm.login) as portfolio_mgrs,
      GROUP_CONCAT(psf.login) as service_finance_pocs,
      p.project_number as program,
      c.center_number as MIPR,
      ’30 days overdue’ as alerts,
      ‘OPEN’ as status,
      p.project_number, p.description, a.amount, o.uid, o.type, o.year,
      o.year_count, o.month_1
      FROM projects p,
      budget_centers c,
      budget_amounts a,
      obligations_outlays o,
      _projects_service_project_mgrs m,
      _projects_portfolio_admins ppa,
      _projects_portfolio_mgrs ppm,
      _projects_service_finance_pocs psf
      WHERE p.uid  = c.project_id
      AND a.budget_center_id = c.uid
      ANd a.year  = 2013 – p.begin_year + 1
      AND o.project_id = p.uid
      AND o.funding_id = c.uid
      AND o.year + o.year_count – 1 = 2013
      AND o.year_count = 1
      AND ISNULL(o.month_1)
      AND p.uid = m.project_id
      AND p.uid = ppa.project_id
      AND p.uid = ppm.project_id
      AND p.uid = psf.project_id
      GROUP BY o.uid

 

Phil 10.11.12

ESSO 8:00 – 2:00

  • Finished putting FlashBuilder back together
  • Adding bar column and pie chart awareness of color, if available
  • Burned updates and status report
  • Status meeting at 10:30
  • Starting on setting color to match words in columns

Phil 10.10.12

7:30 – 4:30 ESSO

  • Demo for Col. Dukes.
    • For a column where the items are colors, the bar/pie/column should match that color
    • Need to add commas and remove decimal places to tooltip renderer
    • Tried to open Flashbuilder, but no luck. Spent the rest of the day re-installing everything.
  • Need to bring in my status tomorrow along with patch disk
  • GWT Chapter 3
    • Chapter 3 example code compiles and runs!

Phil 10.9.12

8:00 – 2:00 ESSO

  • Backed up everything
  • Had an odd problem with what boiled down to a FY Month zero problem on the script that produced charts showing who had projects that had listed the same amount spent between the current month and the previous month. Since there was no month before October (Month 1), the SQL query crashed. Fixed by adding a test to see if the month was October, and adding a “no data available” case to the logic of the script.
  • It appears that the Ingest Manager my still be trying to merge tables. Dong’s going to test this (and add in the ChangeLog?). THe correct behavior should be a DROP TABLE

2:00 – 4:00 FP

  • QM

Phil 10.5.12

8:00 – 4:00 – ESSO

  • Backups
  • Uploaded new data for presentation on Wednesday
  • Discovered that the filter set up for VSS was interfering with http://localhost calls (“not authorized web page”). Since we really don’t need the filter there, I put in an HTML redirect for the test applet and turned off the filter and the test applet in web.xml. Everything should be working now, but rather than going and re-ingesting everything, I’m going to let the timed tasks run and check up on them on Tuesday.
  • Talked to Jessica and Larry about the “Reconcile” option, which they likes. Dave W was listening, and approved.
  • GWT chapter 3. Downloaded code from Manning.
  • Discussion with GAO folks about their app this afternoon.

Phil 10:4.12

8:00 – 2:00 ESSO

  • GWT Chapter 2
  • Installing Web development tools in Eclipse. I need an HTML editor!
    • The Juno Web Page Editor is quite nice. WYSIWYG, with linking (highlights) between the source and the rendered page. Design and preview tabs.
  • Progress meeting at 10:00 – nope, cancelled for an impromptu sometime next week.
  • GWT Chapter 3