Category Archives: Projects

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.

Christine 12.23.2010

  • Making some progress on the MavenAssist / environment issue. Earlier, rather than running the archetype command through MavenAssist, I set up the project then ran the command via terminal. Project created successfully and I was then able to use MA to view the POM and use some of its other features.
  • Question: is there a problem with http://www.fgmdev.com:8081/ ? Couldn’t set the POM of the project. Received “Unable to set repository. Path = [http://www.fgmdev.com:8081/nexus/content/groups], name = [pulbic/] error = Connection refused”. Tried to access URL in browser and same thing.

Phil 12.23.2010

8:00 – 4:30 VISIBILITY

  • Spent some more time looking at firefox plugin development.After a long talk with Mike, tentatively decided that it was better to go with the DJ Project approach and build a Java wrapper. Spent the rest of the day finding the CVS repo, reading documentation and pondering.

Dong Shin 12.23.2010

  • upgraded Nexus Repo to 1.8.0.1, enabled security so that anonymous doesn’t have full auth anymore. It was also unstable going down without warning, will keep monitoring…
  • working on MySQLDataObject to extend DefaultDataObject

Dong shin 12.22.2010

  • display DB meta info in Tree format
  • created dynamic form based on table meta data
  • creating TableDataObject and TableColumnDataObject
  • <Row NAME=”test” SCHEMA_NAME=”test” TYPE=”DATABASE”>

    <Row DATABASE_NAME=”test” NAME=”doubletable” TYPE=”TABLE”>

    <Row COLUMN_DEFAULT=”” COLUMN_KEY=”” COLUMN_NAME=”value”

    COLUMN_TYPE=”double” DATABASE_NAME=”test” EXTRA=””

    NAME=”value” TYPE=”COLUMN”/>

    </Row>

Phil 12.22.2010

7:30 – 4:30 VISIBILITY

  • Tentatively scheduled my Spider training for Jan 5 at 11:30
  • Looks like you use the NET command to add users, etc using the command line. There are lots of options:
  • Once the user is created, then mkGroup -l > /etc/group and mkPasswd -l > /etc/passwd have to be run to make cygwin aware of the new users. Also, new home directories need to be made. Then the new user can telnet in and everything works fine.
  • Spent a good deal of time looking at making sure that whatever framework we used could support debugging client code. I think the the choice is reall between two options. Either the debugger (and some/all of the dev environment) browser, or the browser runs in the dev environement
    • Running inside the browser means something like Firebug. They have the flashbug plugin, and my guess is that it wouldn’t be too hard to put in additional pieces if we needed too.
    • The other option is to run the browser in the IDE. The DJ Project seems to ba a framework that would support this

Phil 12.21.2010

7:00 – 4:00 VISIBILITY

  • Now that the basics of the process-based interaction work, I’m going to make it a useful member of the program family instead of the unstable CPU hog it currently is.
    • Added sleep(10) to the processing loops and made everything work with buffered inputs and outputs. CPU usage is unnoticeable, and responsiveness feels the same.
    • Added watchers for the three threads so they all shut down when the user types “exit”
    • Can navigate around through the OS, run maven and other cool things 🙂
    • Cleaned up the user input so that it is split from the thread that watches the keyboard and the method that sends the command to the process.

On a side note, went out for a lunchtime ride and averaged 18.2, including the parking lot. A nice, summery pace on a day with a 37 degree high.

Christine 12.20.2010

  • Debugging flexbuilder mojos error I continue to receive when using MavenAssist.
  • Checked out FGMUtils and received Flex 4 SDK error. Working on figuring out why Flex plugin isn’t working properly in my environment

Dong Shin 12.20.2010

  • refactored DataObject project to DataManager project
  • imported Phil’s DataManager code to new DataManager project
  • added basic information interface to the DataManagerServer
    • getInfo – list of databases
    • getDbInfo – list of tables
    • getTableInfo – table structure
  • added support for Solr XML format