7:30 – 4:00

• Had to reset everyone’s roles today. Not sure why
• Trying to set up a meeting to discuss data and column headers
• Working on getting checkmarks and multiple selection to work using xml – done
• Thinking about adding <options> tag, which would be a bunch of “where clauses” that could be added to the base query.
  • Make a new tab, for the time being we’ll call it “columns”. It’s king of like questions
  • In the “Edit” section, there is a “start” button that runs a “select *” query. THis is then used to build an XML document that has all the columns (minus timestamp and uid) in it as <select> elements. THe contents of each column is read into a Dictionary and used to create a set of <where> elements under the <select>.
  • The XML is used to create a tree like Questions. THere is a TextArea that allows editing of the XML
  • Clicking on the <where> tags causes the query to add to the SELECTstatement. WHere cluses are “OR-ed” together
• Waiting for Anne to get back for meeting
• Had Dong get more aquainted with Maven so that we can automate our dev process a little better.
• Mesed up my Subversion access somehow. Spent some time chasing that down

7:30 -7:30

• Deployed the latest and greates at the Fort
• Added an edgeDemo user that has access to fake data so Jeff can demo
• Meeting ith ??? at 10:30
• Need to make the Questinos interface a bit more like VIS1 – then I think we may be done?
• Spent the rest of the afternoon working on Aarons build issues.

7:30 – 3:00

• Deployed the new version, there are a few bugs with the new tree views
  • “Set Query Builder” is not causing the appropriate table to be checked – may have been related to branch problems, below. Regardless, it seems to be working here
  • Clicking on the table (blue bar, not check box) selects the table but does not check the box – fixed
  • foo_bar_baz and foobar_baz will cause two branches, one for “foo” and one for “foobar”.  The “foobar” branch is correct, while the “foo” branch will have “foobar”entries in it. – fixed
• Need to move the parser to a static method in “utils” – done

7:30 – 4:00

• Updated data and found a few bugs. See yesterday’s post for details
• Working on changing table combobox to a tree – done.
• Doing the same to the questions page – done
• Rolled in Dong’s changes and burned a disk
• Wrote up my 20% plan for Brian

7:30 – 4:00

• Getting ready for the next deploy
• Deployed – there are still a few problems:
• We need to be able to delete uploaded files
• The date in the table Combobox is still the date of first ingest, not the last
• “temp” file is left in the upload directory on the server
• The table Combobox is getting way too many entries. Need to change it to a tree like the column view

7:00 – 3:00

• Ingested data, fixed some logins, and added a superuser that had somehow gotten deleted
• Thinking about form builder – got a good start. It’s *big*
• Dong found a bug with the QueryBuilderBase tree builder – fixed

8:00 – 3:00

• Autoingest appears to be working, though not at exactly the right time
• Ingested data
• Working on bug fixes
• Fixed password issues
• Added checkbox renderer to user role presentation
• Added checks to “Add” and “Add Child” to Questions view in Advanced Query Builder

7:30 – 4:30

• Tried deploying but got nowhere. The code kept trying to connect to 127.0.0.1 rather than the actual server, even though I verified that the config files were correct
• Deployed to laureldemo to see if there was any difference. It seemed to deploy just fine. There was one problem with private data being visible to other users. Dong’s fixing that now. Done
• Burned  a new disk and going to try again
• Talked to Anne, Pat can’t remember her password
• Deployed the new version. Most things work, made a list of 12 bugs to bring in

7:30 – 3:30

• Deployed the new version – there are a few bugs:
  • Although remote files validate, they don’t read in – looks like the problem was that the remote files don’t terminate in .xml
  • Blanks are counted in the UniqueCounts view – fixed
  • Need to clear out the “where clauses” if the last item is unchecked – fixed
  • Need to keep the where clauses in the unique count query construction – fixed
• Had a good discussion with Mike C about data
• Scheduled a meeting with Anne to go over the new features
• Burned a new disc and am ready to deploy tomorrow.

7:30 – 3:3o

• Integrating Dong’s code in prep for release – done
• Burned a disc

7:30 – 3:30

• Another meeting with John, Anne, Brian, and Mike this time
• Based on getting new data (roster2) John is much happier with the tool. Mind you, there have been no changes to the tool.
• Working on getting an “insert column” capability, *then* we might get to multiple selects – done

7:30 – 4:00

• Long and painful meeting with John and Anne. My notes follow:
  • Data names are not clear from source
  • Should be able to check a box and get a list of names
  • Eliminate redundant columns
  • Fix column names
  • Either the basic tree or the question tree needs to have some checkboxes that represent “where clauses” that would be OR-ed together
  • Collapse redundant entries in columns on Flex side – i.e. how many unique names there are. This may be a new chart view
• Working on Question interface – first pass is done. Rolling up to bring in.
• Tomorrow, work on AdvancedQueryWidget.onCreateChartClicked() so that multiple bars can be selected.

7:30 – 5:00

• Ingested data at the fort. Talked to John, who tried to find info with Pat yesterday. I said that the display is only as good as the data, but I don’t think it stuck.
• Working on “Questions” interface
  • Modify – done
  • Add – done
  • Add as Child – done
  • Delete – done – turned out to be tricky. You have to use the delete operator.
  • Have “Set Query Builder” populate the _questionQuery.text field
  • Add a setTableQuestions(String questions,  String tableName) method in DbRemoteObject that a) Creates a table_questions table if there is none, and b) loads the xml as a blob in the table row (note: only one set of questions per table) See the dashboard entry for how to handle xml – done
  • Add a getTableQuestions(String tableName) method in DbRemoteObject that a) Creates a table_questions table if there is none, and b) either returns the xml if it exists or returns and empty <questions/> xml string. – done

7:30 – 3:30

• Deployed the new version with Mike’s fixes. Everything seems to be working fine
• Talked to Anne about building special-purpose tables from the master table to make it easier to explore the data
• Floated the question idea
• Realized that we could also have all the available strings in a column listed in the (a?) hierachy view, so some level of drilldown could be available…
• Changed all query double quotes to single quotes
• Phone call from Anne – Meeting with here and John on Thursday. Might have a version by then.
• Started on the question tab, mostly because it’s an easier problem to solve that might give us what we want. Go the part where you can click on a tree component “question” that runs a query.
  • Need to be able to interactively build the xml
  • Need to save the xml in a table-specific entry (only one entry per table holding the xml)