Monthly Archives: July 2013

Dong Shin 07.30.2013

  • continue working on FA
    • jar created with maven works in Tomcat!
    • set all the TitleWindows to position at upper left corner
    • changed Clear COGNOS Data to COGNOS Data Mgmt
    • query to find duplicates (records having same amount) in COGNOS imports
      • SELECT c1.*
        FROM contracts_cognos c1
        INNER JOIN contracts_cognos c2
        ON c1.committed_amount = c2.committed_amount
        OR c1.obligated_amount = c2.obligated_amount
        OR c1.expensed_amount = c2.expensed_amount
        WHERE c1.uid <> c2.uid
        AND c1.sub_budget_center = c2.sub_budget_center
        AND c1.requisition_id = c2.requisition_id
        ORDER BY c1.uid

Phil 7.31.13

8:00 – 10:00 SR

  • Backups
  • Got the development environment including Mike’s old workspace set up on the integration machine
  • Was able to run the PKI test code and get good results. Next is to attach to the server and step through the filter to see what’s going on.

10:00 – FP

  • Finish getting the Phidgets code working in KF_Hand_3 – done
  • Start to add sound classes – done inasmuch as sounds are loaded and played using the library I wrote. More detail will come later.
  • Start to integrate Phantom. Got HelloHapticDevice2 up and running again, as well as quite a few demos

Phil 7.30.13

8:00 – 10:00 SR

  • Backups
  • Tried to do some training, but the servers were undergoing maintenance.

10:00 – FP

  • Brought in my fine collection of jumpers and connectors. Next time I won’t have to build a jumper cable…
  • Built the framework for the new hand test. The basic graphics are running
  • Added cube code to the FltkShaderSupport library
  • Next, I’m going to integrate the Phidget sensor code into the framework, then hook that up to sound code.
  • Had Dong register for Google’s Ingress, just to see what’s going on.
  • Loaded in the Phidgets example code and the library that works is the x86 library. Using the 64bit library results in unresolved externals errors.
  • There are a lot of straight C examples. Just found the C++ class examples simple.h and simple.cpp.

Dong Shin 07.30.2013

  • continue working on FA
    • setting up Eclipse to create jar file for the FA server
      • figured out a way to create a jar file using maven!
      • http://maven.apache.org/plugins/maven-war-plugin/war-mojo.html
        • <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <configuration>
          <version>X.Y</version>
          <archiveClasses>true</archiveClasses>
          <attachClasses>true</attachClasses>
          <classesClassifier>${project.build.version}</classesClassifier>
          </configuration>
          </plugin>
    • working on duplicate resolution for COGNOS data

Dong Shin 07.29.2013

  • went to the Fort to figure out why doubling/tripling occurs
    • the rows have different dates with same amount! These are same data with slightly different dates and/or additional info on columns.
  • continue working on FA
    • converting ProjPortfolioMgr to WTP project – FinancialAssistantServer
    • working on conflict resolution to resolve doubling/tripling problem

Phil 7.29.13

SR 8:30 – 10:30

  • Backups
  • Found the source of the doubleing and tripling bug. New lines for the same values are being ingested. There needs to be a conflict resolution screen that is part of the ingest process.
  • Need to escape reserverd characters from query builder
  • Need to ensure that reserved words aren’t used in export to viztool.

FP 10:30 –

  • Prepping for demo
  • Fixing cable that broke on Friday
  • Got a lot of new parts in over the weekend including probes, cable, and sensors
  • Nice meeting with Dave Coleman. No concrete results (more meeting[s] required), but I think it went well.

Dong Shin 07.26.2013

  • trouble-shooting DynamicPanel hiding min/max/close buttons when it’s minimize with a title set
    • had to override set title method – invalidateViewMetricsAndPadding() messes up everything
    • add a Label to the titleBar – default titleTextField property is not working!
  • continue working on FA
    • looking at incorrect Committed and Obligated Amounts for EA’s

Phil 7.26.13

