Category Archives: Projects

Phil 2.28.14

8:00 – 4:00 SR

  • And, with a temp of 14 degrees, we say goodbye to February. Good riddance, I say.
  • Backups
  • Deploying new FA and DB fix. Success!
  • Meeting with Chris, Lenny and Dong
  • Wrote status report for Tangie.
  • JavaScript
    • Poked around with the slide show API and nver got it to work. After looking at how it’s handled in CSS, I realized that there just wasn’t that much code needed – just a timer and a way to fade in/out nodes in a list. YUI has that quite nicely and it only wound up being about 30 lines of code. It makes me want to do a Ken Burns effect slide show using the transition library, but that can wait until I get the basics up and running. Next scrolling text. I think this might be fun to use: http://yuilibrary.com/yui/docs/scrollview/scrollview-scroll.html. It’s also touch compatible, which is nice.

Dong Shin 02.27.2014

  • deployed new FA/Reqonciler with new query for Planned Outlays… everything is well
  • Lenny reported that some Obligations are not imported
    • found fiscal year is set to NULL in views – __view_monthly_obligations_outlays_by_contract
    • view definition looks at the date from expensed date, need to look at obligation date as well
    • modified the view to examine both expensed and obligation dates for fiscal year – this would resolve the second year problem as well?
      • IF(ISNULL(if((month(MAX(`cc`.`expensed_date`)) > 9),(year(MAX(`cc`.`expensed_date`)) + 1),year(MAX(`cc`.`expensed_date`)))),
        if((month(MAX(`cc`.`obligation_date`)) > 9),(year(MAX(`cc`.`obligation_date`)) + 1),year(MAX(`cc`.`obligation_date`))),
        if((month(MAX(`cc`.`expensed_date`)) > 9),(year(MAX(`cc`.`expensed_date`)) + 1),year(MAX(`cc`.`expensed_date`)))) AS fiscal_year,
  • Funding Description in FA is disabled – fixed
  • new Query for Lenny/Chris – will try to implement it on-site tomorrow morning
    • Capability, Budget Center, Req ID, Req Title, Req Funded Amount, Current Month Outlay Plan, Current Month PM Actuals, Difference (in $) between Outlay Plan and PM Actuals, Difference (in %) between Outlay Plan and PM Actuals

Phil 2.26.14

8:30 – 4:30 SR

  • Lovely traffic today. Took twice as long to get to work. I think I averaged a hair over 20 mph.
  • Backups
  • Looks like I missed registering a site. Fixed.
  • FF 21 and IE 8 are displaying the JavaScript test improperly. Pretty sure I tested this last night on my home machines and all was OK. Yep, just checked on IF, FF, and Chrome at work and they all behave.
  • It’s possible that this is a result of the stylesheet not working correctly. The buttons don’t look right.
  • And it’s ridiculously slow in IE.  looking for some drawing/animation libraries. These all work in IE 8 with reasonable performance

Bad Stylesheet?

  • So the question is, can this be fixed? I’m going to try to bring up a new instance of YUI3 and point at it explicitly. Regardless, let’s see if I can get the rest of all these pieces working together.
  • Working on improving performance. Got the Math.sqrt out of all the force calculations. Now I need to see if that helped. I fear that mostly it’s drawing speed.
  • Something to test

Dong Shin 02.26.2014

  • snow! again! working at home
  • added where config to queryBuilderConfig.xml and modified to QueryBuilder code to read the config….
  • added currency fields in queryBuilderConfig.xml
  • set query name when saving existing query in QueryBuilder
  • changed Spark DataGrid to Advanced DataGrid in pre-processing to support multi-columns sorting
  • changed Col Pref window to ResizableWindow
  • added multiple selection support in Claimed/Unclaimed contracts

Phil 2.25.14

