8:00 – 4:00

• Clear fluids today! Wheee!
• Deployed at the fort. Combined now ingests in a few seconds. Talked to Mike C about various issues. Tuns out that there was a bug in Mike’s code that generated spurious entries in the xml table.  The upshot is that we’ll wait to see how Anne likes the new data
• Talked to John W. He’s like a not from Brian about our burn rate and how it gets us through to October
• Working on Advanced Queries. Just realized that there is no equivalent for mySQL “discrete”. Goint to have to figure out a workaround. Not only that, but advanced queries can’t be the same as “normal” if this is the case. Hmmmm. Fixed by putting rows in a HashMap with their string values as the key

• Working on QueryInfoObject – finished the java side, mostly done on the flex side
• Started advanced tab in querybuilder – got to the point that A query is sent and the results come back and are visible in the debugger. For Monday, start transitioning over queryWidgets to use the google format and replace the whereClause code
• Talked to Anne for a while about the source for the combined.xml file. She’s going to talk to Mike C.

• Deployed data at the fort
• Started getting classification working. Managed to break the server (the jblocks jar is needed) so we punted for a while
• Lunch for Mike
• Working on getting the google API integrated
• Select Al button in Query builder is broken

• Deployed data at the fort
• There was a problem with the spreadsheet that we had uploaded. Fixed
• Got the google Visualzation data API working
• Walked Ines through how Vis2 works

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