CRMTrackerChangeLog 10.9.2012 -- CRMTRACKER database and application were moved to new servers. 12.4.2007 Duplication of PLSS rows on the Wyoming report cover sheet has been fixed. 11.30.2007 The report cover sheet has been updated to include the aliquot parts for projects, clean up some miscellaneous problems (meridian is no longer shown as a number, some minor wording changes to be more accurate, minor format changes). 11.7.2007 Fieldwork authorizations approved by the lead agency can now be deleted by the consultant. When this happens, an email is generated to all involved parties. Last update 3.20.2007 3.20.2007 Lengthened allowed text length for the lead/managing agency eligibility rationale from 100 characters to 200 characters. Intent is to keep this a short field. 3.16.2007 Fixed problem with Fieldwork authorization map references not being saved. Changed map references dropdown on fieldwork authorization and on investigation to show first 3000 maps in a state, avoiding the "more" button. Fixed map references so that scale, etc., are held in the database. 3.12.2007 - updated the investigation report to fix several problems with truncation, and to bring up the T/R/S list on to the main page (saving paper). Last update 10.9.2006 PreInvestAddCounty.aspx?rid={tbl_PreInvestRecordControl:FV:iPreInvestID}&eid={tbl_PreInvestRecordControl:FV:gEventID} PreInvestAddEDocFile.aspx?eid={tbl_PreInvestRecordControl:FV:gEventID}&rid={tbl_PreInvestRecordControl:FV:iPreInvestID} PreInvestAddEDocFile.aspx?eid={tbl_PreInvestRecordControl:FV:gEventID}&rid={tbl_PreInvestRecordControl:FV:iPreInvestID} Public Sub Button1_Click(ByVal sender As Object, ByVal args As EventArgs) 'skip the base event 'Button1_Click_Base(sender, args) Dim url As String = "../CRMTracker_LeadAgency/PreInvestAction.aspx?rid=" + Request.QueryString("rid") + "&eid=" + Request.QueryString("eid") _ + "&dbnum=" + tbl_InvestRecordControl.tbl_PreInvest_sDBAString.Text If System.Web.HttpContext.Current.Session("userRole").ToString = "31" Then url = "../CRMTracker_PerfOrg/PreInvestAction2.aspx?rid=" + Request.QueryString("rid") + "&eid=" + Request.QueryString("eid") _ + "&dbnum=" + tbl_InvestRecordControl.tbl_PreInvest_sDBAString.Text End If Response.Redirect(url) End Sub 10.11.2006 + Reversed order of UTM entry on site record forms (now set to East then North, previously it was the reverse). 10.9.2006 + Fieldwork authorizations - when performing organization deletes request, an email is sent to lead agency if the request was already submitted to them. +Fieldwork authorizations - when lead agency deletes request, an email is sent to performing organization + Fieldwork Authorizations - Added "Attached Documents" button to fieldwork authorization action screen that links to the attached document window (works for lead organization and performing organization) + Fieldwork Authorizations - Changed order of entry on Fieldwork Authorizations so that it goes from main screen to attached document screen and then to county and PLSS screen and then to Actions screen 10.4.2006 + Changed wording on Undertaking form from Conditions of Approval to Requirements and Stipulations + Fixed Save button on Undertaking form for a New Undertaking so that it keeps user editing the same, new, undertaking record. + Fixed Next button on Undertaking form so that it always goes to location and site information. UndertAddOtherInfo.aspx?eid={tbl_UndertakingRecordControl:FV:gEventID}&rid={tbl_UndertakingRecordControl:FV:iUndertakingID}&dbnum={tbl_UndertakingRecordControl:FV:sDBUString} + Undertaking form - fiscal year on new entries defaults to a calculated value for current federal fiscal year. 9.29.2006 Changed Inbox_LeadOrg.Controls.vb filtering so that role = 21 and role = 99 see the same records. 9.25.2006 Fixed numerous small, behind the scenes, bugs and warnings generated when saving and editing records. These were invisible to the user Modified WY report cover page to eliminate truncation of characters in the thousands, ten thousands, etc., columns for acres. Modified WY report cover page to stop truncation of long strings of crew chief and crew members. 9.14.2006 + Fixed SAVE button behavior on project review (Undertaking) edit - Now stays on page instead of returning to previous page 9.13.2006 + Revised undertaking entry and edit form. - Added a review timeframe list - Added a mail to field to direct clerks where to mail documents - cleaned up formatting of entry and edit screens - changed database field lengths for agency numbers, descriptions, effects, notes. - undertaking description (1000 bytes), stipulations (3000 bytes), effects 1000 bytes, notes (500), interested parties (200) - hid metadata fields + Revised undertaking report form - Fixed truncating fields + Email when sending a fieldwork authorization request to lead agency - Fixed date showing as 1/1/1. (Your authorization has not been waiting THAT long!!) 9.12.2006 + Enabled automated email sending. Currently, email gets generated in 3 circumstances:  1. When a field organization submits a fieldwork authorization to a  lead agency. - Addressee: Lead Agency POC - Sender:  crmtracker@gnomon.com  - cc: signed on user email address (not necessarily field  organization POC) - Subject DBA_WY_200x_xx (field org. project  name) FIELDWORK REQUEST - Address in body of message for reply:  signed on user email address - Comments: field organization  comments.  2. When a lead agency approves or disapproves a fieldwork  authorization request - Addressee: Performing (Fieldwork)  Organization POC - Sender: crmtracker@gnomon.com  - cc: signed on user email address (not necessarily lead agency  POC) - Subject DBA_WY_200x_xx (field org. project name) REQUEST  APPROVED or REQUEST DENIED - Address in body of message for reply:  signed on user email address - Comments: lead agency comments. + Undertaking - additional info page Users can now enter a site directly on this page. It lacks the dropdowns, but it will let you enter and save the record + Administrative user sign-on shows all records When an admin user signs in, they can see all records for their state. 9.11.2006 + Updated all reports Fixed numerous spacing and text truncation issues Verified site sorting