Version 4.4.07 28 July 2010
Fix added for Excel 2007 bug not removing conditional formatting
Sheet protection changes.  Can now store the password used for Sheet protection so the program can operate through it
Change "Error" row status to "Rejected" for consistency with other products
Added Upload Error column

Version 4.4.06 25 May 2010
Sheet Protection changes. Updated common modules

Version 4.4.05 18 March 2010
Improvments to Toolbar/Menu so that rerendering not required

Version 4.4.04 16 March 2010
Common Modules for Toolbars/Right Click Menus imported and implemented

Version 4.4.03 16 February 2010
Fix for context setting problem in R12

Version 4.4.02 21 January 2010
Stop failure in set_global_info API call from stopping upload
Use MOAC Org ID for R12 not fnd_global.org_id

Version 4.4.01 16 January 2010
Round Revenue and Billing Event values down to maximum of 2 decimal places
Will display form on session cookie error

Version 4.4.00 10 January 2010
New simpler connection method
Mod to Reinstall_ProfileOptions macro to allow run by non-named user
Fix for behavior of Download form when using Classification / Type LOV criteria

Version 4.3.02 10 December 2009
Some of the exchange rate/type/date columns were not downloaded into the right columns

Version 4.3.01 20 November 2009
Added support for Reference columns 1-10, only uploadable from family pack L

Version 4.3.00 19 November 2009
Licence model altered to prevent use of the tool for non-named users except for About form functions
DFF module upgraded to current version. Form widened

Version 4.2.10 18 September 2009
Removed two parameters for PA.K and below, for x_project_rate_type and x_projfunc_rate_type
Fix for Billing Hold not updating properly for PA.K and before if column left blank

Version 4.2.09 21 July 2009
Changed call to calendar form. To fix blank dates showing as 1899 and Calendar form popping in the wrong place.

Version 4.2.08 13 July 2009
Added further information to discover errors in feedback procedure

Version 4.2.07 31 March 2009
Fix for non-ascii characters causing Asciistr() commands to be written into the Event Description column

Version 4.2.06 17 March 2009
Reset mouse pointer on form load
Prevent error from occuring on Event form load after row 100
Updated common modules

Version 4.2.05 27 January 2009
Fix for problem validating new trial keys

Version 4.2.04 16 January 2009
Fix to About and Activation key forms for v4 infrastructure

Version 4.2.03 11 January 2009
Updated internal connection modules, About form, login forms
Stop Event form writing generated (provisional) Event number to sheet

Version 4.2.02 11 September 2008
Correct inefficient DFF segment validation on upload
Internal improvements to DFF module and form

Version 4.2.01 26 August 2008
Added workaround for bug in PA_EVENT_PUB API failing to initialize the error message stack

Version 4.2.00 26 August 2008
Upgrade to About form to accomodate new Activation Key

Version 4.1.17 8 August 2008
Usability improvements to Named User maintenance form
Changed names of Login options. SSO method is now Standard

Version 4.1.16 31 July 2008
Bug fix in form where search criteria exactly matches result

Version 4.1.15 8 July 2008
Upgraded DFF module to current standard

Version 4.1.14 24 June 2008
Existing Event Description was being overwritten when loading form

Version 4.1.13 6 June 2008
On creating Events, default Bill and Revenue amounts to zero if columns absent from layout

Version 4.1.12 2 June 2008
New colour scheme for layouts
Added search button for Tasks on Event and Download form
Added Up/Down button to allow Event form to navigate to the next/prior row
Project and Task search now works on both Project/Task Number and Name
Client specific customisation added for Key Member security
Field order on form altered only for one customer

Version 4.1.11 3 April 2008
Get New Event Number call was not working in R12

Version 4.1.10 31 March 2008
Updated R12 Org selection form

Version 4.1.9 1 February 2008
Added new About, Help, Login, URL forms and R12 versioning information

Version 4.1.8 25 October 2007
Removing 'Event ID' column caused an error in the upload
Ignore existing Event ID value if it doesn't exist

Version 4.1.7 20 October 2007
Added Adjusting Revenue Flag column to form
Apply technique to stop toolbars locking

Version 4.1.6 9 October 2007
Customisation added for Oracle to avoid form field bug in API
Added Foreign Currency columns
Added Adjusting Revenue Flag column

