Monthly Archives: February 2010

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.

Phil 2.11.2010

3:00 – 4:00

  • Worked with Dave Roche on getting a VISIBILITY compatable spreadshhet. Got it. Need to fix a few things and read in tomorrow
  • Talked to Dong about a flex problem he was having

Phil 2.10.2010

9:00 – 5:00

  • Remarkably, it’s snowing again. So work will be interspersed with shoveling. Sort of the lunchtime ride
  • Spent about ½ hour getting everything set up, but everything seems to be working now. Note: don’t deploy! The edge repo is not visible! Seeing if Mike can help with the VPN.
  • Now that group load is working, going to work on group save
  • Got the saved group dashboards showing. Need to know which context – group or individual- is selected so that the appropriate save can be made (addDashboard() vs. addGroupDashboard(). Done!
  • Look through load to make the decision on which chart to display based on strings? There is a lot more going on with QueryWidgets and TrendWidgets. This may be a better thing for Mike to take a look at?
  • Need to make sure that user roles are used when getting the data from a table. It’s possible with saved dashboards to get at information that you shouldn’t see.

Dong 02.11.2010

  • Spent some time trouble shooting TableMgmtDG’s ComboBox item renderer; turned out, overriding of data setter and IList(DataGrid(owner).dataProvider).itemUpdated(this.selectedIndex) are required to properly update the datagrid’s all components (item renderers).
  • Fixed a bug not updating table structrures
  • Enabled the changing of existing table structure, but decided to leave it for later

Dong 02.10.2010

  • validator for date and time format on DataEditorField using 2009-08-24 13:01:36.0 format returned from MySQL
  • rework CreateTableCanvas and ManageTableCanvas for new layout and added icons
  • added uid for CreateTableCanvas, but decided to make it invisible for both creation and modification
  • trouble shooting the TableMgmtDG not working correctly; whenever data type changes, cannot get the size to update correctly.

Dong 02.09.2010

  • basic layout and navigation of data finished on DataEditorWindow
  • added _queryStr to DatabaseList to refresh the data with stored query
  • DataEditor can now store edited data; varchar and int working

Phil 2.9.2010

11:00 – 4:00

  • Spent the morning shoveling my folks out.
  • Infotek meeting was canceled. May reschedule or try as a phone call.
  • Working on Group Save/Load. Load is done. Save next.

Dong 02.08.2010

  • cleaned up in DBFormBuilder and other panels to use default width and height of 100%
  • fixed datagrid displaying the columns in wrong order by pre-setting the column headers
  • need to figure out how to set column header for DatabaseList
  • basic layout and navigation of data complete for DataEditorPanel
  • started on DataEditorWindow

Phil 2.8.2010

11:00 – 3:30

  • Snowpocalypse. Not easy getting in today.
  • Rolling in Mike’s changes – all the changes work, though we lost which chart is being shown on the load dashboard. Need to look at that
  • Deployed to Laureldemo and burned a disk for S2F
  • Back to group dashboards – nearly have the group dashboard pull working. After that, I need to be able to do the save, which is going to need to use the pull for the categories.
  • Removed some duplicate code. Dong and I are kind of stepping on each others work %-b
  • Helped Mike with maps. He’s up and running now.