Category Archives: VISIBILITY

Phil 6.24.14

8:00 – 5:00 SR

  • DB backups
  • Tried the test program and the server seems fine. I think the next step is to deploy a new MySQL on the integration server and evaluate. If that works, then we’ll put it on the production server.
  • Discussions with Lenny about the new app. Here’s (a) way to generate word documents: https://github.com/leonardoanalista/java2word
  • SimilarityDistanceWidget.
  • Got all the calculations done and working. There is a strange positional artifact that seems to whant to put the items in a plane. Javascript math?
  • Today’s progress: http://philfeldman.com/WebGLSimDistTest.html

8:00 – 3:00 SR

  • Rolled back the FA changes from Friday.
  • More server problems – things like lost endpoints. Restarted the VM, which seemed to fix it.
  • Bill didn’t get my email with the test code in it. Trying to send him the link instead.
  • Fixed the callout incorrect name bug.
  • Starting on Similarity Distance widget, since it’s a straightforward extension of the network widget. Speaking of which, I need to make NetworkCanvas and NetworkComponent JSON friendly.
  • Today’s progress: http://philfeldman.com/WebGLSimDistTest.html

Phil 6.20.14

8:00 – 4:00 SR

  • Deployed new FA
  • Tried Maria, but too complex to upgrade
  • Full backups and deploy to integration server
  • The test server appears to run at 30% the speed of the integration server. I wrote up a small executable that will run a system call in a specified loop and time the result (the default is “cd .” 500 times. It takes 8.64 seconds on my dev workstation 21 seconds on the laptop. Should be interesting to see what the servers do.
  • Set selected id to the UUID for the THREE object3D.
  • Adding animation for changes in height, inner radius and outer radius. The callout for the name is getting changed to the original name whenever height or radius is changed.
  • And here’s how you use textures to exchange gpu calculation: http://stackoverflow.com/questions/22940678/reading-data-from-shader

Dong Shin 06.20.2014

  • deployed new FA with the reworked Query Builder – all is well.
  • experimented with MariaDB and some database performance testing on-site.
  • working on Query Builder
    • added Obligation, Outlay, PM Actuals columns back…. still need % values
    • required columns added to queryBuilderConfig.xml

Dong Shin 06.19.2014

  • did some performance testing of the temporary table, __view_project_detailed_data
    • data generation took 90 sec
    • query is faster
    • need Update button in Query Builder when data generation is needed
    • installed MariaDB and compared the performance
      • data generation too 20 sec
      • some error running stored procedure… may need to run – mysql_upgrade.exe -uroot -p –force 
        • #1728 - Cannot load from mysql.proc. The table is probably corrupted 
  • working on Query Builder
    • added Update Data in Query Builder to update project detailed data
    • added _table_last_update_status to keep track of tables status
    • added triggers to update the _table_last_update_status – obligations_outlays, budget_centers, committed_amount, and contracts_cognos for now
    • modified users queries to match new structure of __view_project_detailed_data

Phil 6.18.14

Phil 8:00 – 5:30 SR

  • Hey! A full day that I can work!
  • Backups
  • Integrating wedge size adjustment – animation, tooltips, add and delete, and rippling across all the wedges.
  • Got size adjustment working, but timing is off? Fixed.
  • Adding wedges is done.
  • Rippling is done.
  • Working on deleting wedges. Done, but there are some artifacts. Select doesn’t work the first time on post-deleted wedges. Auto naming is too naive – we can get multiple “Pie Chart 3”, for example. There needs to be an overall count or id field.
  • Anyway, here’s progress for testing on other machines: http://philfeldman.com/WebGLPieChartTest.html

Phil 6.17.14

8:00 – 1:00

  • DB Backups
  • Pie charts
    • Creating a WebGLPieWedgeComponent so that it can hang on to the current and desired angles and calculate transitions as needed.
    • Refactored wedge calculation to reside in WebGLPieWedgeComponent.
    • Hanging onto start and end angles as well as vertices.

Dong Shin 06.17.2014

  • installed MariaDB, works with the current MySQL data! little performance improvements… . 3.04 vs 2.72
    • mysqld –datadir=<directory to data>
  • experimenting with Triggers/Store Procedures to generate summary data
    • drop and create tables not allowed
    • delete and insert takes 5 sec on RA/RA data entry

Dong Shin 06.13.2014

  • checked out projects from new SVN repo
    • builds, but cannot check in…. permission issues
    • org.apache.subversion.javahl.ClientException: Permission denied
      svn: Commit failed (details follow):
      svn: Can’t move ‘/home/vectr/svn/307519/db/txn-protorevs/3263-2iv.rev’ to ‘/home/vectr/svn/307519/db/revs/3/3264’: Permission denied

Phil 6.13.14

8:00 – 5:00 SR

  • DB backups
  • Lenny is now security guy for our servers! And is getting the paperwork done that I was forbidden to do. And our authorization is now through September 9
  • Pie Charts!
    • Chart description (XML or JSON?). XML. And after a lot of flailing, I’m producing an xml description and reading it in. JS is very clunky WRT traversing XML. Basically every time I think it’s going to be something easy, JS makes it into an all day affair.
    • Tooltips
    • Calculations
    • resizing
    • Legend (in 2D overlay. Match the color to the Math.max(ambientColor, emissiveColor) of the wedge.
    • Labels (plus percent/value) with indicator lines leading to the outer top of the wedge. This means that labels will need to have a 3D offset option.
    • Upload?

Dong Shin 06.12.2014

  • working on Query Builder
    • converted old queries to new format
    • reworked __view_total_committed_amount_by_budget_center
      • CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `__view_total_committed_amount_by_budget_center` AS select `committed_amounts`.`budget_center_id` AS `budget_center_id`,sum(`committed_amounts`.`committed_amount`) AS `total_committed_amount`,MAX(`committed_amounts`.`committed_date`) AS `max_committed_date`, group_concat(`committed_amounts`.`committed_date` separator ‘,’) AS `committed_dates` from `committed_amounts` group by `committed_amounts`.`budget_center_id`;
    • reworked __view_project_detailed_data to include obligation date and committed date
    • going through the user queries….
  • svn migration complete – trying to check out…