Category Archives: VISIBILITY

Dong Shin 01.07.2011

  • PPM changes
    • thinking of using tables’ comments field for editable/non-editable indicator
    • ALTER TABLE tablename COMMENT = 'editble';
    • fixed itemRenderer issue by setting icon at set data method, not at creationComplete method
    • changed all the tables to have InnoDB engine
    • backed up database to project_portfolio
    • set editable tables by ALTER TABLE <table name> COMMENT = ‘editable’;
      • budget_center_names (budget_centers)
      • budget_center_number (budget_centers)
      • capabilities (budget_centers)
      • expenditure_centers (budget_centers)
      • funding_transaction_names (budget_centers)
      • funding_transaction_numbers (budget_centers)
      • funding_transaction_types (budget_centers)
      • investment_portfolios (budget_centers)
      • users
    • setting relationiships for foreign keys in the database
      • projects and users done.
      • budget_centers related tables done (budget_center_names, budget_center_number, capabilities, expenditure_centers, funding_transaction_names, funding_transaction_numbers, funding_transaction_types, investment_portfolios)
    • added warning dialog – cancel closes the panel
    • added dataToolTips for the datagrid

Dong Shin 01.6.2011

  • PPM Enhancement
    • DB Mgmt
      • added icons for editable/non-editable tables in the tables list
      • added Record numbers text
      • Begin, Prev, Next, End buttons working
      • mx:Label for AdvancedDataGridItemRenderer is too slow for large sets of data?, tried to extend AdvancedDataGridItemRenderer. no success. changed Label to Text component, it’s a lot faster now
      • added toolTips
      • added Key information on the DataGrid column header

Phil 1.6.2011

7:30 – 4:30 VISIBILITY

  • Working on a simple “echo” Java GUI in SWT
  • Eclipse Labs on Google code: http://code.google.com/a/eclipselabs.org/hosting/
  • Talking to the servlet in the GUI. Switching from echo to implementing exec() in the servlet and getting the response into the GUI. For something that takes a while, like a maven build, I’ll need to do something to show progress. Also will need to handle error messages as separate entities in the message wrapper?
    • Cleaning up ExecShell() to make it work with the GUI.
    • Spent a good deal of time trying to figure out when to inform the client that the command was finished executing. Wound up looking for elements of the command prompt for now (this assumes “C:”). It’s working now. I expect I should be able to roll it in to the servlet tomorrow.
      • As an aside, it should be possible to send back intermediate data to the client, as long as the client sends a “send more output” request to the server with the same session id until the server is done.

Phil 1.5.2011

7:30 – 4:30 VISIBILITY

  • Rode the motorcycle in today – brr.
  • Working on making the binary communication classes useful.
  • Good link on how to hook up the eclipse debugger to a servlet running in tomcat: http://wikijava.org/wiki/Debugging_a_servlet_with_tomcat_and_Eclipse_tutorial
    • If you’re using the launcher in windows, add the following argument to your tomcat->config->java tab:
      • -Xrunjdwp:transport=dt_socket,address=8000,server=y,suspend=n
  • Sending wrapped serialized objects. The “toString” method for printing works as well.
  • Starting the client IDE. I’m thinking SWT, since we’ll probably raid Eclipse for components.
  • Connected to the Eclipse CVS repo

Phil 1.4.2011

7:30 – 4:00 VISIBILITY

  • Deployed the new PPM to rave reviews! Well, not really. But no one complained either 🙂
  • Lots of activity on VISIBILITY logs today
  • Had to bounce the fgmdev tomcat server. There was a service available problem.
  • Working on Data xfer
    • Binary data wasn’t getting to the servlet as a parameter. Testing Ascii data using POST. Yep, that works.
    • Found a better example for binary communication: http://www.j-nine.com/pubs/applet2servlet/Applet2Servlet.html
    • Binary is now working. Need to expand it out to a workable library.
    • Added logging to the doGet() method, so you can go to the servlet html and see what it’s doing

Dong Shin 01.04.2010

  • PPM Changes
    • fixed Save Confirmation – set flag to false before Query execution so that it forces state to saved
    • unable to duplicate Project Names disappearing from Create Project Panel….
    • dump current database schema and data to ProjPortfolioMgr server – webapp/scripts/project_portfolio_01042011.sql
    • copied project_portfolio database to project_portfolio_01042011
    • working on DBMgmtUtils….
  • forcing foreign key updates
    • ALTER TABLE table1 ADD
      CONSTRAINT fk_keyfield
      FOREIGN KEY(keyfield)
      REFERENCES table2(keyfield)
      ON DELETE REJECT
      ON UPDATE CASCADE

