Author Archives: pgfeldman

Phil 9.7.11

8:00 – 4:30 VISIBILITY

  • My 1987 Porsche passed emissions with 30% of the limit on Co2 and 15% of the limit on HC. What were they driving back then? Tanks?
  • More scroller work.
    • Added ScrollingDateChooserEvent
    • Added all the edge conditions to handle 12 and 24 hour time
    • Added military and civilian date and time formats
    • Moved code to a separate library and checked into SVN – Mobile/ScrollingChoosers
  • Mike’s gotten the Google App Engine talking to web and phone with GraniteDS. Next will be to write some methods that assemble table meta information such as unique counts that the Google Data API doesn’t cover.
  • Talked with Bill D. about getting our desks. We sent a *memo* about it!

Mike 9.6.2011

  • Continued working on library to access and query google spreadsheets
  • Methods working to list tables, list columns, and execute a simple generic query
  • Due to some limits of the google query language, we can’t execute what we need in a single query, such as list how many distinct values are in each column
  • Going to investigate Google App Engine as a possible solution

Phil 9.6.11

7:30 – 4:30 VISIBILITY

  • Need to do some clarification for Stuart WRT the patent – done
  • Need to put together a date picker and then something more general.
  • And it looks like I need to move my 401k around a bit.
  • Figured out this SQL query again for Mike:
    • select model, count(model) from cars group by model;
  • Visit with Bill D. Some paperwork and strategizing with Brian

Tom DeVito 9.6.2011

Start: 10:00

  • Continued to work on the higher level control class.  This class is also to monitor a given input pin, as well as receive/run test simulation data for a designated  finger, similar to how the original test sketch works.
  • Wired a second 1 Watt amplifier which is controlled by the second rheostat on the first IC
  • Added code to the amp class to control the second register

End: 6:00

Tom DeVito 9.2.2011

Start: 10:00

  • Finished midi class and start debugging.  This one didn’t have as many problems as the others and was relatively simple to debug.
  • Started a higher level module which controls the amp and midi controller so I can initialize both in one instance

End: 6:00

Phil 9.1.11

8:00 – 5:30 VISIBILITY

  • It’s now dark at 5:45. Time for the alarm clock. Sigh
  • Bill D. is off for the rest of the week, so I get two full days of development. Yay!
  • Adding ESRI mapping to VisMob
  • Got a scrolling time widget working. Need to do a date widget and then figure out how to generalize. Maybe. It’s not much code.

Mike 8.31.2011

  • Created a project and artifact called Log4Flex which contains the flex logging code / UI to start separating out FGMFlexUtils
  • Started on the google-services library
    • Created a general authenticator that will get a token to make authenticated http requests to any of the gdata services (tokens are service specific)
    • Added some test cases for the authenticator
    • Created a GoogleSpreadsheetService class which will handle executing queries on spreadsheets
    • While testing it, I couldn’t get it to work like the prototype code until I realized it worked within an air app but not inside a browser.  The HTTP Requests from within the browser were getting messed with and I kept getting not authenticated error messages.  So apparently the authentication method I am using will only work for AIR / Mobile apps.

Tom DeVito 8.30.2011

Start: 10:00

  • Got the simulation working with the midi controller
  • Changed the output to show the instrument, note, and simulation position.
  • Debugging the amp class so I can use it for a multiple finger simulation

End: 6:00

Phil 8.31.2011

8:00 – 4:00 VISIBILITY

  • Continuing with the wireframes
  • Got the charts in a ViewStack. It turns out that you need to explicitly include the mx.swc and the sparkskins.swc.
  • Making sure that all this runs on the phone still – and it does! Dropdown menus don’t work though. They don’t seem to fire  events.
  • I think it should be possible to make a popup rollover dialog using lists. Will try that tomorrow.
  • Had a chat with Bill D. He’s going to try to get us a couple of desks at NBP 324.

Dong Shin 08.30.11

  • adding monthly PM Actuals to Financial Status
    • PM Actual Outlay tooltip added to FinancialStatusDataForm
    • query – long and +gly, grabs whole year’s data
    • SELECT * FROM (SELECT r.funding_amount as statusAmount, r.*, c.uid as contractUid, c.contract_number as contractNumber, c.name as contractorName, c.location as contractorLocation, c.amount as contractAmount, d.uid as directCiteUid, d.obligation_amount as dObligationAmount, d.outlay_amount as dOutlayAmount, NULL as rObligationAmount, NULL as rOutlayAmount, b.center_number, a.amount, r.uid as fundingRequestId, a.uid as budgetAmountsId, o.month_1, o.month_2, o.month_3, o.month_4, o.month_5, o.month_6, o.month_7, o.month_8, o.month_9, o.month_10, o.month_11, o.month_12 FROM funding_requests r LEFT JOIN direct_cites d ON r.uid = d.funding_request_id LEFT JOIN contracts c ON d.contract_id = c.uid LEFT JOIN budget_centers b on r.project_id = b.project_id LEFT JOIN budget_amounts a on b.uid = a.budget_center_id, obligations_outlays o WHERE b.project_id = 100 AND a.uid = 1395 AND NOT ISNULL(d.funding_request_id)  AND r.fiscal_year = 2011 AND o.year = 2011 AND o.project_id = 100 AND o.funding_id = 213 AND o.type LIKE ‘PM Actuals Outlay%’ AND o.year_count = 1 UNION SELECT r.funding_amount as statusAmount, r.*, NULL as contractUid, NULL as contractNumber, NULL as contractorName, NULL as contractorLocation, NULL as contractAmount, NULL as directCiteUid, NULL as dObligationAmount, NULL as dOutlayAmount, r.reimbursable_amount as rObligationAmount, r.outlay_amount as rOutlayAmount, b.center_number, a.amount, r.uid as fundingRequestId, a.uid as budgetAmountsId, o.month_1, o.month_2, o.month_3, o.month_4, o.month_5, o.month_6, o.month_7, o.month_8, o.month_9, o.month_10, o.month_11, o.month_12 FROM funding_requests r LEFT JOIN budget_centers b on r.project_id = b.project_id LEFT JOIN budget_amounts a on b.uid = a.budget_center_id, obligations_outlays o WHERE b.project_id = 100 AND a.uid = 1395 AND r.fiscal_year = 2011 AND r.uid NOT IN (SELECT funding_request_id FROM direct_cites) AND o.year = 2011 AND o.project_id = 100 AND o.funding_id = 213 AND o.type LIKE ‘PM Actuals Outlay%’ AND o.year_count = 1) AS T1 ORDER BY uid, contractUid, statusAmount DESC

Mike 8.30.2011

Looking in to some difficulties we may encounter when trying to remotely access google data services with URL requests only:

  • Authentication – http://code.google.com/apis/accounts/docs/AuthForInstalledApps.html details how we may request a service token which can be used for further data requests.  Each token is service specific so here’s a list of services and their (not obvious) names http://code.google.com/apis/gdata/faq.html#clientlogin
  • List Spreadsheets? – once we know a spreadsheet’s name / key we can make queries against it, but how do we get a list of spreadsheets?
  • column name resolution? – google identifies all their columns using ‘A’, ‘B’, ‘C’… from left to right.  What we refer to as the column name they call the label.  Queries are made using the identifiers and not the labels so changing column order changes the query results.  We may not care though…

Phil 8.30.11

7:30 – 5:00 VISIBILITY