Category Archives: Phil

Phil 9.28.2009

7:30 – 3:30

  • Gotta install sp2…. Well that was 20 minutes well spent! Wheee.
  • Working on multiple select = done. Leaving the single select code in place for a while out of, well, superstition and fear, actually.
  • I’m thinking about adding another chart that has the unique counts for each column – that way it would be possible to easily find out how many people we in a query, even if they had multiple skills. – done

Phil 9.25.2009

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

Phil 9.24.2009

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.

Phil 9.23.2001

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

Phil 9.22.2009

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)

Phil 9.21.2009

7:30 – 4:00

  • Hey! It’s Fall! No wonder it’s dark when I get up these days
  • So I come in this morning and find that Mike has fixed half the issues that Anne and John listed. It’s like having pixies do the dishes at night!
  • VIS2 Meeting at 10:30
  • Writing up support for S2Dash
  • Need to make the system more Pat-freindly. Not sure what that means, but I’m leaning towards “Questions” that point to queries

Phil 9.18.2009

7:30 – 5:30

  • Deployed the latest attempt at the fort and it seems to be working well. Uploaded new data
  • Trained up Anne and John on the new features. Based on their suggestions, here’s what needs to be added
    • Allow users to delete their dashboards
    • Start up in ‘Builder’ layout
    • Update tips
    • Add tips to the IngestManager
    • If nothing is selected, have a popup that says “No items selected for query”
    • Provide direct transition from minimize and maximize
    • Don’t allow components (particularly minimized windows) to go behind the top “VISIBILITY2” UIComponent
    • Resize events on the builder window should re-trigger the layout
    • Automatically scroll to the selected item in a search on a datagrid
    • Add a “Suggestion Box” under Utils that’s like the old bug reporter on TUMMS
  • Architecture (get aquainted session?) in Fairfax. Ran a little long. Note. If you leave VA at 3:15 on a Friday, it can take ’till 5:00 to get back to Laurel.

Phil 9.17.2009

7:30 – 5:00

  • Uploaded data
  • Tried another version of VIS2 – this time it got confused with lines that have the same words in them – i.e. “Position_Person” vs “Person_Position
  • Fixed the ordering problem and discovered a case where I got runaway recursion.
  • Fixed that, but then had a problem where one of the leaf nodes of a branch had the same name as the branch. Fixed that, too.
  • Added timers for how long pull and collapse hapens on the server
  • Removed redundant data from QueryInfoObject
  • Removed some logging from the XML ingestor
  • Added tooltips to titlebar and query entry field. Tried to get datatips on the widget finder to work, but no luck
  • Ftp’d new version home so I can burn a disk
  • John Williams is having trouble with the system running in IE. Related to the debugger version?

Phil 9.16.2009

7:30 – 4:30

  • Uploaded data
  • Tried deploying a new VIS2, but the hierachical display didn’t work on some of the tables. Rewrote so that the system uses recursion
  • Meetings
  • I had more to add, but my computer sized up yesterday and rebooted on me.

Phil 9.15.2009

7:30 -4:00

  • Ingested data
  • Yesterday I got most of the hierarchical decomposition of column headers into a tree view. Need to make that work with BaseQueryWidget. Done.
  • Integrating with Dong’s code – done

Phil 9.14.2009

7:30 – 3:30

  • Ingested data
  • Sent out the new URL to the S2F folks
  • Had a chat with John about bringing him up to speed on the VIS2 system. Wednesday or Thursday AM
  • Working on getting a tree view of column headers where prefixes match – Mostly working in sandbox

Friday Log (9.11.2009)

7:30 – 4:00

  • Gloomy damned day
  • Committed the new ingestors
  • Fixed the query builder so that selects are inserted before any other reserved word. This means that any fancy query can be adjusted by clicking on columns without loosing the clauses
  • Meeting with Pat, Anne, John, Mike K, and Brian
  • Fixed the query reference so that it does not contain developer info
  • Need to do the following:
    • Enable tooltips on title bar and widget finder
    • Make query into a TextArea?
    • Keep tabs on save. It may be broken
    • See if it’s possible to build a tree view of the columns that group by sections that match within underscores (i.e. “foo_bar” and “foo_baz” would be under “foo”)
    • Add search to builder
    • Make darker panels – done
    • Make bigger scrollbars – done

Thursday Log (9.10.09)

7:30 – 4:00

  • Ingested data at the Fort
  • Talked to Anne about the next proposal – I think it’s more of a TUMMS monitoring app with CoreItems than VISIBILITY or AppBoard
  • Making a csv ingestor to deal with all of the xls ingestion problems – done
  • Also put together a tab seperated ingestor
  • Looked over Brian’s proposal

Wednesday Log (9.9.9)

7:30 – 3:30

  • Updated data at the Fort
  • Verified that if I run tomcat as myself, that remote uploading can work. The problem is that the server box won’t let Tomcat run with my id once I log off. And it automatically logs you off, so it can’t be left in the state that we leave the subversion server or laureldemo. Sigh
  • Cleaned out some of the debugging traces in the code.
  • Still had some problems reading files with special characters in the columns. Going to work on that next. – Fixed
  • Meeting on new Mission Dashboard Thingy