Dong Shin 01.03.2011

  • PPM Changes
    • fixed a bug not updating Summary Data for Year 2, 3, so on when editing Financial Data
    • added formatter for invoice amounts
      • InvoiceSelectWindow
      • InvoiceFormWindow
    • allow negative values for invoice amounts
      • red for negative amounts
    • bigger comments area for invoices
    • added comments indicator – number of comments and last updated (tooltip)

Phil 1.3.2011

7:30 – 4:00 VISIBILITY

Phil 12.30.2010

7:30 – 4:00 VISIBILITY

  • Imported Anne’s spreadsheet. One column had paragraph-length descriptions, which wouldn’t fit in the DB. Not sure if this needs to be fixed or not…
  • Working with Christie to see if her mavanized air app will compile and run on my machine. Close – It compiles but the air app does not install properly. Also an issue with getting the assets directory and its contents into the project
  • Got my sandbox applet up and running. Much easier when you know what you’re doing. Next step is to upload and download binary data.

Phil 12.29.2010

7:30 – 4:30 VISIBILITY

  • Meeting with Anne this morning. We were able to pull data (via excel) from the main database into visibility. Not too many steps either. She’s going to work on putting together a good example table or tables that will let us make a particularly nice set of visualizations
  • Dong and I have a meeting with Adam and Christie at 11:00 – 1:00
    • Summary section year one is summing properly but subsequent years are not.
    • Budgets can be for only one year
    • Explicit save for financial data entry. There may need to be some rolling backup (saving to the client?) that the user may restore from if there is a problem.
    • Show the date of the last comment in the add/view comments area
    • Add commas to the invoice number entry fields
    • make login test not case sensitive
    • need to be able to enter negative amounts for the invoices
    • project name disappears from modify project screen occasionally when returning from some other task
    • Bigger invoice list view to include comments
    • Automatically add a comment if a past value has been changed. Something to the effect 12.28.2020 – Phil Feldman changed November 2010 program actuals for line item xyz from $123 to $345
    • Admin capability to add/modify/delete/merge tables produced using “add new”. Default behavior could be to present a list of projects that use the tag, and have the admin fix each manually. There could also be a global replace button.
    • Add a Financial Status page that only lets HQ see and change project info. This panel mostly shows data from the Funding Requests, but also allows the user to change the funding request by editing fields in the table. To do this several fields need to be added to the Funding Request widget:
      • Reference number in FACTS in reimbursable section (possible uniqueness test?)
      • if certified date != null, put funding amount in initiate/comment
      • Add outlay entry to reimbursable and Direct Cite
      • Add contractor name and location to Direct Cite table
      • Column that subtracts outlays from obligations
      • Roles will need year ranges
      • Program Elements and FACTS PE add to budget line item
      • Remaining to distribute – Total budget minus distributions
      • A scan of Trish’s spreadsheet is here

foo

Dong Shin 12.29.10

  • PPM
    • copied PPM stuff for deployment at /exchange/PPM_122910
  • MavenAssist
    • modified CreateProject and UserSettings to use archetypeRepository
    • -DarchetypeRepository=http://repository.sonatype.org/content/groups/public
    • current version is 1.9.2.8
  • meeting with Trish and folks
    • lots of notes to come….
  • PPM Bugs
    • Summary not updating for year 2, 3, so on in Financial Data
    • Ability to create project with 1 year span
    • Save Confirmation pops up on Financial Data – not working properly
    • Add comments status indicator, possibly number of comments and/or last updated date
    • Add commas to invoice dollar amont
    • Update login not possible because it’s used as database key. Let users change it and use no case-sensitive joins for existing data?
    • Allow negative values for invoice amounts
    • Project Name in Create Project disappearing?
    • larger View Invoices Panel in Financial Data so that comments are visible
    • logs/alerts for changing previous months data
      • from <> to <> by user id?
    • add delete/modify capabilities to all tables that use single drop down list to add a string to projects, funding requests, etc.
  • PPM Enhancements to support Financial Statu Sheet
    • one to one relationship with project
    • most of the data comes from Project and Funding Requests
    • if Certified Data != null, Initiate/Commit needs to be filled
    • new fields in Project – added to the Budget Datagrid
      • Program Element
      • FACTS BE
    • new fields in Funding Request
      • Reference Number in Reimbursable Amount – uniqueness test/
      • Contractor Name and Location in Reimbursable Amount/Direct Cites
      • Outlay in Reimbursable and Direct Cites
    • PM Actual Outlay = obligation – outlay
    • Roles to support users to fall into FYs and Projects
    • Remaining to Distribute = total budget – distributions

Phil 12.28.2010

