Dong Shin 03.04.2011

PPM
- reworked Export to retrieve all the data for the selected year (year + year_count) = selected year
  - order by Appropriations, year, budget_center….
- fixed a bug showing FMP (Financial Mitigation Plan) on empty data
- export data sets are identified by Funding Transaction Name?
- using uid to divide the data sets
- adde funding amount to export

Phil 3.3.11

7:30 – 5:30 VISIBILITY

Had a thought about getting data out of R. In the same way that I’m writing pix out to files that will then be read.
- Tried it, but no luck. It appears that the output from RServe is not considered redirectable
Went looking for more hints and found this in the RServe FAQ:
- String s=c.eval(“paste(capture.output(print(summary(mymodel))),collapse=’\n’)”).asString();
- And that seems to work nicely. The moral of the story seems to be “Find a way to get R to do the work”
Starting on the RemoteObject – should be mostly finished
Started RFlexClient
Accessing the setupModel.xml file
Having some problems getting the message broker. Found a redundant entry in the remoting-config.xml file. That, plus a recompile, redeploy seems to have fixed it.
Connected to the RemoteObject! Time to make some fancy widgets 🙂

7:30 – 3:30 VISIBILITY (3.4.11)

Hoping to deploy new PPM today, and that there will be no mysterious 502 error message…
Starting on some test statistical widgets to try out the remote object methods
Deploy went well. Nearly there
The queries are SLOW. Wondering if it has something to do with getting the RConnection. Going to try bouncing back the request on Monday (Depending on the stove delivery…)

Dong Shin 03.03.2011

PPM
- reworking queries that retrieve the request data – done.
- rearranged Show All and FY Filters, Show Selected
- show Color coded status on Status column only in Requests Panel and Title column in Request Form
- verified Financial Data in the Excel spreadsheet, fill 0’s with empty data
- request status is the worst from projects’ status
- removed user specific requests
- delete requests added

Christine 03.02.2011

Spent time yesterday and today continuing on with the Flex/Java/Tomcat setup.
To avoid Tomcat’s settings.xml file from being overwritten, I had to modify the server.xml file in Eclipse (under Servers < Tomcat: localhost). Still don't know why, but it works and I'm happy
Had minor setback with a Messagebroker issue, but that was resolved with a click of a Tomcat setting
Set up and ran a test Java/Flex project. Success. Discovered a bug with SDK 4.0 where an error was returned when calling mx.rpc.Responder (error message was: Can not resolve a multiname reference unambiguously. flash.net:Responder (from /Applications/AdobeSDK/flex_sdk_4.0.0.14159_mpl/frameworks/libs/player/10.0/playerglobal.swc(flash.net:Responder)) and mx.rpc:Responder (from /Applications/AdobeSDK/flex_sdk_4.0.0.14159_mpl/frameworks/libs/rpc.swc(mx.rpc:Responder)) are available). Found out that this is a known bug and the way to resolve it was to explicitly call the full classname
Now that I have a better understanding of the Flex/Java setup, tomorrow I will begin trying to get Ingest Manager up and running *finally*
Non-dev related: Claire was very excited to have her purple shovel again

Dong Shin 03.02.2011

haven’t checked for FGMDEV backup for a while – still working.
PPM
- finally got Excel export working
- as3xls does not work with multiple sheets….
- added multiple files support along with single file
  - users can export the projects to a single file or multiple files
- added progress bar
- ExcelFile.saveToByteArray slows the application down, not allowing UI updates when it writes data
- disabled project select on INCOMPLETE projects – cannot be exported
- added error capture on export

Phil 3.2.11

7:30 – 4:30 VISIBILITY

Went over the latest version of PPM with Dong. We have a bit of a problem saving out multiple files without having a dialog pop up for each file. It’s possible that an Applet might be a workaround
Working on figuring out how to properly traverse a REXP object
- Attr
  - Parse the debug string?
    - Split on commas
    - Stuff to the left of ‘=’ is an attribute
    - use getAttribute()
    - Recurse to parser?
