Category Archives: Projects

Phil 5.15.13

8:00 – 1:00 SR

  • Backups.
  • Some back and forth about revoking my old certs. It will turn off the annoying emails, so I confirmed the request as long as it doesn’t affect my new, shiny certs.

FP

  • Need to send iRevolution white paper to Shawn, and a link to this blog.
  • Need to put together a schedule for my “Summer of Code”
  • Still no extension cord (Whee! It came in after lunch!).
  • There is a multichannel test binary that you can run. (C:\Program Files (x86)\OpenAL 1.1 SDK\samples\bin\win64\PlayMultiChannelWin64.exe). It should run

    front left, center, front right, rear right, rear left, and subwoofer.

    Instead, it’s running

    front left, front right, and center.

    I’ve verified that all eight speakers are working in the test app that comes with the drivers. I’ve also verified that the sound is correctly sent using the Control Panel Sound->configure tool. So I’m not sure if it’s OpenAl or something else. Ah well. That’s for tomorrow.

Dong Shin 05.15.2013

  • continue working on FA/RA
    • added POC filter for adding service POC’s to Req’s
    • filter Requisitions List in RA per assigned Service POC’s to the Req’s
    • working on getting status for Req’s – done!
      • query to find Overdue, Due, Current Req’s
        • SELECT * FROM (
          SELECT ‘CURRENT’ AS status, c.* FROM budget_centers c WHERE uid NOT IN (
          SELECT funding_id FROM (
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_1) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_2) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_3) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_4) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_5) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_6) GROUP BY year, year_count, funding_id
          ) AS t)
          UNIONSELECT ‘DUE’ AS status, c.* FROM budget_centers c WHERE uid IN (
          SELECT funding_id FROM (
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_1) GROUP BY year, year_count, funding_id
          ) AS t)
          AND uid NOT IN (
          SELECT funding_id FROM (
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_1) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_2) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_3) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_4) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_5) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_6) GROUP BY year, year_count, funding_id
          ) AS t)

          UNION

          SELECT ‘OVERDUE’ AS status, c.* FROM budget_centers c WHERE uid IN (
          SELECT funding_id FROM (
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_1) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_2) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_3) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_4) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_5) GROUP BY year, year_count, funding_id
          UNION
          SELECT count(*) as null_count, funding_id, year, year_count FROM budget_centers c, obligations_outlays o
          WHERE c.uid = o.funding_id AND o.year + o.year_count = 2014 AND ISNULL(month_6) GROUP BY year, year_count, funding_id
          ) AS t
          )
          ) AS t2 ORDER BY uid

Dong Shin 05.14.2013

  • continue working on RA/FA
    • converting FilterableDG and associated components in FGMFlexUtils45 to spark components…. – done
    • got Requisition data list to display in RA
    • working on getting status for the Req Data

Phil 5.14.13

8:00 – 1:30 SR

  • Backups. Added a line in the script for the PPM enhanced db
  • Started the paperwork to mark the old certs as superseded. Here’s hoping I did that right!
  • General mucking about getting integrated with the Novetta portal. The IE browser plugin doesn’t work. But Firefox does. Switching over.

1:30 – 4:00 FP

  • Starting to walk through the OpenAL source code
  • Meeting with Shawn this afternoon or Thursday
    • Discussed various FP concepts. Of the concepts, iRevolution seems to be the best fit with the IRAD dept. There was also some discussion about building a data visualization capability.

Dong Shin 05.13.2013

  • continue working on FA/RA
    • Degrafa 3 (Maven) is not compatible with Flex 4
      • download news one at https://degrafa.googlecode.com/files/DegrafaFlex4.swc
    • got User Management Panel to work
    • working on Budget Center / Requisition View in RA
    • moved FilterableDG components to EdgeUtils and FGMFlexUtils45 from FA

Dong Shin 05.10.2013

  • discussed with Phil about new database layout for FA/PA/RA….
  • continue working on FA/RA(Req Assistant)
    • converting Financial Assistant to Flex 4.6
      • mix of 3.5 and 4.6 results  in weird compile errors
      • converted EdgeUtils to Flex 4.6

Phil 9.10.13

