• checked in all the changes so far….
  • MySQLIf
  • ProjPortfolioMgrClient
  • ProjPortfolioMgrServer
• Going down the list from Phil
  • Saving user and Funding requests failed – fixed, added toSQLString method to add escape character for special characters; /, ‘, and “
  • “logged in as null” on banner fixed
  • There should be a way of creating a new project from an existing one (only the FY changes in many cases) – added Create New from…
  • We will need to delete items that have been added in. How? As administrator? TBD
  • For comboboxes and select buttons, include “Add” feature
  • General Notes:
    • Add Users
      • All fields should be blank
      • No ‘Phone’. Just ‘Classified Phone’ and “Unclassified Phone’
      • No ‘Classified Email’
      • New names for roles (should be common across all panels)
        • ‘Portfolio Manager (NSA)’ [NSA POC from funding]
        • ‘Service Project Manager (site)’ [Technical POC from funding]
        • ‘Finance Analyst (NSA)’ [Funding Mgr from funding]
        • ‘Service Finance POC (site)’ [Financial POC from funding]
    • Create Project
      • Does start FY have a validator for bad years (i.e 200001)? This could be a dropdown from current year -4 to current year + 4?
      • Year columns in grid should be based off of the Start FY
      • Make roles in project creation the same as those in “Add User’, above
      • ‘VFR’ should be ‘UFR’
      • ‘Appropriation’ should be a combobox
      • ‘Add Budget’ dialog should have the following fields:
        • Budget Center Number (validate for uniqueness)
        • Budget Center Name(validate for uniqueness)
        • Capability (Addable list)
        • Expenditure Center (Addable list)
        • Investment Portfolio (Addable list)
    • Add Funding
      • Populate information in funding request from project info: (project name, project number, budget center and budget
      • Move save button to lower right
      • Eliminate capability field, since it’s linked to budget center
      • Portfolio manager field can be deleted. It’s the NSA POC (which should be ‘Portfolio Manager (NSA)’)

• working from home
• changing CollapsiblePanels of FinancialDataSetCanvas to DynamicPanels and putting it in ManagedCanvas… done
  • start with minimized – hitting some performance snags on Maximize.. disabled for now
  • disallow – Maximize, Close
• Disabled future date selection on Invoice Date Entries – only past dates and today are allowed
• Invoice Form and Datagrid switched – Form on top, Datagrid on bottom
• only PM Actuals row can enter invoice data on Financial Data
• uploaded ProjPortfolioMgr.052810.zip to http://downloads.viz-n.com

• foreign key and delete constraint added on fundings table to obligations_outlays table so all the related financial data gets deleted when a funding is deleted
• fixed a bug not showing Appropration Text on Create Project Panel
• added appropriate title for SelectProjectWindow
• add/remove Budget Center (Fundings) working
  • few bugs found and fixed….
  • removed add/remove buttons from Project Viewer
  • Only ModifyProject can add/remove funding
  • added few validators – check for duplicate Budget Centers, empty list
• changed HAccordion to TabNavigator for FinancialDataSet
• Alert formular changed to less than previous month, skip NULL values
• fixed a bug highlighting wrong column for current month in Financial Data Viewer
• Summary Data uses FinancialSummaryDataDGItemRenderer so that only Goals are highlighted
• fixed Summary Data when $ value is 0, nothing is shown

• replaced main canvas with EdgeUtil’s ManagedCanvas
  • panel.minimizePanel () not working??
  • ManagedCanvas.setLayoutManagerIndex (n) is required!!!
• added runSQLArr to ProjPortfolioMgrServer
  • allows multiple SQLs in one connection, merge all the results if any
  • MySQLIf.swc changed accordingly (executeSQLArr method added), installed, deployed
• Feedbacks from JM
  • Modify Project title added to select project
  • Project Delete button added and works
    • moved Obligations Outlays Goals to separate table
    • created foreign key constraints for fundings and obligations_outlays tables
  • Added additional fields to Create Project Panel
    • Project Mgr, Project Admin, Portfolio Mgr, Portfolio Admin
• setting autocommt to false caused all kinds of SQL failures…..

• funding combobox finally working – using events to set the label because ItemEditor gets destroyed before update
• added Project ID (project_number in the database)
• enabled Proj Portfolio Manager CB in Create Project Panel
• Project ID and Title shown on Financial Data Input Panel (Project Viewer)
• hide debug panels (Local and Server)
• Project Fundings can now be removed and added on Project Editor
• ProjectPortfolioMgr.swf.zip uploaded to http://downloads.viz-n.com
• remove Funding Request from menu
• Funding Request can be generated from Project Editor

• going through the list of changes from JM’s feedback
• allow ‘.’ in login field
• changed the second password label, Confirm Password
• removed full name
• removed email
• removed xml
• removed contact info
• ADD User refreshes Manage User panel
• Modify Project edits data
• Enter Financial Data shows Project Viewer
• moved the New Funding to top of the ComboBox- not behaving well….

To Do

• Add project ID
• Finish Edit Project

• viz-n.com is awfully slow. Tried to restart Tomcat several times. It throws exceptions….
  • remove old logs and restarted…. nothing obvious
  • seems ok now @ 8:53AM.
• Server and Local Logs visible, moved around to make Login Panel visible
• cleaning up codes

• fixed some bugs found on fresh install
  • appropriations not loading at Create Project
  • Initial Data for Goals in Obligations/Outlays data
• Reworked installation document for simpler install
• moved Local and Server Logs to separate menu item
• working off Phil’s list – done
  • Review funding request: status: status: false
    sqlStr: SELECT * FROM null.funding_requests ORDER BY uid LIMIT 0, 100
    statusString: Error occurred during runSQL()
    errorString:
    exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user ‘projportfolio’@’localhost’ for table ‘funding_requests’
    data:
  • Comment out all non-running menu selections
  • Comment out “Project Manager”
  • Comment out Alerts
  • “Project Builder” -> “Modify Project”
  • Move “Contract” Menu heading to “Manage Contracts” under Projects
  • Fix “Close” behaviors on “Create New User”
  • Comment out User Search
  • Add Help menu with “documentation” and “tutorial” pointers
• new ProjPortfolioMgr.zip uploaded to http://downloads.viz-n.com

• added scriptFile and createUser options to SQLScriptRunner.properties to specify script file to run and create user
• created README and walked through with Phil, too complicated. need a simpler
• tried to install on viz-n.com, not success. Takes down Tomcat when deployed…..
• changed the way MySQL Connection sets up, server handles it now from properties file instead of client sending it up.
• Create Project calculates total automatically now

• user registration (NEW_USER) and password changing now functional
• disabled unnecessary menu items
• old CreateNewProjectPanel replaced with CreateProjectWindow
• fixed an IngestManager bug – special characters in column names
• moved to SQLScriptRunner to ProjPortfolioMgr
  • works like bootstrap – load database when database is not present
  • create user
  • more testing and configure needed

• SQLScriptRunner can view contents of the selected script file
• Database Login ID and password added to SQLScriptRunner client
• login added to SQLScriptRunner client
• created database, vizncom_projport
• create database user, vizncom_demo/demo
• tried to deploy SQLScriptRunner to viz-n.com; script runs, but Server Log generated errors
  • [ERROR] Mon May 17 2010 07:50:17 AM com.edgeti.EdgeUtils::BlazeServerLog.faultHandler():40
    faultCode:Client.Error.MessageSend faultString:’Send failed’ faultDetail:’Channel.Security.Error error Error #2048: Security sandbox violation: http://www.viz-n.com/SQLScriptRunner/SQLScriptRunner.swf cannot load data from http://localhost/SQLScriptRunner/messagebroker/amf. url: ‘http://localhost/SQLScriptRunner/messagebroker/amf”
  • modified assets/setupModel.xml

• Server Loggging works
  • log4j.properties, remoting-config.xml needed to be corrected
  • using com.fgm.javaUtils.logging.VisibilityLogger for LogRemoteObject, not sure if separate ones are needed for separate servlets.
• Dump three sql files from project_portfolio and added to scripts directory
  • project_portfolio_clean.sql for clean install
  • project_portfolio_inserts.sql for updating data
  • project_portfolio_update.sql for updating structure and data

• created SQLScriptRunnerServer project
• creates SQLScriptRunnerClient project
• deployed SQLScriptRunnerServer, but didn’t behave…
  • found commons* jar files are required
• SQL Script runs from remote object call!
• Visibility Logging not working properly – http instead of https?

• working from home
• reinstalled the Flex Builder plugin for Eclipse Galileo
  • links/com.adobe.flexbuilder.feature.core.link file is missing “path=” at the beginning of the line!
• exported com.edgeti.Uilts package from Visibility2 to com.fgm.ServletUtils
  • need log4j and other stuff
  • deployed to viz-n.com
  • http://www.viz-n.com/nexus/contentrepositories/releases/com/fgm/ServletUtils/ServletUtils/1.0/ServletUtils-1.0.jar
  • imported for SQLScriptRunner project – seems ok….
  • found out Phil already converted it…
• SQLScriptRunner runs as java app, converting it to Servlet
• Troubleshooting Servlet crashing hard with Tomcat…..
  • turned out web.xml had duplicate lines
  • fixed and deploys good now
  • logs/SQLScriptRunner.log visible
  • on to actual interface implementation!

• refresh () in onCreateComplete in FinancialDataCanvas causing the data view update twice…. Fixed now and it’s lot faster.
• Changed FinancialDataDGItemRenderer to highlight the current month’s $ cells only. Removed whole column highlight
• highlight the cells that fails the criterias
  • less than 90% of next cell
  • no in previous cell
• cells with comments generate red borders?