Monthly Archives: October 2011

Dong Shin 10.18.2011

  • attempt to deploy new PPM and PPM Widget
    • start up query that retrieves project status takes to long – 145,000 records in __view_financial_data_status_view
    • remove default (debug) login
    • show status of query
    • Font size increase messed up PPM
    • Data Window in DB Table Mgmt needs scroller
  • added Alert to ask user to view project status up on login
  • added user information on top
  • added debugUser information to setupModel.xml
  • modified query to retrieve the projects status
    • SELECT p.*, IF(p.uid IN (
      SELECT p.uid
      FROM obligations_outlays o, projects p
      WHERE o.project_id = p.uid AND ISNULL(o.month_1)
      AND (o.year + o.year_count – 1) = 2012), ‘OVERDUE’, ‘CURRENT’)
      AS status FROM obligations_outlays o, projects p

      WHERE o.project_id = p.uid
      AND (o.year + o.year_count – 1) = 2012
      AND (proj_mgr_login = ‘annaleese’ OR p.uid in (SELECT project_id FROM
      _projects_service_project_mgrs WHERE login = ‘annaleese’))
      GROUP by p.uid

Tom DeVito 10.17.2011

Start: 9:00am

  • I am pretty confident the electronics are working well enough to move to communicating with computer.
  • Reviewed the pc and arduino side classes for data transfer.
  • Passed a string from a sandbox sketch to the computer to refresh my self on how to do this.
  • Got the sensor data to display in my pc console.
  • Considering making a graphical ui for adjusting the instrument and tone of each finger so we can experiment better.  Not sure how hard it is to integrate this into a console application.
  • Looking into how to do this I found you that you can’t simply add a gui to a console app but it can be done in a MFC application.
  • Asked Phil about the GUI.  He recommended FLTK.  (http://www.fltk.org/)
  • I forgot about the thumb and index finger shorting out when used at the same time.  Will have to remember to look into this tomorrow.

End: 6:00pm

Phil 10.17.11

8:00 – 4:00 VISIBILITY

  • Got admin privs on Mikes machine and gave him Tomcat
  • Installed subversion on my box so we can keep synchronized.
  • Went over Dong’s progress. He has a new widget and a new PPM burned to disk. We’ll try deploying tomorrow
  • Assembled a description of the VISIBILITY suite for Chris Bailey
  • Got a little googling done. Mikes making good progress with maps.
    • Drat, the Google Query Language does not support inserts. Looks like a new AppEngine

Tom DeVito 10.14.2011

Start:  9:00am

  • Got the audio to split properly.  Assigned different tones to each finger.  The higher pitch sounds are actually more tactile.
  • There is some weird thing that happens when the thumb and index are pushed simultaneously where all the electronics go into some type of weird grounding loop.  I have examined everything and haven’t found a short yet.  It seems to be related to the midi controller because it doesn’t happen if only the amplifiers are active, however, it could just not be happening because there is no signal in this case.  I just noticed the polarity of the signal input capacitors might be the cause. I will be sure to check this Monday.
  • The sound quality is not equal across all speakers.  I might be able to increase quality by hooking up the midi devices differently using a method which better isolates the signal.  I had a link for this a while back.
  • Along with pitch bend it might be good to have the amps ramp up on curved function rather then the current linear way.

end: 6:00pm

Dong Shin 10.14.11

  • working at home
  • PPM
    • made font size bigger (12)
    • fixed endpoint errors not getting to MySQLIf (timing)
    • find overdue budget centers
      • select *, ‘overdue’ as status from obligations_outlays
        where (year + year_count) = 2013 and isnull(month_1)
        and funding_id in
        (select uid from budget_centers where project_id = 99)
        group by funding_id
    • find overdue years for the budget center
      • select *, ‘overdue’ as status from obligations_outlays
        where (year + year_count) = 2013 and isnull(month_1)
        and funding_id = 181
        group by year

Tom DeVito 10.13.2011

start: 9:00am

  • Got the fifth finger to work.  At first I thought it was the rheostat then I thought it was the amplifier.  Turns out the amplifiers power wasn’t connected properly.  It was hard to tell because theres two grounding capacitors on the power line so it looked like it was connected.
  • Mounted one rheostat and 1 amplifier to break to break out boards to try to resolve the problem above.  These will probably come in handy later.
  • Working out the issue with panning the channels so each finger can have individual sound.
  • pictures:

If I reviewed the pictures yesterday I might have seen that the amplifier had no power.

End: 5:00pm

Phil 10.13.11

8:00 – 4:30 VISIBILITY

  • Attempted to deploy Dong’s PPM Widget.
    • It launches in IE, but not in Firefox. Need to bring in debug players
    • There is an endpoint problem. Took screenshots for Dong to peruse
    • Meeting with Tangi
    • Impromptu meeting with Bill
  • Renewing my ACM membership
  • Submitting reimbursement for patent application fees
  • More work with Mike’s Google interface.

Tom DeVito 10.12.2011

Start: 9:00am

  • Finished the diagnostic sketch
  • Had lots of trouble with the addressing of the i2c rheostats.  I forgot that the arduino drops the left most bit because it automatically takes care of the read/write bit.  I found my blog entry which reminded me.
  • the registers sub address are 0x80 or 0x00.
  • The secondary register circuitry was wrong.  It was attached on the wiper side instead of the power side.
  • reordered the speaker wires so its easier to tell which amplifier knob goes to which finger.
  • Got 4 fingers working.  The last one is not getting the proper voltage rating from the control voltage divider.
  • currently each midi is producing a constant tone for testing purposes on both left and right.  Once I get the left and right to play independently I can experiment with pitch bend and different tones per finger.

end: 5:00pm

Mike 10.12.2011

Been awhile since my last update…

  • Been at my internal desk each morning for the past couple weeks submitting requests, setting up my development environment, and doing as much development as possible.
  • Acquired PKI certificates for myself and the servers
  • Figured out how to configure a tomcat server to use the certs, two-way ssl, and pass the cert along the HTTPRequest
  • Wrote a Filter that pulls the certificate off the requests and attempts to validate the user with the central authentication server
  • When the user’s credentials come back, the information is stored on the session for future requests and the user is allowed to continue
  • If the user is not authorized a generic page stating that fact is shown
  • Wrote a simple test servlet that demonstrates this capability
  • Deployed the servlet to the integration machine where it is currently working just fine

Dong Shin 10.12.2011

  • PPM Widgets
    • added Project status
    • updated FinancialDataView to have the fields from Project, added FinancialDataViewStatus for project status
    • added query to retrieve the status of the project (may need fine tuning, takes about 4 seconds to retrieve the data)
    • burned the software to test on-site
    • working on Budget Centers, Years, Year Counts for overdue projects
      • select b.`uid` AS `uid`,
        b.`project_id` AS `project_id`,
        `appropriations`.`status` AS `status`,
        ‘complete’ as project_status,
        O_type, o_year, o_year_count, o_uid, o_month_1
        from `budget_centers` b
        left join `appropriations` on
        b.`appropriation` = `appropriations`.`type`
        left join __view_financial_data_view
        on project_id = p_uid and b.uid = c_uid
        where p_uid = 100 and o_year = 2012 and o_year_count = 1
        and ISNULL(o_month_1)
        and uid not in (
        select b.`uid` AS `uid`
        from `budget_centers` b
        left join `appropriations` on
        b.`appropriation` = `appropriations`.`type`
        left join __view_financial_data_view
        on project_id = p_uid and b.uid = c_uid
        where p_uid = 100 and o_year = 2012 and o_year_count = 1
        and NOT ISNULL(o_month_1)
        GROUP BY uid)
        GROUP BY uid
        UNION

        select b.`uid` AS `uid`,
        b.`project_id` AS `project_id`,
        `appropriations`.`status` AS `status`,
        ‘overdue’ as project_status,
        O_type, o_year, o_year_count, o_uid, o_month_1
        from `budget_centers` b
        left join `appropriations` on
        b.`appropriation` = `appropriations`.`type`
        left join __view_financial_data_view
        on project_id = p_uid and b.uid = c_uid
        where p_uid = 100 and o_year = 2012 and o_year_count = 1
        and NOT ISNULL(o_month_1)
        GROUP BY uid

Tom DeVito 10.11.2011

Start: 9:00am

  • The thumb sensor was not working.  I think the heat from the soldering broke the contacts attached to the wiring on the sensor.
  • Started a diagnostics sketch which helps test the individual components by making it easy to activate and deactivate the parts.  This sketch will come in handy for diagnosing issues in the future as well as easy experimenting of change how the amps and sounds ramp up and down to get a more natural feel.
  • This sketch is pretty much done but there are a couple of bugs that need to be worked out.  This should be working early tomorrow so hopefully I will be able to test everything tomorrow so the main sketch will work.
  • Took a bunch of pictures with my phone.  Going to look through them and e-mail the good ones to myself.  They will be up tomorrow morning.

end: 5:00pm

Dong Shin 10.11.2011

  • created FinancialDataDataGridSkin and modified FinancialDataItemRenderer
    • hover highlight and selection removed for non-editable row
    • backGround color added for editable row
    • MX + Spark setting in Flex Build Path not allowing spark theme? This doesn’t allow Spark DataGrid to use alternatingRowColors property, ended up modifying FinancialDataItemRenderer instead of using the skin class
  • cleaning up UI
  • create view for budget_centers and appropriations joined
    • CREATE ALGORITHM = UNDEFINED VIEW `__view_budget_center` AS SELECT budget_centers . * , appropriations.duration, appropriations.status
      FROM `budget_centers`
      LEFT JOIN appropriations ON budget_centers.appropriation = appropriations.type

Tom De Vito 10.7.2011

start: 9:00

  • Powered everything up.  No smoke
  • Sensors working but no sounds coming out on “contact.”
  • Attached headphones and found that the midi was working properly so it is probably a problem with the amplifier.
  • Eventually got to a point where the peak light on the large amplifiers was lighting up.  Looked at the speakers and found out I used the wrong wires on one end.
  • Once fixed sound worked.  Although the vibration goes through the whole unit, the finger that the speakers has strong enough vibrations that you don’t notice the other fingers vibrating as much.
  • Fixed the analog inputs so 0 is the thumb and 4 is the pinky.
  • Got the second finger working on that rheostat.  Currently both fingers are playing the same sound because the pan functions not working right.  Also there’s a direct connection to the i2c controller so I am still not sure if the bus will work properly.
  • Forgot my phone today so pictures will be included on Mondays entry.
  • All testing has been done using my old sketch so I still have to work out the problem with the simulation to get all the fingers working at the same time.

end 6:00