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


Advertisements

Phil 5.31.11

8:00 – 4:30 VISIBILITY

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