Dong Shin 08.31.2012

• added Document Number in Funding Request Select window
• Two problems reported
  1. SQL Error from Chris Gawdun – old version error, newly deployed PPM has the fix
  2. Sub projects showing 0 for Total Allocated – unable to duplicate here.
• sent updated bugs list that JR maintains – fixed
  • 4. Nothing show under Manage Contracts when you go to the Projects toolbar and then Manage Contracts
    5. There are a few typos in some of the mitigation questions under the OUSD(I) section
    8. Handle Sub__BC problem in BC and scripts
    13. You cannot exit the financial mitigation plans without saving. Someone may just want to cancel without saving
    15. Make the month before the current month highlight pink in the monthly financial data spreadsheet
    16. Make a project past due if data is not entered by the 14th of each month
    17. The invoice form pops up even if the PM actual is zero (in PM, data entry screen)
    18. Allow editing of start year after project creation
    21. Allow editing to end year after project creation
• Trouble shooting Project Mgmt panel not updating correctly after Project save

Advertisements

Phil 8.31.12

8:30 – 4:30 ESSO

• Finally got the new version of PPM deployed. I had put the CD in the wrong machine. Which kind of explains why the old one was showing up. D’oh!
• Data saves.
• Went to talk to Denise P., but she won’t be back until Wednesday.
• New bugs:
  • PA has a SQL error when used by Christine G. I have a print out. It may be the same MySqlIF problem that PPM had. Need to check with Dong.
  • Subprojects are only showing 0.00 for Total Allocated. May have something to do with adding people to the project?
• Adding new Java
• Finished up and committed the fixed version of MavenAssist.

Dong Shin 08.30.2012

• weekly status meeting
• Funding Request save errors – caused by mailing_address_poc_id default set to NOT NULL
  • fixed it on site
    
  • ALTER TABLE `funding_requests` CHANGE `mailing_address_poc_id` `mailing_address_poc_id` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL
• Monthly Financial Datagrid has current month set to 14th day of next month – configurable in setupModel.xml

Phil 8.30.12

8:30 – 2:30 ESSO

• Built and burned new PPM with fixes and scripts
• 10:30 Meeting
• Finish up MavenAssist today? Should just be a matter of seeing why the standalone and the plugin don’t work quite the same way…

2:30 – 4:30 FP

• Qualitative methods, and started thinking about the iRevolution App as my thesis.

Phil 8.29.12

8:30 –  4:30 ESSO

• Meeting with Jessica – here’s the bug list
  • Make the the month before the current month before the current month highlight in the monthly financial data data grids
  • Make a project past due if it is not entered by the 14th of each month (should be a variable in the DB, setupXML or properties)
  • Invoices pop up even if the PM actual is zero (PPM data entry screen)
  • Allow editing of start year after creation of the project, and for the backwards editing of end years
  • Sub-project incomplete status is not calculating correctly for the (parent?) project. A set of sub-projects apparently entered completely over a period of days flag as incomplete.
  • Add Document number (Found in Funding Request-> Finance Data Tab->Document Number field) amount column to Funding Requests table (Projects->Funding Requests->Modify Funding Request). Column replaces Funding type, and should be the second column.
• Plus, there was a DB error ‘Unknown column ‘projects.uid’. It strikes me that we could use an Alert that puts the text into a scrollable panel, where we can ask the user to cut-and-paste into an email.

Dong Shin 08.29.2012

• Bug Fixes
  • enabled Start FY editing on existing projects
  • added SQL Error panel to capture SQL errors for better trouble-shooting
  • disabled Invoice Pop-up when PM Actual is 0
  • set cut-off day of the month is 14th in setupModel.xml
  • fixed SQL error for non-admins on Project Mgmt
• reinstalled Eclipse Juno and plug-ins – Subclipse 1.8 is not compatible with OS X
• minor tweaks to VisibilityScripting4
  • made all debug panel always on top
  • sorted published names in PublishedDataPanel
  • expanded publishedFullNameCombo
• created scripts under src/main/resources/scripts/ in VS4 project
  • to get Current Year Procurement data – Procurement_Data_Current_Year.py
  • to get Current Year RDT&E data – RDT&E_Data_Current_Year.py
  • to get Current Year O&M data – O&M_Data_Current_Year.py
  • to get 2012 O&M data – O&M_Data_2012.py
