Spent sometime configuring the new server

• blog installed and configured, but needs restore from Edge Blog
  • http://blogs.viz-n.com
• wiki installed and configured, but needs restore from Edge Wiki
  • http://wiki.viz-n.com
• uploaded Visibility3.war and deployed, not successful
  • need valid SSL keys and change endpoint configuration – http://127.0.0.1…..
• changed the tomcat server password, but would not take it or don’t know how to bounce the server….
• SVN up and running with SSH
  • SVN setup:
    port: 5868
    user: vizncomsvn
    password: 10sImw
    path: /home/vizncom/SVN
    access example: svn –username vizncomsvn checkout svn://viz-n.com:5868/test
• tried to restore SVN back up, but the server needs Pre-revision property change hook set up – waiting for resolution from hosthava.net

• create SQLPanel to run any SQLs
• added Date type to TableDataEditor
• blocked out from vis-n.com?
• looking into backing up all the data…
  • SVK to back up the SVN repository?
    • svk mirror <host> <local repo>- to set up
    • svk sync <local repo> – to back up
    • VisualSVN installed on laptop-13
      • dongshin created
  • Blog has its own back up/restore
  • Wiki??
  • hostjava.net – bkane@fgm.com
• SVN backup took 5 hours(!) thru VPN
  • http://devlicio.us/blogs/christopher_bennage/archive/2009/03/11/mirroring-subversion-from-windows.aspx

svnsync sync %dst_repo%
	--source-username buildserver --source-password 1234
	--sync-username user --sync-password 1234

svnsync init %dst_repo% %src_repo%
	--source-username buildserver --source-password 1234
	--sync-username sync_user --sync-password 1234

• Reworked Funding Data in ProjectViewer to show only the FY ranges
• Added toolTips to ProjectViewer
  • “Click to edit or enter new data” for editable cells
  • “Double Click to view Invoices Data” for the cell being edited
• Modified DataEditorPanel, DataEditorWindow, and DataEditorField
  • supports Add and Delete
  • primary keys can be string or int with auto_increment – Add requires string key format or auto_increment generate it automatically
  • may need set whole tableStructure to an Object instead of individual ones
  • added StringValidator to DataEditorField to ensure needed data is entered
• Added more validations to CreateProjectPanel

• invoice data integrated to the spreadsheet
  • view and edit invoices for existing data
  • new data needs at least one invoice
• CollapsiblePanel- seems very suitable..
  • http://lab.arc90.com/2008/03/17/collapsiblepanel
  • http://designingwebinterfaces.com/40-custom-flex-controls
• received Appropriation data (Obligations/Outlays Goals) and put in to database
• calculating Summary for funding data

• Continue going down the meeting notes
• Created Invoice table and added some data
• Created _projects_invoices tables for Project and Invoice relation
• Click/DoubleClick events conflict in Flex….
• Went over entire project to change static DBUserInfo
• Added more information to FormBuilderassetsdatauserinfo.xml to separate database access info

• Continue going down the list of the S14 meeting notes
  • all obligations/outlays added upon project creation.
  • spreadsheet shows up per year now – two sets for two year project
  • % value rows are added per $ rows – calculated….
  • highlight current month

• Created FloatItemRenderer and FloatFormatter to format the various currency used
• Deployed latest FormBuilder (as of 04/16) to Laureldemo – set edgeDemo as user
  • http://laureldemo.edge-technologies.com/FormBuilder/ProjectPortfolioMgr.html
• Going down the list of notes from the last S14 meeting
  • Meeting Notes
  • Project Funds, Budge Center Funds added
  • Funding Total automatically calculated

• Continue configuring XAMPP- done
  • Visibility not working!
  • Turned out the Tomcat for XAMPP uses Java 1.5
  • replaced jre directory with Java 1.6 and everything seemed well
• Testing XAMPP install package on laptop-13- done
  • http://laureldemo.edge-technologies.com:8080/wiki/index.php/XAMPP_Software_Package_Install for details
• added total_budget to budge_centers table, budget to _funding_requests_budget_centers table
• added FloatItemRenderer to display floats in currenty format (double precision) – need to do DG.validateNow()

• added Contracts data(table data) to Funding Request – allows users to view contracts data and add to the funding request
• Downloaded and configured XAMPP 1.7.3 with Tomcat server 6.0.20 add-on from http://www.apachefriends.org/en/xampp-windows.html
  • http://laureldemo.edge-technologies.com:8080/wiki/index.php/XAMPP_Install_%26_Configure
• dumped and copied databases for new XAMPP
  • formbuilder.sql
  • project_portfolio.sql
  • userinfo.sql
  • visibility_dev2.sql
  • users_and_roles.sql

• continue working on Funding Request editor
  • Save, Request, Send to BF34, Certify, Accept works (updates the status accordingly)
  • Date updates can now be saved
• working on Triggers to store data logs (SQL’s)

mysql> delimiter $$
mysql> CREATE TRIGGER Employee_Trigger
    -> AFTER UPDATE ON employee
    -> FOR EACH ROW
    -> BEGIN
    -> INSERT into Employee_log
    -> (user_id, description)VALUES (user(),
    -> CONCAT('Id with ',NEW.id,' is modified ',
    -> ' from ',OLD.start_date, ' to ', NEW.start_date));
    ->  END$$
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

• separated FundingRequestForm from the panel so it can be used as an editor for existing data
• working on FundingRequest editor

• added data navigation buttons (Prev and Next) and data record information (Record # of #) to TableDataViewerCanvas
• created TableDataSelectWindow to select specific data from a table – select Funding Request to view
• modified FundingRequestPanel to use TableDataSelectWindow to select contacts and managers
• TableDataSelectWindow supports optional Add/Remove data – enableAdd()

• funding_requests table created
• renamed all relation tables to start with “_”
• FundingRequestPanel form now working
  • all related data can be stored (contacts, budget center, etc)
• TableDataViewer canvas created to view single set of data from specified table
• FundingRequestViewer uses TableDataViewerCanvas to view the data
• Demo for LDAT folks at 2PM – seemed very interested in Visualization and Spreadsheet

• started working on putting Invoice information to the datagrid cell editor
• working on Funding Request
  • received scenario from Chris Blackard
  • got some clarification about the data
  • Funding Request form finished
  • created Contacts table and put some data in
  • attached Contact data to Funding Request form so the data can either be selected from database or manually entered
  • added budget center table (just name and description for now)
  • budget center can now be added from the Funding Request Form

• working on dynamic table form to support various types of forms..
• created testing app for forms
• created database utils to consolidate often used methods
  • database list
  • table list
  • database and table strucrue
• most of DataGrid, ComboBox, List, Form are done and tested