Dong Shin 06.02.2011

  • PPM Changes
    • added Contract select button to Financial Status Data form so that the contracts are editable only from Contract Select Window
      • Contracts cannot be added/changed to Reimbursable (Non-Direct Cites)
      • added Update query for contracts
    • reworking Financial Status data query – not returning correct data…. – fixed
    • save Obligations and Outlays based on Direct Cite status – No Direct Cite saves the data directly to the funding_request table, direct_cites table otherwise
    • changed the way the financial status data gets saved – save at the Financial Status Data form and fire an event to refresh the data
    • looking into Role Management

Phil 6.2.11

8:00 – 5:30 VISIBILITY

  • Pinged Christine
  • Trying to figure out the report creation scheme of SonicRecruit. The help is absolute crap.
    • Reports
      • Candidate
        • Application – produces small table of last name, first name, date applied, status date, job id, and job title
        • Candidate Historical – produces large table of last name, first name, status, status date, job id, job title, status changed by. Ingesting
        • General – produces large table. Name, Title, Recruiter, Location, City, Education, Source, Applied for, Job Title, Status, Date, How did you learn about this opportunity, Job status, Job recruiter, job category, job duration, job date posted, currently, location, Clearance level. Ingesting
        • Historical
        • Duplicate Candidate
        • Status / Source
        • Feedback Form
      • Job
        • Job General
        • General
        • Historical
        • Job Candidate
        • Statistical
        • Cost Per Hire
        • Crosspost Summary
        • Crosspost Detailed
        • Bottleneck
      • Division (Dialog)
      • Activity
        • Events
        • Comments
        • User Login / Logout times
        • Hiring Manager Login / Logout times
        • Action Report
      • My Saved (no templates saved on any)
        • Candidate Templates
          • General
          • Historical
          • Status
          • Feedback
        • Job Reports Templates
          • Job/Candidate
          • General
          • Historical
          • Statistical
          • Cost-per-hire
          • Crosspost detailed
        • Division Reports Templates
          • General
      • All Saved (Same as My Saved except for)
        • Candidate Reports Templates
          • New Hires (standard)
        • Job Reports Templates
          • open jobs/candidate report 2011 (excel)
      • Analytics
        • Resumes
          • Source Efficiency
          • Hired Source Efficiency
          • Hiring History
          • Current Applicant Status
          • Historical Applicant Status
          • Applicants for Open Jobs
          • Custom Fields Reports
        • Jobs
          • Opened/Filled Historical Status

FP

  • Worked with Tom on putting together a better-structured testbed

Cool thing:

  • Sandboxie runs your programs in an isolated space which prevents them from making permanent changes to other programs and data in your computer.

Tom DeVito 6.1.2011

Start:  8:30

Com Monitor Console:

  • r is for carriage return which makes the next line overwrite the previous.  If the string is shorter in length it will not clear all the extra characters.  Padding the data with zeros helps make sure the string stays the same length.  It is important to resize your console to fit the whole line or it will scroll the first line and go back to the beginning of the second line.
  • Need to make another class to handle actual communications instead of having it in the monitor class as it is now.
  • getch() halts the loop so its not good for user input in this case.  I forget which one to use instead.

Notes for ComManager class:

  • Init should be moved into this class
  • sendData and recieveData should also be moved and changed to accept null pointers and a size.  This should be easy on the sending side but I am not sure about the receiving side unless the size is always the same.  I will have to see if there is a way to get the size of a incoming package so that the method knows how much its receiving.  One possible solution, if nothing else, might be to put the size in the first byte and have two ReadFile calls one to grab the size and the other to grab the remaining data using that size.
  • Need to read this tomorrow to get an idea of how calloc is used to make a generic array:  http://www.cplusplus.com/reference/clibrary/cstdlib/calloc/
  • Need to look up more information on void pointers.  They seem to be typeless pure memory and can be cast into anything.

End: 5:00

Mike 6.1.2011

  • Got a lot done with the Document Management pane.  Users can:
    • Create new reports
    • Edit report meta data
    • Delete Reports they created
    • It also automatically keeps track of the last time the report was saved and who made the changes
  • Had some difficulty when creating a new report mostly because a Flex Tree, when displaying an empty data provider, automatically puts in a branch that isn’t there.  It really screwed up my drag and drop report builder, but I hacked around it by putting in a temporary item if the report is empty
  • Working on enabling internal and external linking through html text.  Once this is working the system should be able to support something resembling webpages.

Dong Shin 06.01.2011

  • PPM Changes
    • Year selection based on Appropriation length – defaults to current month if possible
    • Year and Month changes trigger retrieval of goals data and update datagrid
    • reworked the color highlighting – compared with the goals now
    • separate Initiate/Commit
      • ALTER TABLE `funding_requests` CHANGE `initiate_commit` `initiate` DOUBLE NULL DEFAULT NULL
      • ALTER TABLE `funding_requests` ADD `commit` DOUBLE NULL DEFAULT NULL AFTER `initiate`
      • Funding Request Form changed to support initiate and commit
      • Financial Status Panel and Form changed

Phil 6.1.11

7:30 – 5:00 VISIBILITY

FGM

  • Submitted my paperwork for class reimbursement.
  • Was able to generate excel docs from sonicats records. Need to save off a few queries (reports?) and export to visibility
    • And make a Recruiting role
    • And add (who?) to the role
    • And make a slideshow.

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