7:30 – 4:00

• Updated data
• Discovered a bug with Uploader.java – it’s including the path as well as the filename when storing data in the upload directory
• Had some problems ingesting Anne’s new spreadsheet – columns with “-” and ” ‘ ” made mySQL choke without a good message to the user – had to go through the server log
• I showed Arron what was going on, and he has two suggestions:
  • Diff the code that we have now with code from early August and see what the difference is. It might be something obvious.
  • Change the connect() and disconnect() methods so that they re-use the connection if it exists. Add a terminate() method that calls connect() and then closses the connection at the end of the remote object call.
• Turns out that some browsers may store the entire path in the item name. Added some checks and am testing with Firefox, IE, and Opera
• Burned a new copy of VIS2
• Installed at the fort. Igestors now work! THe last remaining problem is that the auto ingestors need to work as a SYSTEM service

8:00 – 4:00

• set pom so the output war is now called Visibility3.war – done
• Change the VISIBILITY_DEPLOY variable in FlexBuilder preferences->General->Workspace->LinkedResources to point to Visibility3 – done
• Change the VISIBILITY_SERVER_SERVICES variable in FlexBuilder preferences->General->Workspace->LinkedResources to point to Visibility3 – done
• Set the AccountManagers->Preferences->Root URL to Visibility3 – done
• Set the IngestManager->Preferences->Root URL to Visibility3 – done
• Set the vis2->Preferences->Root URL to Visibility3 – done
• Have uploader.java produce a better web page so that uploading doesn’t seem so skanky.
• Continue to beat on ingestor problems

7:00 – 7:00

• Hopefully, today we can have a better install.
• Need to do the following:
  • Get an HTML-based file upload running that we can have the flash app point to. That seems to be working in VisibilityHsqlServer
  • Get a stand-alone version of the ingestor running with some test files so that we can do some debugging at the fort
  • Fix the ingestor so that it can 1) Point to a remote file – i.e. “\yourServeryourDirectoryyourfile.xml”  2) Verify that the file is visible, 3) Ingest the file immediately, and then on a schedule.
• Deployed the new version as Visibility3
  • Need to change the pom file so this tracks
  • After futzing about with endpoints and other issues, got the new version to work, although with the same problems as last time. However, the HTML version of upload works, so I’m going to change the upload to launch a webpage to handle uploading until we can figure out what’s going on.
  • Ran a lot of tests and took screenshots. These are now on Dong’s desk.

7:30 – 5:30

• Deployed
• There is going to be a demo on Sept 11
• Added “Select All” and “Clear All” to QueryBuilderBase
• Everything works on Laureldemo – going to burn a disk – done
• Going to the Fort to try rolling out the new version
• Some things worked, a lot didn’t:
  • File upload hangs
  • Timed ingestor won’t read in files that are not in the “uploads” directory
  • Ingestor has “too many connections” error with MySql and fails on combined.xml. Can read billets.xml. The old ingestor handles these files just fine.
  • Didn’t try ingesting xml

7:30 – 3:30

• Wow, it’s September. Sixty four degrees this morning, highs in the seventies – clear and crisp.
• Deployed
• Downloaded Mike’s stuff, which works great
• Waiting for Dong to finish up, then we’re going to do a test deploy.
• Sent a note to maryanders@aol.com about the property on Hercules Rd. in Jessup.
• Interesting article on pocket-switching network language: http://delivery.acm.org/10.1145/1600000/1592617/p43-yoneki.pdf?key1=1592617&key2=3597181521&coll=ACM&dl=ACM&CFID=15151515&CFTOKEN=6184618
• Dong is finishing up his part. Deploy to edge test server today?
• Dentist at 4:00

10:00 – 5:00

• Demo for Pat
• Deployed
• Things to do:
  • Changes search from ‘==’ to ‘contains’ – done
  • Clear checks on new table selected – done
  • Add documentation button back
  • see how to do combinations of “and” and “or” in googleSQL
