Monthly Archives: January 2014

Phil 1.15.14

8:00 – 4:00 SR

  • Backups
  • Went through the server registration process with Tim E.
  • New swfs for everything
  • We still have the clear problem with Reqonciler
  • It’s possible to loose a floating panel if it’s dragged beyond a certain point.
  • Change Complete/Due/Overdue to look at Planned, Obligated and PM Actuals only
  • JavaScript
    • Turning code into a YUI module. Set up the module and created <div> nodes to attach things to and styled them.

Phil 1.14.14

8:00 – 4:00 SR

  • Backups
  • Tried to ping Tim E. Got ahold of him later. Will call around 8:30 tomorrow to walk through the paperwork.
  • Server paperwork with Bill V.
  • increased storage in MySQL, but we’re still having slow page loads on RA
  • JavaScript
    • Break the ChartWithRemoteData3.html into files. Done, and took a detour into typescript. It’s just not documented well enough with respect to YUI (and it’s not at v1.0 either) to use without a struggle.
    • Tomorrow we’ll try to turn this into a proper YUI module
      • Need to create some additional <div>s for the components to attach too
      • Change the css so that it’s more generic.

Dong Shin 01.13.2014

  • working on adding FMP’s to FA
  • fixed RA throwing exception on refreshing Financial Data
  • experimented MySQL with some different configuration, but no noticeable difference as mine is already quick, but will try on-site tomorrow
    • key_buffer = 16M
      max_allowed_packet = 100M
      table_cache = 64
      sort_buffer_size = 512K
      net_buffer_length = 8K
      read_buffer_size = 256K
      read_rnd_buffer_size = 512K
      myisam_sort_buffer_size = 8M
    • innodb_buffer_pool_size = 16M
      innodb_additional_mem_pool_size = 2M
      ## Set .._log_file_size to 25 % of buffer pool size
      innodb_log_file_size = 5M
      innodb_log_buffer_size = 8M
      innodb_flush_log_at_trx_commit = 1
      innodb_lock_wait_timeout = 50

      key_buffer = 20M
      sort_buffer_size = 20M
      read_buffer = 2M
      write_buffer = 2M

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