- Payload
  - Object o = rl.elementAt(i);
Attempted to install PPM on site, and had the following bugs:
- When running on Trish’s machine, I got a remote object error 502 when trying to save a report for the first time. This did not happen on my box, but it has a static IP address and a hole in the firewall just for it. Will try on another machine today
- When bringing up a report request, the fields were blank until some event (i.e. show all) was clicked
- XLS files did not contain dollar figures

Tom.DeVito 3.1.2011

Finally have the Arduino, capacitors, and the SOMO 14-D. Still need to figure out what micro-SD memory card to get for the SOMO as not all are compatible.

Computer Controlled Amplifier

To reduce number of problems, the oscillator circuit will be used to produce the sound. Later this will be replaced with the SOMO 14-D.
Fried first amplifier because I had the pin numbering wrong. Pin numbering on ICs is numbered down on the left side then up on the right side. For some reason I thought it was down on both sides and got the VCC and GND pins reversed causing smoke.
The capacitor used to filter the audio signal is not supposed to be polar but a polar capacitor will work as long as, the positive side is on the pin and the negative side goes to the audio source. This seems strange considering the direction of the current but when I had it the other way no sound came out. Luckily the audio signal isn’t strong enough to blow the capacitor.
Switched piezoelectric speaker with regular speaker to make sure it wasn’t causing problems due t it having a higher resistance
Realized that when the amplifier was changing volume the sound light sound would cut off. I figured this was due to lack of power. Took the whole circuit off the i2c-usb controller’s power and onto the power supply.
Was not able to change the resistance on the the rheostat chip. Realized that all i2c controlled chips must be grounded to the i2c controller gnd.
Test class worked for controlling volume!
The amp has to be muted digitally in order to get absolute silence. The piezoelectric speaker, due to having a higher internal resistance, can be adjusted down to being “muted” without having to control the mode of the amplifier.
The piezoelectric speaker seems to work well. Not sure how good it will be for playing sounds, instead of tones. Need to find out if I can get samples of those tiny speakers I mentioned in a previous post.

Arduino

Considering part of the goal is to reduce the number of usb devices(not a very important goal but still), the mega would have probably been better then the Uno. That said, the uno should be useful to see if it will work for our application, and should have enough outputs for a two finger prototype. Another advantage of the mega is it can speak i2c which would eliminate the need for the usb-i2c adapter. However, if I find its better to control the mute function on the amplifier with the second rheostat on the variable resistor chip, we will need two i2c channels in order to communicate with 5 amplifiers.
Before I attempt to get the Arduino to communicate with the SOMO 14-D, I am going to try some basic tutorials to make sure I understand how to program it.

Speakers

Spoke to a representative at Murata to see if we could get samples of the VSLBP2115E1200-T0. He directed me to a local distributor Glen White Associates(434-385-6110). He also said that the Speakers should be used with a audio amplifier for ceramic speakers. There is no problem with using a regular amplifier but it may not be loud enough due to the higher impedance.

Dong Shin 03.01.2011

PPM
- reworked Data Request update queries to allow new entries. This will remove non-selected and existing data, update current, add newly selected.
- working on exporting Financial Data Request to Excel.
  - added project headers
  - added user/contact information
  - added for each project
    - Budgets
      - financial data for selected year from Oct to Sep

Mike 3.1.2011

I figured out how to intercept the property assignments between java objects and when Hibernate places them in the database. Combining this with the ability to create run-time Hibernate table mappings, I can take pretty much any object or structure of objects and place them in to a database.

Phil 3.1.11

9:30 – 7:00 VISIBILITY