7:30 – 5:30 VISIBILITY

  • Meeting with Katie C. went well. I showed her the entire VISIBILITY suite, and she walked though what her group needs. She’s going to get together with her division chief and schedule a demo
  • Trish found a bug(?) with user data, where a phine number with an extension can’t be stored in the DB. Let Dong know about it.
  • Working my way through protocol buffers.
    • I have to say, this is getting complex. So far you need cygwin and the gcc compiler to *build* the protoc.exe compiler. Right now I’m running the config utility that is determining *how* it will make the executable….
    • And now I need make. Getting that. Done (Cygwin is pretty cool sometimes). Running.
    • Failed CommandLineInterfaceTest.WindowsOutputPath test. Seems to be that the checks don’t understand cygwin’s way of referencing the c drive (cd cygdrive/c as opposed to cd C:/). Reading the blogs, this appears to be tolerable. The install seems to work.
  • And before I go and try this, I’m going to look for some simpler binary transfer mechanism. This is OK if you’re Google, but I’d like something that doesn’t add complexity to an already complex concept.
  • Started building a war file for a test servlet project and ran into Christine’s problem. It turns out that when we’re adjusting the pom file after it’s creation but before eclipse:eclipse is run on it, the number for the flex-mojo plugin is coming from the flexVersion variable instead of the flexArchetype variable from the User Settings. Fixed that, and uploaded the new code into subversion.

Dong Shin 12.28.2010

  • working at home….
  • continue working on MySQLDataManager and MySQLDataObject
    • retrieves data in XML and add dynamic properties to each row (Object) of the data
    • dynamic object in DefaultDataObject may not be very usable…. need to change it to the properties of the Class itself
  • PPM Changes for adding phone extensions
    • DB changes
      • ALTER TABLE `users` ADD `unclass_phone_ext` VARCHAR( 4 ) NULL AFTER `unclass_phone`
      • ALTER TABLE `users` ADD `class_phone_ext` VARCHAR( 4 ) NULL AFTER `class_phone`
      • ALTER TABLE `funding_requests` CHANGE `financial_poc_phone` `financial_poc_phone` VARCHAR( 35 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL
      • ALTER TABLE `funding_requests` CHANGE `technical_poc_phone` `technical_poc_phone` VARCHAR( 35 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL
      • ALTER TABLE `funding_requests` CHANGE `nsa_poc_phone` `nsa_poc_phone` VARCHAR( 35 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL
    • Added extensions to AddUserForm
    • Add/Modify works
    • Added extensions to all contacts in Funding Request
    • Added extensions to SelectProjectWindow, ProjectMgmtPanel, ProjectViewerPanel sot that the extensions shown on Financial Data

Dong Shin 12.27.2010

  • helped Christine with Maven stuff
  • Nexus Maven Repo Server unstable?
    • 1.8 crashed after 20 mins.
    • back to 1.7 from 1.8, looks stable now….
  • Continue working on DataManager and DataObject
    • MySQLDataManager and MySQLDataObject extended from base class
    • base classes modified to support more variables/methods
    • testing DataManager and DataObject

Phil 12.27.2010

8:00 – 4:00 VISIBILITY

  • I hereby declare that this is the festival of Contractorious. It covers the time between Christmas and New Years at Government facilities
    • Monday – The Festival of Light Traffic: Here we revel in the ability to drive anywhere at any time, at or above the posted speed limit
    • Tuesday – The Celebration of Easy Parking: In which we park close enough to the buildings we work at so we do not freeze to death in our sojourn across the Parking Lots Most Remote
    • Wednesday – No Meeting Day: We would gather to celebrate this, but it might be misinterpreted as a meeting
    • Thursday – The Day of Just Showing Up: We celebrate by just making it in. Observing this by napping at the desk or by leaving early is acceptable.
  • Had some scary flashbacks to text flow containers. Did find a useful article: http://devgirl.wordpress.com/2010/04/26/flex-4-and-the-text-layout-framework/
  • Starting to try some test applications with the DJ_Project
    • SimpleWebBrowserExample – Too cool. Handles flash and everything
    • Walking through the code for this example.
    • Working on the HTML Editor example. I needed to go out and get the zip files for CKeditor, FCKeditor, and TinyMCE editors, and add then to the classpath so that the app could find and launch them. Not sure how it’s doing that yet. I’m gussing that it’s related to the same way that the browser is incorporated. Not sure that it matters for what we’ll be doing, which is more along the lines of raiding eclipse for components and then adding them in in a more direct (i.e. integrated to work with compiler/debugger output). We’ll see.
  • Last thing to check out is a way to communicate between the IDE and the Client. Aaron suggested that Google Protocol Buffers were cool, easy and fast. Looking into them now.