Category Archives: VISIBILITY

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.

Dong Shin 05.03.2013

  • deployed new FA – few problems..
    • creating new Project results in SQL error fixed
      • INSERT INTO projects …. – Column count doesn’t match!
    • Sub Budget Center Name & Number not working correctly fixed
    • Un-Funded Amount = Req Amount – Funded (calculated, non-editable) – done
      • removed unfunded_amount from budget_centers table
    • Req Type should be non-addable in the combobox done
      • MIPR, REQ, EA, RTA, and EAO
    • Upload Data should delete row 1 and last two lines from the excel spreadsheet
  • built VSS and associated libs for more testing as we got weird errors on-site this morning

Phil 5.3.13

7:30 – 4:00 SR

  • Backups
  • Deployed new FA
  • Customer meeting. Dong has the list of bugs. Actually, things went pretty well. I think we’re on track for alpha deployment next week.
  • Test of DB upgrade on Integration?
    • Error saving a script. Line 589 in ScriptFacades.
  • Status Report for April
  • More Junit.

Dong Shin 05.02.2013

  • continue working on FA
    • obligations/outlays data updates with fiscal_year from budget_centers
    • getting View Financial Data to work with new database
      • updated Project Editor to keep appropriation in budget_centers table
      • updated Budget Information datagrid with new Req Data structure
  • burned a CD for deployment tomorrow