Phil 2.23.2010

8:00 – 4:30

  • Had a meeting with Anne G – she’d like to write an (marketing-style) article about VISIBILITY. Also, she really likes the idea of slide shows. I’m thinking that these could be stored in the user’s profile XML?
  • Talked to Anita Komlodi about PhD program
  • 2:00 demo at Infotek
  • Breaking out some of Visibility. Utils and DBaccess? Basically the generalized stuff that can be used on other projects
  • Need to add some interfaces to Jython that are set by a properties file
    • Read data from somewhere (i.e. LDAT)
    • Create/Delete/Modify tables – will need some user protections
    • Add data to tables
    • Read from tables
    • Write XML to a named location

Phil 2.22.2010

8:00 – 4:00

  • Terrible traffic today in the neighborhood. Scohol is open on time again
  • Talked to Chris DeVito (Thom’s mom) about building a database that would indicate smuggling flows from documents in the public domain. She’s going to get us a point of contact
  • Demo this morning – need to put in some real (looking) data and re-demo soon
  • Back to Jython. Got some good interprocess communication going!
  • Got a return call from Anita Komlodi (410-455-3206) Hall back tomorrow at 9:30 re HCI PhD

Dong 02.22.2010

  • Alert interface working. Currently just update the timestamp for now. Actual email/scripting interface need to be added.
  • deployed the DBFormBuilder to laureldemo, but database doesn’t want to behaving; straight select sql does not work….
  • demo
  • fixed a bug failing to save the form inputs
  • cleaned up FormViewerCanvas to display data from FormViewerPanel (less code) instead of calling server for more data

Phil 2.19.2010

7:30 – 4:00

Phil 2.18.2010

7:30 – 4:00

  • So I go and deply the new VISIBILITY system and the group dashboards aren’t working. I come back, run the debugger, and find that the TableListNames is null. Turns out I commented it out yesterday when I was working on fixing the AccountsManager problem yesterday. Sigh. Burn a new disk.
  • Pinging Doug Yeager on his Groovy? remote object. Still looking at Jython for the time being.
  • Going to stick with Jython for the time being at any rate. Doug’s code is minimal on the (Non RemoteObject) Java side and doesn’t deal with host access in the ways that we (think?) we need to.

Dong 02.18.2010

  • adjusted query to return list of forms in FormViewer that the user has access to; owned and has user privileges
  • installed mediaWiki on laureldemo @ http://laureldemo.edge-technologies.com:8080/wiki/ – not sure if we want to use it….
  • found a project management tool; trac, it looks like what we wanted, but cannot get Python to behave with XAMPP on laureldemo. on hold.
  • added alert_status, alert_frequency, alert_last_run to forms table for Alert Management
  • FormAlertMgmtCanvas added to FormMgmtPanel

Phil 2.17.2010

7:00 – 4:30

  • Meeting with Duncan Witte this morning
  • Changed some of the S2F XML to reflect organizational changes
  • Uploaded the new Visibility code, but will deploy tomorrow
  • Adding role tracking to TrendWidget. If a role is not supported, auto update should be turned off
  • Need to look into Jython scripting support.
  • Found a bug that I had added when I had been messing with getAllUsers(). Fixed.
  • Burning a new disk

Dong 02.17.2010

  • FormUsersDG is now shared by FormUserMgmtCanvas and FormAddUsersCanvas
  • status field added to forms table to indicate published/unpublished
  • FormUserPanel changed to FormMgmtPanel to handle publish/unpublish of the forms addition to the form users management
  • all panels now are disposed upon logout
  • fixed a bug not creating user information when all the fields are not filled.
  • double click enabled for user updates on UserMgmtPanel – brings up Update User Information