8:00 – 4:30 SR

  • Backups
  • Downloaded WebStorm, and basically starting over. It’s been a while.
  • Had a long discussion with Dong about how to hendle the next phase of development (i.e. FA/RA). We think there may be three phases:
    1. Do the minimum changes to the current DB to support a req-based set of tools
    2. Change out the DB under the  flex tools to support a cleaner database schema
      1. IMG_2077
    3. Develop a new set of apps that allow for dynamic db configuration and template-based GUIs
      1. IMG_2078

Dong Shin 05.09.2013

  • VizTool meeting at Fort
    • lots of notes – at Phil’s blog
  • continue working on FA
    • working on Users (Service POCs) for Req’s – done!
      • created table, _budget_centers_users to map Req’s and users
        • CREATE TABLE IF NOT EXISTS `_budget_centers_service_pocs` (
          `budget_center_id` int(11) NOT NULL,
          `login` varchar(255) NOT NULL,
          PRIMARY KEY (`budget_center_id`,`login`)
          ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
      • added AddServicePOCWindow
  • created new project – ReqAssistant – copy from Project Assistant for FA

Phil 5.9.13

7:30 – 11:00 SR

  • Deployed new FA and Javadoc for VSS
  • Updated main web page to add links
  • Added current users to FA db
  • backed up everything but enh. Need to start doing that.
  • Meeting with the PIT crew
    • Add the ability to build custom, named queries instead of the dropdowns in the Funding Status screen
      • Implies column config, or something like that
      • sortable columns
      • validator for matching parens, etc might be handy
    • Anywhere a budget is entered by had, a dialog should come up when it it changed. (who, why, when, more?)
    • Switch to Budget center based table structure. This may mean that the PIT crew will have to enter all the PA data over again with the new PA.
    • Change sub projects so that there is simply a “parent id” field. Recursively search to build trees.
    • Add individual tracability to req line items
    • Funding Status
      • Common elements are in top grid
      • Unique items are in main grid
      • Queries are stored in a dropdown
      • SQL might have macros in it that cause a dialog to pop up with fields?

Phil 5.9.13

8:00 – 4:00 SR

  • Both the integration and production servers are running smoothly.
  • Regular backups.
  • JUnit on ServerFacades. Almost done. Dong needs to add some comments to:
    • saveSQLs (String queryName, String databaseName, String SQLs, String xml)
    • saveMacros (String queryName, HashMap<String, String> valueMap)
  • Installed JAutodoc. I want to try to improve the visibility to comments in ScriptFacades.
  • Copied the VSS docs and a new FA to disk for tomorrow.
  • Got Junit up and running on ScriptFacades. YUI next.

Phil 5.7.13

8:00 – 4:00 SR

  • Pointed the server at the new cert on the production machine after verifying that the test machine was still happy. 
  • Rolled over to the new MySQL bd. A few hiccups getting the new db loaded, but after setting the max_packet_size in the conf file to 512M, everything worked when sourced from within mysql
  • Deployed the new FA beta
  • Deployed the new VSS. And it would have taken less time, except that winzip kept timing out when accessing a network folder. Copying everything to the local disk and compressing from there worked.
  • Back to JUnit
  • Review at 2:30, possibly 1:30.
  • Updating all the various Novetta and successfactors resumes.

Dong Shin 05.06.2013

  • continue working on FA
    • got Project Viewer panel to display the financial data correctly – only the years the Req Data falls in
    • fixed new project saving error
  • tested freshly built VSS server and client
    • null exception for _selectedSQLObject – fixed

Phil 5.6.13

8:00 – 4:00 SR

  • My fresh-out-of-the -shop car stalled three times getting out of the neighborhood this morning. Gave up, got it home and took the other car in. Grrr.
  • Backups
  • Status report.
  • Put the new server cert on the integration machine. Seems to be working.
  • In playing around with VSS on the integration server, I think that the SQL editor may be misbehaving…. It’s also doing the same thing on the production machine. Not sure if it matters, but the problem definately shows if I type ‘show tables’ as the first query after the webapp comes up.
  • Looks like the problem was a null pointer when no sql source was selected. Which means that the new db is ok. Looks like I can deploy the new certs and the new db tomorrow if the integration machines is still happy.
  • Updated my Novetta profile. That is what I’d call a “lowest bidder” interface.