Dong Shin 04.03.2013

  • wrapped up changes to Budget Info
  • started importing xlsx files
    • as3xls supports only xls files
    • as3-xlsx-reader looks promising – https://github.com/childoftv/as3-xlsx-reader
      • requires fzip – https://github.com/claus/fzip
      • got example to work
      • modifying the example to read the Contracts data
    • created example contracts xlsx file – Contracts Example.xlsx
    • working on File Uploader – http://biemond.blogspot.com/2008/08/flex-upload-and-download-with-blazeds.html
      • got the example to work – both server/client

Phil 4.3.13

8:00 – 4:00 SR

  • Got all the certs incorporated. I should be able to switch over at any time. Might try that on Friday.
  • Helped Chris with his accounts. He needs to change his passwords and attempt to log on to the test and integration servers.
  • Work on the xmlparsers today?
    • There are two problems, one with the hash, and one with components that can be turned on and off
    • If the items in the xml are not in the same order, then the hash will differ, which is bad.
    • The different lengths of xml are due to the the fact that the initial xml is not created by interrogating the display item.
    • Dong suggests the solution is to make the id from only the displayName and yField. That won’t guarantee uniqueness, but it’s close. I could add a validator that checks for a unique displayName too.
    • Yay, that seems to have done the trick. For now. Checking in and burning a new disk for tomorrow.
  • Did you know that JSON has functions? Check this out: http://www.jayway.com/2013/04/01/three-undocumented-features-of-json-3/

Phil 4.2.13

8:00 – 4:00 SR?

  • Spent a long time working through keystore and renewing the sever certs. And then I was informed that server certs could not be renewed, contradicting the email and website instructions that say that they can be renewed. Sigh. More tomorrow.
  • Got the FlexiChart bug fixed. I wound up adding a Hash class to Utils, and calculated a hash based on the string (with id set to -1). An RSHash is then computed based on the XML string and that result is used to set the Id. That ID hangs around long enough to be useful, although it does get recalculated when the values change, so it’s not a permanent ID.
  • Need to add fix from ColumnSeriesConverter to all the other converters.
    • Which also meant adding seriesConfigChanged(seriesConfig) to all the xxxConfig classes and handling that in SeriesConfig.
    • Which also meant handling the initial creation of the id hash in SeriesConfig.addSeries_clickHandler(event:MouseEvent)
    • The initial creation and updates work, but there is a point that the hashes get out of sync. Making the addSeries perform the hash seemed to move the hash downstream one step.
    • Hmmm. Looks like we have a new bug. With an area chart, the item is initially created as
      • <series id=”2387166208″ seriesType=”AreaSeries” displayName=”New Series” form=”segment” fillColor=”0″ fillAlpha=”0.4″ strokeEnabled=”false” strokeColor=”0″ strokeWeight=”3″ strokeAlpha=”1″ yField=”Totals”/>
    • but when “Apply” is clicked, it changes to
      • <series id=”1515104256″ displayName=”New Series” seriesType=”AreaSeries” yField=”Totals” form=”segment” fillColor=”0″ fillAlpha=”0.3″ strokeEnabled=”false”/>
    • Which, naturally enough, leads to a different hash.
    • However, once this makes a “round trip(?)” to TrendWidget, it takes the shorter form and everything works.
  • Need to clean up a lot of debugging statements…

Phil 4.1.13

Classes this morning, so a half day today.

And I think this is my favorite April Fools item, if only for the effort and attention to detail:

1:00 – 6:00 ESSO? (that’s the only option on the timesheet, anyway…)

  • Working on incorporating my fix into the Flexichart codebase.
    • And that turns out not to be the problem at all. The <id=> attribute is getting recalculated on every config. Adding a hash value in to fix that…

Dong Shin 04.01.2013

  • working on changes requested for FinancialAssistant (changed from ProjectManager)
    • adding more info to Budget Info Grid
      • add sub budget center number and namel; database tables, addable CB list.
      • keeping DB changes to DBUpdateEnhancements.sql

Phil 3.29.13

8:00 – 4:00 ESSO

  • Backups
  • Got the PIT Crew wish list from Lenny. Putting all of it in the PPM/PA Req’s page (as a GIANT grid. Sheesh!)
  • Back to debugging Flexichart.
    • Yay – found where the xml isn’t getting updated using the SeriesConfig.subConfig_seriesConfigChangedHandler() method I added. The seriesSubConfig.seriesConfig xml is updating but the config xml isn’t reflecting that change. Now I need to find out why…
    • Have not found out why, but here’s the fix. I’ll put it in SeriesConfig.subConfig_seriesConfigChangedHandler() on Monday:
	var targetId:String = (subConfig).@id;
	var changeTarget:XMLList = config.series.series.(@id == targetId);
	if(changeTarget.length() > 0){
		changeTarget[0] = subConfig;
	}

Phil 3.28.13

