Phil 1.13.14

8:00 – 4:00 SR

  • Backups
  • Cleanup of all the backups. And in the process I managed to delete the backup batch file, and cpPlusDate/mvPlusDate. Found everything (in the “installed” folder. How about that!), and rewrote the batch file which is a bit cleaner now. The remote drives are not connecting today, so those parts need to be uncommented tomorrow.
  • Tim E. is not answering his emails. I need to start beating on that harder.
  • One of Carla’s users is having trouble connecting to the server. The certs look OK, so I sent the standard connectivity problems email.
  • Javascript
    • Working on getting data to show up properly using post. I think I might just send a property named JSON. Need to make sure that the size is within the limits set in the server.xml file: http://stackoverflow.com/questions/2943477/is-there-a-max-size-for-post-parameter-content
    • Done and commented. Walked Dong through it and it seemed clear to him.
    • Checked JavaScript, Java and server config into svn.
    • Next, break code out into reasonable containers. Maybe with TypeScript.

Phil 1.10.14

8:00 – 2:00,  3:00 – 5:00SR

  • The weather word for today is “ick”.
  • Backups
  • No word back from Tim E.
  • Add “only show if conflict” as a line choice in Reqonciler.
  • Timesheet crap.
  • Email chain with Brad about how to move off of fgmdev.
  • Lunch at 2:00.
  • It looks like the POST configuration can be set up in datasource-io, since there is an ioConfig attribute (http://yuilibrary.com/yui/docs/api/files/datasource_js_datasource-io.js.html#l56). Going to set up the servlet to listen to POST as well and see what happens when I send data. This is the io-base example that seems to be appropriate: http://yuilibrary.com/yui/docs/io/
  • Wow. That worked! Need to sent the argements over correctly, but the response is already coming back ok.

Dong Shin 01.09.2014

  • Phil found that RA takes too long to retrieve the list of Req’s
    • looked at various MySQL configurations – will try my-large.ini or my-huge.ini tomorrow (xampp/mysql)
  • working on queries for reports
    • now I have the goals, committed, obligation/outlay, PM actuals!
    • get goals matching project’s appropriation
      • SELECT p.*, bc.*,
        (bc.funded_budget * obligation_month_1 / 100) as month_1,
        (bc.funded_budget * obligation_month_2 / 100) as month_2,
        (bc.funded_budget * obligation_month_3 / 100) as month_3,
        (bc.funded_budget * obligation_month_4 / 100) as month_4,
        (bc.funded_budget * obligation_month_5 / 100) as month_5,
        (bc.funded_budget * obligation_month_6 / 100) as month_6,
        (bc.funded_budget * obligation_month_7 / 100) as month_7,
        (bc.funded_budget * obligation_month_8 / 100) as month_8,
        (bc.funded_budget * obligation_month_9 / 100) as month_9,
        (bc.funded_budget * obligation_month_10 / 100) as month_10,
        (bc.funded_budget * obligation_month_11 / 100) as month_11,
        (bc.funded_budget * obligation_month_12 / 100) as month_12,
        (bc.funded_budget * outlay_month_1 / 100) as outlay_month_1,
        (bc.funded_budget * outlay_month_2 / 100) as outlay_month_2,
        (bc.funded_budget * outlay_month_3 / 100) as outlay_month_3,
        (bc.funded_budget * outlay_month_4 / 100) as outlay_month_4,
        (bc.funded_budget * outlay_month_5 / 100) as outlay_month_5,
        (bc.funded_budget * outlay_month_6 / 100) as outlay_month_6,
        (bc.funded_budget * outlay_month_7 / 100) as outlay_month_7,
        (bc.funded_budget * outlay_month_8 / 100) as outlay_month_8,
        (bc.funded_budget * outlay_month_9 / 100) as outlay_month_9,
        (bc.funded_budget * outlay_month_10 / 100) as outlay_month_10,
        (bc.funded_budget * outlay_month_11 / 100) as outlay_month_11,
        (bc.funded_budget * outlay_month_12 / 100) as outlay_month_12
        FROM projects p
        LEFT JOIN budget_centers AS bc ON p.uid = bc.project_id
        LEFT JOIN obligations_outlays_goals AS oo ON p.appropriation = oo.appropriation
        WHERE oo.year = 1 AND bc.fiscal_year = IF(MONTH(CURDATE()) < 10, YEAR(CURDATE()), YEAR(CURDATE()) + 1)

Phil 1.9.14

8:00 – 4:30 SR

  • Backups
  • Deploy new FA, RA, RQ
  • Truststore issue *is* fixed!
  • Pinged Tim E. To get renewal process restarted.
  • Javascript

Dong Shin 01.08.2014

  • fixed some bugs and went through FA, RA, and Reqconciler to use GLOBALS 
  • working on queries for presentation using Phil’s test data
    • query to get all obligations/outlays for current fiscal year
      • SELECT * FROM projects p LEFT JOIN budget_centers AS bc ON p.uid = bc.project_id LEFT JOIN obligations_outlays AS oo ON p.uid = oo.project_id AND bc.uid = oo.funding_id WHERE oo.year_count = 1 AND bc.fiscal_year = IF(MONTH(CURDATE()) < 10, YEAR(CURDATE()), YEAR(CURDATE()) + 1)
    • query to get monthly committed amounts by req_id
      • SELECT budget_center_id, year(committed_date), month(committed_date), sum(committed_amount),
        SUM(IF(month(committed_date)=10, committed_amount, 0)) as month_1,
        SUM(IF(month(committed_date)=11, committed_amount, 0)) as month_2,
        SUM(IF(month(committed_date)=12, committed_amount, 0)) as month_3,
        SUM(IF(month(committed_date)=1, committed_amount, 0)) as month_4,
        SUM(IF(month(committed_date)=2, committed_amount, 0)) as month_5,
        SUM(IF(month(committed_date)=3, committed_amount, 0)) as month_6,
        SUM(IF(month(committed_date)=4, committed_amount, 0)) as month_7,
        SUM(IF(month(committed_date)=5, committed_amount, 0)) as month_8,
        SUM(IF(month(committed_date)=6, committed_amount, 0)) as month_9,
        SUM(IF(month(committed_date)=7, committed_amount, 0)) as month_10,
        SUM(IF(month(committed_date)=8, committed_amount, 0)) as month_11,
        SUM(IF(month(committed_date)=9, committed_amount, 0)) as month_12
        FROM committed_amounts
        GROUP BY budget_center_id

Phil 1.8.14

8:00 – 4:00 SR

  • Backups
  • Truststore issue is probably fixed! Worked for Mike M. at any rate. Fingers crossed.
  • More progress on the SA front.
  • Javascript
    • Servlet – done. Generates HTML, XML and JSON data via doGet() format is
    • Adding remote DataSource to YUI code. Connecting was pretty straightforward. You do have to wrap the data as described here. Then it was mostly a matter of making my JSON correct. Next, make it so that the variables can change as with the local version.

Phil 1.7.14

8:00 – 11:00 SR

  • Backups
  • Still waiting for someone to give me enough information to let me fill out a ticket.
  • Still waiting for a response back on what network the server is on. Today’s busy, but I’ll get on that tomorrow.
  • Javascript
    • Servlet development

11:00 – 4:00 FP

  • Poster for SIGCHI 2014

Phil 1.6.14

8:00 – 2:00 SR

  • On call to pick my folks up at the hospital, so I might be leaving early.
  • Backups
  • More problems with people connecting to the server
  • Training
  • Status  report!
  • Javascript
    • Got the Local DataSource working with callbacks
    • Commented
    • Working on getting a Java servlet running that will provide JSON data on request.
    • Here’s a page that talks about getting JSON data back from a server.
    • Starting on servlet

Dong Shin 01.02.2014

  • removed Committed Amount/Date from Unclaimed/Claimed Contracts section in Req Info
  • cleaned up Phil’s Test data for Reports queries
    • had to add distinct values from Req Description, Req ID, Req Type, Sub Budget Center Number, Types

Phil 12.31.13

8:00 – 4:00 SR

  • Backups
  • Still having problems with certs. The trust store is correct, so I’m thinking that there may be a machine that is not correctly configured between here and there?
  • Javascript
    • Here’s the DataTable roadmap: https://trello.com/b/fTpWY4oN/datatable-roadmap
    • Data input in a table and in forms.
      • This looks like the semi-official version currently in the gallery: http://yuilibrary.com/gallery/show/datatable-celleditor-inline
        • Which works like a charm.
      • Now I need to grab the events and use them to update the page. Done. Spent a long time looking around for the event. I found it by running the HTML in the debugger, opening the “scripts” tag, and searching through the gallery code for “fire”. Which led me to “cellEditorSave”. Using that to search around the YUI documentation I found that it was listed in the overview document in the above link. Sigh. It’s how you learn, I guess.
    • Data sources for grids and charts.

Phil 12.30.13

8:00 – 11:00 SR

  • Backups
  • Javascript
    • Created a timer callback, modified the dataprovider and re-rendered the chart. Seems to be working fine, with no flicker, even with a 100Msec update rate.

11:00 – 1:00 FP

  • Meeting with Andrea. Looks like uniqueness can be determined by word choice in a corpus as small as 500. That does make things easier. It also allows for triangulation against other metrics, which would allow for looking at accelerometer data from several body positions for example. Though I’m not sure that’s needed.
  • An issue to consider is that people who might use the site would have other examples of their writing. This means that an anonymous source could be identified. As a way around this, a vector-based translation algorithm could be trained using identification code to remove/modify the parts of the user’s language that are identifiable.
  • And actually, this means that I could build a simple website that you train once, then write to. The site then transpiles the user’s words and publishes to twitter or Facebook for example. This just addresses the anonymous part of the problem, not the trustworthiness part, but it’s nice low-hanging fruit.

1:00 – 4:00

  • Javascript
  • Added a datatable, which behaves better. For example, the set() method fires a refresh. Spent the rest of the day trying to get the same behavior with the chart and finally wound up posting on the forums.

Phil 12.27.13

8:00 – 3:00 SR

Yay!

chart1