Version 4.1.5 5 October 2007
Event form was not resetting before loading
DFF form field substitution did not handle null task values
Numeric test was returning the wrong result for a negative number
Added support for form field :EVENTS.PRSave NowOJECT_NUMBER
Handle scenario where Event number is missing from the spreadsheet but the ID exists

Version 4.1.4 2 October 2007
Added support for Context Reference Event Type
Customisation added for client to avoid form field bug in API

Version 4.1.3 21 September 2007
Fix for SQL syntax in download

Version 4.1.2 19 September 2007
Handler added for very long numbers. Excel changes them to scientific format which is not desirable

Version 4.1.1 13 September 2007
Was not converting DFF value set IDs to values on download
Can now choose your own Event Numbers, and change Event Numbers for Existing Events

Version 4.1.0 10 August 2007
Upgraded DFF module.
DFFs were not being loaded using API as a parameter was missing
Excel 97 can no longer be used from this release

Version 4.0.0 6 June 2007
Single Sign-on supported
Added logged in responsibility to About form
Tolerate missing port number in login URL (for 8000 default)
Better error handling for invalid URL setup
Added Servlet test to Connection Setup form

Version 3.0.19 19 April 2007
Fix for timeout problem caused by Internet Explorer 7
Cache one Task at a time instead of all Tasks for the project during Upload
Slight performance improvements in Upload process (SQL Bind variables)
Fix for bind parameter not URLEncoding special characters

Version 3.0.18 15 February 2007
Added Debug feature. User adds "Debug" sheet to enable it
Errors returning from API were not being reported correctly

Version 3.0.17 28 December 2006
10g database was not being detected properly for non-ASCII character handling
Cosmetic improvements to About form
Completed Mods for installation on OOD instances

Version 3.0.16 9 November 2006
Handler added for errors caused by apostrophe character in filename
Override feature was not working
Re-enable URL Setup button if login fails

Version 3.0.15 20 September 2006
New Event API employed for releases from PA Family Pack L

Version 3.0.14 3 June 2006
Handle apostrophe charcter in Event Description
Minor enhancements to login form to improve ease of use

Version 3.0.13 24 May 2006
Fix for a new API parameter not required even in Family Pack M Rollup
Special character handling function added to cope with new cesurity in 11.5.10CU2

Version 3.0.12 18 May 2006
Login enhanced to allow non alphanumeric and space characters in password
Updated Named User form
New user functionality to make optional columns 'Task Number' and 'Event Date" required
Enhancement to login form to better show HTML error messages
User Functionality for making optional columns mandatory changed and form added for this purpose
Further enhancements to new Mandatory field feature

Version 3.0.11 15 March 2006
Calendar positioned for Excel 97

Version 3.0.10 28 February 2006
MS-Office Calendar replaced with VBA calendar
Stop login loop if M4APS_XML package not installed
Switched XML object from Fixed Reference to Late Binding

Version 3.0.09 26 October 2005
Added Product Code upload for Family Pack L and above
Fix issue when downloading without Task Number column

Version 3.0.08 4 August 2005
Update was not changing Amounts for PA.J and above

Version 3.0.07 22 July 2005
Change to recognition of patch level due to family pack M

Version 3.0.06 20 July 2005
Allow full responsibility LOV
Support new login validation method

Version 3.0.05 25 June 2005
Remove Digital Certificate
Upgrade Login configuration
Upgrade to latest XML module
Multiple languages supported
Named User Licence model added
Fix for Jan-1900 dates being downloaded, and other values set to zero

Version 3.0.04 31 March 2005
Fix for problem retaining digital signature
Suppress Login Configuration usless Setup toolbar shown

Version 3.0.03 06 March 2005
Performance improvements
Remove Function to Check for non-Ascii characters
Fix for European decimal character not being handled properly

Version 3.0.02 24 October 2004
Mods to Template and load/export config functions
Messages for Delete Event
Allowed add/update to include events marked deleted
Fix for faulty result from Get Default Org
Moved Get_Defaults currency code into database procedure

Version 3.0.01 4 October 2004
Improve performance using block sql upload method

Version 3.0.00 7 September 2004
Convert from ODBC to web-connection

Version 2.0.02 26 April 2004
Changed Responsibility LOV for 11.5.9
Backported to R11.03

Version 2.01 4 August 2003
The following enhancements have been made in this release:

Updated for PA.K.

  • Remember toolbar positions
  • Logout button
  • Removed logos causing Invalid picture error
  • Removed Flexgrid
Version 1.01
This is the first commercial release. Built on R11i and tested on PA.G and PA.H