Dong Shin 04.12.2013

  • deployed the new PPM, PA, and FA
    • problem with VersionTracker not creating database
    • max_allowed_packet option need to back up the visibility_scripting database
    • Lenny’s contracts data ingested successfully – ~488 rows
  • continue working on FA
    • added comments to Budget Center table
      • ALTER TABLE `budget_centers` ADD `comments` TEXT NULL
    • removed Funding Type, Org, Location from Budget Center

Phil 4.12.13

8:00 – 3:30 SR

  • Tried out FA and version tracker. VT is not creating tables, but we don’t know why. Need to add some tracking.
  • Found out that the backup of visibility_scripting.sql was corrupted because the packet size was too small. Wound up using the –max_allowed_packet=512M argument as shown here.

Phil 4.11.13

8:00 – 3:00 SR

  • Backups
  • There seems to be a problem with PA: “February in VizTool is showing ‘overdue’ If everyone input their data for Feb shouldn’t it be March that’s overdue?” – Heidi. Lenny also had the same problem. I’ll bring a printout of the entire email.
  • Make AS3 version tracker
  • Start on script(?) to convert months for slide show. I’m guessing python. But since we’re adding server side code this time anyway, we might want to add a way for the scripting system to insert a ‘visibility_dev2″ table to bypass the ingestor. This means managing roles, users and ingest(?) tables.

Dong Shin 04.10.2013

  • finished FA server coding of checking for duplicates of COGNOS contracts data….
    • a SQL PrepareStatement trick to check for null values by binding NULL
      • (? IS NULL AND budget_center IS NULL) OR (budget_center = ?)
  • tested ingesting 7500 rows at a time… no isssues running on localhost…
  • added contracts_cognos_history table to database to keep track of upload history
  • added last uploaded info label to Project Editor
  • integrated the new VersionTracker to PA!!!

Phil 4.10.13

8:00 – 4:00 – SR

  • Sleepy – went to see Marc Broussard last night. Got to sleep after midnight and up at 5:45. Ow.
  • Backups.
  • Start moving VersionChecker to a component. Done. Added it to FGMFlexUtils45
  • Next, let’s add this to EdgeUtils.
  • Dong has incorporated VersionChecker into PA, and we have a disk full of installs for tomorrow.

Phil 4.9.13

7:30 – 4:30 SR

  • Imported new FA
  • VizTool Review (More notes in Req’s & Bugs & Stuff)
  • And now I can’t put my bike in the basement hallway. Gonna try the gym, which I thought would cause complaints. People don’t seem to like bicycles here.
  • Got the logic working on the test and updates. Now I just need to package and make versions for 3.x and 4.5+

Phil 4.8.13

8:00 – 4:30 SR

  • Someone stole my last few teabags! Trader Joe’s today…
  • Backups – done
  • Prep for review tomorrow
    • Get demo-able version of VersionTracker
    • Status report
    • Burn Dong’s system for deployment on integration server
  • Spent the entire morning trying to get the DbObjectTestbed server running in Eclipse. It was working just fine when I turned off the machines for the weekend.
    • Committed my code changes and reloaded the project – nothing
    • Did notice that the properties might be corrupted. I could not edit some of the properties tabs.
    • Added JavaUtils as a project that DbObjectTestbed depended on. That forced a rebuild, which placed the .class files I needed in the Tomcat directory.
    • Rebuilt and deployed the VersionTrackerTest Flex project, and after a hiccup (I’m assuming the server was still coming up), everything is now working. Well, sort of. I have to stop the server, rebuild the Java code then restart the server for the classes to get updated in the webapps directory.
  • Working on getting a very finicky Date.parse() to work properly so that the milliseconds since the code was compiled to assemble properly.

Dong Shin 04.05.2013

  • continue working on Contracts Parser
    • cellIterator cannot be used to get NULL cells, ugh!
    • copied ProjPortfolioMgr to FinancialAssistant project
    • server side looks complete
    • created ContractsParserWindow for reviewing the data
    • saving contracts and vendors work!
  • add following code snippet to enable log4j in java applications…
    • Properties logProperties = new Properties();try {logProperties.load(new fileInputStream(“src/main/webapp/WEB-INF/classes/log4j.properties”));PropertyConfigurator.configure(logProperties);

      } catch (IOException e) {

      throw new RuntimeException(“Unable to load logging property”);

      }

Phil 4.5.13

8:00 – 4:00 SR

Dong Shin 04.04.2013

  • went to Fort, no meeting…..
  • continue working on XLSX uploader – done
  • working on XLSX parser (Server) for contracts

Phil 4.4.13

7:30 – 3:00 SR

  • Thought there was a meeting today, but nope.
  • Deployed the new vis2.swf, which seems to be working fine.
  • Approved Chris so that he can see the SSP. Funny.
  • Looks like these are the guys -http://www.vsi-corp.com/