Author Archives: pgfeldman

Dong Shin 08.27.2012

  • updated database on site for 2013 data
  • fixed Project deletion errors by removing foreign keys on _projects_portfolio_admins table
  • Jessica reported
    • Funding Request Save errors – suspecting some invalid characters, but could not resolve it over the phone. more information needed
    • Total Allocated Budget is needed in addition to the Total Budget – added to Project Management Panel
      • SELECT p.*, p.uid as ID, p.project_number as ‘Project ID’, p.title as ‘Project Name’, begin_year as ‘Start FY’, end_year as ‘End FY’, begin_year as startYear, IF(ISNULL(lock_id), if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’),
        IF (lock_id=’projportfolio’, if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), ‘LOCKED’)) as Status,
        (end_year – begin_year) as duration, services, p.total_budget as ‘Total Allocated’, sub.project_id as parent_project_id, sub.sub_project_id,
        SUM(IF(ISNULL(t.budget_amount), 0, t.budget_amount)) as ‘Total Budget’
        FROM projects p
        LEFT JOIN _project_sub_projects as sub ON p.uid = sub_project_id
        LEFT OUTER JOIN yearly_totals AS t ON p.uid = t.project_id
        GROUP BY p.uid

Phil 8.27.12

8:00 – 4:00 ESSO

  • Backed up all the databases
  • created a new project_portfolio_preFY13 database
  • Copied over ProjPortfolioMgr to ProjPortfolioMgrPreFY13
  • changed all the .settings and assets files to point at the proper endpoints and databases
  • ran Dong’s scripts, which created the FY13-only db
  • Still need to setup .htaccess
  • There is some problem with storing SOW info, possibly tied up with special characters. They are trying to fax over the error message, but the technology is not cooperating. Verified that the fax was running and online on our side.
  • Now that I know that the browser control works, I need to integrate it  an then start parsing the html that it stores.
  • New version of GWT in Action is in the Exchange folder on fgmdev.
  • Burning a disk for tomorrow.

Dong Shin 08.24.2012

  • Jessica reported that she couldn’t delete projects – found too many foreign keys on _projects_portfolio_admins
    • need to remove by ALTER TABLE _projects_portfolio_admins DROP FOREIGN KEY <KEY_NAME>
  • starting fresh on Flex Projects with the SVN repo – done
  • query to retrieve O&M (FY10) data for 2012
    • SELECT p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      o.uid, o.type, o.year, o.year_count,
      IF(o.year_count = 1, month_1, 0) as Oct_2011,
      IF(o.year_count = 1, month_2, 0) as Nov_2011,
      IF(o.year_count = 1, month_3, 0) as Dec_2011,
      IF(o.year_count = 1, month_4, 0) as Jan_2012,
      IF(o.year_count = 1, month_5, 0) as Feb_2012,
      IF(o.year_count = 1, month_6, 0) as Mar_2012,
      IF(o.year_count = 1, month_7, 0) as Apr_2012,
      IF(o.year_count = 1, month_8, 0) as May_2012,
      IF(o.year_count = 1, month_9, 0) as Jun_2012,
      IF(o.year_count = 1, month_10, 0) as Jul_2012,
      IF(o.year_count = 1, month_11, 0) as Aug_2012,
      IF(o.year_count = 1, month_12, 0) as Sep_2012,
      IF(o.year_count = 2, month_1, 0) as Oct_2012,
      IF(o.year_count = 2, month_2, 0) as Nov_2012,
      IF(o.year_count = 2, month_3, 0) as Dec_2012,
      IF(o.year_count = 2, month_4, 0) as Jan_2013,
      IF(o.year_count = 2, month_5, 0) as Feb_2013,
      IF(o.year_count = 2, month_6, 0) as Mar_2013,
      IF(o.year_count = 2, month_7, 0) as Apr_2013,
      IF(o.year_count = 2, month_8, 0) as May_2013,
      IF(o.year_count = 2, month_9, 0) as Jun_2013,
      IF(o.year_count = 2, month_10, 0) as Jul_2013,
      IF(o.year_count = 2, month_11, 0) as Aug_2013,
      IF(o.year_count = 2, month_12, 0) as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays o
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND c.uid = o.funding_id
      AND o.year = 2012
      AND c.appropriation IN (SELECT type FROM appropriations WHERE duration = 2)
      GROUP BY o.type, c.uid
    • SELECT p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
      a.amount * SUM(IF(g.year = 1, obligation_month_1, 0)) / 100 as Oct_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_2, 0)) / 100 as Nov_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_3, 0)) / 100 as Dec_2011,
      a.amount * SUM(IF(g.year = 1, obligation_month_4, 0)) / 100 as Jan_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_5, 0)) / 100 as Feb_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_6, 0)) / 100 as Mar_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_7, 0)) / 100 as Apr_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_8, 0)) / 100 as May_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_9, 0)) / 100 as Jun_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_10, 0)) / 100 as Jul_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_11, 0)) / 100 as Aug_2012,
      a.amount * SUM(IF(g.year = 1, obligation_month_12, 0)) / 100 as Sep_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_1, 0)) / 100 as Oct_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_2, 0)) / 100 as Nov_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_3, 0)) / 100 as Dec_2012,
      a.amount * SUM(IF(g.year = 2, obligation_month_4, 0)) / 100 as Jan_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_5, 0)) / 100 as Feb_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_6, 0)) / 100 as Mar_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_7, 0)) / 100 as Apr_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_8, 0)) / 100 as May_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_9, 0)) / 100 as Jun_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_10, 0)) / 100 as Jul_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_11, 0)) / 100 as Aug_2013,
      a.amount * SUM(IF(g.year = 2, obligation_month_12, 0)) / 100 as Sep_2013
      FROM `projects` p, budget_centers c, budget_amounts a, obligations_outlays_goals g
      WHERE
      p.uid = 176
      AND p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND p.begin_year + a.year = 2013
      AND g.appropriation = c.appropriation
      AND c.appropriation IN (SELECT type FROM appropriations WHERE duration = 2)
      GROUP BY c.uid

