Author Archives: pgfeldman

Phil 6.28.2010

7:30 – 4:00 VISIBILITY

  • Sent Trish a note to reschedule meeting from Friday to Thursday. After getting to the office, it looks as though the meeting was already scheduled for Thursday 0900.
  • Went over the change requests with Dong
  • Chasing the bug that clears out the interval_minutes when scripts are run manually. It looks like the issue is when a script is updated, interval minutes is blown away. Fixed.
  • Was looking at Mike’s changes to the network widget, and made the suggestion that rather than selecting single lines in the table, that we use the name field (either in the chart or the selected line on the grid) to create a query that preserves the networking information, along the lines of:
    • select `Name`, `souRce`, `targeT`, `icon`, `text` where (Name = ‘Jason’ or souRce = ‘Jason’ or targeT = ‘Jason’) or (Name = ‘Mary’ or souRce = ‘Mary’ or targeT = ‘Mary’) or (Name = ‘Mark’ or souRce = ‘Mark’ or targeT = ‘Mark’)
    • This gets us away from having to deal with the uid as the means by which we determine what rows we’re getting and allows for a network-based drilldown into the data.
    • Maybe this means that instead of having the query be added to the data page, that we build the query in the network view using a “new widget” button like for the other charts.
  • Pulling slideshow off into its own SWC. I’m pulling a lot out of vis2, so if anyone does any work in there, please let me know!
    • Having huge memory leak problems compiling the app now that I’m including the slideshow library.  Compiles fine with maven.
    • Interestingly, the swc compiled using maven is 2781kb, while the flexbuilder version is 2783 kb.

Need to order

Phil 6.25.2010