8:00 – 5:00 SR

  • Backups
  • Deployed some new SQL. Lenny found a couple of bugs, but not too bad. Dong has notes, but he went home because it’s his birthday. Some people. Jeez.
  • More inevitable server paperwork.
  • JavaScript
    • You would think that drawing and clearing lines would be easy. Nope. For some reason, YUI Path.clear() does not clear in all conditions. If I draw the line on each frame, everything’s fine. If I draw a line occasionally, it stays. I wound up just calling moveTo() if there was no line, which works.
    • Added the ability to anchor a shape. Physics don’t work on it. Also got drag and drop to work with that.
    • Test this

Dong Shin 02.25.2014

  • deployed to new query, query config… missing some details in where clause
  • some notes
    • add saved name when updating a query
    • 2nd year Obligation/Outlays not updating properly
    • bigger col prefs
    • multiple contracts selection in unclaimed/claimed
    • separate pre-processing for FY13/FY14
    • enable multi-column sort in Reqonciler
    • add Expensed Date in Duplicate Expensed Amount > 0 pre-processing query

Phil 2.24.14

8:00 – 4:00 SR

  • Backups
  • Copied all the webapps and data from the production machine to the test machine.
  • More server paperwork.
  • Javascript
    • Make the controls a pop-up panel. Got stuck on getting a button to work in the graphics container. It looks like all mouse events are being trapped. Was able to add the button to a new wrapper around the control container. Using that I’m able to fade the controls in and out.
    • Build a multi-part network for more testing will all connections.
    • Progress for today

Dong Shin 02.21.2014

  • working on the query for Lenny/Chris
    • capability AS Capability, bcc.budget_center_name AS ‘Budget Center’, req_id AS ‘Req ID’, req_description AS ‘Req Title’, vrt.req_id_total AS ‘Req Funded Amount’,
      SUM(IF(o.type=’Planned Outlay $:’,month_1,0)) AS ‘Oct 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_2,0)) AS ‘Nov 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_3,0)) AS ‘Dec 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_4,0)) AS ‘Jan 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_5,0)) AS ‘Feb 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_6,0)) AS ‘Mar 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_7,0)) AS ‘Apr 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_8,0)) AS ‘May 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_9,0)) AS ‘Jun 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_10,0)) AS ‘Jul 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_11,0)) AS ‘Aug 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_12,0)) AS ‘Sep 14’
      WHERE fiscal_year = 2014
      GROUP BY capability, req_id
    • getting the second year will be tricky….

Dong Shin 02.20.2014

  • deployed all swf’s with Mod/Revision text
  • missed queryBuilderConfig.xml
    • LEFT JOIN __view_committed_totals AS vct ON vct.budget_center_id = bc.uid
  • checked in all Flex projects
  • working on query for reports
  • Query Request from Lenny/Chris
    • query that shows Capability, Budget Center, Req ID, Req Title, Req Funded Amount,Outlay Plan by month
    • The column headings would be: Capability, Budget Center, Req ID, Req Title, Req Funded Amount, Oct 13, Nov 13, Dec 13, Jan 14, etc. through the first two years.

Dong Shin 02.19.2014

  • building vis2 with new settings… wouldn’t let me build with Flex SDK 3.
    • would not compile in Flex 4 workspace , weird. created a new workspace just for Flex 3 projects
    • built IngestManager – had to check out as a new project, AccountManager
    • packed up everything to VizTool.zip

Phil 2.19.14

8:00 – 10:00 SR

  • Backups
  • More server firedrills.
  • Talked to Lenny more about report queries. He’s producing a list. We also discussed what could be done simply with cognos data that predates vistool info.

Phil 2.18.14

10:00 – 4:00 SR

  • Backups
  • More paperwork. There’s a new list of items that the web pages have to have, so we’ll need to modify all our flash files.
  • Worked on adding banners to Data Visualizer and Scripting. Had all kinds of problems with the properties pointing to the wrong folder for the .swf, and then the java export functionality was broken. Finally had to delete all the servers from Eclipse , reinstall, and then change the settings  on the server so that it explicitly used the current Tomcat 7.0 Install. After that, the server came up. Next will be to get the VSS server side code to export.
  • Javascript?

2:00 – ?? Mandatory All Hands. Nope, wrong contract