Author Archives: pgfeldman

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

Phil 10.2.12

8:00 – 2:00 ESSO

  • Back from vacation! Pix are here: http://www.flickr.com/photos/21701734@N04/sets/72157631554682788/
  • Deployed Dong’s new PA, and made a new DB. Need to add that to the bcakups, but no rush. Right now it just has test data in it.
  • Backups
  • General client coordination. No fires. Yay!
  • Installing updates to every Adobe product, so no Flashbuilder for a while
  • Going to start on GWT Alert app
  • Yay! Updates are done
  • Not quite. Needed to update Java and change the environment variables too.
  • Ok, *now* I’m back to GWT. Reviewing up to Chapter 2.

2:00 – 4:00 FP

  • Qualitative methods.

Dong Shin 10.01.2012

  • syncing DEV works perfect…, but Visibility wouldn’t work on my laptop, but works on the desktop…..
  • found PA month and year calculations wrong when new FY kicked in!! – fixed
  • added SQLErrorWindow to PA
  • Alerts panel removed when no alerts are found

 

Dong Shin 09.28.2012

  • modified SearchBox in SeachableDataGrid
    • use DataGridSearchFilterHBox schema
    • add red to matching text/string
  • changed AlertDataGrid to use SearchableDataGrid
    • if verticalScrollPolicy=”on” is not set, the columns resize misbehaves….