Category Archives: FGM ASD Blogs

Mike Kluever Status – week of 8/10/2009

  • Adjusted DynamicPanel to allow the saving / loading of minimized / maximized states
  • Implemented the saving of DynamicPanel states in the vis 2 views
  • Created simplified basic query builder
  • Walked through some of the procedure required to use PKI and integrate in to a central authentication server
  • Changed the spawning of new QueryWidgets from clicking in a chart to first making a selection then clicking a button
  • Commented a number of classes

Mike – Week of 8/03/09

  • Deployed a new version inside to help diagnose pop-up / export issues: it is definitely a size limit imposed by the proxy
  • Implemented a tip of the day welcome panel to prototype shared object functionality which may later be used in default dashboard saving
  • Provided a status update to John Williams
  • Added an ‘Advanced’ menu to QueryWidgets allowing users direct control over the columns on the widget and the queries being run against those columns.  Advanced users can now add / remove columns on the fly as well as create more robust queries.
  • Gave a demo to a number of S2F members and added some more beta user accounts

Dong Shin Visibility Status – July 09

Week of 07/27

  • changes to Ingestor for Roles/Classification management
    • listTables() working – need ingest working
    • change TableInfoObject.as and TableInforObject.java
    • changed table structure in the database, table_data, uid to id.
    • added IngestConfirmWindow to IngestManager
    • added getColumnHeaders to XMLIngestor.java, ExcelIngestor.java
    • added listColumnHeaders to IngestManger.java
    • added Roles and Classification for file selected to IngestVBox.mxml
    • addes StringColumn.as ad ColumnRenderer.mxml for Roles column selection
  • Started working on Tables Management util.
    • added tables management to ManagementUtilsText
    • TableInfoOjbect, TablesManager, TablesMgmtPanel
    • added getTablesTree() to UsersAndRoles.java
  • added user id to autoingest; FlexAutoIngestRow, IngestManager, AutoIngestor,
  • allowClose=false not working!!!!! added menu item to bring IngestManger back in case it’s closed
  • changed Canvas to ManagedCanvas to utilize Windows menu – abandoned because ManagedCanvas doesn’t support allowClose=false
  • added menus to IngestManager – disabled unnecessary ones for future use
  • added createTable() and constructor to DBRemoteObject.java to fix error when there TABLE_INFO table doesn’t exists.
  • SecurityUtils moved to ManagementUtils for accessing SecutiryUtil Objects
  • integrated LoginScreen.mxml to IngestManager

Week of 07/20

  • added tableinfo table to keep timestamp info when data gets ingested
  • added timestamp info to the returning table list and to return the data, server
  • added DROP / ADD DATABASE USERS_AND_ROLES
  • Finally solved build problems; checked out the complete project, overwrite the changes…. NEVER CREATE new projects in Flex/Eclipse!!!!!!!!!!!!!!!!!!!!!
  • create table if not exists added to handle merge – Server
  • File Browse button added to AutoIngestConfig, but directory cannot be appended to the filename… hardcoded path to C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/Visibility2/uploads/
  • rearranged serverLog, ingestPanel, and debugPanel so that it lays out better
  • chaged all java files to utilize new log4j implementation
  • implemented AutoIngestorServlet to utilize AutoIngestor with preset interval defined in web.xml
  • TomCat servlet can be used with Timer.schedule
  • could not find a way to log with scheduled task. abandoned idea of using the scheduled task
  • Create a Scheduled Task – http://support.microsoft.com/kb/308569
  • Java Service Wrapper successfully set up AutoIngestor as a service – C:UsersDong ShinDesktopwrapper-delta-pack-3.3.5
  • Created C:Program FilesApache Software FoundationTomcat 6.0webappsrunAutoIngest.bat to run AutoIngest from command line
  • Started looking into Java Services for windows
  • rebuilt flex projects with the improved logger. Had compile issues, but Flex Build Paths settings needs reset.
  • started FlexMySQLAdmin to experiment database interface using amfPHP and Flex
  • Change project compiler setting for AMFPHP – -services “services-config.xml”

Week of 07/13

  • Enable/Disable buttons on IngestPanel according to user selection
  • Set up XAMPP to use different port: 8080, disable SSL.
  • Added merge option for data ingest – client and server (07/16)
  • Added merge option for automatic data ingest configutation – clien and server
  • data uploader now hidden under Upload File Control – client
  • changed Table Name setting to use all lower case to match DB tablenames – client
  • changed Server return of boolean to readable message – server
  • merged data uploader with ingestor – client (07/15)
  • delete table added  – client and server (7/14)

Week of 07/06

  • changed dynamic panel on IngestPanel to  SaveStatePanel – client
  • IngestPanel now not closeable…
  • added AutoIngestConfigVBox for configuration of auto ingest – client and server
  • deleted old Data Ingestor codes – server
  • created new DatabaseIf.java for better interface and control – server
  • File Ingest support all xml and xls files in one window – client
  • added filter for each supported ingest file type – client
  • added existing database tables to view o the ingest panel  – client

Mike – Week of 7/27/09

  • Added Export to Excel button and backing code
  • Added screen shot button and backing code
  • Helped Tom with checking out and building code
  • Added delete dashboard feature to save dialog
  • Deployed latest version inside
  • Met with Anne to discuss new features and take her input
  • Selected column and chart and now properly saved / loaded
  • Debugging issue with Excel export and snapshot
  • Added change password feature to log in page
  • Implemented the find panel list

Mike – Week of 7/20/09

  • Finished up logging changes, wrote short guide, provided support for changes
  • Created log in screen and connected it to user management remote object
  • Connected the save / load feature to the remote object

Mike – Week of 7/13/09

  • Finalized a lot of the current layout managers (Cascade and Vertical)
  • Started work on saving panels off in xml format and loading them back in
  • Created a new Flex Project to house our main application (named vis2 instead of GenericQueryTest)
  • Starting to standardize the logging to use log4j

VISIBILITY 2 short-term development plan

VISIBILITY 2 short-term development plan

Add roll management to system — August 1

• Develop role management tool
• Incorporate rolls in data rendering
• Specifying global data rolls

Add user management – August 30

• Display/query storage and retrieval
• Display/query publish
• Data publish

GUI refactoring – July 15

• Make each widget a unified data/meta-data widget with direct query capability
• Implement a layout manager
• Login screen with password protection
• Develop VISIBILITY2 look and feel
• Develop map visualization basic capability
• Widget tab in QueryBuilder should help find “lost” panels
• Enable multiple selection

Database enhancements – August 30

• Extend VISIBILITY1 ingestor to produce “record_status” column based on record_ingest_date
• Develop “plug-in” architecture for ingestors
• Rework server log so that data is no longer sent over in xml
• Source ingest management tool (manual and automatic ingestion)