8:00 – 4:00

  • Viztool meeting? Waiting for Dong’s paperwork
  • Notes from meeting:
    •  Calculate the BASE (“xxBxxx”) and OCO (“xxJxxx”) using the 3rd letter of the program element. Should be no need to have a button.
    • Program Element -> FACTSPE
    • Center Name -> Budget Center Name
    • Center Number -> Budget Center Number
    • Sub Budget Center Name
    • Sub Budget Center Number
    • Total Budget -> MIPR Amount
    • Make the total “Project Budget” grid so that 10 rows will fit in a 1280 x 1024 display
    • Add validator so that Req Number can have only numbers. No characters, or special characters
    • Remove “Contract” from Clamed and Unclaimed
    • Unclaimed:
      • Change “filter” to “Column Preferences” have all possible columns from Cognos selectable, and reorderable. Of particular importance is Req. Number, which should be a default.
      • “filter” should be search
    • Claimed:
      • Change “filter” to “Column Preferences” have all possible columns from Cognos selectable, and reorderable. Of particular importance is
      • “filter” should be search
    • Project Info:
      • Change “filter” to “Column Preferences” have all possible columns from the project data selectable, and reorderable.
      • “filter” should be search
      • Total Budget -> Req Amount
      • FYXX -> FYXX Req Amount
  • Printed out and signed InfoTek’s NDA for Dong and myself. Handed them to Athena.
  • More bug hunting. I had to restore from the repository last night after managing to break the event connection where a series is selected. Managed to keep the “configSeriesChanged” change to SeriesSubConfig and SeriesConfigEvent. I also changed the “Apply” and “Done” events sot that they call methods rather than launching the events directly. This should allow some space to reassemble the xml if I can’t manage to do it anywhere else.
  • Should we be switching over to MariaDB? It’s the open-source successor to MySQL, run by the original developer (and team). Here’s why.

Dong Shin 03.27.2013

  • prep for Col. Duke’s presentation
  • deployed ProjectManager, looks good
  • working on VSS
    • changed variables_values from TEXT to BLOB
      • ALTER TABLE `table_queries` CHANGE `variables_values` `variables_values` BLOB NULL DEFAULT NULL
    • changed variables_values to macros
      • ALTER TABLE `table_queries` CHANGE `variables_values` `macros` BLOB NULL DEFAULT NULL
    • changed all references to variable/variables to macro/macros
    • modified ScriptFacades to use BLOB – convert String to BLOB to store, BLOB to String to retrieve
    • Using Matcher.quoteReplacement(variableValue) to avoid illegal group errors caused by reserved RegEx characters

Dong Shin 03.26.2013

  • prepping for Col. Duke’s presentation
  • burned a CD for Project Manager dated 03.19
  • trouble-shooting FlexiChart
  • continue working on VSS
    • problem with saving variables xml with sql string – fixed by adding a parameter, xml
    • problem with quotes and single quotes in xml….

Dong Shin 03.25.2013

  • projects in my Flex workspace have disappeared again, ugh!
  • working on variables for VSS’s SQL
    • created a column to store variables in visiblity_scripting.table_queries
      • ALTER TABLE `table_queries` ADD `variables_values` TEXT NULL
    • modified ScriptFacades.dbStoredQuery to look for stored variables and replace with the values stored
    • added ScriptFacades.saveVariables(String, HashMap) to save the variable/value pairs
    • added ScriptFacades.saveVariablesXML(String, String) to save the xml string
    • added new methods to VSS server
    • added variables window in VSS client to view, edit, and save the variables xml string

Phil 3.25.13

8:30 – 4:30

  • The first big snow of the year in in the Spring. So there.
  • A request for my access extension has been submitted. Yay! Nothing on the certs yet though.
  • Sent Thom Lenny’s FY 12 and FY 13 spreadsheets so he can do a pull.
  • Still need to scan and deploy the bug fix from Friday – done.
  • Working on 6 month versions of the FY12 and FY 13 presentations
    • Done with FY12 charts
    • Done with FY13 charts
    • Done with slideshows. Lenny wasn’t in today, so the new data will have to wait until tomorrow.
  • Came into the office to find that my computers were really only partway through their OS updates. And I’m still waiting on my AV software, which is updating as I write this. Sigh.
  • More tracing of the data corruption bug.
  • I am not sure that this isn’t the result of some linking problems. In attempting to step through SeriesConfig, the debugger is getting completely lost.

Phil 3.22.13

8:00 – 4:30 ESSO

  • Asked Chris to renew my access
  • Created 6 month versions of the queries
  • Realized that the trend charts are based on time-specific selections, and that they won’t work with the 6-month rolling window. We are going to have to write a script that updates the dashboard xml to have the correct columns selected
  • Lenny’s chart broke, when pointing back at the 24 month data. To diagnose, we loaded local log and ran again. Something happens after the headers are read in in GenericQueryWidget
  • The values for the config are being changed back at some point. They are ok in ColumnSeriesConfig.commitProperties, but by the time the code hits TrendWidget._flexiChartConfig_configApplyHandler(event:FlexiChartEvent):void, the values are wrong.
  • Burned a new disk for the dateFormatter bug.

Dong Shin 03.21.2013

  • experimented with MySQL’s stored procedure to create 6 month of data for the presentation
    • too complicated and long
  • created a complex python script to generate a SQL that generates FY13 data. After discussing with Phil, it would be better to have SQL Editor/Runner with replaceable variables within the SQL
    • saved off the Python script to 6monthsTest.py