Phil 8.24.12

8:30 – 4:30 ESSO

  • Deployed the new version of PA and it’s associated Remote Objects
  • Found a new bug where a foreign key is interfering with the deletion of a project. Made a printout of the error for Dong.
  • Working more on learning and using MavenProject.
  • Trying a cheat. Rather than using the seriously complex maven tasks, I’m trying the SWT browser. That gives me access to the generated HTML, which I can then pull the appropriate DIV from. This appears to be what I’m looking for:
  • <div id="browsePage">
        <div class="pageContent">
            <div id="browseHeader">The Central Repository Browser</div>
                <div id="browseResult">
                    <div id="browseDocs"><div><h3 style="float: left;">Index of </h3><h3 id="browsePath" title="Click to enter path..."><a onclick="return BrowseManager.createHistoryAndLoad(true, '47');" href="#browse%7C47">central</a>/<a onclick="return BrowseManager.createHistoryAndLoad(true, '-1144916964');" href="#browse%7C-1144916964">HTTPClient</a>/<img src="ajaxsolr/images/editpen.png"></h3></div><table id="browseResultTable"><thead><tr><th>Name</th><th>Last Modified</th><th class="number">Size</th></tr></thead><tbody><tr class="d0"><td><a onclick="return BrowseManager.createHistoryAndLoad(true, '47');" href="#browse%7C47">../</a></td><td></td><td></td></tr><tr class="d1"><td><a onclick="return BrowseManager.createHistoryAndLoad(true, '-160590208');" href="#browse%7C-160590208">HTTPClient/</a></td><td>04-Jan-2007</td><td class="number">717.8 K</td></tr></tbody></table>
                    </div>
               </div>
          </div>
    </div>
  • Need to install the changelog in the apps I’m responsible for.

Dong Shin 08.23.2012

  • Added ChangeLogsPanel to EdgeUtils and FGMFlexUtils45
    1. define logs file in main application – <mx:XML id=”logsXML” source=”/assets/changeLogs.xml” /> or <fx:XML id=”logsXML” source=”/assets/changeLogs.xml” /> for Flex 4
    2. pass the logs file to the panel – logsXML = {logsXML} on the ChangeLogPanel
  • added FGMFlexUtils45’s ChangeLogPanel to ProjectAssistant
  • 10:30 status meeting
  • removed FAD from MIPR/FAD wording in Funding Request (per JR’s request)
  • fixed some Funding Request bugs resulted from the database changes (projects table)

Phil 8.23.12

8:00 – 4:00 ESSO

  • More repo navigation. Done and deployed as Version 1.9.2.14
  • Had some thoughts about an ‘assistive slider’ that might be a good thing to use in an upgrade of IngestManager
    • Slider brings up an associated window, kind of like code complete in Eclipse. Clicking in that window allows further interaction?
    • A slider could go from “Easier” to “More Secure” on how the data is ingested. Easier maps to “Publish” at the lowest level Roles. “More Secure” maps to private. Choices in the middle are explained in the associated window.  Custom variants on the ‘default’ option can be managed within the window.
  • Status meeting at 10:30
    • Status report
    • Some bugs came up that we’re working on. Also we committed to rolling out the FY13 change on Monday

Dong Shin 08.22.2012

  • FGM mail and timecard down today
  • created a SQL script to clean out PPM database to be used for setting up for ’13 data – DBClean.sql
  • IngestManager Errors at site
    • com.edgeti.VisibilityServer.Database.databaseIf.SQLError (DatabaseIf.java:108)
    • Data truncation: Data too long for column ‘FMP’ at row 1 (INSERT INTO…)
    • I believe this is cause by string too long for the database column type String
  • updating Eclipse to 4.2 Juno

Phil 8.22.12

