Dong Shin 08.14.2012

spent some time at Fort preparing for Col. Duke’s presentation
- alerts when a PM Actuals have stayed the same from one month to the next
- alerts when COGNOS data (for a specific PFR or grouping of funding (budget centers)) has stayed the same from one month to next
- add FMP to CurrentStatus.py
  - add this query to
  - SELECT o.uid, fmp.uid, fmp.obligation_outlay_uid
    FROM obligations_outlays as o
    LEFT OUTER JOIN financial_mitigation_plans as fmp ON o.uid = fmp.obligation_outlay_uid
    GROUP BY o.uid
VisibilityScripting bugs
- scripts are not deleted by delete button
- scripts persists after they are delete in the DB
checked in the latest VSS code that had delete script support

Phil 8.13.12

8:00 – 4:30 ESSO

Put in the cleaned-up scripting client. Much faster. It’s still slow when it downloads published data. Need to look into that.
Need to add a warning dialog to AccountManager that warns to rebuild roles when roles are deleted. Had a fright with that today.
- Working on getting the Alert listener to behave…
Put together slide show with Jessica. Need to add some scripts tomorrow to fill out presentation

Phil 8.10.12

8:30 – 5:00 ESSO

Gave Jim Griffie the writeup on why we need at least 2.5 FTE on VISIBILITY
Jessica found a bug (or at least, something bug-ish). If an invoice has a zero value, it still saves.
Redid the VISIBILITY website to behave more in line with the way that people use it, and to add Account Manager.
Reworked VSS so that there are fewer requests of the server at login. Also fixed a bunch of formatting problems. It turns out that a ResizeEvent won’t cause the vertical resize to occur on a Spark form. I had to go back to mx:Form to make resize work properly.
sent a note about my SSBI

Phil 7.9.12

8:00 – 5:00 ESSO

Dong says that the problem was that ‘courier’ isn’t available of windows. You have to use ‘courier_new’. That does explain why everything was working, yet not working…
Weekly meeting
Jessica and I have XACTA accounts now, but with read only roles. Denise is going to work on this.
One more training down, about three to go.
Writing up a justification for more than one FTE after October 1. Instead of doing FTE work.
Burning a new copy of VSS4 now that the font problem has been licked.
Wrote up a screed on VISIBILITY staffing for Jim Griffie

Dong Shin 08.09.2012

weekly status meeting at Fort
added Courier New font to the PrettyTextEditor in VSS4, using it in .css file would not work for Windows. It took me a while to figure that out?

Phil 7.8.12

8:30 – 4:30 ESSO

The contractors punched a hole in my roof today. Got to see the neighborhood from waaay up high. Pretty cool.
Backups
Denise is going to put Jessica and I in for xacta(?) accounts
Made progress through the yearly training. Funny thing, after I started, I could hear someone else doing theirs as well. Need to bring in earphones though – it’s a noisy office.
Need to burn some images for Brian.
Need to fix the VISIBILITY website. People are interacting with the links wrong, so I’m going to change the links to make the pages match the actions. I’m installing Adobe Creative Suite so that I can use the project. I wonder if Coldfusion can check out from subversion? Nope.
Checked out Visibility from Documentation. Going to try DreamWeaver on it.
I think I opened the correct project, but it does have some Ipsum Lorem in it…
Highlighted fields for PPM and PA should reflect that users are entering data for the previous month. “Past Due” should reflect the 10th day (possibly the 17th) in PA
Working on VSS4, trying to figure out why the fon’t isn’t courier. It comes in OK, just is never set in PrettyTextEditor.as. Wondering if ApplyFormatOperation is the culprit? I think I may need to build a small sandbox project to try out.

Dong Shin 08.08.2012

changed VisibilityScripting4 to embed AS3Dictionary.xml and SmartEditor.css
fixed FlexUtils not showing Compilation Date correctly
working on users’ project status script…
- query to return all project mgrs with overdue data
  - created CurrentMonthOverdueUsers.py – in VS4 resources/scripts directory
  - SELECT m.login as user_login, p.project_number, p.description, a.amount, o.uid, o.type, o.year, o.year_count,
    o.month_11 as ‘Aug’
    FROM projects p, budget_centers c, budget_amounts a, obligations_outlays o, _projects_service_project_mgrs m
    WHERE p.uid = c.project_id
    AND a.budget_center_id = c.uid
    AND a.year = 2012 – p.begin_year + 1
    AND o.project_id = p.uid
    AND o.funding_id = c.uid
    AND o.year + o.year_count – 1 = 2012
    AND o.year_count = 1
    AND ISNULL(o.month_11)
    AND p.uid = m.project_id
    UNION
    SELECT p.proj_mgr_login as user_login, p.project_number, p.description, a.amount, o.uid, o.type, o.year, o.year_count,
    o.month_11 as ‘Aug’
    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 a.year = 2012 – p.begin_year + 1
    AND o.project_id = p.uid
    AND o.funding_id = c.uid
    AND o.year + o.year_count – 1 = 2012
    AND o.year_count = 1
    AND ISNULL(o.month_11)
    AND NOT ISNULL(p.proj_mgr_login)

