8:00 – 4:30

• Had a long discussion with Mike about form input and building a more customized query.
• Thinking about making the query like what Lance and I were pondering on TUMMS – a Google-style interface(http://code.google.com/apis/base/docs/2.0/query-lang-spec.html)
  • a blank line would return all values in a table
  • the full or partial name of a column would return the values for the column (i.e. “bar” would return all the values of column “bar”, while “ba*” would return all the values for “bar” and “baz”.
  • the default search term (and the default) is “columns:”, which means return onlyt the values specified. The other option is “row”, which means to return all columns where the specified constraints are met. (“rows: foo[10]” would return all entries where the value for the columns “foo” is 10)
  • Brackets would constrain searches ( ba* [1..10] would return all entries of bar and baz that lie between 1 and 10 inclusive, while animals[kittens, puppies, ponies] would constrain the search to only those animals listed)
  • Searches could be combined so that ba*[1..10], date[1/1/1990..1/1/2000] would return all the values for bar and baz that are between 1 and 10 and were collected within the specified dates
  • The NOT operator “!” can be used to keep something from being returned (“rows: !ba*” will return the contents of the table without “bar” or “baz”, while “columns: !foo[10]” will return all vaues of foo that are not 10)
• Looks like there is a java API that supports this: (http://code.google.com/apis/visualization/documentation/dev/dsl_intro.html). Also, there is a nice video overview here: http://code.google.com/apis/visualization. It’s not quite what’s specified above, but it’s close, and it’s got MySQL support. Going to look more deeply tomorrow.
• Another useful link on same: http://ouseful.wordpress.com/2009/05/18/using-google-spreadsheets-as-a-databace-with-the-google-visualisation-api-query-language/

7:00 – 4:30

• Deployed new VIS2 at fort. Problems with screenshots and excel export
• Went over next two week schedule with Dong and Mike
• Proposal work for VIS2 next phase

7:00 -3:00

• Meeting at the fort this morning with John and Anne. Basically to discuss what it would take to put together schedule and cost for finishing VIS2 and also doing form input
• Got roles working in ManagementUtils
• Built a method for Dong to get whether one role is above or below another
• Worked with Mike to get the Excel exporter working
• Burned disks for tomorrow’s deploy attempt.

8:00 – 4:00

• Making role addition work when there are no roles to attach to. Done
• Need to upload new role tree. Which means I need a RoleInfoObject – Done
• Meeting tomorrow with John Williams

6:30 – 1:30 (3:30 actual, but with 2 hr lunchtime appt)

• Deployed this morning. The scheduled task didn’t occur – windows (sigh). Also made the _wtfPanel invisible.
• Working on getting role panel up and running. Role loading and tree manipulation are done. Need to upload the results. Also, maybe add an xml ingester to save work?
• Doctor’s appt. today at noon.

7:30 – 4:30

• Deployed, but had a tough time doing so. It looks like the exception handling in the Flex logger that Mike wrote is making the code go off and hang – not sure where. After we realized that, everything went reasonably smoothly.
• Changed the ManagementUtilsTest to be menu driven
• Need to add role configuration and login screen (with backdoor, for original install)

7:30 -4:30

• Deployed and talked to Mike C about rosterbillet for a while
• Working on dashboard management – done
• Need to add a create and delete table control – done
• Need to add a roll management panel too.

9:00 -5:00

• Building dashboard tree. Currently it will be by name, but we’ll probably have to include data sources later
• Need to write up geico thoughts

7:30 – 3:30

• Meeting with Anne, John, Mike C, Brian and I re: data entry of HR info in new and improved ways. As a side note, MC and I discussed building a rosterbillet.xml file to see how that would work.
• Meged with the current tree. Lots of hand waving. For example, the remoting-config.xml file did not update properly, and we had a hellofa time with updating until we had deleted all the target files.
• Going to start on a having UsersAndRoles returning a tree of dashboards

7:30 – 4:00
•    Need to update the creation of the _userCollection to reflect active roles. Should be able to use the userInfoObject’s list of role IDs and match to the role info that’s stored in the FlexTreeObject data object. Done!
•    Send status to Brian – done
•    Talked with Dong about roles, data, users and bridging tables.
•    Need to handle add, delete, and modify users.
•    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`users_and_roles`.`table_role_user`, CONSTRAINT `table_role_user_delete_user` FOREIGN KEY (`user`) REFERENCES `table_users` (`id`) ON DELETE CASCADE – I think this was because I was using user id=999 ad a default. Fixed now.
•    AddUser now works. Need to handle updateUser

7:30 – 4:00

• Need to update the creation of the _userCollection to reflect active roles. Should be able to use the userInfoObject’s list of role IDs and match to the role info that’s stored in the FlexTreeObject data object. Done!
• Send status to Brian – done
• Talked with Dong about roles, data, users and bridging tables.
• Need to handle add, delete, and modify users.
• com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`users_and_roles`.`table_role_user`, CONSTRAINT `table_role_user_delete_user` FOREIGN KEY (`user`) REFERENCES `table_users` (`id`) ON DELETE CASCADE – I think this was because I was using user id=999 ad a default. Fixed now.
• AddUser now works. Need to handle updateUser

7:30 – 5:00

• Deployed over at the Fort
• Had a talk with Mike C about data dictionaries and the like
• Wrote up a more detailed schedule (more of a task list, really) for Anne.
• Wrote up a weekly status for John Williams
• Worked on getting roles for users showing up as trees. Based on the earlier discussion with Mike C, role hierarchies are going to be large and mutable. We’ll need to be able to add nodes, remove nodes, move nodes around and change their names. Without changing the id number, which would invalidate all the user/roles and data/roles that we will have set up
• Got UserInfoObjects built on the Java side and coming over to Flex. Now I need to update the creation of the _userCollection to reflect this. With luck, I can use the ArrayCollection directly

8:00 – 4:30

• Deployed data at Fort
• Sent our edge tasking spreadsheet to Ann and John, and injested it
• Had a bitch of a time getting the new Flex code stuck under maven
• Reworking the data objects so that they have listeners for when data chnges. Listeners provide a callback function when data is changed. This way, each data object can be pretty well self contained.

7:00 – 4:30

• Went to a very quet fort and delpoyed new roster data. They are still working on geting permissions set up right on the server box. Did verify that teh server has java 1.6
• Let’s see if we can get all the pieces of visibility2 working today! Yep. Wheeee!
• You can now click on a chart portion and get a new chart.
• Need to add a way of loading dashboards