Phil 2.11.11

7:30 – 3:00 VISIBILITY

  • It looks like the customer uses Flash 10. Not sure about the exact version.
  • Interview with Phillip Tomlin.
  • Sank into a Friday stupor and was unable to get anything substantial working.

Dong Shin 02.10.2011

  • while searching for ways to save PPM data into excel format, found
  • PPM Changes
    • saving database changes to DBUpdateSQLs02102011.sql
    • Funding Request Changes
      • larger mailing address POC
      • added email and phone/fax for mailing address POC
      • two more fields to funding_requests table – mailing_address_email and mailing_address_phone
        • ALTER TABLE `funding_requests` ADD `mailing_address_email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `mailing_address` ,
          ADD `mailing_address_phone` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `mailing_address_email`
      • removed Contracts from Reimbursable
      • Add Contract added to Direct Cite window
      • added a new field to contracts table
        • ALTER TABLE `contracts` ADD `ACRN` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `contract_number`
      • remove all, but FY and Budget Center in BudgetCentersWindow for Financial Status
    • working on a pivot query to return financial data for selected project, month, year
      • find all first month data for year 2011 from projects and obligations_outlays tables
        SELECT year, project_id, year_count,
        GROUP_CONCAT(IF(type=’Planned Obligated $:’, month_1, NULL)) AS ‘Planned Obligated $:’,
        GROUP_CONCAT(IF(type=’Reported Actual Obligated $:’, month_1, NULL)) AS ‘Reported Actual Obligated $:’,
        GROUP_CONCAT(IF(type=’Planned Outlay $:’, month_1, NULL)) AS ‘Planned Outlay $:’,
        GROUP_CONCAT(IF(type=’Reported Outlay $:’, month_1, NULL)) AS ‘Reported Outlay $:’,
        GROUP_CONCAT(IF(type=’PM Actuals Outlay $:’, month_1, NULL)) AS ‘PM Actuals Outlay $:’,
        GROUP_CONCAT(IF(type=’Outlay $ (Reported in FACTS)’, month_1, NULL)) AS ‘Outlay $ (Reported in FACTS)’,
        p.*
        FROM obligations_outlays o, projects p
        WHERE year = 2011 AND year_count = 1 AND o.project_id = p.uid
        GROUP BY year_count, year, project_id
        ORDER BY project_id, year

Phil 2.10.11

7:30 – 5:30 VISIBILITY

  • Downloaded Dong’s update on my home machine, but my CD drive just died, and I can’t burn the thing.
  • Good meeting with Trish and Lea(?). The bug fixes appear to be working. We spend some time on small features, and how the email generation should work. Dong has my notes right now, but I’ll add detail later.
  • Meeting with Anne and the CMM folks. Went very well. We’re going to get together again to discuss in more dtail. The possibility appears to be that CMM would like to incorporate VISIBILITY, possibly by sending a RESTful request to the server containing the table to display. We, on the other hand would like to run a set of queries against the CMM data to have more data for VISIBILITY reports. I think we can have both, which might maker everyone very happy.
  • Generalizing the data input, and adding another test to the statistics package. As an aside, CMM is attempting to develop confidence intervals on the data they provide to their users. Hmmm.

Phil 2.9.11

7:30 – 6:30 VISIBILITY

  • Installed new version of PPM. Everything seems to be working, though the meeting to walk through was postponed until tomorrow. The Combobutton is still in
  • Worked on actionscript statistics classes.
    • Completed the Randomized Test
    • Updated the data sources to take user data as well as generating random

Tom.DeVito 2.9.2011

Repairing the hand:

  • Index finger is still not acting right.  Tried replacing the bottom just to get exactly the same resistance as before which is equal to the other working ones.
  • Replaced top one again.  Still 100 ohms too high.  Think this might be due to a groove in the metal.
  • Smoothed out the metal and put insulating layer on it.

Computer Controlled Amplifier:

  • Came across this website listing various amplifiers:  http://www.datasheetcatalog.com/function/Analog_and_Mixed-Signal_Devices/Signal_amplification/Audio_amplifiers.shtml
  • The one that looks good for our purposes is:  1 W BTL audio amplifier with digital volume control TDA8551
  • This IC is controlled by a trinary input(3 signals)
  • High signal is between 4.2-5 volts
  • Float signal is between 1-3.4 volts
  • Low signal is between 0-.6 volts
  • I was able to get these 3 signals using the i2c rheostats we have in combination with 500 ohms of resistance.  The power from the i2c adapter is connected to b1 with 500 ohms resistance and then w1 is connected to ground.  The voltage is divided at b1 so the signal is between Vdd and b1.
  • The mode is also controlled by a trinary input so one i2c rheostat chip(which has 2 rheostats in it) will control 1 amplifier using the two rheostats for each input.
  • We can only have 4 of these on one i2c bus so the fifth finger will need another usb-i2c adapter.

Calculating R2 for voltage divider:

R_2 = frac{R_1} {({frac{V_mathrm{in}}{V_mathrm{out}}-1})}
R1 = 500 ohm
Vin = 5
Vout = x (desired output voltage)

Christine 02.09.2011

  • Deleted and re-checked out EdgeUtils2 only to have the same errors occur. Met with Dong:
    • More maven fun, this time on the mac. Discovered flexmojos:flexbuilder not working correctly for library apps (ex: EdgeUtils)
  • Installed MySQL on Windows machine; got Tomcat working in Eclipse on both Mac and Windows.

Tom.DeVito 2.8.2011

Repairing the hand:

  • Index finger still has problems.  Found out it was actually the bottom, not the top, that had the wrong resistance.  Attached a new one waiting for glue to dry.

I2C volume control:

  • Found out the difference between a rheostat and a potentiometer.  A rheostat only has 2 leads while a potentiometer has 3.  The potentiometer changes the resistances between the wiper and both ends producing two different resistances which add up to the total.   All potentiometers can act as rheostats but rheostats can’t act as potentiometers.
  • Our i2c chips are rheostats which is a problem because our amplifier needs a potentiometer.  I was able to mimic a potentiometer by setting the second register to (255 – register1).  This worked but there is no way to cut off the sound completely.  The chip has a shutdown command but it shuts it down at A which doesn’t exist on these circuits.
  • There is a version of this chip which is a potentiometer and the cut off switch would work but these are not addressable.  To use these I would either need a usb hub or some type of i2c multiplexer which I am still confused how you actually address it.
  • The other option is to get a complete audio amplifier IC.  Finding one of these that is not tiny and has leads is hard.
  • Going to read documentation for the ad5243 to see if there is a special way to mute it.   Have a feeling only the potentiometer version can do this.

Mike 2.8.2011

Working on the back-end database and java interface.  After going through a lot of documentation and partial examples, I figured out a way to dynamically map java HashMaps of key value pairs to a hibernate managed database.  I did it by using the dynamic mapping capability of Hibernate.  Hibernate simply requires an xml document to map keys to database columns.  I plan on creating a meta class structure that will either store object meta information or read it straight from the database tables and create the required xml documents as required.  If a new property is added to a dynamic object, the meta class will generate a new xml document for Hibernate and hibernate takes care of the SQL ALTER calls.

Reasons why this is good:

  • We can make use of dynamic Flex objects
  • Our object types can evolve and grow with time and be transferred between instances
  • We can connect to almost any database type (all types supported by hibernate) without rewriting anything
  • We can make use of libraries made to work with hibernate for things like lazy loading and data pagination
  • We don’t have to write sql queries for most things (if a Car has an Owner and we have a reference to the Car object, calling car.getOwner() will cause hibernate to do the database call for us)

Dong Shin 02.08.2011

  • PPM Changes
    • created SelectContractWindow that has filtering/searching capabilities, mapped to Funding Request
    • consolidated many buttons in ProjectMgmtPanel into PopUpButton
      • disabled click, works like ComboBox
    • added support to view Project Status from Main menu
    • fixed Start / End date validation
  • FGMDEV backup
    • dump files still not getting to the server
    • created and configured second script to transfer that runs one hour after the first one – check tomorrow.

Phil 2.8.11

7:30 – 5:30 VISIBILITY

  • Mike Cowan leaves S2F this Friday.
  • Got a few more screenshots from Trish and Christie. Fortunately they have nothing new in them. Dong is still on track for a disk by COB
  • Working on getting RemoteObjectTestbed2 working. This one has no java code in it and has logging. Got both working. Next, projects.
  • Taking a detour into building a few statistics actionscript classes.

Phil 2.7.11

7:30 – 5:00 VISIBILITY

  • Meeting with Trish, Christie, and someone new who I can’t remember right now.
    • Bugs – several, all hopefully having to deal with DB configuration. I gave Dong the screenshots
      • Also, add two more lines under mailing address in funding request
      • Funding request warning dialog has “financial” misspelled as “fianancial”.
      • Add “RTAs” to funding type under “detailed Information” tab
      • Selecting names seems to offer up only 20 or so names. What is the selection criteria? The same list appears for all selection buttons
      • Add check so that no start date be saved that is after an end date
      • The “Add Funding” dialog needs a sortable list for contract number – it’s a very long list. It’s also too narrow – there are some very long contract numbers. Panel is too small as well.
    • Next highest priority is the “email generator” This will produce messages to copy and paste into messages to the Financial and technical POCs
      • Create an email like the one in Funding Request for each POC that has the current financial data that they have to fill in, and the associated forms if they are not on goal
      • Have a list of all projects that the user can move through to create all emails in and easy way
      • List should have a dropdown that lets the user select the year and reporting period. Selecting a time period (FY/Quarter?) will bring up the list of POCs and the status
      • Users should be able to indicate the state of the contact:
        • Nothing done
        • Email sent out
        • Response back
        • Response entered – incomplete (if a goal has not been met and there is no justification, this should be flagged automatically. There may be an additional button if this is the case that asks the POCs for justifications
        • Response entered – complete
    • Status panel notes:
      • PPM calculated outlay should be a “checksum” of numbers. The true PM Actual Outlay needs to be entered by hand
      • Available balance is the percentage of the “last remaining to distribute” divided by the total budget
      • Goals are calculated as the total budget times the “out year” in the appropriation
  • Worked on migrating DbObject classes out of the sandbox and into the utils jars/swcs

Phil 2.4.11

12:00 – 6:00VISIBILITY

  • GREs this morning
  • Working on InfoObjectManager.as
  • Got an overview of the new PPM capability from Dong so that I can talk intelligently to Christie and Trish on Monday
  • Interview at 4:00
  • More InfoObjectManager.as. I think I have the actionscript side working.

Dong Shin 02.08.2011

  • FGMDEV backup
    • still missing database dump files….
    • modified the script to tar up the dump files and transfer, check tomorrow
  • PPM Changes
    • FinancialStatusDataGrid acting weird… Could not select anything other than last one. Turned out the uid field in the class causing it. Had same uid’s populated on the data. Changed it to dataUid, works now….
    • Errors reported on the latest deployed version
      • changed Create Project to set program_element and FACTS_PE fields to NULL for existing data
      • updated server code to remove INSERTs
    • Fixing bugs
      • Funding request warning dialog has “financial” misspelled as “fianancial”.
      • Removed limit of data in Names list  – had 100 entries
      • Increased width of Contract Number in Direct Cite Window
      • added RTAs to Funding Type
      • check for Start Date and End Date, also disables dates based on selection
      • working on SelectContractWindow

Christine 02.05.2011

  • Checked out and tested Ingest Manager, EdgeUtils2 and AccountManager on my mac to see difference:
    • Needed to remove duplicate dependencies
    • Definitely needed to change flex-maven_plugin to version 3.8
    • file .flexconfig.xml was generated by maven on Dong’s mac. This file was NOT generated on mine.
    • The -locale flag in Compiler settings needed to be empty in Flash Builder/Eclipse on my Mac because it threw the same errors that were occurring on my Windows machine yesterday.
  • 2 issues remain:
    • Ingest Manager: could not install application via Maven Assist. It led to to OutOfMemory: Java Heap error. I set MAVEN_OPTS in the terminal. Still failed to install application in Maven Assist, but could successfully install the application via the terminal window.
    • EdgeUtils: Continue to get a problem associated with the compiler settings. By default (after checking out the project) the additional compiler settings had “-include-sources:C:Phil…..EdgeUtilssrcmainflex”. I removed this setting completely, only to receive another error “nothing was specified to be included in the library” (this same error was generated if I added in the -locale argument). Finally, I took original argument, but changed it to point to my EdgeUtilssrcmainflex directory, only to be told that “could not find resource bundle in logging, messaging, rpc, SharedResources, validators”. Need to find out from Dong what his compiler argument is set to — hopefully that will resolve the issue on my mac.