Category Archives: VISIBILITY

Dong Shin 02.22.2011

  • FGMDEV backups working….
  • PPM
    • rearranging components to support Active Project search…
    • Project filtering query…..
      SELECT p.begin_year, (p.end_year+MAX(a.duration)) as end_year, p.uid
      FROM budget_centers c, projects p, appropriations a
      WHERE c.project_id = p.uid AND c.appropriation = a.type
      GROUP BY p.uid

Phil 2.22.11

9:00 – 6:00VISIBILITY

  • Had a talk with John W last Friday about the increase in hours charged 4 hrs/week to 10 hrs week for catwalk. Told him that I basically couldn’t do the level of support that I had been doing for 45min/day and that I wouldn’t be coming by unless he tells me that there is a problem.
  • Going to try to talk to R through Java today.
  • Found a cool audio synthsizer library for the next hand – https://ccrma.stanford.edu/software/stk/
  • So that I can find this the next time: Webstart, Servlet, IDE, findme!
  • Interviews!
  • Got RServe installed. Going to take a look at interfacing that way.

Dong Shin 02.21.2011

  • FGMDEV Backup – noticed deletion not working properly, modified the script. check tomorrow…
  • PPM
    • Added DataRequestsEmailsWindow, RequestEmailTextHBox to support multiple request email generation from DataRequestPanel
    • continue working on Excel export….

Dong Shin 02.18.2011

  • FGMDEV backup is working… yeah!
  • PPM Changes
    • set dataProviders manually so that filtering doesn’t flicker between all list and filtered list in DataRequestFormWindow
    • filtering added to Users in DataRequestFormWindow
    • Status filtering ComboBox and Description filtering textbox added to DataRequestPanel. This work together as a filtering set.

Phil 2.17.11

7:30 – 4:00 VISIBILITY

  • Meeting with Trish Christie and Leia(?).
    • add “… for the monthly status report deliverable which is due (month) 10th”  to the generated email.
    • Add the ability to sort and filter”Create New Request” panel and “Saved Requests” (project, status, personnel roles. etc)
    • Time that a project should be included in a report request is from the first budget year to the last budget year plus the appropriation period
    • For creating (or adding to?) a request, it may be necessary to look at projects that will become active up to some period in the future, so that as projects become active, they will be included in requests
  • Went over meeting action items with Dong.
  • Based on a conversation with April, I’m looking at developing a Flex GUI interface to R, running on the server and accessed through rJava.
  • Talked to Brian about moving my client schedule from morning to afternoon

Dong Shin 02.17.2011

  • FGMDEV backup working….. check again tomorrow.
  • PPM
    • creating queries for project export…. would like to put all the calculation on queries.
    • got feedback on Data Request
      • moved Users and Project to DataRequestFrom
      • added color-coded status for the Requests
      • added CheckBox filters to show selected/saved users and projects

Phil 2.16.2011

7:30 – 5:30 VISIBILITY

  • Working on setting up a meeting with Christie and Trish to go over Dong’s proposal
  • Showed Dong how to set up the Web Application with server in Eclipse. He thinks that he might be able to make it work with Maven
  • Endless ANOVA
  • Worked a bit on the hand with Tom. Everything seems to be working. Yipee!

Dong Shin 02.16.2011

  • FGMDEV backup still not working
    • tweaked the script to use /exchange/backups directory…
  • PPM
    • server code is out of sync, saved all the changes, rechecked in and out.
    • working on Project export
    • Security error when trying to save Excel file…
      • Error: Error #2176: Certain actions, such as those that display a pop-up window, may only be invoked upon user interaction, for example by a mouse click or button press.
      • for security reason, FileReference.save() must be initiated from a user interaction… Arrrgh!
      • Added Alert to confirm save
    • Changed EdgeUtils.ExportUtils to have an option of saving files with and without header
  • Eclipse and Tomcat server configuration using Maven for Dynamic Web Project
    1. set up your Tomcat server instance within Eclipse IDE
    2. generate Eclipse project settings from the pom.xml you created, the packaging type must be war to use this feature.
      • mvn eclipse:eclipse -Dwtpversion=1.5
    3. web.xml may need some changes as Eclipse complains about the order of elements within <webapp/>. Follow this order….
      1. icon
      2. display-name
      3. description
      4. distributable
      5. context-param
      6. filter
      7. filter-mapping
      8. listener
      9. servlet
      10. servlet-mapping
      11. session-config
      12. mime-mapping
      13. welcome-file-list
      14. error-page
      15. taglib
      16. resource-env-ref
      17. resource-ref
      18. security-constraint
      19. login-config
      20. security-role
      21. env-entry
      22. ejb-ref
      23. ejb-local-ref
    4. add the project to the server by right clicking the Tomcat server in Servers view and selecting Add and Remove in the context menu.
      • got weird errors, “Validation Message” that points to nowhere… no effect on building projects, though.
    5. set a break point, stop and start the server in Debug… now you can debug your Java/Server code!

Phil 2.15.11

7:30 – 4:30 VISIBILITY

  • Deployed Dong’s code. All works well, and we *can* save out excel from Flex!
  • Filed out as much as I could of Brian’s SSP
  • Downloaded the Apache Commons Math library source for conversion to Actionscript
  • Tried the easy way and found a Java to Actionscript converter (J2AS3). It needs some wotk for handling the FastMath class. Before I go in and change it by hand, I may try to improve the parser.
  • More ANOVA