Dentist this morning
Testing Dong’s code. It looks good as far as it goes. We need some kind of excel export for the financial info.
Added a page for PPM req’s (for 2011) : http://www.fgmdev.com/blogs/?page_id=4987
Somewhat useful tutorial for RServe: http://www.ci.tuwien.ac.at/Conferences/DSC-2003/Drafts/Urbanek.pdf
Here’s another: http://www.stat.auckland.ac.nz/~iase/publications/17/C340.pdf
Building a more robust data.frame reader. Done
- It turns out lists can be recursive. I temporarily have the DataFrameReader calling itself, which kind of works but could be better. Fix tomorrow.
Working my way through getting some basic calculations. There are some issues where if a string is assigned it is not considered a factor (whatever that is…). Unlike in the R interpreter, a factor must be explicitly set (i.e. “menuType <- as.factor(menuType)”)
Went to the customer site and sat around for two hours.

Dong Shin 02.28.2011

PPM
- reworking Financial Data Request
  - Request spans from earliest FY and latest FY in selected projects
  - Request template creates monthly request status
  - Data Request Panel start in current year and month, removed All and reworked filtering
  - Individual Project Status added
  - added data_request_templates table and reworked _data_requests_projects and data_requests tables

Mike 2.28.2011

More work on the data system

issue with reserved column names, dealt with it by appending underscores to the beginning and end of each column name mapping
issue with longs strings, first tried clobs for any string > 250 in length but that involved casting back and forth so instead put in some logic to double the available length every time it doesn’t fit starting at 255, then 511, 1023 etc.
Successfully saving strings, integers, doubles, and booleans. Now need to save references to other objects.

I had to share this line of code from a Hibernate java class:

private static class IncrediblySillyJpaMapsIdMappedIdentifierValueMarshaller implements MappedIdentifierValueMarshaller{

Christine 02.28.2011

It’s been a while, but I wanted to compile a bunch of info before posting since my schedule has been so sporadic.

Been working with Tomcat/Eclipse/Flash setup on both Mac and Windows.
- SSL: Although Dong sent me his .keystore file, it was out of date and contained his info. Created new certificate keystore, then modified settings.xml file.
- Took a few steps back to try and get a test project working. Combining Phils steps with additional documentation, I was able to successfully get a Flex/Java project working on both mac and windows… with one snag. Question: Why does Tomcat’s settings.xml file reset itself when using Tomcat through Eclipse? (side note: my Mac and Win eclipse are set to “use Tomcat Installation”) Here’s what I found – after modifying the settings.xml file to use SSL, when I use Tomcat through Eclipse SSL is no longer enabled. When I check the settings.xml file I find that it’s been reverted back to its original state (with the SSL connector info commented out and the keystoreFile info removed). Is there a way around this?
- As for getting a test project to work, I ended up downloading BlazeDS.
  - In Eclipse I start a new project by going File < Import and selecting Java/War file. Name my project and click "finish".
  - Right-click on the project and select “Add/Change Project Type” < "Add Flex Project". I configure the server type to be BlazeDS and click 'Next'.
  - The following screen should be configured as such: Root Folder-Point to the WebContent directory of your project, or if you changed the name point to the folder with the WEB-INF and META-INF directories in it; Root URL-end with project name; Context URL-is the last part of the URL minus the ‘/’. Validate the server location and click “Finish”. (You may see a “Recreate HTML Templates” error in the ‘Problems’ view. Right-click and fix)
- After this was set up, I moved over the xml files from a working project (see Phil’s post, step 9). Because I created the project as an import using BlazeDS war file, the (basic) jars needed were already imported and a web.xml file was already created. So then I refreshed, rebuilt and tested by going to “http://localhost://messagebroker/amf” and it worked. yippee.
- But my celebration ended abruptly when I tried to test the secure messagebroker only to discover that the settings.xml file was reverted back to it’s original state. Need to find out why.
Thanks to Phil for helping me deal with Window administrative issues that was making it impossible to run Tomcat. Windows and I have been through a few counseling sessions and we’re starting to get along

Phil 2.28.11