8:00 – 4:00 VISIBILITY

  • Discovered that running a script manually clears the autorun table. Need to fix that.
  • Meeting with Anne about potential work.
  • Meeting with Trish about PPM. Notes follow:
    • User registration (at login) needs all the new fields (email, address, etc). Also, fix scroll bars
    • Unable to add user from “register” screen. SqlException: Column count doesn’t match value count at row 1. I have a printout of the error
    • After playing with the above, and then loggin in as “projportfolio”, the “create project” panel did not come up when the menu selection was made.
    • Need to add a warning “Are you sure that you want to close this project without saving”
    • Funding Request
      • In “Add Funding” basic panel, make all the fields editable. The form may be sent to people who are not in the system
      • Closing and selecting dropdowns in the details view causes the panel to change back to the “basic” (Note: This happened on Trish’s machine, but not my FGM laptop)
      • Finance Data
        • Funding request should not close when saved
        • Can delete the Certify and Accept buttons.
        • Alert the user if the various amounts do not equal the “Funding Amount” from the “Funding Request Details” tab.
        • Acceptance date should be moved to after Document Number
        • Direct Cite can have multiple entries. Rewrite so that it more resembles the line item grid from Project Creation
        • Obligation amount is lost on the reload
    • Financial Data
      • Where are goals edited?
      • The maximize button has to be clicked twice to get the first maximize to work
      • “Obligation Goals” should be “Obligation Goal %”, also add % in data, just like other rows.
      • Add Contract info to financial data forms (not sure if this can be guessed at based on other project data entered or not. This data can then be shown in the “Manage Contract” grid.
        • Contractor/Vendor:
        • Contract Number / Amount:
        • Contract Type:
        • Period of Performance:
        • New or existing Contract:

FP notes:

Dong Shin 06.25.2010

  • working at home
  • changed FinancialDataCanvas( ManagedCanvas to VBox) and  FinancialDataSetCanvas (SaveStatePanel to CollapsiblePanel), it looks more manageable and doesn’t crash….
  • couldn’t duplicate the chart crash

Viz-n ssh

  • ssh connections to viz-n now require a public key.
  • The key file doesn’t work with cygwin but does work with Putty.
  • Using Putty type viz-n.com port 1033 and switch it to SSH in the session settings.
  • Under Connection->SSH->Auth add the private key file. (This can be found in the downloads folder on the ftp server)
  • Open it and log in as vizncom.
  • To restart the tomcat cd /appservers/apache-tomcat-6.0.26/bin and run ./shutdown.sh wait a few seconds and then run ./startup.sh
  • If tomcat crashes this should fix it.

Dong Shin 06.24.2010

  • adjusted validators in Funding Request – custom components needed for currency?
  • packaged up PPM and reviewed with Phil
  • changed BackGround color on CreateProject and FundingRequest
  • added emails tab to Funding Request – active only when request is sent to BF
  • fixed some SQL bugs (not allowing spaces for FUNCTIONS)
  • uploaded the latest PPM to viz-n.com

Phil 6.24.2010

7:30 – 2:00 VISIBILITY

  • Tried to VPN over to the WPAFB server. The VPN seems to work, but I couldn’t connect to the site.
  • Trying to set up meetings for Friday
    • Talked to Anne.
  • The querylog script had stopped running on the 16th, for some reason. Which is odd because the details pull scripts were running just fine. Anyway, put the querylog script back in the queue. It seems to be running fine now.
  • Need to walk through PPM with Dong today and burn a disk – done.
  • Need to see what problem Tom is having with getting the Scripting Server running on viz-n – fixed
  • Updating Visibility and Scripting on viz-n
  • Burned new copies of PPM and VISIBILITY to deploy tomorrow.

2:30 – FP

  • Mounted the wrist motor

Deploying to Viz-n.com

Before doing this create a vizncom_PrjPortMgr and vizncom_Visibility database using the control panel found here:  http://whm11.hostjava.net:2082/frontend/x3/index.html.

ProjPortfolioMgr:

  • Edit ./assets/setupModel.xml so that each address starts with http://www.viz-n.com.  Change the endpoint to look for messagebroker/amf instead of amfsecure.
  • Edit the database name in ./assets/data/userinfo.xml to match the database you are using.  In this case vizncom_PrjPortMgr
  • Edit the database, user, password, scriptDir in ./WEB-INF/classes/SQLScriptRunner.properties.  In this case database = vizncom_PrjPortMgr, user = vizncom_root,  password = edge, and scriptdir=/home/vizncom/appservers/apache-tomcat-6.0.26/webapps/ProjPortfolioMgr/scripts.
  • Edit the database, user, and password in ./WEB-INF/classes/MySQLIf.properties.  Same as in SQLScriptRunner.
  • Zip up folder and rename to .war.  FTP into viz-n.com and drop the war file into /appservers/apache-tomcat-6.0.26/webapps
  • Because the database is already set up the script needs to be edited so it doesn’t try to create a database.  Remove these two lines from project_portfolio_complete.xml in ./scripts

CREATE DATABASE `project_portfolio` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `project_portfolio`;

  • I was not able to get the script to run automatically so I imported it using the phpMyAdmin from the control panel.
  • Go to http://www.viz-n.com/ProjPortfolioMgr/ to test.  Default user/password is projportfolio.

Visibility:

  • Edit ./assets/setupModel.xml so that all the addresses start with http://www.viz-n.com.  Switch endpoint to look for amf instead of amfsecure
  • Edit the upload/download directories, database, user, and password in the ./WEB-INF/classes/visibility.properties.  Example:

fileuploader.uploadDirectory=/home/vizncom/appservers/apache-tomcat-6.0.26/webapps/Visibility3/uploads/
excelexport.downloadDirectory=C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/Visibility3/downloads/
database.database=vizncom_Visibility
database.user=vizncom_root
database.password=edge

VisibilityScriptingServer:

  • This one doesn’t seem to be working correctly yet.

Dong Shin 06.23.2010

  • packaging up PPM for demo
  • found that JDBC doesn’t support CREATE TRIGGER!!! — removed the trigger from the script
  • added auto insert of Goals when new appropriation is added
  • rearranged Funding Request components

Mike 6.23.2010

  • Added slide in / slide out controls to the network widget
  • Tried adding a scale option to the network map… it took awhile to get every container, mask and forces to behave correctly and finally once it was working changing scale really didn’t have a great effect.  Small scale changes could kind of make things more visible but anything more than a little would slam nodes against the walls and create weird behavior so I tore it all back out.

Phil 6.23.2010

8:00 – 11:00 VISIBILITY

  • Swung by the customer site. Answered some questions for Anne
  • Upgraded our mysql-connector to version 5.1.12. Updated the javaUtils and Visibility2 projects.
  • Walked through some PPM with Dong

11:00 – 5:30FP

  • Got the servo assy moving for one finger. Need to finish the other and then put the heim joints in.
    • Assembled the second finger
  • Mounted the two high-torque motors
  • Need to move the strain gauge assy. rearward of the stepper motor attachment points – done

Dong Shin 06.22.2010

  • added additional fields for Funding Request and rearranged components
  • removed Validate button, let Save button handle the validation
  • fixed Project Viewer un-maximizing after data entry/update
  • created a trigger to populate obligations_outlays_goals when appropriation is added
  • created a delete cascade for obligations_outlays_goals when appropriation is deleted

Phil 6.22.2010

7:30 – 10:30 – VISIBILITY

  • Swung by customer site. All is well. Chatted with JW about dogs
  • Talked to Dong about the BF form
  • Thinking about upcoming tasks for S2F
    • Sharepoint integration
    • “Sailor” interface (slideshow and dashboards – view only)
    • Formbuilder
    • …?

10:30 – 5:00 FP

  • Ordered additional motor and controller ($196.60 CAD)
  • Going to try to put the gripper together today.
  • Made a “wrist” joint
  • Made the components for the finger KF. Assembled one.

Mike 6.21.2010

  • Completed the “Query Selected” feature on the data tab of the AdvancedQueryWidget.  This is a new option in the dropdown menu
  • Tested that it works on single and multiple items as well as chaining widgets in various orders [ie. select * to select * where salary = 100,000 to select * where salary = 100,000 and (uid = 6 or uid = 7)].  Seems to work in every situation

Phil 6.21.2010

8:00 – 2:00 VISIBILITY

  • Deployed Dong’s new swf, which did fix the financial load problem!
  • Demo’d to Trish, notes are below. Next demo is Friday afternoon
    • Project
      • Save Project Error
        • Code: Server Processing
        • Message Out of bounds Exception – Index 9, size 9
      • Services are not getting checked when project is loaded
      • Add “other” service check box with an Addable dropdown to list of services
      • Change DHS to USCG
    • Funding Request
      • Combine valuation and save. They really don’t need to be different buttons
      • Save funding req gives out of bounds error
      • Change all “BF 34” to “BF 5”
      • BF panel should have the following fields
        • Acceptance Date
        • Submit Date
        • Certified Date
        • Document Number
        • Reimbursable (Tab? Grouping?)
          • Amount
        • Direct Cite (Tab? Grouping?)
          • Obligation Amount
          • Obligation Date
          • Contract #
          • Contract Date
    • Enter Financial Data
      • “Planned Obligation” is blanked when saving data on other lines and window automatically un-maximizes
      • Percentages are not being calculated on some charts. THes seems to be the case when Goals are not showing
      • Un-maximize seems to happen on saves of data
    • Next meeting is Friday afternoon, time is TBD

2:00 – 4:00 – FP

  • Working on framework

Dong Shin 06.21.2010

  • experimented SaveStatePanel and ManagedCanvas with some datagrids to trouble-shoot maximize problem… nothing found
  • added Utils.checkResolution
  • fixed a  bug not showing Services correctly for saved projects
  • other with AddableListComboBox for services added
  • fixed IndexOutOfBound exception bug
  • corrected Save Button label for Copy Project’
  • changed DHS to USCG