- VizTool status meeting at Fort
- Changed Reported Actual Obligated to Reported FACTS Obligated, no need to update database as of today.
- continue working on Planned Obligation/Outlay Editor
- got edit to work – saves to database!
- moved buttons to the top
- resized the Financial Data Navigator window
- added DropDownList to Status view to filter MIPRs
- still needs filtering
- managed to corrupt the workspace I was using Flash Builder 4.7 with… and couldn’t get 4.7 to start! removed and re-installed, but no luck. going back to 4.6
Phil 2.13.13
7:30 – 3:30 ESSO
- Still feel like crap, though I am now on antibiotics.
- Meetings until noon. Dong is going to handle the Capability Review.
- Changed Reported Actual Obligated to Reported FACTS Obligated in project_portfolio
- Stated digging into YUI. While looking for an IDE, stumbled upon Cloud9 (c9.io), which is a cloud-based IDE developed initially for JavaScript, with jsHint support. Trying out some YUI code from the book. So far, so good! No server side Java support though. Need to see if the code can reach out to a dev server.
Dong Shin 02.12.2013
- working on Planned Values entry
- got UI layout done
- query working!
- trouble-shooting Editing….
Phil 2.12.13
8:30 – 4:30 ESSO
- Was going to go to CASPORT users group, but had to write a status report for Jim G. instead.
- Backups
- More Javascript OO programming today…
- The Yahoo! User Interface (YUI) library was the first to include parasitic combination inheritance in a widely distributed JavaScript library via the Y.extend() method. YUI is a free, open source JavaScript and CSS library for building richly interactive web applications.” Nice documentation and examples…
- And it already has a logging console!
- Jumped ahead to tools and found jshint, which is at http://jshint.com. There is also another lint, JavaScript Lint that runs in windows explorer. it’s here: http://www.javascriptlint.com
- Ok, I think I’m going to try some YUI tutorials. Confident enough to get the Kindle edition of the YUI 3 Cookbook. I need some standalone examples.
Dong Shin 02.11.2013
- bugs
Replace “next incomplete record” tooltip with “next record”Add text following “x of y” at the bottom left to indicate what is being stepped through- Take a look at users table cascading problem
Create a script that deletes all contracts that are not being used- RemoveUnusedContracts.sql in PPM
- Flash Builder 4.6 has been crapping out on me past months continuously giving me various run time errors, ugh! – downloading 4.7 (1GB!) – working better but waiting for a license from Adobe (free upgrade from 4.5, 4.6)
- working on queries to retrieve committed (Funded Budget) for PA
- SELECT bc.*, (SELECT commit
FROM _funding_requests_budget_centers frbc, funding_requests fr, budget_centers bc
WHERE frbc.funding_request_id = fr.uid
AND frbc.budget_center_id = bc.uid AND bc.uid = 18)
FROM budget_centers bc
WHERE bc.uid = 18
- SELECT bc.*, (SELECT commit
- working on queries to retrieve contracts for PA
- SELECT GROUP_CONCAT(c.contract_number)
FROM _funding_requests_contracts frc, funding_requests fr, contracts c, projects p
WHERE frc.funding_request_id = fr.uid
AND c.uid = frc.contract_id
AND fr.project_id = p.uid
AND p.uid = 193
GROUP BY fr.uid
- SELECT GROUP_CONCAT(c.contract_number)
Phil 2.11.13
8:30 – 4:30 ESSO
- Bronchitis. Urk.
- Backups, and some fixing of databases, as well as acknowledging all the alerts. We really need to turn some scripts off tomorrow.
- Showed Carla how the issue was really bad labeling of what the “1 of 4” items actually were.
- Javascript
- So this is how you define an inheritable class:
- Wow – this overwrites the value in the base parent Object, so that every instance of the superclass or subclass now say “foo”:
SubType.prototype.saySuperName = function(){ return "foo"; }; - This appears to be a good way to do inheritance:
//--------- SuperType definition ------------ function SuperType(name){ this.name = name; this.nickName = "None"; this.colors = ["red", "blue", "green"]; } SuperType.prototype.setNickname = function(nickName){ this.nickName = nickName; } SuperType.prototype.sayName = function(){ alert("Name = "+this.name+", Nickname = "+this.nickName); }; //--------- SubType definition ------------ function SubType(name, age){ SuperType.call(this, name); this.age = age; } SubType.prototype = new SuperType(); SubType.prototype.sayAge = function(){ if(this.nickName == "None"){ alert(this.name+" is "+this.age+" years old"); }else{ alert(this.nickName+" is "+this.age+" years old"); } }; //----------- sequential code -------------------- var instance1 = new SubType("Nicholas", 29); instance1.setNickname("Nick"); instance1.colors.push("black"); alert(instance1.name+"'s colors are: "+instance1.colors); //"red,blue,green,black" instance1.sayName(); //"Nicholas"; instance1.sayAge(); //29 var instance2 = new SubType("Greg", 27); alert(instance2.name+"'s colors are: "+instance2.colors); //"red,blue,green" instance2.sayName(); //"Greg"; instance2.sayAge(); //27
Dong Shin 02.08.2013
- PPM
- select contract from funding request data instead of projects data in PPM for the Invoice
- removed from Financial Data Navigator in both status and line item view
- Expenditure Center
- Investment Portfolio
- Program Element
- FACTS PE
- changed Identifier to use MIPR (center_name) in Yearly View
- Reported FACTS Obligated is disabled
- added BETA image to PA
Phil 2.8.13
8:00 – 4:00 ESSO
- Backups.
- There is an issue where an item that is showing up in the Line Item View in PA and the Financial Data Entry view in PPM is not showing up in the Status View in PA. I’ve taken screenshots on what I think all the relavent pages are.
- Turns out that’s a feature. That particular project is complete, and does not remain to fill out. Dong will verify on Mondy, but we’re betting that’s the case.
- Javascript.
Dong Shin 02.07.2013
- updated PPM/PA req’s and bugs and stuff with comments from Chris and Carla
- created a script to update Reported Actual Obliated $: to Reported FACTS Obligated $: in database
- DBUpdateSQLs02072013.sql
Phil 2.7.12
8:00 – 4:00 ESSO
- Backups
- Got comments from Chris and Carla. Handed off to Dong
- Lunch with Diane
- More JavaScript
- Looking at how to implement the Data Dictionary
- Leave promptly at 4:00! Class!
Dong Shin 02.06.2013
- Viz Tool status meeting – notes at PPM/PA req’s and bugs and stuff
- clean up!
- Financial Assistant Specification with Phil
Phil 2.6.13
Phil 2.5.13
8:00 – 4:00 ESSO
- Deployed new Vis2, PPM and PA. Mostly went well, except for one hiccup with the financial_remediation_plans table, that took about an hour of beating on before it submitted to our will
- Walked through the potential architecture for FA with Dong. Now we need to write it up here.
Dong Shin 02.04.2013
- phpMyAdmin has been really slow since I upgraded XAMPP to 1.8.0 which contains a Tomcat instance. Upgrading pmyMyAdmin to the latest (3.5.6) didn’t resolve it.
- Adding $cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’; to config.inc.php (careful with the single quotest!) as suggested at http://ellislab.com/forums/viewthread/224775/ did the trick!
- Changed PPM to require FMP’s on only Obligations and Outlays
Dong Shin 02.01.2013
- cleaned up sql scripts – fixes errors when running stored procedures with temporary/in-memory tables
- figured out how to back up stored procedures, is turned off by default
- mysqldump –routines outputfile
- need to add this to the backup script on site
- working on PPM to have only Obligations and Outlays require FMP’s

You must be logged in to post a comment.