Dong Shin 02.15.2011

  • FGMDEV backup still not working
    • put absolute paths in the script
  • PPM
    • continue working on Data Requests – primary functions added
      • create and save requests by selecting users and projects
      • update requests – change status, description, month, and year
      • added textArea for email
      • printed screenshots for review

Phil 2.14.11

7:30 – 5:30 VISIBILITY

  • Found a problem with Flash Player dealing with debug statements. It’s covered here, but the gist of it is that the non-debug version of Flash Player seems to choke on debug statements – at least Error.getStackTrace() (not sure about trace().
  • Adding Randomized ANOVA to stats package. It turns out that CMM is trying to have a measure of confidence in their presentation of data but they don’t have a good statistical basis for making the call. How convenient 🙂
  • Testing Dong’s new PPM and hopefully burning a disk.
  • Had a grand time figuring out what’s up with flash debuggering.
  • Added the following to the FGMUtils pom file to get our compiler flags in. It looks like this:

<plugin>
<groupId>org.sonatype.flexmojos</groupId>
<artifactId>flexmojos-maven-plugin</artifactId>
<version>3.8</version>
<extensions>true</extensions>
<dependencies>
<dependency>
<groupId>com.adobe.flex</groupId>
<artifactId>compiler</artifactId>
<version>4.0.0.14159</version>
<scope>compile</scope>
<type>pom</type>
</dependency>
</dependencies>
<configuration>
<definesDeclaration>
<!–  this is the command line: define=CONFIG::debugging,true -define=CONFIG::release,false –>
<property>
<name>CONFIG::debugging</name>
<value>true</value>
</property>
<property>
<name>CONFIG::release</name>
<value>false</value>
</property>
</definesDeclaration>

</configuration>
</plugin>

Dong Shin 02.14.2011

  • FGMDEV backup still not behaving
    • created a separate script that dumps database an hour before the ftp transfer….
  • PPM Changes
    • added Export testing button for Project Mgmt Panel for Beta only….
    • added email, phone/fax to MIPR Request Form
    • uploaded the latest PPM for release/testing to /exhange/PPM_021411
    • working on email request generator
      • created data_requests table
      • created _data_requests_projects table
      • created _data_requests_users table
      • set up relations between tables

Dong Shin 02.11.2011

  • PPM Changes
    • Working on data email generator
    • Working on a sandbox app to save datagrid data to excel file – donefla
    • added a test button to Project Mgmt to test exporting – works!
    • added ExportUtils to EdgeUitls
    • deployed com.as3xls.as3xls:1.0:swc to FGMDEV Nexus
      • <dependency>
        <groupId>com.as3xls</groupId>
        <artifactId>as3xls</artifactId>
        <version>1.0</version>
        <type>swc</type>
        </dependency>
  • Flash running at the site is v10.0

Phil 2.11.11

7:30 – 3:00 VISIBILITY

  • It looks like the customer uses Flash 10. Not sure about the exact version.
  • Interview with Phillip Tomlin.
  • Sank into a Friday stupor and was unable to get anything substantial working.

Dong Shin 02.10.2011

  • while searching for ways to save PPM data into excel format, found
  • PPM Changes
    • saving database changes to DBUpdateSQLs02102011.sql
    • Funding Request Changes
      • larger mailing address POC
      • added email and phone/fax for mailing address POC
      • two more fields to funding_requests table – mailing_address_email and mailing_address_phone
        • ALTER TABLE `funding_requests` ADD `mailing_address_email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `mailing_address` ,
          ADD `mailing_address_phone` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `mailing_address_email`
      • removed Contracts from Reimbursable
      • Add Contract added to Direct Cite window
      • added a new field to contracts table
        • ALTER TABLE `contracts` ADD `ACRN` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `contract_number`
      • remove all, but FY and Budget Center in BudgetCentersWindow for Financial Status
    • working on a pivot query to return financial data for selected project, month, year
      • find all first month data for year 2011 from projects and obligations_outlays tables
        SELECT year, project_id, year_count,
        GROUP_CONCAT(IF(type=’Planned Obligated $:’, month_1, NULL)) AS ‘Planned Obligated $:’,
        GROUP_CONCAT(IF(type=’Reported Actual Obligated $:’, month_1, NULL)) AS ‘Reported Actual Obligated $:’,
        GROUP_CONCAT(IF(type=’Planned Outlay $:’, month_1, NULL)) AS ‘Planned Outlay $:’,
        GROUP_CONCAT(IF(type=’Reported Outlay $:’, month_1, NULL)) AS ‘Reported Outlay $:’,
        GROUP_CONCAT(IF(type=’PM Actuals Outlay $:’, month_1, NULL)) AS ‘PM Actuals Outlay $:’,
        GROUP_CONCAT(IF(type=’Outlay $ (Reported in FACTS)’, month_1, NULL)) AS ‘Outlay $ (Reported in FACTS)’,
        p.*
        FROM obligations_outlays o, projects p
        WHERE year = 2011 AND year_count = 1 AND o.project_id = p.uid
        GROUP BY year_count, year, project_id
        ORDER BY project_id, year