- PPM
- created DBUpdateSQLs02252011.sql for adding data request tables
- working on Project export
-
Get all budget centers and amounts querySELECTc.center_name as `Budget Center`,c.center_number as Number,GROUP_CONCAT(if(a.year=1,a.amount,NULL)) as FY1Amount,GROUP_CONCAT(if(a.year=2,a.amount,NULL)) as FY2Amount,GROUP_CONCAT(if(a.year=3,a.amount,NULL)) as FY3Amount,c.appropriation as RemarksFROM projects p, budget_centers c, budget_amounts aWHERE p.uid = c.project_idAND c.uid = a.budget_center_idAND p.uid = 96GROUP BY a.budget_center_id
SELECT c.center_name as `Budget Center`,c.center_number as Number,
GROUP_CONCAT(if(a.year=1,a.amount,NULL)) as FY1Amount,GROUP_CONCAT(if(a.year=2,a.amount,NULL)) as FY2Amount,GROUP_CONCAT(if(a.year=3,a.amount,NULL)) as FY3Amount,
c.appropriation as Remarks
FROM projects p, budget_centers c, budget_amounts aWHERE p.uid = c.project_idAND c.uid = a.budget_center_idAND p.uid = 96GROUP BY a.budget_center_id
-
- Array Collection not returning data in ordered manner? May have to write own parser…
Phil 2.25.11
7:30 – 4:30 VISIBILITY
- Looking for the mythical java client for Rserve. It does not appear to be in the distro or the svn trunk repo
- Found it. It was in the snapshots here: http://www.rforge.net/Rserve/files/.
- compiled the Rserve jar (using make!). Put it up on the maven repo as net.rforge.rserve ver 0.6.3
- Added R.dll to my path
- Started the server and connected to it with Putty. The connection was successful, and then the server crashed. That may be because PuTTY sent some bad characters.
- Talking to the server in java without killing it. Wheee!
- Writing up a description of our data migration plan – done.
- Actually able to run an ANOVA and understand what I was doing. I think I can even generate plots and have them put in a particular server folder so that they can be downloaded and displayed in flex.
Tom.DeVito 2-24-2011
Arduino research:
- Found many links regarding the Arduino electronics platform:
- Explanation of different version: http://www.ladyada.net/library/arduino/unofaq.html
- Tutorials: http://arduino.cc/en/Tutorial/HomePage
- 414 Arduino projects and counting: http://hackaday.com/category/arduino-hacks/
- Search engine for chips: http://www.findchips.com/
- Ada’s Store: http://www.adafruit.com/
- Sparkfun Store: http://www.sparkfun.com/
- I determined that the version we want is the Arduino Uno. I believe that all latest versions have similar specs, but this one is probably the best for our stage of prototyping. A smaller one, which mounts onto a board may be better once the electronics are finalized.
- Due to the recession, DIP chips are getting hard to find because many producers are cutting costs by only make SMTs, which have higher demand. This is making it so the arduino’s main chip is becoming increasingly rare. There is a SMT version now to help keep up with demand. I figured we should stick with the DIP chip while we still can.
- The Arduino cannot directly control our amplifiers. This can possibly be done using a gate to route the current through a volatage spliter maintaining a Float, open or close the gate with a second pin to bypass the voltage splitter to make a High and turn off the main pin to make a Low. This may be easier to program then the current method because you just have to control 2 pins. That said the Arduino can communicate with i2c devices like the rheostats
- The Arduino is very easy to program. Basically you just initialize and loop. Communication to the device works very similarly to communication with the usb-i2c master chip. Just set the arduino loop to listen to the com port and do various things depending on what it is sent. On the PC side its identical to the i2c program, since the Arduino has more memory, I believe the commands can be in the form of char arrays as opposed to hex only.
- When we were looking at ladyada.net you asked where do people get the time to do all this stuff? The answer is MIT. All the students are required to have a website.
Other Electronics
- I’m going to call the murata company and see if we can get some samples of http://www.murata.com/products/catalog/pdf/p82e.pdf. They are finger tip sized full-ranged peizoelectric speakers. Currently I can only find them in quantities of 2000…. They really look perfect for our application but don’t think we will need 2000 til we start production. (not to mention its still $5 each at this quantity)
- There are some other options for speakers but I haven’ sen any that look as good as those. Most speakers this size have a far more limited range of sound.
Amplifier Circuit:
- Waiting on a few capacitors that were not at the electronics store.
- Found a small portable break-out board to play audio with. http://www.sparkfun.com/products/9534. Its has somewhat of an amplifier but only 7 volume settings so our amp chips will still be needed.
- Needed a bigger breadboard to prototype this circuit. Not nearly enough room on the one I have
- Audio will be driven by the aurdino.
Dong Shin 02.24.2011
- PPM
- added reset filters on Requests Data
- joining projects, budget_centers, appropriations doesn’t return projects with 0 budget because those might not have budget centers data – fixed by adding OR p.total_budget = 0 in the query
- removed colors for projects and added status – incomplete gets red
- rearranged project filter buttons
- reworked Active Year filters
- added tooltips to projects datagrid
Phil 2.24.11
8:00 – 5:00 VISIBILITY
- Now that I’ve got rJava/RMI working, I’m going to try building a few composite commands and parsing the results.
- And now I’m wondering if rServe makes more sense. It appears to create a separate workspace for each connection. That would work much better for a webapp. The only thing to watch out for is that the server goes down now and then, so it will have to be restarted under control of the Remote Object.
- Spent the afternoon with the customer drawing diagrams of how our data will be packaged and migrated between platforms.
Mike 2.23.2011
- Finally resolved the deletion issue
- Now working on a basic Flex app for browsing and managing the data base
- It currently:
- Displays a list of all existing object types
- Can retrieve and display all dynamic objects of a selected type
- Displays meta information about each object type (property names and primitive types)
- It will:
- Allow new object types to be created
- Allow modification of existing types
- Allow deletion of object types (including removing of every dynamic object of that type)
Dong Shin 02.23.2011
- Verified that FGMDEV backup works
- My Eclipse is not behaving!
- hangs at Loading Web Service DOM….
- found a offending bug on WTP – related to Tomcat?
- adding -clean to eclipse.ini resolved it temporarily
- moved projects to different workspace…
- PPM
- Request filtering using Year, Month, Description and Status
- Project filtering (Active Project) based on Start and End Year range using appropriation length
Phil 2.23.11
7:30 -5:30 VISIBILITY
- Server Meeting today at 11:15. Don’t see how I can make that
- Over at site starting at 1:30
- Setting up rJava: http://www.mumuen.com/2010/10/running-r-in-java-with-jrirjava.html
- Got the rtest code in the rJava examples directory compiling. It turns out that the CRAN directory has an old version. Sheesh. Updated the maven repo with the version 9 jars. Added R_HOME to the path. Restarting all to register changes… No joy.
- Following the directions here: http://mithil-tech.blogspot.com/2009/11/r-and-java-jri-via-eclipse.html
- That worked!
- Next will be to get R to run in Tomcat: Here’s where I’ll start: http://wiki.cvrgrid.org/index.php/RJava/jri_Setup
- Useful r packages so far (google “CRAN xx’ for detailed info on the package):
- sqldf – allows SQL manipulation of tables
- reshape – for manipulation of data types
- gwidgets – support for interactive graphics
- HH
- rJava – java interaction
- RServe – R as a webserver
Dong Shin 02.22.2011
- FGMDEV backups working….
- PPM
- rearranging components to support Active Project search…
-
Project filtering query…..SELECT p.begin_year, (p.end_year+MAX(a.duration)) as end_year, p.uidFROM budget_centers c, projects p, appropriations aWHERE c.project_id = p.uid AND c.appropriation = a.typeGROUP BY p.uid
Tom.Devito (2-17-2011) – (2-21-2011)
2-17-2011
- Got to a point with the audio amplifier controller which I cannot pass without testing my assumptions on the chips operation.
- Chips came in but no adapter boards to mount them on yet
- Resumed work on the OpenGL articulated hand.
- Got one finger working, mirrored it to make sure all my assumptions were true.
2-18-2011
- Still no adapters for chips continued to work on the articulated hand.
- Added Camera function. Had a lot of problems getting this working. Almost all of these problems had to do with me putting things in the wrong place.
- Noticed that there are some flaws with the current method of rotation. Found this site http://stackoverflow.com/questions/2758501/rotating-in-opengl-relative-to-the-viewport which explains that you need to use quaternions to make it so you can spin the object without its coordinates flipping. There is some example classes in java on this site. Will look for a c++ class or transcribe this once I get the hand drawn.
- Experimented a bit more with various OpenGL functions as prepared to move the current work out of the sandbox.
2-21-2011
- Moved out of the sandbox. Set the stage, made a finger class with parameter(x,y,z,length)
- Had many many problems getting this to behave properly mostly due to forgetting to initialize variables and other simple things eventually got it to draw right.
- Was having a problem with the animation that it was jumping all over the place. Thought this might be a real-time issue since the animation method was no longer in the top level glut program. Read a bit of the chapter on real-time then I realized yet again forgot to initialize yet another important variable….
- All the animation I did so far was 2D. I experimented with animating in 3d since the thumb is going to need this.
- Random Thought: It may be good to put a force based joy-stick on the thumb to help give it a greater degree of freedom then can be achieved with strain gauges alone. The thumb has a great amount of 3-dimensional freedom that is essential to being able to pick up small objects. I think this would work best if the surface is flat and it disables the extra freedom when you press in so that the thumb does not move around when you try to grab something.
Phil 2.22.11
9:00 – 6:00VISIBILITY
- Had a talk with John W last Friday about the increase in hours charged 4 hrs/week to 10 hrs week for catwalk. Told him that I basically couldn’t do the level of support that I had been doing for 45min/day and that I wouldn’t be coming by unless he tells me that there is a problem.
- Going to try to talk to R through Java today.
- Found a cool audio synthsizer library for the next hand – https://ccrma.stanford.edu/software/stk/
- So that I can find this the next time: Webstart, Servlet, IDE, findme!
- Interviews!
- Got RServe installed. Going to take a look at interfacing that way.
Mike 2.21.2011
- Came in this morning and the internet was out. Ended up calling Comcast with Kristi and they helped us sort it out
- More progress on saving and loading of dynamic objects
- Have custom serialization working to minimize the amount of data sent back and forth while sending dynamic objects
- Have a simple UI for querying for all available types
- It can then request all object of a specific type and display them
- Attempted to delete object but ran in to some problems, still sorting it out
Dong Shin 02.21.2011
- FGMDEV Backup – noticed deletion not working properly, modified the script. check tomorrow…
- PPM
- Added DataRequestsEmailsWindow, RequestEmailTextHBox to support multiple request email generation from DataRequestPanel
- continue working on Excel export….
Dong Shin 02.18.2011
- FGMDEV backup is working… yeah!
- PPM Changes
- set dataProviders manually so that filtering doesn’t flicker between all list and filtered list in DataRequestFormWindow
- filtering added to Users in DataRequestFormWindow
- Status filtering ComboBox and Description filtering textbox added to DataRequestPanel. This work together as a filtering set.
Christine 02.17.2011
- Just checking in. Slowly working through getting Ingest Manager running. Have had little time to do so b/c child has been sick with the flu and now I have it. Not a good week

You must be logged in to post a comment.