Phil 8.7.12

8:00 – 2:00 ESSO

Made backups
Looks like the test plan is good enough for Vern. Jessica is sending it off to Denise
New data uploads on Friday. We’ll see how the reports look
Finished with scroll bars in SeriesConfigBase.
Wrote up monthly status report

2:00 – 6:00 FP

Bringing the prototype to PAD meeting
Demo went well – Shawn thinks that the “sensorator(?)” “haptor(?)” (sensor/actuator) might be the best thing to build the paper out of. The trick would be to show a bunch of uses and focus more on the driver(s).

Dong Shin 08.07.2012

added “No Email” for the users with no email address when generating Financial Data Request
removed EdgeUtils from VisibilityScripting4
working on query to generate user, project, description, status, and month (for the last 4 months maybe?) as rows
- query to extract current year and fiscal month
  - SELECT DATE_FORMAT(CURRENT_DATE(), ‘%Y’) as year,
    IF(DATE_FORMAT(CURRENT_DATE(), ‘%m’) – 9 < 1,
    DATE_FORMAT(CURRENT_DATE(), ‘%m’) + 3, DATE_FORMAT(CURRENT_DATE(), ‘%m’) – 9 ) as month
- query to find missing August entries
  - SELECT p.begin_year, a.*, o.uid, o.type, o.year, o.year_count,
    o.month_11 as ‘Aug’
    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 a.year = 2012 – p.begin_year + 1
    AND o.project_id = p.uid
    AND o.funding_id = c.uid
    AND o.year + o.year_count – 1 = 2012
    AND o.year_count = 1
    AND ISNULL(o.month_11)
    AND p.uid = 99

Phil 8.6.12

8:00 – 4:00 ESSO

Tried out the test plan that JR and I put together last Friday. It went well, and she’s going to see how Vern wants it integrated into the actual test plan
It looks like that the email-based system will be used for about 14 of the PMs until they are able to connect to the VisTool. So that means that we need to tweak that part of the tool
- All emails for a peorson should be listed in the “cut and paste” email that’s generated. If there is no email in a particular field, then it should probably read “unset” rather than blank or some unprintable character, which is what’s happening noe.
- August is misspelled.
- We need to write a script that produces a table with user, project, description, status, and month (for the last 4 months maybe?) as rows. This will let us produce reports in VISIBILITY.
Back to putting in help/guidance in FlexiChart. Done!
- Add scrolling frame for series manipulation

Dong Shin 08.06.2012

added ChangeLogs panel to keep track of change/fixes to PPM – Moved to EdgeUtils
fixed typo for Auguest in PPM
working on configurable line items for Monthly Financial Data

Dong Shin 08.03.2012

added the revised questions for the Financial Mitigations Plan
fixed typos in the FMP
fixed Contract Window not showing contracts
clean database set up for PPM src/main/resources/database/project_portfolio_clean.sql
went over the database structure to clean up relations – src/main/resources/database/DBUpdateSQLs08032012.sql
fixed Project Mgmt permissions not behaving correctly
fixed logging out messing up panels states
fixed services filter not working

Phil 8.2.12

8:30 – ESSO

10:30 Weekly Meeting
1:00 Test plan walk through. Well, that didn’t go well, in that it was a cut-and paste job from the manual and not a test plan at all. Will start writing an actual plan tomorrow.
Installed Flashbuilder 4.5 from disk. That appears to have fixed my particular problem.

Instructions
use this panel to set up properties that apply to the entire chart

X-Axis Field: Determines which row will be used to provide the labels for the X-axis in the chart. This will need to be adjusted only very rarely.
Base at Zero. Plots values relative to zero. If more range is needed, uncheck, and results will be plotted so that the lowest value is on the X-axis
Legend Enabled: Shows a legent identifying the chart components
Legend Position: Lets you select between a legend placed at the bottom of the chart or to the right

}

Phil 8.1.12