• Timesheet!

7:30 – 4:00

• Deployed
• Working on QueryBuilder. Also need to stop sending the full response over from the server and only send the discrete response
• Finished QueryBuilder- now QueryBuilderBase. AdvancedQueryBuilder extends base. So QueryBuilder and AdvQueryBuilder should be deleted. Going to do that after the demo on Monday.
• Set up a demo at S2F for Monday at 11:30

8:00 – 4:30

• Deployed. Uploaded and ingested a spreadsheet for Anne. It had some problems (duplicate columns and multiple worksheets) that had to be resolved. Also had a conversation with Mike C about HRMS data
• Talked to Dong about making more instructive error messages for ingest
• Email with Mike K. He’s going to be working on the layout manager
• Going to get the check marks to autopopulate  today. Maybe depricate QueryWidget
• Meeting with Anne – 2:00 – 4:00

7:30 – 4:00

• Deployed. There was a note from Anne about a slow query. After looking at the logs, it looked like it could have been a query that used columns that were no longer in the data. She’s going to try to rebuild the query and see if that affects performance.
• Talked to Dong about checking to see that columns exist before running the query. If they don’t then run the query in a degraded mode
• Talked to Dong about role management admin screen
• Working on putting column name checkboxes in AdvancedQueryBuilder – done
• Need to add a rollover to search – done
• Added Google Query Language Reference documentation to AdvancedQueryWidget

7:30 – 3:30

• Deployed data
• Working on search in AdvancedQueryWidget. Also did QueryWidget. Took a while to figure out how to set selected in a chart. Turns out you set the selected index of the series.
• Need to add column checkbox to ADG

7:30 – 4:00

• Deployed VIS1 & 2
• Talked to Mike C about putting “Current”, “stale” and “Obsolete” tags in a “Data Freshness” column in his data sources
• Sent a note of To Mike K about making a Pat display
• Talked to Dong about roles
• Caught up with Brian and Clift.
• AdvancedQueryWidget
  • Put new where clauses immediately after “where” – done
  • Add implicit “select”? – still thinking about this
  • Added the ability to set the query in the builder from an AdvancedQueryWidget
  • Getting loading and saving working
  • Need to have “setQueryBuilder” also set the table name. This requires adding table to QueryStringEvent – done

7:30 – 4:00

• No meeting today – put off until next week sometime
• Showed Anne the new stuff – her suggestions:
  • Have an indication in the chart as to what columns is being displayed
  • Populate the QueryBuilder from the loaded chart so that additional queries, based on the current query can be performed
• Back to AdvancedQueryWidget.
  • Got the date grid part working
  • Need to match up data types from the google types->primType->ColumnInfoObject
  • Integrating charts – things are displaying properly.
  • Need to get AdvancedQueryWidget to save and load properly
  • Need to change AdvancedQueryWidget so that the “and” clauses are inserted immediately after the where. See line 119 for details.

8:00 – 4:00

• Prepping for 10:00 meeting
  • There will be some kind of follow up meeting where I bring in a laptop to evaluate responses
  • Add search box for Inez. Done, but not wired to the datagrid/dataprovider highlighting yet
  • Didn’t get to AdvancedQueryWidget at all today. Try again tomorrow
• Stuff for Mike
  • Need a layout that has the query builder open with the appropriate boxes checked
  • Cascade layout should put panes back in their saved xy positions in addition to size
  • Column ordering is not saved (does not load in saved order)
  • Vertical scroll layout should adjust so that QueryBuilder does not obscure

7:30 – 5:30

• Deployed at the fort. Told Kathy W. and John W. that we’d have a better interface in about two weeks. Meeting tomorrow at 10:00
• Helped Dong fix his project
• Added user info to all remote object queries
• Back to advanced query widget
• Got most of the pieces put together. Need to extend QueryWidgetBase to AdvancedQueryWidget, and deal with columns and saving/loading

out sick