Dong 02.16.2010

  • FormUsersMgmtCanvas and FormAddUsersCanvas added and quite functional.  add and delete users from form
  • added queries setter to DatabaseSQL.as to support for multiple inserts and others.
  • combined primary key is needed for proper insertion and deletion for forms_users table
    • CREATE TABLE IF NOT EXISTS `forms_users` (
      `forms_id` int(11) NOT NULL,
      `user` varchar(256) NOT NULL,
      PRIMARY KEY (`forms_id`,`user`)
      ) ENGINE=MyISAM DEFAULT CHARSET=armscii8;
    • this limits the duplicate records when using INSERT IGNORE, regular INSERT generates error when duplicates are found
  • created view; view_users, for easy query build
    • create view view_users as select db.user as ‘User ID’, full_name as Name, Description, email, contact_information as ‘Contact Info’,
      if (strcmp (grant_priv, ‘Y’), if (strcmp (create_priv, ‘Y’), ‘FORM USER’, ‘FORM OWNER’), ‘ADMIN’) AS ‘User Level’
      from mysql.db LEFT JOIN  mysql.user_info on (db.user = user_info.user) WHERE db=’formbuilder’
  • side-tracked to Visibilit 2 bug tracking…..
    • DatabaseIf.getTablesInfo (user) not working properly, removed and put UsersAndRoles.getUserTables()

Phil 2.16.2010

7:30 – 4:00

  • Swung by the fort. It’s still there and everything is working. Burn a disk and deploy tomorrow. Lots of changes – that should be *fun*
  • Meeting with Duncan Witte tomorrow at 0800. Jim Murphy also wants to come over to Edge to see what we’ve got.
  • Need to make sure that panels don’t load data that the user doesn’t have the role to see.
  • Discovered that the method that we were using for getting role hierarchy information, DbRemoteObjectgetMetaEntryList() was not returning tables that were under the user’s role hierarchy. Switching to UsersAndRoles.getUserTables().

Dong 02.15.2010

  • Presidents’ Day – working at home
  • added emptyField to DatabaseComboBox to set top of the ComboBox to blank
  • queries can now be saved to forms_query table from QueryBuilderPanel
  • clear button added to clean out all query building components (queryFields, queryTextArea, queryResultDG) from QueryBuilderPanel
  • separated TabNavigator from QueryViewPanel – DatabaseTabNavigator
  • QueryViewer is operational supporting basic SELECTs saved in form_query table
  • added owner (user id) field to forms table that is mapped to user logged in when a form is saved.
  • DBFormBuilder now has DATABASE_TO_INCLUDE and TABLES_TO_IGNORE to filter out unnecessary databases and tables from database tree views
  • started on FormUserPanel for form users management

Mike 2.12.10

Started work on a way to upload and manage custom map icons:

  • Created a new upload servlet similar to the file ingest one
  • This one also manages an index xml file which contains the filename and a title designated by the user
  • The index file will be required by the Flex component for loading the icon files

Dong 02.12.2010

  • cleaned up DataTypes.as
  • set default data type to VARCHAR in TableMgmtDG
  • separated all inline item renderers from TableMgmtDG and put in renderers directory
  • tested IngestManager with Phil’s new changes; seems to be working fine…
  • having weird problem with TableMgmtDG again….. It seems that the reloading of the same table wipes out the TextInput enable/disable control. Tried various things; cleaning out dataProvider, invalidateEVERYTHING. It looks like the DataGrid controls keeps haunting me. Ugh!
  • resolved the above problem by setting the enabled property explicitly by looking at the “VARCHAR” in data setter. The problem is that sizeEnabled = true in DataTypes in initialization and the ItemRenderer and DataGrid doesn’t want to create new components for the new data provider if there is existing components! It just replaces the data for existing components and creates new ones if new rows are needed.

Phil 2.12.2010

7:30 – 3:30

  • Tried to go to the Fort this morning, but traffic was *terrible* will swing by on the way home
  • Looking into why panels don’t show their graph properly when reloaded. Fixed, I think.
  • Having Dong test Ingest Manager after I removed about 500 lines from UsersAndRoles.java
  • More stuff with Dave Roche. I got his data uploaded and working. Added a “hexColor” magic word for maps
  • Need to make sure that panels don’t load data that the user doesn’t have the role to see.