SR 8:00 – 10:00

  • Found some query builder bugs
    • “GROUP BY” is getting stripped out
    • Two requisition ID’s is confiusing
    • If you select new items after an modifier, incorrect SQL is generated
    • Need to be able to group similar rows (i.e. roll up all rows with the same req id)
  • There seems to be a math error on the “Budget Information” panel. Lenny found that on project 236, there are three EA lines (and nothing else). One line is correct, one line is doubled, and one line is tripled.
  • Backups
  • Installed Eclipse 4.2 and Mikes old workspace on the server.

FP 10:00- 4:00

  • Today, the goal is to build a circuit with three channels that connects to the Phidgets voltage sensor. The only thing I’m wondering is if I’ll get the resolution with the voltage range I’m getting – Zero to about 2.5 volts. I’m estimating that I should get about 1500 – 3000 steps out of that, assuming -30v to +30v is resolved to a (unsigned?) 16-bit int.
  • Done!

ratsnest

Phil 7.25.13

8:00 – 10:00 SR

  • Backups
  • Deploying new swfs

10:00 – 5:00 FP

  • Got the sensor resistance converted to voltage. A 1k ohm resistor seems to work best, since I want most of the sensitivity to be light pressure. Next, build a circuit with three channels that connects to the Phidgets voltage sensor. The only thing I’m wondering is if I’ll get the resolution with the voltage range I’m getting – Zero to about 2.5 volts. I’m estimating that I should get about 1500 – 3000 steps out of that, assuming -30v to +30v is resolved to a (unsigned?) 16-bit int.

Phil 7.24.13

8:00 – 10:00SR

  • Backups
  • Ran the query_logs to Viz query with the column names changed. It works like a charm
  • Added the new jars to VSS for better logging

10:00 – 4:00 FP

  • Organized the lab. Or at least a good start.
  • Hooked up one of the pressure sensors. The question is should I use a Wheatstone bridge or a pullup resistor? Sparkfun suggests a pullup resistor.
  • Picked up the power supply, crimping tool and wire

Phil 7.22.13

8:00 – 2:00 SR

  • Uploaded new VSS jars to the server to see if I can track down the problem with large(?) files.
  • Backups
  • Added more logging, but it turns out that the problem was in the creation of the table with reserved column names (“index”, etc);
  • Checked in scriptengine and JavaUtils. Also created an “Eclipse Server Projects” and checked the Vis3Testbed and VSSTestbed projects into it.

2:00 – 4:30 FP

Brian came over last night and we were able to load up his laptop with the drivers and software and run examples. At this point, we’re looking at three things to study with the rig:

  1. What is/are the best frequencies for spatial orientation (position and distance) using these actuators?
  2. What happens with speed and accuracy when there are more than one signal?
  3. Do 7 actuators work better than 4?

We’re in the process now of writing up the test plan. In the meantime, I’m now going to try to adapt the Audio2X software to replace the synthesizers and use a Phidgets 1019 to replace the Ardino of the previous telepresence test rig. Once that’s done, then I’ll add in the Phantom. For reference, here’s a video of the first version running:

And here’s a picture of the latest interface that will be attached to the Phantom:

IMG_1444To move this along, I’ve brought a small pile of electronics in from home. Tomorrow’s goal is to make sure that I can connect to the interface board. Once that’s working I need to hook up the sensors from the old prototype (note! Bring in crimping pins for female DB15 connector!).

Phil 7.22.13

8:00 – 4:00 SR

  • Viztool meeting. See Dong’s notes for details
  • Deployed new FA and RA. Next week we’ll change the links on the VizTool webpage so that the primary links are to the new tools
  • Discussed how to handle the column width issue with Dong. It’ll be a method like ‘width = getColumnWidth(minWidth, numColumns, parentWidth);’ that’s called on resize().
  • Looking into the issue where large tables appear not to be inserted into the vis2 database. And of course, everything is working fine here. Need to add some more logging, I guess.

Dong Shin 07.22.2013

  • VizTool meeting – notes at Req’s page
  • all projects disappeared (again?) from my workspace, ugh!
  • continue working on FA/RA
    • fixed SQL error updating users.
    • removed PM Actuals from Project Editor
    • added Search to FA
    • removed all dates and MIPR description in Req View in RA
    • added Type datagrid to Req View in RA to freeze the Type and finance data scrollable