• query to get O&M(FY10) data with Obligation/Outlay goals
  • SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
    o.type as type,
    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
    UNION
    SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
    ‘Obligation Goal’ as type,
    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 = ‘O&M (FY10)’
    GROUP BY c.uid
    UNION
    SELECT p.uid as project_uid, p.project_number, p.title, c.appropriation, c.center_number, c.center_name, a.year, a.amount,
    ‘Outlay Goal’ as type,
    a.amount * SUM(IF(g.year = 1, outlay_month_1, 0)) / 100 as Oct_2011,
    a.amount * SUM(IF(g.year = 1, outlay_month_2, 0)) / 100 as Nov_2011,
    a.amount * SUM(IF(g.year = 1, outlay_month_3, 0)) / 100 as Dec_2011,
    a.amount * SUM(IF(g.year = 1, outlay_month_4, 0)) / 100 as Jan_2012,
    a.amount * SUM(IF(g.year = 1, outlay_month_5, 0)) / 100 as Feb_2012,
    a.amount * SUM(IF(g.year = 1, outlay_month_6, 0)) / 100 as Mar_2012,
    a.amount * SUM(IF(g.year = 1, outlay_month_7, 0)) / 100 as Apr_2012,
    a.amount * SUM(IF(g.year = 1, outlay_month_8, 0)) / 100 as May_2012,
    a.amount * SUM(IF(g.year = 1, outlay_month_9, 0)) / 100 as Jun_2012,
    a.amount * SUM(IF(g.year = 1, outlay_month_10, 0)) / 100 as Jul_2012,
    a.amount * SUM(IF(g.year = 1, outlay_month_11, 0)) / 100 as Aug_2012,
    a.amount * SUM(IF(g.year = 1, outlay_month_12, 0)) / 100 as Sep_2012,
    a.amount * SUM(IF(g.year = 2, outlay_month_1, 0)) / 100 as Oct_2012,
    a.amount * SUM(IF(g.year = 2, outlay_month_2, 0)) / 100 as Nov_2012,
    a.amount * SUM(IF(g.year = 2, outlay_month_3, 0)) / 100 as Dec_2012,
    a.amount * SUM(IF(g.year = 2, outlay_month_4, 0)) / 100 as Jan_2013,
    a.amount * SUM(IF(g.year = 2, outlay_month_5, 0)) / 100 as Feb_2013,
    a.amount * SUM(IF(g.year = 2, outlay_month_6, 0)) / 100 as Mar_2013,
    a.amount * SUM(IF(g.year = 2, outlay_month_7, 0)) / 100 as Apr_2013,
    a.amount * SUM(IF(g.year = 2, outlay_month_8, 0)) / 100 as May_2013,
    a.amount * SUM(IF(g.year = 2, outlay_month_9, 0)) / 100 as Jun_2013,
    a.amount * SUM(IF(g.year = 2, outlay_month_10, 0)) / 100 as Jul_2013,
    a.amount * SUM(IF(g.year = 2, outlay_month_11, 0)) / 100 as Aug_2013,
    a.amount * SUM(IF(g.year = 2, outlay_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 = ‘O&M (FY10)’
    GROUP BY c.uid

Phil 8.28.12

8:30 – 4:30 ESSO

• Database backups. I could add a script that walks through the directory listing and deletes all files with similar names that are the same size?
• Added the login/password restriction to the ProjPortfolioMgrPreFY13 folder. The information on how to login is on the ROOT/index.html page. At this point, you have to really *want* to use the old db. It’s almost impossible to access by accident.
• Adding browser and manual artifact loading to RepoNav. Browsers are in and load as a sort of failover if the tree can’t load any children. Need to be able to add a text artifact to the dependency tree next. Also I want to be able to show the dependency that’s been selected.
• Looks like this is done using DependencyComponents.setElement() on line 574. I think we can just make a dummy Dom4j Element and then print it to the Text area.

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
  • Actually, no – htaccess works with Apache, but not Tomcat. You have to do something a little more involved. Works though.
• 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.
  • Eclipse Aether?
  • An example from Sonotype.
• 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
  • Looking into using MavenProject to navigate repo1.maven.org
• 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
  • Eclipse Code Recommenders
    • http://eclipse.org/recommenders/
  • Subclipse
  • Maven stuff
    • Maven Integration for Eclipse
    • Apt M2E Connector
    • GWT M2E Connector
    • Maven Integration for Eclipse WTP
  • GWT Plugin
    • https://developers.google.com/eclipse/docs/install-eclipse-4.2

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.