Phil 8:30 – 4:30 ESSO

  • My cat, Andy made it back home after vanishing Sunday evening. He was not doing well and spent the night at the vet, getting a transfusion, antibiotics and ultrasound. More tests today.
  • Did the regular backups and talked to Jessica, who said the new code and DB was behaving itself.
  • Got permission to create the new FY13 db. We’re aiming for Monday.
  • Working through GWT in Action.
  • Installed Eclipse 4.2 – Juno
    • And Subversion
      • Downloaded and compiled JavaUtils and MavenAssist.
    • And Google Plugin
    • And MavenAssist
      • Which has some bugs in the repo browser. Fixing those
        • Fixed environment variable substitution in the conf/settings.xml file
        • Need to strip off the entire leading part of the tree if it’s there. Sometimes nexus doesn’t make relative hrefs.

Dong Shin 08.21.2012

  • attempted to deploy new PPM/PA with the database updates removing users in projects table that resulted in confusion….
    • ALTER TABLE projects DROP proj_mgr_login
    • ERROR 1025 (HY000) : Error on rename of ‘.project_portfolio#sql-6f4_5f3a’ to ‘.project_portfolioprojects’ (errno: 150
    • this is cause by existing foreign key set up on the column and command line solution is
      1. show create table projects;
      2. remove all the foreign keys by ALTER TABLE `projects` DROP FOREIGN KEY `projects_ibfk_7` ;
  • added Change Password capability to PA and PPM server
    • modified LoginScreen.mxml to have changePassword states and associated text fields/validators
    • added changePassword method to PPMUserService.java

Phil 8.21.12

8:30 – 2:30 ESSO

  • Rolled out the new DB change that allows single and multiple users (PMs, Admins, etc) to be listed in a single table, and thereby create better charts. It was exciting, and we seem to have broken the MySQL instance a little, but everything is working.
  • Sent Tom D. a copy of the UIST white paper for Novetta to mull over.
  • Created a disk of my workspace with the most recent versions of all the code and Maven. I need a DVD for the repo, so that will wait until tomorrow.
  • Starting on GWT In Action again.

2:30 – 4:30 FP

  • PAD meeting.

Phil 8.20.12

8:00 – 4:30 ESSO

  • Backups and such
  • Did some updating as well, or more specifically looked into why updating wasn’t(?) straightforward.
  • Working from home as I wait for the AC guy.
  • Installing FB4.5
    • Main install complete
    • Getting subversion
    • rebuilding my local maven repo
    • Could not get the projects to build. Need to see what’s going on at the Mill, maybe burn the entire workspace and compare.
  • Installing MSVC 2010
    • Done – downloading FP project to verify everything’s working
    • Had to re-point to the same projects (in the *exact* same places, mind you). But all is compiling.
    • The texture and shader folders were not up-to-date. Had to do some scrambling.

Phil 8.17.12

8:00 – 2:30 ESSO

2:30 – 4:00 FP

  • 3:15 Meeting with Dr. Kuber to discuss research opportunities for the interface device

Dong Shin 08.17.2012

  • working at home
  • removed all logins in projects to use relation tables (_projects_…. tables)
    • DBUpdateSQLs08172012.sql
  • changing PPM code to reflect the above
    • save/update projects
    • modified Monthly Financial Data to include the first PM and Admin
    • modified SelectProjectWindow to include the new schema
    • modified PA to work with new table structures

Dong Shin 08.16.2012

  • working at home
  • query to get projects that has same value in previous months
    • SELECT p.project_number, p.title, p.proj_mgr_login,
      c.uid, c.center_number, c.center_name, c.appropriation,
      a.year, a.amount,
      o.*
      FROM projects p,
      budget_centers c,budget_amounts a,obligations_outlays o
      WHERE p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND o.project_id = p.uid AND c.uid = o.funding_id AND o.year_count = a.year
      AND ((o.month_1 = o.month_2 AND NOT ISNULL(o.month_1))
      OR (o.month_2 = o.month_3 AND NOT ISNULL(o.month_2))
      OR (o.month_3 = o.month_4 AND NOT ISNULL(o.month_3))
      OR (o.month_4 = o.month_5 AND NOT ISNULL(o.month_4))
      OR (o.month_5 = o.month_6 AND NOT ISNULL(o.month_5))
      OR (o.month_6 = o.month_7 AND NOT ISNULL(o.month_6))
      OR (o.month_7 = o.month_8 AND NOT ISNULL(o.month_7))
      OR (o.month_8 = o.month_9 AND NOT ISNULL(o.month_8))
      OR (o.month_9 = o.month_10 AND NOT ISNULL(o.month_9))
      OR (o.month_10 = o.month_11 AND NOT ISNULL(o.month_10))
      OR (o.month_11 = o.month_12 AND NOT ISNULL(o.month_11)))
  • no 10:30 meeting
  • created script to generate project data that has same value as previous months – src/main/java/resources/scripts/EqualMonths.py
    • working on passover years
  • need to clean up associated managers in projects, move all the managers to separate table and remove the fields in the projects table