- 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.uidFROM budget_centers c, projects p, appropriations aWHERE c.project_id = p.uid AND c.appropriation = a.typeGROUP BY p.uid
Category Archives: VISIBILITY
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
- set up your Tomcat server instance within Eclipse IDE
- 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
- web.xml may need some changes as Eclipse complains about the order of elements within <webapp/>. Follow this order….
- icon
- display-name
- description
- distributable
- context-param
- filter
- filter-mapping
- listener
- servlet
- servlet-mapping
- session-config
- mime-mapping
- welcome-file-list
- error-page
- taglib
- resource-env-ref
- resource-ref
- security-constraint
- login-config
- security-role
- env-entry
- ejb-ref
- ejb-local-ref
- 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.
- 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
- continue working on Data Requests – primary functions added
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
- needed some changes to pom.xml files in both PPM and EdgeUtils to specify Flash Player v10.0
- https://docs.sonatype.org/display/FLEXMOJOS/How+To+Specify+Flash+Player+Target+Version
-
ExportUtils.exportToExcel (arrCol:ArrayCollection, filename:String=null, header:Boolean=true)
- 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
- http://zachsgeospatial.blogspot.com/2010/08/export-arcgis-query-results-to-xls-file.html
- uses as3xls
- save xls file on client using FileReference
- only for FlashPlayer 10.0 and up, wouldn’t compile if target is set to minimum version
- 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 tablesSELECT 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 pWHERE year = 2011 AND year_count = 1 AND o.project_id = p.uidGROUP BY year_count, year, project_idORDER BY project_id, year
-

You must be logged in to post a comment.