8:00 – 4:00 SR

• Backups
• Deployed new versions of FA, RA, and Reqonciler
• Debugged queries with Dong
• Started to write a Cognos fake data generator. This will produce a .sql file containing a set of projects and a series of excel files that will mimic Cognos downloads. The excel files will have errors in them that mimic what we’re finding in the Cognos pulls that Lenny is doing. A text file will also be produced that lists the number and types of errors. THe goal is that Dong should be able to upload the sql files (which will truncate the project tables and reload them) and then ingest (probably 3) spreadsheets. If there are no errors and all the numbers add up correctly, then we have a bug free system. At this point the project and rough framework are done.
  • This looks like a nice api (JExcelApi) and here’s the tutorial.