Monthly Archives: May 2011

Tom DeVito 5.31.2011

Start: 9:30 am

Examining new components:

  • The 13mm exciters are the perfect size but may not be powerful enough with only a 1 watt rms
  • The 25mm exciter is a bit bigger and heavier then I initially thought but has a 15 watt rms which may be needed.
  • The base shaker seems to be a good size but weighs a bit more then I thought it would.  This also has a 15 watt rms
  • Need amplifiers to test the bass shaker and higher powered exciter.  Will test the 13mm tomorrow.

Incorporation of COM to RCS:

  • Set up the read, write, init functions
  • Am trying to figure out how the DataDictionary works as well as where changes will need to be made for the simulaton to read off the new arduino controlled entries as opposed to the phidget inputs.
  • Forgot to add DWORD n and HANDLE hCom are both required for com communication
  • Not sure if there is a way to scan com ports for specific devices.  Currently its hard coded but may need to be manually entered in case port changes.

Com Monitor Console:

  • Copied relevant functions into a new project to eliminate some of the complexity as Phil asked.
  • Outputs will be printed on one line which will not scroll.
  • Found the proper sketch for testing this and renamed it “ComTest”  so that I don’t get it confused again.
  • Will finish this tomorrow

End: 6:00 pm


Dong Shin 05.31.2011

  • PPM Changes
    • add performance_location to contracts table – ALTER TABLE `contracts` ADD `performance_location` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `location`
    • add additional_info, title_task_name to funding_request table –
      • ALTER TABLE `funding_requests` ADD `additional_info` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `statement_of_work`
      • ALTER TABLE `funding_requests` ADD `title_task_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `uid`
    • contract add/remove now working
    • modify Contract Form Window to save contracts data with new field – performace_location
  • talked to Christina/Phil about the Recruiting App, ingested the latest spreadsheet.

    Kristi 05.31.2011

    Hope everyone had a nice holiday! 😉

    A few minor items:

    1.  Projects – Create Project – Services – “Marine” should be “Marines”

    2. Projects – Create Project – Services – Center Name – When double clicking empty field, New box no longer opens… Update Budget Center Datawindow is now opening in all fields – can this bug be fixed?

    Thanks!

    Phil 5.27.11

    7:30 – 4:30 VISIBILITY

    • I have a UPS! And Service Pack 7! It’s almost like Christmas – maybe Hogswatchnight.
    • Going over Trish’s new requests with Dong:
    • Discovered PortQuery, just what I wanted! Burning a copy to CD.
    • Tried out portquery. It turns out that there is someting between my desktop box and the VM that Tomcat is running on. Regardless of whether or not I have Tomcat running, ports 443 and 80 read as LISTENING from my desktop. Running from the VM, turning Tomcat on and off chage the ports from LISTENING to NOT LISTENING. Trying to track that down.

    Dong Shin 05.27.2011

    • additional fields needed to Funding Request – also in Bug List
      • Title/Task Name
      • Program Element in Budget Center/Funding list
      • Contracts Info: Contract Numbers, Contractor Names, Contractor Place of Performance
      • Additional Info (required so MIPR will not be rejected)
    • PPM Changes
      • fixed Create Project panel showing AddBudgetCenterWindow on double click on empty DG (itemDoubleClick)
      • funding_request table modification so that Appropriation changes reflect…
        1. ALTER TABLE `funding_requests` ADD INDEX ( `appropriation` )
        2. ALTER TABLE `funding_requests` CHANGE `appropriation` `appropriation` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
        3. ALTER TABLE `funding_requests` ADD FOREIGN KEY ( `appropriation` ) REFERENCES `project_portfolio`.`appropriations` (`type`) ON DELETE NO ACTION ON UPDATE CASCADE ;
      • update Appropriations
        1. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘O&M (FY10)’ WHERE `appropriations`.`type` = ‘FY10 O&M’;
        2. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘Procurement (FY10)’ WHERE `appropriations`.`type` = ‘FY10 Procurement’;
        3. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘RDT&E (FY10)’ WHERE `appropriations`.`type` = ‘FY10 RDT&E’;
      • added new fields to Funding Request panel
        • Title/Task Name
        • Program Element
        • Contract Info datagrid
        • Additional Info
      • created _funding_requests_contracts table to support contracts info
        1. CREATE TABLE `_funding_requests_contracts` (`funding_request_id` INT NOT NULL ,`contract_id` INT NOT NULL , INDEX ( `funding_request_id` , `contract_id` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
        2. ALTER TABLE `_funding_requests_contracts` ADD INDEX ( `contract_id` );
        3. ALTER TABLE `_funding_requests_contracts` ADD FOREIGN KEY ( `funding_request_id` ) REFERENCES `project_portfolio`.`funding_requests` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
        4. ALTER TABLE `_funding_requests_contracts` ADD FOREIGN KEY ( `contract_id` ) REFERENCES `project_portfolio`.`contracts` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;

    Dong Shin 05.26.2011

    • PPM Changes
      • Tweaked YearComboBox to support Full Year, Year #, etc. It can use calendar year (2011 , etc) or year count (0, 1, 2, etc).
      • reworking the query to retrieve all Financial Status data –
        SELECT r.*, c.contract_number, c.name as contractor_name, c.location as contractor_location, 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 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 WHERE b.project_id = 99 AND a.uid = 1335
        UNION
        SELECT r.*, NULL as contract_number, NULL as contractor_name, NULL as contractor_location, 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 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 WHERE b.project_id = 99 AND a.uid = 1335

    Phil 5.26.2011

    7:30 – 4:00 VISIBILITY

    • It’s gonna be *hot* today.
    • Looking into the java.security.cert.CertificateException: java.io.IOException: DerInputStream.getLength(): lengthTag=109, too big.
    • Asked for port 443 to be opened based on Allen’s suggestion.
    • Still not sure if the certs are in correctly. When I was initially checking on Jeff’s machine, the cert came back as unverified when checking from an outside browser. On the machine itself, it was fine. Then later, it was fine. Very confused.
    • One of Jeff’s PKI team is sending be a section of their keystore ‘how to” for Windows Server that might be some help

    FP

    • Ordered Tom’s parts
    • Ordered some pressure sensitive resistors to play with

    Cool thing for the day:

    Mike 5.25.2011

    • Completed a drag and drop interface for structuring Reports
      • The report structure is represented as a flex Tree object on the left side of the panel
      • A list of available section types is on the right side (Nodes, HTMLText, Image, and Table for now)
      • Users can drag items from the list to the tree to add sections to the report.
      • Users can also rearrange the report by dragging sections around the tree
      • Sections are removed by selecting them in the tree and pressing a ‘Remove’ button
      • The report updates immediately in the background whenever changes are made
    • Now that users can modify reports, I’m starting work on a document management panel modeled after the main screen of Google Docs

    Dong Shin 05.25.2011

    • lost the script I was working on yesterday… Found that the scripts are not saved on the sever
    • meeting with Trisha
      • list of changes coming
    • PPM Changes
      • changed the Appropriation types – UPDATE `project_portfolio`.`appropriations` SET `type` = 'O&M (FY10)' WHERE `appropriations`.`type` = 'FY10 O&M';
      • Appropriation ComboBox removed from Financial Status panel
      • HeaderRenderer (ComboBox) for Obligation/Outlay types removed
      • added YearComboBox and FYMonthComboBox to Financial Status panel

    Phil 5.25.11

    7:30 – 5:30 VISIBILITY

    • Meeting with Trish
      • Rename appropriations so that the year is in parens  – i.e. R&D (FY10)
      • Make sure that the change ripples across the tables. It does not change in the Funding Request dialog
      • Have a line for each Direct Cite and for Reimbursable in financial status
        • And clicking on each line should bring up a unique dialog for that line
      • No ComboBox for Appropriation at the top of the Financial Status panel. Instead, on the right-hand side of the panel, have an appropriation year and appropriation month ComboBox. These should default to the correct month year for the project based on today’s date. In other words, if the money for the contract was appropriated (using project create) on Oct 1 2009 (i.e. FY10), and today is Oct 1 2010, then it’s October (month 1) of year 2.
      • Add a global refresh
      • Add an ‘Initiate’ Column and a ‘Commit’ Column to replace the Initiate/Commit’ column currently in the financial status
      • Add an ‘Initiate’ field and a ‘Commit’ field to replace the Initiate/Commit’ field currently in the funding request
      • Percent in financial status needs to be calculated against the goal percentage based on the current month/year in the appropriation cycle
    • Had another power failure last night – still need a UPS
    • Looking through Tomcat documentation to see if I can find what’s going on with my problem child server

    Tom De Vito 5.24.2011

    • Passing multiple bytes of data worked but is a little hard to tell if its going in the right places with a scrolling console screen
    • Brought in the dependent classes from RCS system into the sandbox so that the test class will function more like it will in the final product
    • Working on adapting it to the RCS controller format and displaying output on an openGL overlay so I can see everything is working clearer.

    Dong Shin 05.24.2011

    • not getting any useful info out of all financial data script
    • few question to convert to script
      1. What projects are under #% under budget?
      2. What managers/Financial people have project > 10%?
      3. What projects are overdue?
    • query to retrieve current year data – year 2012 is for 2011 (year = 2011 + year_count (1…))
      • SELECT p.project_number, c.center_number, a.*, o.* from projects p, budget_centers c, budget_amounts a, obligations_outlays oWHERE p.uid = c.project_id AND c.uid = a.budget_center_id AND p.uid = o.project_idAND year_count = a.year AND (o.year + o.year_count) = 2012

    Phil 5.23.11

    7:30 – 4:30 VISIBILITY

    • Added default login to RFlexClient – done
    • Write up RFlex description – done
    • Study https tomcat setup – see if there is anything I’m missing.
    • Actually got a Server up! It’s one of Jeff’s but I am not complaining 🙂

    Dong Shin 05.23.2011

    • VisibilityScriptingServer
      • changed content field in visibility_scripting.table_publish to LONGBLOB to handle large amount of data
      • modified com.fgm.javaUtils.database.DbTable.java to handle LONGBLOB
      • tweaking query to generate the data in right format….