Version 8.9.20 (09-Jan-2012)
Fix when loading Tasks using Bulk Loader mode for error messages not being returned to the spreadsheet and status incorrectly being set to "Loaded" or "Updated"
Added performance improvement noticable when loading large numbers of Tasks
Program Links form title was incorrect when showing links to Parent programs
Child Program Links were not downloading when Workplan structure was not enabled |
 |
Version 8.9.19 (06-Jan-2012)
Fixed bug in Tasks download when Task Customer columns exist
Version 8.9.18 (10-Dec-2011)
Fixed bug in download form when querying Key Member role without a Key Member
Version 8.9.17 (08-Dec-2011)
Added Planned Effort and Planned Work Qty columns to Workplan section
Version 8.9.16 (06-Dec-2011)
More work on download and upload validation for Employee/Job/Non-Labor Bill rate Schedules. Removed all six Operating Unit columns as they are not necessary
Refresh Task cache after Task upload to prevent Task validation errors during processing of subsequent sections
Version 8.9.15 (30-Nov-2011)
New option to choose Draft or Published Workplan version when downloading
New option to publish Workplan after WBS update
Alphabetic sort enabled for downloading non-shared or unpublished Workplan versions. Requires package update
Reject upload when using Add Class Code column and the API does not contain the feature
Reject upload when trying to set Customer Default Flag to Yes when Project is not enabled for Top Task billing
Fix for 'Program requires to locate relevant project' message when uploading all Transaction Controls on worksheet
Fix for 'Cannot run the macro ...!Upload_Selected_Asset' message when uploading a selected Asset
Version 8.9.14 (11-Nov-2011)
Modifications to use of Structure Version and Type parameters when loading Tasks to avoid structure errors in certain circumstances
Task level Bill Rate Org and Operating Unit were not downloading properly for releases prior to family pack M
Task DFFs not downloading properly when workplan shared
Version 8.9.13 (05-Nov-2011)
Fix to Classifications DFF loader required when Classification rejected by API
Fix for Type Mismatch error when updating a project and Copy Tasks from Source option turned on
Fix for 'Invalid use of null' message when opening DFFs form. This was caused by new Classifications DFF functionality
Fix for Tasks DFF columns not being set when loading Tasks DFF form
Fix for Tasks form and Task upload error in Family Pack L caused by a column not present in that release
Prevent Program Links, Deliverables, Actions, Resource functions from operating prior to Family Pack M
Version 8.9.12 (29-Oct-2011)
Fix to 8.9.09 bug re Project Type
Added support for :CLASS.CLASS_CATEGORY and :CLASS.CLASS_CODE form block fields to Classifications DFF functionality
Version 8.9.11 (27-Oct-2011)
Fix to Classifications upload for errorloading DFF values
Version 8.9.10 (26-Oct-2011)
Fix for Update/Create Rules function not operating properly for Tasks DFFs
Version 8.9.09 (18-Oct-2011)
Fix for Network Rail customization. Was not retrieving Project Type when using Tasks toolbar and an R12 specific
Fix for failure to update existing classifications. Was adding new ones if multi-code allowed
Version 8.9.08 (17-Oct-2011)
Support Context defaults in Classifications and added support for form field :class.project_id
Version 8.9.07 (14-Sep-2011)
Support for Classifications DFFs added. This uses an internal procedure as the public API does not contain the functionality
Version 8.9.06 (12-Sep-2011)
New option to Process Program Links upwards as well as downwards. Also option to publish Workplans after Upload/Delete Link operations
Version 8.9.05 (26-Sep-2011)
Fix for message using "Upload All Assets for Selected Project" icon. Error message was "The macro Upload_All_Assets cannot be found"
Fix for "Program requires to locate the relevant Project'" message when creating/updating a project, caused by the Transaction Controls section
Version 8.9.04 (08-Sep-2011)
Allowed Customer download to work for Indirect Customers, prevent Customer upload for Capital Projects
Fix to Reference column value for new Deliverables
Renamed Sub Projects to Program Links
Fixed a problem in the Program Links form when the Project is new
Version 8.9.03 (07-Sep-2011)
Fix for incorrect size constraint when loading new Deliverables
Version 8.9.02 (05-Sep-2011)
Fix for failure to validate Employee Name when it contains a trailing space
Version 8.9.01(31-Aug-2011)
Section added to support multiple Project Customers incl Bill-To & Ship-To addresses, Bill Split percentage, Relationship. Only from Family Pack M
Version 8.8.84 (24-Aug-2011)
Fix for problem when closing Key Flexfield combinations form caused by new Splash form
Updated Key Flexfield form for R12 segment LOV security
Version 8.8.83 (22-Aug-2011)
Asset upload count was not showing after upload using 'All Assets on Sheet' option
Version 8.8.82 (11-Aug-2011)
Stop Resource Assignments form from loading when a valid Project or Template cannot be determined
Version 8.8.81 (08-Aug-2011)
Message stack was not initializing for each Task in Direct update mode. This caused the message to overflow the size limit
Prevent error when validating ETC Effort and Percent Complete columns on older PA patch levels
Fix error when creating Actions with a Name longer than 25 characters
Version 8.8.80 (01-Aug-2011)
Improvement to performance of Project Asset download
Fix for Asset and Asset Assignment upload counters resetting after each project
Version 8.8.79 (29-Jul-2011)
Fix for program trying to load from row 9 when no data exists for Actions, Transaction Controls, Deliverables
Stop Assets and Asset Assignments loaded message appearing for each project when processing multiple projects
Version 8.8.78 (28-Jul-2011)
Deliverable Actions were not loading when using the main upload
Version 8.8.77 (26-Jul-2011)
Bug fix for the Tasks DFF parameter not being recognised - only affected version 8.8.76
Version 8.8.76 (13-Jul-2011)
Added section for Deliverable Actions
Organization and Operating Unit columns added for each Bill Rate Schedule at Project and Task levels. 12 new columns in total
Fix for ^ character incorrectly writing into DFF segment columns on download after uploading
Added DFF and wbs_level columns to re-order procedure to avoid DFF processing error
Version 8.8.75 (20-Jun-2011)
Changed view used for Customers when downloading for performance reasons
New sections added for Deliverables and Deliverable Assignments
Allow for no default currency when loading Bill Rate Overrides
Bill Rate Override currency was not being loaded in certain circumstances and was not included in the update at all
Version 8.8.74 (10-Jun-2011)
Added support for Context Reference PROJECT_TYPE_CLASS_CODE
Version 8.8.73 (08-Jun-2011)
Fix to SQL error when downloading Bill Rate overrides
Version 8.8.72 (27-May-2011)
Added Team Template column (Pending testing on newer API as Update does not work)
Version 8.8.71 (26-May-2011)
Copy Transaction Controls procedure was not operating except for Capital Projects
Fix to Copy Tasks procedure where there are multiple structure versions on the source Project
Version 8.8.70 (19-May-2011)
Assets and Assignments were not loading from main toolbar when Project uploaded
Fix for fault in messaging for new Intercompany Tax column update
Fix inability to use copy/paste buffer on PC while Wizard is uploading
Version 8.8.69 (18-May-2011)
Test for AMG version before passing Task attributes 11-15
Fix for incorrectly passing p_tasks_dff parameter in early R12 versions
Version 8.8.68 (11-May-2011)
Added Transfer Pricing Schedule columns to Copy Tasks from Source feature
Version 8.8.67 (11-May-2011)
Pass default number to Task Org ID instead of null when copying Tasks from Source Project/Template
Added Burden and Bill Rate Schedules to Copy Tasks from Source feature
Version 8.8.66 (10-May-2011)
Correct bug when using Project toolbar to upload projects. If there are no Tasks the other sections were not loading anything
Version 8.8.65 (06-May-2011)
Correct bug in Task validation when certain workplan columns removed
Version 8.8.64 (18-Apr-2011)
Added column 'Intercompany Tax Receiving Task'. Update is done after the upload is completed due to the need to get a Task value for loading into the Project header
Improved technique for copying hidden Template sheets
Version 8.8.63 (14-Apr-2011)
Re-enabled Financial_Task_Flag column when loading from the spreadsheet or copying from Source Project or Template
Fix for Subscript out of Range error cause by DFF module update on 6-Apr
Removed separate licensing for Asset and Asset Assignments functionality
Version 8.8.62 (11- Apr-2011)
Added fix for large Task uploads (in Bulk mode only) failing on infrastructure versions dated 15-Feb-2009 and earlier
Version 8.8.61 (06-Apr-2011)
Changed MIN start date to MAX start date for selection of employee record for downloading
Changed DFF module to query profile options while running the SQL rather than perform a substitution with the separately queried value
Version 8.8.60 (04- Apr-2011)
Added 'Output Tax Code' column
Version 8.8.59 (04-Apr-2011)
Bill Rate Schedule LOV may have been incorrect in R12 due to multi-org changes
Version 8.8.58 (28-Mar-2011)
Fixed problem loading Percentage based Classifications when Oracle bugfix 6780834 installed
Made beta fix for contingent workers permanent
Version 8.8.57 (21-Mar-2011)
Fixed Opportunity and Priority columns accidentally disabled in version 8.8.55
Version 8.8.56 (18-Mar-2011)
Fixed Type Mismatch message introduced in 8.8.55
Version 8.8.55 (15-Mar-2011)
Task Type criteria added to download form
Login performance improvements added
Disable screen refreshing during download - this is a considerable performance improvement in Excel 2007+
Version 8.8.54 (22-Feb-2011)
Performance improvement to all section downloads where joins to HR Employees are required. Also applies to the search on the Download form
Fix for Debug/Trace option not working
Version 8.8.53 (10-Feb-2011)
Change Copy tasks option on Project creation to avoid full-WBS error
Upgraded package to fix Trial Counter option not working in R12
Version 8.8.52 (07-Jan-2011)
Fixed fault in Person validation affecting scenarios where multiple employees have the same name
Warning/Error message from Task validation extension was reversed
Version 8.8.51 (04-Jan-2011)
Replaced Task level Bill Rate Schedule IDs with Names for download prior to PA.M
Mod to Task validation extension to compensate for LLNL customization
Version 8.8.50 (22-Dec-2010)
Bug fix in Task download SQL
Release 8.8.49 (17-Dec-2010)
Added tests for Contract and Capital projects to avoid unnecessary joins during download Bug fix. Was failing to add last section to large upload command
Release 8.8.48 (16-Dec-2010)
Fix to initialization for Planning Resources module for Budget Version ID. Better mechanism employed for determining existence of p_tasks_dff parameter in Tasks APIs Distinguish between updating and adding planning resource assignments when reporting upload status. Added DFFs to WBS re-sort procedure to avoid API error
Release 8.8.47 (23-Nov-2010)
Planning Resources section added. Supports - Create, Download, Delete, Update operations. Works on draft work plan version only when versioning enabled 07/12/10
Reorganized toolbars to reduce the number of them.
Split Assets and assignments into separate toolbars.
Removed Show/Hide options from all but Setup toolbar
Release 8.8.46 (10-Nov-2010)
Paste button added to Download form for Project List field to workaround carriage returns not working in windows paste function
Release 8.8.45 (09-Nov-2010)
Key Member Customization added for KPMG
Release 8.8.44 (03-Nov-2010)
Substitution added for Bull SAS for WBS Level
Release 8.8.43 (21-Oct-2010)
Fix for Bulk Task Loader not working for child Tasks
Release 8.8.42 (18-Oct-2010)
Added call to M4APS_PW_EXTENSION validation package and profile option 'More4Apps: PW Call Validation Extension' to control use of the new feature 19/10/10.
Burden Schedule cache was not re-initializing on change of operating unit.
Release 8.8.41 (15-Oct-2010)
Date type DFF segments were not downloading into the sheet using the PC's local date format
Expenditure Type was not loading into Transaction Controls form
Delete Assignment button was activating Delete Asset function
Enhanced Delete Assignment function to allow multiple row selection
Corrections to Asset Assignment template sheet
Not all fields were disabling on Assets form when Asset found to be Capitalized
Release 8.8.40 (14-Oct-2010)
Client specific customization to prevent the Wizard from preferring the Context default over the Reference field
Version 8.8.38 (6-Oct-2010)
Fix for bug in 8.8.30. Was not loading Project level customer from spreadsheet
Version 8.8.37 (27-Sep-2010)
Added support for TEMPLATE_FLAG project level DFF Reference
Version 8.8.36 (23-Sep-2010)
Added Allow Cross Charge columns at Project and Task level
Version 8.8.35 (20-Sep-2010)
Improvement to SQL for downloading Sub Project links
Set UDAs to null when updating and cell value is blank
Version 8.8.34 (16-Sep-2010)
Debugging extended to cover session context and R12 Orgs lOVs and all SQL/PLSQL calls
Version 8.8.33 (14-Sep-2010)
Project level UDAs were not being loaded
Version 8.8.32 (13-Sep-2010)
Fix to Bulk Task loader mode for R12
Version 8.8.31 (10-Sep-2010)
Fix for UDA download
Version 8.8.30 (29-Aug-2010)
Added code to copy Customers from Source Project. Will NOT work if the customers are duplicated on the Project Template
Copy Tasks procedure was not working on some older instances due to Oracle bug affecting Parent reference in child Tasks. Workaround added
Copy Contacts procedure added. Will NOT work if the customer contacts are duplicated on the Project Template
Delete Project function was not checking for login status before commencing
Version 8.8.29 (18-Aug-2010)
Added Invoice Method and Customer columns to Copy Tasks procedure
Project Form. Logic reports error on Name > 30 chars only once per string now.
Version 8.8.28 (15-Jul-2010)
Fix added for conditional formatting bug in Excel 2007
Version 8.8.27 (13-Jul-2010)
Stop passing Task scheduled dates when workplan not enabled
Version 8.8.26 (12-Jul-2010)
Add DFF Context defaulting for Oxfam.
Updated handling for Worksheet Protection. Now can use any password provided it is set using the new form on the Setup toolbar
Version 8.8.25 (7-Jul-2010)
Only turn on Workplan DFFs if the workplan is enabled, otherwise use the Financial structure DFFs
Change Responsibility button added to About form
Version 8.8.24 (22-Jun-2010)
Fix for error messaging in UDA module
Turn off DFF control for LLNL as Rules sheet superceeds this
Version 8.8.23 (16-Jun-2010)
Task Status download criteria was not working when filtering projects
Most of the Task filter conditions were incorrectly operating on Projects rather than Tasks
Version 8.8.21 (10-Jun-2010)
Fix for SQL error when validating Template
Version 8.8.21 (3-Jun-2010)
Added option to include or exclude non-active Employees in forms and upload validation
Version 8.8.20 (25-May-2010)
Hide at startup option caused toolbar creation to be skipped
Fix to allow copy/paste between sheets to work. You still cannot do a copy/insert columns or copy/insert rows
Version 8.8.19 (19-May-2010)
Fix for bug in Copy Classifications procedure
Version 8.8.18 (6-May-2010)
Fix for Protection problem in Excel 2000
Improved messaging for installation problems
Fix Asset Form button on toolbar which was duplicating the Show/Hide Template sheets function
Version 8.8.17 (6-May-2010)
Project number validation was interfering with a client specific customisation
Version 8.8.16 (4-May-2010)
Prevent Project Status update while approval workflow is in progress
Version 8.8.15 (18-Apr-2010)
Customisation - Disable re-sort for (customer)
Version 8.8.14 (18-Apr-2010)
Rightclick menus and labeled Add-in toolbars changed to not completely refresh each time a dropdown is selected
Version 8.8.13 (9-Apr-2010)
Rightclick menus and labeled Add-in toolbars updated
Version 8.8.12 (23-Mar-2010)
Trim cell values before validation to stop cells containing a single space from being validated
Version 8.8.11 (18-Mar-2010)
Allow expired employees in Key Members LOV
Version 8.8.10 (17-Mar-2010)
Fixed bug in Aliases SQL on Assets form
Version 8.8.09 (8-Mar-2010)
Asset Assignments were not being downloaded if the Display option was set to "Show with the Task"
Version 8.8.08 (7-Mar-2010)
Workplan Descriptive Flexfield set to use PA_PROJ_ELEM_VER_SCH_DESC_FLEX configuration rather than PA_TASKS_DESC_FLEX for non-shared workplan structures
Version 8.8.07 (6-Mar-2010)
Transaction Controls toolbar Display/Hide options were mixed up with those for the Bill Rate Overrides toolbar
Version 8.8.06 (4-Mar-2010)
Toolbars were not displaying/hiding appropriately on creation of new sheet from template
Fix Application or Object defined error when uploading Asset Assignments
Fix for error when establishing Set of Books ID in R12 for Assets module
Version 8.8.05 (26-Feb-2010)
Remove non-active employees from form LOVs/upload validation
Version 8.8.04 (22-Feb-2010)
Fix for scenario where there are no records in Bill Rate Schedules
Version 8.8.03 (9-Feb-2010)
Remove dependency on Asset Category from Asset Book Type
Completed R12 Multi-Org fixes
Version 8.8.02 (16-Jan-2010)
Allow for protection on Rules sheet. Protection must not be passworded
Version 8.8.01 (5-Jan-2010)
Was checking the wrong KFF view to see if Asset Category defined
Mod to Reinstall_ProfileOptions macro to allow run by non-named user
Version 8.8.00 (29-Dec-2009)
New simpler connection method
Version 8.7.08 (17-Dec-2009)
Customer search on Project form now includes Customer Number as well as Name
Version 8.7.07 (9-Dec-2009)
Added 'Allow Capital Interest' and 'Capital Interest Schedule' columns. Applicable from PA.L
Prevent ^ character caused by AMG bug from being downloaded from DFF segments
Version 8.7.06 (8-Dec-2009)
Fix for Task download prior to PA.M
Fix for UDA download bug introduced in last version - 8.7.05
Version 8.7.05 (4-Dec-2009)
Multiple Template sheets supported. Users can now define unlimited Template sheets. 5 sample Templates provided
Tool now ignores hidden columns in forms and during the upload. The download function will still populate hidden columns
PRIMAIR relationship code supported (Netherlands)
Task schedule columns required to be added to the "Rules" sheet
Version 8.7.04 (27-Nov-2009)
Optional Key Member ID column added to uniquely identify Employee when names are duplicated
Optional Task Manager ID column added to uniquely identify Employee when names are duplicated
Optional Assigned To Person ID column added to uniquely identify Employee when names are duplicated
Stop Tasks, Key Members, Transaction Controls, and Assets from being downloaded more than once for duplicates caused by employee name changes
Version 8.7.03 (24-Nov-2009)
7 new Site/Responsibility/user level profile options added to allow control over the various delete functions
Fixed fault in Get_Aliases procedure
Version 8.7.02 (23-Nov-2009)
Fix for Structure version not being retrieved for Direct Task Loader after new project created
Version 8.7.01 (19-Nov-2009)
Task Scheduled dates defaulted to Task Start and Completion dates to prevent AMG from copying these back over the Task and Project dates
Version 8.7.00 (16-Nov-2009)
Licence model altered to prevent use of the tool for non-named users except for About form functions
Version 8.6.14 (13-Nov-2009)
Fix for Customer download SQL not valid in FP-K
Fix for attempt to retrieve structure version ID in FP.K using FP.M procedure calls
Financial Structure download was picking up Workplan DFF values
Performance improvement in UDA downloads
Version 8.6.13 (5-Nov-2009)
Stop SV2.GET_KEYSTRUCT message occurring. This happened once only if a single Asset was uploaded directly after the login
Support use of delimiter character in Key Flexfield segments
Version 8.6.12 (5-Nov-2009)
Stop Key Member from being downloaded more than once for name changes
Version 8.6.11 (3-Nov-2009)
Use Working structure version for uploading Tasks into rather than latest published version. Applies to both Workplan and Financial structures
Added message to prevent use of the selected Task upload when in the Bulk Task loader mode
Bill Rates Overrides toolbar display was not respecting Show/Hide setting
Version 8.6.10 (30-Oct-2009)
Support :PROJECT_FOLDER.OPERATING_UNIT_MIR Context Reference
Version 8.6.09 (29-Oct-2009)
Prevent Subprojects download prior to Family Pack M
Version 8.6.08 (27-Oct-2009)
Fixed SITE_USE_CODE error in SQL for Project Download
Version 8.6.07 (23-Oct-2009)
Added column Source Reference
Version 8.6.06 (22-Oct-2009)
Fix for Task upload messaging bug introduced in 8.6.04
Fix to call to LOAD_STRUCTURE using incorrect Structure Type in certain circumstances
Disable Task level DFF upload for (customer)
Version 8.6.05 (15-Oct-2009)
Added error handling for UDA Groups with Duplicate Attribute form prompts.
Version 8.6.04 (8-Oct-2009)
Fix to check for 'Open Integration Toolkit Funtions Menu' SubMenu to use logged in Application ID not 275
Mod to Task level DFF uploader to not pass values that are not changing on Task update
Customisation for (Customer) added to allow Task DFF 1,2,6 updates only if existing value is null
Version 8.6.03 (6-Oct-2009)
Classifications were not being passed during Project update due to fault in version 8.6.00
Improvements to handle versioning in both Workplan and Financial Structure
Version 8.6.02 (2-Oct-2009)
Simplify use of Direct and Bulk Task Loader options. For the Bulk loader, you now MUST always pass the entire WBS from Family Pack M onwards
This allows the Display order of the Tasks in the worksheet to become the new Display sequence in the HTML forms
When adding new Tasks using using the Direct Task loader, an alphabetical re-sort is done to set the Display sequence
Version 8.6.01 (29-Sep-2009)
Fix in messaging required from 8.5.00
Performance improvement to download to avoid Workplan Structure subquery when not required
Change Workplan subquery to use functions in package PA_PROJECT_STRUCTURE_UTILS
Version 8.6.00 (23-Sep-2009)
Design change to Classifications upload to accommodate scenarios where there are Classifications on the Template
Version 8.5.01 (21-Sep-2009)
Stop downloading Percent Complete and Task Effort values if columns are removed. This prevents error when no such columns in the AMG view
Altered Right-Click menu to only show menus applicable to the active sheet
Version 8.5.00 (1-Sep-2009)
Added section for Employee and Non-Labor Bill Rate Overrides
Fix for Customer download for PA.K
Hide toolbar when toolbar not applicable to worksheet. Reverse when applicable again
Fix for Date conversion error message not appearing in correct error column except in Project section
Version 8.4.09 (10-Aug-2009)
Re-Sort Financial Structure for HTML forms after using Bulk uploader mode to create Tasks
Project Status from last download was not being cleared before upload
Better sort facility added for Task Download / Re-sort. Only available for XML package body 5.1.19 or greater
Fix for Long Task Name being downloaded instead of Task Name (bug in Oracle view pa_struct_task_wbs_v) Bug affects Project Wizard versions from 8.4.01
Version 8.4.08 (6-Aug-2009)
Added Task level Schedule Discount and Discount Reason columns
Fix for Service Type Code download of Code not Name
Version 8.4.07 (4-Aug-2009)
Use more efficient SQL to determine latest Structure Version ID for Workplans
Version 8.4.06 (3-Aug-2009)
Added Task Manager criteria to download form
Version 8.4.05 (30-Jul-2009)
Fix to DFF upload for older Date type attributes
Completed DFF upload for Classifications but no parameters in the API !!! So turned off again :(
Version 8.4.04 (29-Jul-2009)
Added substitution for :TASKS.TASK_ID in Descriptive Flexfields
Version 8.4.03 (21-Jul-2009)
Fix for the Key Members and Tasks forms truncating leading zeros from Employee Numbers
Stop enforcing mandatory Project Level DFF segments on project creation to be consistent with Oracle form
'Yes' value in new column 'Add Class Code' allows the Wizard to add Classifications instead of updating any existing ones, which is the default behavior when an existing record with the same Class Category is detected. This is only relevant for Class Categories that are allowed multiple times on a project
Fix to Project header form to stop Accept button being disabled
Added 'Indented Task Number' column. Only populates on download
Version 8.4.02 (16-Jul-2009)
Improvements to Task downloader
Version 8.4.01 (25-Jun-2009)
Allow Task loader block to continue if any individual Tasks fail - affects Direct Task Loader mode only
Added Percent Complete and Estimated Effort To Complete (ETC)to Workplan download
Major rebuild of Task downloader to better handle Workplan and Financial Structures
Complete implementation of Bill Rate Schedules at Project and Task level
Add controls for Next Allowable Status as AMG does not include this
Add error message to prevent upload attempt of Workplan Tasks when the Workplan structure is shared with the Financial Structure
Fix to mandatory message for Classifications
Version 8.4.00 (18-Jun-2009)
New option to load non-shared or partially shared Workplans
New columns added to Task section, Task Status, Task Duration, Task Sch Finish Date, Task Est Start Date, Task Est Finish Date, Task Actual Start Date, Task Actual Finish Date, ETC Effort, Percent Complete
Added feature to preserve clipboard when loading data entry forms
Version 8.3.56 (4-Jun-2009)
A blank "Project Limit to Txn Ctrls" column was setting the value to No when it should be ignored
Mod to customisation for 7-Eleven
Use hr_employees to download employee names from PA.M and pa_employees for PA.L and before for performance reasons
Add fix for file size explosion problem in Excel 2007
Version 8.3.55 (28-May-2009)
New option on download form allowing end-dated Classifications to be included or excluded
Fix for Employee ID being downloaded in Task Level Transaction Controls when Task Manager column deleted
Change view used for downloading Employees from hr_employees to pa_employees
Uploading a range of Tasks caused the cache to be refreshed between Tasks
Version 8.3.54 (21-May-2009)
Optional Employee ID column added to Transaction controls section to uniquely identify Employee when names are duplicated
Version 8.3.53 (29-Apr-2009)
Allow for Workplan type ordering in Financial Structure from PA.M RUP4
Version 8.3.52 (14-Apr-2009)
Added filter for Transaction Controls. Can apply to Task downloader
Removed Mandatory Tag Name customisation for (customer)
Version 8.3.51 (8-Apr-2009)
Changed downloaders for Transaction Control, Task Manager, Key Member, Asset assigned person to include non-active Employees
Version 8.3.50 (2-Apr-2009)
Removed control stopping Key Member load if not listed in Template Quick Entry from PA.M
Task Level UDAs were not loading for new Tasks
New Rule validation enhancement was incorrectly erroring Project upload
Version 8.3.49 (31-Mar-2009
Added support for Reference Field :PROJECT_FOLDER.PROJECT_TYPE_CLASS_CODE
Added DB Trace option to Setup toolbar
Problems could arise on 2nd and subsequent use of Task loader because of upload variables not initialised
Version 8.3.48 (23-Mar-2009)
Transaction Controls form Enhancement to allow selection of Expenditure Type from the full LOV when no Expenditure Category selected
Fix to Error handler for Task loader
Version 8.3.47 (16-Mar-2009)
Fix for WBS structure order for Task download not working in PA.L
Version 8.3.46 (12-Mar-2009)
Added new Rules feature allowing administrators to exclude fields from Crate/Update
Version 8.3.45 (25-Feb-2009)
Turned off Set Global Info error message as does not seem required any more
Version 8.3.44 (21-Feb-2009)
Check new Project Reference value to ensure uniqueness for auto-numbered projects
Version 8.3.43 (13-Feb-2009)
Customization added - extra custom Task level DFF attributes for General Dynamics
Version 8.3.42 (10-Feb-2009)
Added new UDAs attribute information and changed download to cater for attributes without value sets
Lack of value sets in date type UDA attributes were causing an error in downloads
Added new public macro "Show_All_Project_Wizard_Toolbars" to show hidden toolbars - necessary for Excel 2007
Version 8.3.41 (5-Feb-2009)
Modified task level udas to accept project_type as a context
Fix to DFF validation to handle scenario where OR clause in table validated value set SQL returns multiple values
Change to Quick Entry error messages to avoid Prompt field which can be misleading
UDAs - made change so attributes without values sets don't fail on upload
The UDA attributes spreadsheet column references were not being updated
Added reset of column references. Previous column references were being retained when the columns were removed from the spreadsheet
Stopped validation occurring on attributes that were not on the spreadsheet
Version 8.3.40 (2-Feb-2009)
Customer was not being download if relationship type <> PRIMARY
Project level Bill Rate Schedule error messages were being written into the Task error column
Version 8.3.39 (29-Jan-2009)
Change to structure version mod in last version
Version 8.3.38 (27-Jan-2009)
Enable Range select feature to skip gaps in the selected range
Stop Tasks being duplicated in the downloaded when multiple structure versions exist
Minor fixes for form behavior when validating Employees on form load
Version 8.3.37 (24-Jan-2009)
Turn off Template Quick Entry check for Classifications from PA.M
Version 8.3.36 (15-Jan-2009)
Fix for download not working on PA.K or before
Fix to About and Activation key forms for v4 infrastructure
Version 8.3.35 (13-Jan-2009)
Remove UNION statement failing in certain installations
Version 8.3.34 (8-Jan-2009)
Internal changes to support new licence key model
Change to allow XLA to work properly after Lite front-end saved as new filename
Mod to Network Rail customisation. No need to use custom DFF workaround for Top level Tasks
WIP - Fix to Network Rail customisation. Cannot use load_task for separate DFF load as not all Tasks may be passed
Version 8.3.33 (28-Dec-2008)
Workarounds for AMG bug in PA.L added. Bug writes ^ symbol into the Task description when not passed to the API
Client specific customisation added to prevent update of Task DFF Attribute1
Added fix to prevent program stopping when manually entering a date in user forms
Version 8.3.32 (18-Dec-2008)
Copy Key Members process was not setting Start Date to Project Start Date when available
Version 8.3.31 (12-Dec-2008)
Remove check for existing Classifications on Template when creating a new project
Version 8.3.30 (10-Dec-2008)
New Projects created with Tasks were not retrieving WorkPlan settings from the Template
Template validation was allowing expired Templates
Version 8.3.29 (03-Dec-2008)
Fix for Book/Sheet identification problem when using "Lite" workbook
Version 8.3.28 (28-Nov-2008)
Modified Banned profile option to be site and user as well as responsibility
Version 8.3.27 (13-Nov-2008)
Exclude Expired key members option was excluding Key members starting after the current date
'All but Closed' criteria in download was creating an invalid SQL statement
Version 8.3.26 (20-Nov-2008)
Reset Task error message column before upload
Version 8.3.25 (12-Nov-2008)
Disable update of Task Attribute1 for non-cross project users for specific customer
Version 8.3.24 (11-Nov-2008)
Modified Banned profile option to be site and user as well as responsibility
Fix for bug in feedback when creating new Tasks using Direct Loader mode
Change red error colour on forms to lighter colour as easier to read
Version 8.3.23 (5-Nov-2008)
Fix for fault in Project Status criteria on Download form
Version 8.3.22 (31-Oct-2008)
Added support for DFF Reference field value PROJECT_TYPE_MIR
Enabled DFF form field and DFF Context column on sheet if Reference is invalid
Stop program from erroring if required DFF segment columns missing on update
Let Classifications override limit Classifications download
Version 8.3.21 (28-Oct-2008)
Stop upload and download for responsibilities banned using new profile option
Version 8.3.20 (28-Oct-2008)
Remove unnecessary joins in Project download when Customer columns removed
Fix to Network Rail workaround for DFF trigger. Tasks were not being re-loaded in the correct sequence
Version 8.3.19 (24-Oct-2008)
Upgraded connection module for R12 logging
Added further update controls for project level values for Network Rail
Completed Task trigger workaround for Network Rail
Fix for Invalid Type message on Named User form when nothing in right pane
Version 8.3.18 (23-Oct-2008)
Fix for Ampersand character passed to logging procedure
Version 8.3.16 (20-Oct-2008)
Added profile option control option - "More4Apps: PW Prevent Classifications Update"
Added profile option control option - "More4Apps: PW Disable Transaction Controls functionality"
Version 8.3.15 (15-Oct-2008)
Stop Task cache job from repeating for every Task where none exist
Copy Task function uses Source Project's existing display order when Bulk Task loader used and the Workplan Structure is Shared
When using the Bulk Task loader option the spreadsheet display can now be used to order the display sequence in both Add and Update but only when Workplan Structure is Shared
Version 8.3.14 (13-Oct-2008)
Internal change to Template Show/Hide function
Added feature to download form. User can paste in a list of project numbers.
The list can be delimited by carriage returns or commas or both
Minor fix to Download form where Key member cleared using backspace
Project search in Download form now includes Project Names as well as Project Numbers
Version 8.3.13 (9-Oct-2008)
Stop caching Assets config until required
Version 8.3.12 (9-Oct-2008)
Completed new Right-click menu
Version 8.3.11 (9-Oct-2008)
Added Project Cost Revenue Burden Rate Schedule - direct update as there is no API parameter
Fixed Switch_Task_Loader_API_RC
Version 8.3.10 (8-Oct-2008)
Added Project Revenue Burden Rate Schedule and Project Invoice Burden Rate Schedule columns
Version 8.3.09 (7-Oct-2008)
Add support for Project Level Transaction Controls flag. This does NOT use an Oracle API as there is none available
Version 8.3.08 (7-Oct-2008)
Stop missing DFF columns from being cleared when updating Project, Tasks and Assets
Version 8.3.07 (6-Oct-2008)
Toolbar positioning was not working for all toolbars if Assets toolbar not enabled
Version 8.3.06 (24-Sep-2008)
Fix for Custom Downloader error - GETXMLColumnnames Subscipt out of range
New right-click menus added. Additional options added to suppress toolbars
Stop UDA DFF validation from resetting Task Error status
Fix to reorder Tasks function for PA.L
Workaround added for misleading AMG error message re Parent Tasks
Fixed poor performance in checking the number of Tasks to download
Exclude Expired Key Members from Copy unless there is no other unexpired Key member in the Role
Improvements to Task Copy process to better display error messages
Added Bulk Task upload technique to the Copy Tasks function
Version 8.3.05 (22-Sep-2008)
Fix for problem creating Project Assets in R12
Fix for DFFs not being loaded in R12
Version 8.3.04 (16-Sep-2008)
Task Common Costs grouping levels were not being copied when Source set to Template or Source Project
Version 8.3.03 (13-Sep-2008)
Classifications search changed to automatically include wildcard to be consistent with other searches
Query module re-enabled for specific customer
Version 8.3.02 (11-Sep-2008)
Internal improvements to DFF module and form
Version 8.3.01 (10-Sep-2008)
Correct inefficient DFF segment validation on upload
Version 8.3.00 (27-Aug-2008)
Upgrade to About form to accommodate new Activation Key
Version 8.2.04 (7-Aug-2008)
Improvements to Named User maintenance form
Changed names of Login options. SSO method is now Standard
Version 8.2.03 (24-Jul-2008)
Fix for Transaction Control download problem. Project level Controls were overwriting Task level ones
Version 8.2.02 (21-Jul-2008)
Customer Relationship code parameter appears to be redundant for PA.M RUP4 and R12
Version 8.2.01 (18-Jul-2008)
Allow Project and Task DFF forms to load if Project and Tasks do not exist
Version 8.1.24 (4-Jul-2008)
Widened Download form
Restrict Key Members LOV according to Role List set on Project or Template
Add Task Organization search criteria to Download form
Version 8.1.23 (26-Jun-2008)
Finished status reporting when using Bulk Task loader API
Added new option on Tasks toolbar to switch between Bulk and Direct API for loading Tasks
Version 8.1.22 (10-Jun-2008)
Added bulk task loader LOAD_TASK as a user option.
Remove UNION statement from Project Status caching to avoid Oracle bug
Allow all responsibilities to log in and change message to advise if non PA application is used
Fix for login form not closing in Standard login method when Maintain Users form used
Added new parameter to SET_GLOBAL_INFO for R12
Copy 'Allow_Cross_Charge_Flag' column when copying Tasks from database source
Version 8.1.21 (4-Jun-2008)
Minor improvements to the Transaction Controls form
Program was not using the "Create Only" / "Update Only" options correctly when creating a new project
Fix for project error not stopping upload. Bug was introduced when UDA support added
Fix for failing Task validation in Transaction Control load for a brand new project
Version 8.1.20 (29-May-2008)
Fix for WorkPlan Res Flag and Scheduled Flag columns not loading defaults if the columns were removed
Version 8.1.19 (21-May-2008)
Minor issues fixed on Download form
Version 8.1.18 (28-Apr-2008)
Bug fix for new DFF form field substitution stopping creation of new Projects
Version 8.1.17 (24-Apr-2008)
Set Depreciate and Amortize Adjustments Flags to load defaults if columns missing
Version 8.1.16 (23-Apr-2008)
Stop Amortize Adjustments from defaulting to Yes from PA.M
Stop Asset Description from forcing Uppercase from PA.M
Version 8.1.15 (14-Apr-2008)
Added Estimated Asset Units column
Version 8.1.14 (8-Apr-2008)
Added workaround for AMG rejecting DFF segments containing form block fields
Fix for DFF segments containing comparisons to compiled_attribute_values columns which may contain carriage returns
Added two form block fields to DFF segment "substitutions"
Version 8.1.13 (4-Apr-2008)
Allow 'Asset Units' value to be blank on Asset creation
Version 8.1.12 (2-Apr-2008)
Correct another caching job causing an overflow message
Version 8.1.11 (27-Mar-2008)
Support more than 32767 records in cached record sets
Version 8.1.10 (11-Mar-2008)
Fixed Upload bug - multiple UDA groups at project level would error
Fixed Download bug - multiple UDA groups at project level could cause the wrong data to be downloaded
Fixed UDA date download bug. Dates would only download as 12:00am
Missing Required Key Member message was showing Role ID instead of Role Name
Version 8.1.09 (7-Mar-2008)
Added limited support for Task level Bill Rate Schedules
Version 8.1.08 (26-Feb-2008)
Added range delete functionality to the Task delete function
Internal change made to patch identification
Version 8.1.07 (20-Feb-2008)
New test for installation of UDA functionality was always returning false
Stop DFF values exceeding 150 characters. This is to correct a gap in earlier Oracle versions allowing this setup in value sets
Version 8.1.06 (18-Feb-2008)
Changed task download so it downloads in chunks of no more than 500 tasks at a time
This enables large numbers of tasks to be downloaded more efficiently. Projects with large number of tasks were previously causing the wizard to fail or hang for long periods of time
Toolbar button for the SubProjects form was calling a non-existent procedure
Version 8.1.05 (18-Feb-2008)
Changed test for reordering Task sequence in HTML form from "Check Sharing Enabled" to "Check Workplan Enabled"
Version 8.1.04 (13-Feb-2008)
Stop UDA functionality trying to operate where patch level insufficient
UDA functionality was causing task load failure for new Tasks
Cached Task list was not clearing when deleting Tasks from different projects
Space after the Task Number was affecting jobs requiring to validate this value
Version 8.1.03 (11-Feb-2008)
Task Reorder job is only relevant from PA Patchset M
Minor updates to DFF functionality
Version 8.1.02 (8-Feb-2008)
Fixed Key Members form which was not correctly validating Key member on first load
Formatting improved to prevent Excel from truncating leading zeros etc in string values
Version 8.1.01 (7-Feb-2008)
Access Level column added
Can now ignore the 'Project Name' and 'Task Name' columns provided you provide a Long Name
Version 8.1.00 (5-Feb-2008)
Support for Sub Projects added
Version 8.0.11 (30-Jan-2008)
Date Type DFFs were not downloading correctly
UDA errors were not stopping upload
Task Type column should not be mandatory unless loading Task level UDAs
Version 8.0.10 (25-Jan-2008)
Protection added to stop trying to create Classifications on Project Creation when the Classification already exists on the project. This was erroring when the Class Code is NOT listed in the Template's Quick Entry
AMG limitation in updating existing Classifications worked around.
Downside - it is no longer possible to add new Classifications to multi-row Class Categories if one exists
New About, URL, Help, and login forms with updated information for R12 and links to website
Performance improvement in download if Person column missing in Assets or Tasks and Employee option set to Number or Name
Version 8.0.9 (11-Jan-2008)
Copy Tasks from Template procedure was crashing the error message handler
Version 8.0.8 (4-Jan-2008)
User Definable Attributes (UDAs) supported at Project and Task level
Multi-row UDA Groups are not supported
Version 8.0.7 (14-Dec-2007)
Fix to Classifications load for those allowing Percentages. "Missing" AMG value was being loaded and a bug in AMG causes this value to be stored instead of ignoring it
Added "Task Type" column
Version 8.0.6 (5-Dec-2007)
"More4Apps: PW Security" profile option control was not operating for the Task loader
Version 8.0.5 (4-Dec-2007)
Burden schedule validation was not working prior to 11.5.10 because of a change in the Oracle table
Task Display order routine now called if changing Task Numbers as well as adding new Tasks
Default Date format changed to PC's "Short Date" from Regional Settings
Version 8.0.4 (3-Dec-2007)
Re-enabled Asset function security
Version 8.0.3 (26-Nov-2007)
Add fix for Task Display order problem in HTML forms
Version 8.0.2 (17-Nov-2007)
Apply Create/Update controls to Task loader
Version 8.0.1 (19-Oct-2007)
Removed call to Valid_Date_In_Service in Asset Validation
Asset validation parameters required reversing
Fix for R12 testing - date parameter returned for l_def_date not working
Rowidtochar() Function now used for Java to XML compatibility to support R12
Version 8.0.0 (17-Oct-2007)
Mods for new R12 connection
Version 7.1.10 (12-Oct-2007)
Stop DFF form from defaulting to first item in LOV if no default
Client specific customistion to default in Project Level context default
Version 7.1.9 (3-Oct-2007)
Flexfield form was defaulting to Alias tab instead of Segments tab
Added new techniques to help prevent toolbars locking up
Stop Excel from using scientific number format on downloaded data
Version 7.1.8 (28-Sep-2007)
Fix for Alias search not enabling Ok button after search in certain scenarios
Version 7.1.7 (27-Sep-2007)
Added support for Project_Type reference field in DFF context
Set cursor focus to Key Member Role on opening Key Members form
Combinations search was not working from version 7.1.5
Support Project Type reference field in Project DFF Context
Version 7.1.6 (26-Sep-2007)
Scheduled Task Start and Completion dates cannot have nulls passed to them
Task form error message for too long a Description had 20 characters as the maximum when it should have been 250
Aliases search in Flexfield form was not returning any values in version 7.1.5
Version 7.1.5 (24-Sep-2007)
Performance improvement in Key Flexfields on Assets form
Version 7.1.4 (21-Sep-2007)
Load messages were not being re-initialised in case of a load failure
Key Flexfield Aliases were not being checked on Asset upload
Feedback added for any failures during Copy Task process
Task cache was not being reset after adding or deleting Tasks
Flex form was sometimes not display buttons on Alias tab
Flex form now only selects Alias tab on startup if there is an Alias already in the calling form
Version 7.1.3 (19-Sep-2007)
DFF form was loading on rows prior to row 10
Version 7.1.2 (18-Sep-2007)
Excel was rounding scientific format numbers. Cells now switched to Text format to avoid this
Version 7.1.1 (23-Aug-2007)
Change to upload of DFFs. Get defaults before checking if mandatory column is missing
Handle unwanted scientific formatting by Excel in large numeric Project Numbers
Version 7.1.0 (20-Aug-2007)
Added Scheduled Start and Finish dates to Task loader - uses copies of Transaction dates
Version 7.0.9 (13-Aug-2007)
Bug fix in Hide/Display options for Setup toolbar
New validation message 'Role Start Date is mandatory when updating a project'
Version 7.0.8 (31-Jul-2007)
Added options to Show / Hide Transaction Controls Toolbar
Version 7.0.7 (30-Jul-2007)
Key Flexfield form required processing for Profile Options as for Descriptive Flexfields
Version 7.0.6 (25-Jul-2007)
DFF fix for Profile options embedded in Value Set SQL
DFF form fix required where segment is Enabled but not Displayed
Enforce 150 character maximum on DFF segments with no value set
VBA Protection added. Can now use Excel Protection from Excel menu - Tools / Protection
Connection upgraded ready for R12
Version 7.0.5 (27-Jun-2007)
Handle certain Project Form fields in DFF functionality
Handle substitutions for form fields whatever the Case in the value set definition
Version 7.0.4 (19-Jun-2007)
Removed requirement for 'Upload Status' column when deleting Tasks
Fix for Dependant value sets in Key Flexfield form
Version 7.0.3 (12-Jun-2007)
Combinations search on Flexfield form was not handling apostrophes and non-ascii characters
Bug fix for when Flexfield Aliases used
Removed 'Copy from Template' options for Key Members and Classifications as this already occurs by default
Version 7.0.2 (01-Jun-2007)
Upgraded Key Flexfield form
Version 7.0.1 (29-May-2007)
PA.M you cannot update the DFFs on Tasks. Patch 6041360 corrects this but requires a new parameter to be passsed to the API. This version passes the new parameter
Upgraded Key Flexfield module
Version 7.0.0 (28-May-2007)
Single Sign-On supported
Version 6.2.07 (26-May-2007)
Default values were not writing to cells from DFF form
Version 6.2.06 (24-May-2007)
Uppercase Only property on DFF Segment was causing Excel Object error in DFF form
Fix for Dependant Value sets not quering against correct Parent Value Set column
Version 6.2.05 (23-May-2007)
DFF form now does immediate updates on the spreadsheet
DFF Download upgraded to correct processing order based on configuration
Version 6.2.04 (18-May-2007)
Fix to stop numeric values being interpreted as Dates by Excel
Version 6.2.03 (17-May-2007)
Turned off Workplan Fix in version 6.1.10 except for one customer since this is causing problems at other sites
Version 6.2.02 (16-May-2007)
Fixes to 6.2.01 for caching ID based value set values and context in Project header
Version 6.2.01 (14-May-2007)
Enhancements to Descriptive Flexfield module
Version 6.2.00 (11-May-2007)
Added validation for Numeric only and Uppercase to Descriptive Flexfield form
Upload was allowing characters for certain Numeric only Descriptive Flexfield value sets
Added logged in responsibility to About form
Transaction Controls cache was not being reset when updating Project
Expenditure Categories with no Expenditure Types were not available in Transaction Controls upload or LOV
This and all future versions will NOT operate in MS-Excel 97
Version 6.1.15 (1-May-2007)
Download was not converting Task DFF Value Set IDs to Values
Now Caching ID and Values to improve download performance for multiple hits on the same DFF Value Set
Version 6.1.14 (30-Apr-2007)
Some Transaction Control Error messages were not appearing in the correct Error message column
Revert Asset Download to prior method as Key Flexfield views not nesessarily defined
Version 6.1.13 (29-Apr-2007)
Task Descriptive Flexfields were being loaded from the Top Line only, copied to other Tasks
Version 6.1.12 (28-Apr-2007)
Fix to Key Member security check if Project ID on spreadsheet. SQL was failing
Enable DFF Context LOV and validation if Reference field used as otherwise this is not supported
The above excludes Profile Option based Reference values because these are already supported
Version 6.1.11 (27-Apr-2007)
New Key Member download security was not working for downloading Project ranges
Default "Scheduled Flag" and "WorkPlan Resources Only Flag" to No in Transaction Controls
Version 6.1.10 (26-Apr-2007)
Workaround added for Oracle's default ONLINE process updating Task Workplan Structures
Version 6.1.9 (24-Apr-2007)
Added Key Member Security so non-authorised users cannot download projects
Client specific customisation added
Version 6.1.8 (23-Apr-2007)
Forms were not text formatting string values looking like percentages
Classifications form was crashing on load if existing value on sheet invalid
Task validation was indicating wrong column in error if Task Number invalid
Fix Transaction Control load bug caused by missing Scheduled Flag value
Version 6.1.7 (18-Apr-2007)
Performance improvement in Download if Employee ID is selected on the "PW Setup" toolbar
Simplify Assets Download SQL to use Key Flexfield views
Version 6.1.6 (18-Apr-2007)
Bug fix for Transaction Controls download
Fix for special characters requiring URLEncoding in new SQL bind parameters technique
PROJECTWIZARD Product Code was not installing due to PL/SQL syntax error
Version 6.1.5 (2-Apr-2007)
Bug fix for Classification load problem introduced in 6.0.6
Completed performance enhancements to SQL to use bind variable technique where possible
Version 6.1.4 (30-Mar-2007)
Discovered AMG constraint re Key Member Roles and Class Categories on Template does NOT apply when updating existing projects
Version 6.1.3 (27-Mar-2007)
Fix for non-ASCII characters in new performance technique. Requires M4APS_XML package body 3.0.08
Added Template LOV into Download form criteria
Added Template Number and Name into additional wildcard search feature in Download form
Version 6.1.2 (26-Mar-2007)
Task Cost Burden schedule was not resetting for each Task, causing an error in certain circumstances
Version 6.1.1 (23-Mar-2007)
Download form was not always enabling Download button
Toolbar re-set position required change for new Tasks toolbar
Template sheets had wrong title for Cap/Bill Flag column
Version 6.1.0 (21-Mar-2007)
Task status column was not being populated if validation error occurs
New Delete Task function was using 1st row of project only
Validation message missing if mandatory Task DFF column not present
Fix for timeout problem caused by Internet Explorer 7
New Upload All Tasks on sheet option only worked on nearest Project to cursor
Version 6.0.6 (16-Mar-2007)
Classifications Code Search added. Caches complete list if there are less than 5000. Otherwise uses the typical search functionality
Version 6.0.4 (15-Mar-2007)
Task loader was not loading Tasks for Upload All Tasks for Selected project option
Was reloading Task Cache too frequently
Further fix for Asset description converting to Uppercase
Version 6.0.4 (14-Mar-2007)
Descriptive Flexfields were disabled since 5.3.15 as set to the wrong application during testing
Version 6.0.3 (13-Mar-2007)
Fix to 6.0.2 for Asset description not refreshing from prior value
Version 6.0.2 (12-Mar-2007)
Allow lowercase in Project Asset description now that Oracle allows this
Version 6.0.1 (12-Mar-2007)
Added WorkPlan Resources Only Flag to Transaction Controls module
Added Costing, Revenue, and Invoice Burden Schedules at Task level
Asset Form was not updating Project Asset Name for releases PA.L and above
Version 6.0.0 (8-Mar-2007)
Task uploader separated from Project Upload. Now three new options for loading Tasks
Stripped MS Office calendar control references out of frmQuery and changed to VBA calendar
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 5.3.16 (12-Feb-2007)
Added new security feature with new profile option 'More4Apps: PW Security'
Now Administrators can restrict the Create or Update modes at Site/Responsibility/User Levels
Transaction Control load is now done after Project and Task Upload automatically
Task Name column is no longer required when Updating Tasks
Task form now allowed to close even if errors exist or incomplete
Version 5.3.15 (2-Feb-2007)
Upgraded Descriptive Flexfield form and module
Version 5.3.14 (28-Dec-2006)
Asset Category was mistakingly being loaded instead of DFF Category for releases prior to PA.L
Version 5.3.13 (23-Dec-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 5.3.12 (22-Nov-2006)
Removed looping code in creation of toolbars
Cosmetic Improvements to About form
Version 5.3.11 (17-Nov-2006)
Added Person Type column to Transaction Controls module
Fix for program allowing Transaction Controls with no Exp Cat or Employee being loaded
Fix for program allowing the creation of Transaction Control on mid level Task in certain circumstances
Version 5.3.10 (7-Nov-2006)
Added Temporary Bill Rate schedule ID columns to download
Version 5.3.09 (7-Nov-2006)
Handler added for errors caused by apostrophe character in filename
Version 5.3.08 (7-Nov-2006)
Override feature was returning default table/view objects
Version 5.3.07 (25-Oct-2006)
Check for mandatory Key Members and Classifications was not operating if s/s sections missing
Version 5.3.06 (18-Oct-2006)
Support Contingent workers in LOV for personnnel in PA.M
Added Temporary Bill Rate schedule ID columns
Fixed bug in opportunity columns for releases prior to family pack K
Version 5.3.05 (29-Sep-2006)
Support for Dependant Value sets added to DFF module
Version 5.3.04 (14-Sep-2006)
Added support for "Allow Capital Interest" flag in Copy from Template function
Disabled "Copy from Template" options for Classifications and Key Members
Version 5.3.03 (04-Sep-2006)
Fix to Replace97 procedure
Added new special character conversions for Apache in 11.5.10CU2
Version 5.3.02 (04-Sep-2006)
Added Asset Tag Number column
Version 5.3.01 (01-Sep-2006)
Cope with blank Project start date by defaulting to system date for Expected approval date
Version 5.3.00 (29-Aug-2006)
Changed to different APIs for loading Tasks. New Task Status column
Version 5.2.29 (24-Aug-2006)
Program was loading Expected Approval Date when other Opportunity columns were blank
Version 5.2.28 (19-Aug-2006)
Transaction Controls module was not clearing Task cache between projects
Version 5.2.27 (11-Jul-2006)
Probability and Opportunity columns added
Calendar form changed to fix backspace bug
Version 5.2.26 (14-Jun-2006)
Fix for problem using Excel 97
Version 5.2.25 (08-Jun-2006)
Fix for PRIMARY Customer Relationship code
Enhancements to Login form for Host validation and LOV usage
Customer Number column added. Either can be used
Version 5.2.24 (22-May-2006)
Fix to SQL based default Flexfield segment processing
Support Table validated value sets in Key Flexfields
Extend character conversion for 11.5.10CU2 Apache security
Retrieval of Tasks IDS for new tasks was not working for simple numeric Task Numbers
Version 5.2.23 (19-May-2006)
Fix to bulk upload - was not efficient after first block per project
Asset validation was not writing to correct Error Message column
Fix PL/SQL problem with large Project uploads
Version 5.2.22 (17-May-2006)
Check added to prevent duplication of Asset Numbers
Minor improvement to Named Users form
Version 5.2.21 (26-Apr-2006)
Enhancement to login form to better show HTML error messages
Handle space characters in password
Version 5.2.20 (10-Apr-2006)
Login enhanced to allow non alphanumeric characters in password
Default DFF values were not passing validation if column was removed
Version 5.2.19 (5-Apr-2006)
Priority Code Added to Project section
Was not warning if mandatory columns not populated when creating new projects
Small performance improvement to download re Transaction Controls
Version 5.2.18 (27-Mar-2006)
Changes to logic determining new Task Start / Completion dates when copying from Source Project or Template
Version 5.2.17 (22-Mar-2006)
Check added for mandatory Classifications and Key Members during Project creation
Version 5.2.16 (20-Mar-2006)
Support added for Shared Task Structures. Requires Project Wizard package body version 1.0.7
Version 5.2.15 (15-Mar-2006)
Calendar positioning fix for Excel 97
Version 5.2.14 (27-Feb-2006)
MS-Office Calendar replaced with VBA calendar
Version 5.2.13 (9-Feb-2006)
Handle :PROJECT_FOLDER.PROJECT_STATUS_CODE and :PROJECT_FOLDER.TEMPLATE_FLAG in DFF configuration
Version 5.2.12 (1-Feb-2006)
Major performance improvement to validation of Employee records
Handle :PROJECT_FOLDER.PROJECT_TYPE and :PROJECT_FOLDER.PROJECT_ID in DFF configuration
Version 5.2.11 (31-Jan-2006)
DFF module was not turning default user values into IDs when user leaves value blank
Version 5.2.10 (25-Jan-2006)
Added search criteria to Named User maintenance form
Loop added to counter intermittant failure to show toolbars on startup
Version 5.2.09 (14-Jan-2006)
Control options added to download form to ignore unwanted sections
Version 5.2.08 (10-Jan-2006)
Two client specific customisations added
Logout was not clearing Joint Login values
Version 5.2.07 (17-Dec-2005)
Fix for reference duplicate issue when running uploads on multiple PCs simultaneously
Version 5.2.06 (15-Dec-2005)
Redesign "Upload All Assignments on Sheet" procedure
Version 5.2.05 (14-Dec-2005)
Redesign "Upload All Assets on Sheet" procedure
Version 5.2.04 (14-Dec-2005)
Two fixes for issues with 9th Key Flexfield segment
Version 5.2.03 (13-Dec-2005)
DFF Form was not handling Table validated value sets with WHERE clauses
Download was unneccessarily formatting cells as TEXT
Remove unneccessary step to retrieve project Number/ID values after update
Version 5.2.02 (8-Dec-2005)
Fix to potential date formatting issue when updating Project Asset Dates prior to 11.5.9
Fix to bug in 5.2.00 in feedback for inserting / updating Project Assets and Assignments
Version 5.2.01 (7-Dec-2005)
Upload was performing post-update events if upload rejected by Oracle
Distribution Rule was erroring in Oracle because Description was being passed, not Code value
Version 5.2.00 (5-Dec-2005)
Functionality added to upload/update Transaction Controls from the worksheet
Prevented duplication of DFF config caching during Project upload
Version 5.1.07 (14-Nov-2005)
Prevent duplicate database call populating LOVs in DFF form
Fix bug stopping LOV being populated when a default exists
9th Key Flexfield segment was not working
Stop login loop if M4APS_XML package not installed
Stop commas being accepted as Numeric by DFF module
Version 5.1.06 (9-Nov-2005)
More work to support carriage returns required - String arrays do not support chr(10) characters
Version 5.1.05 (8-Nov-2005)
Late binding implemented for Calendar Control
Allow for carriage returns in strings in DFF Value sets
Version 5.1.04 (1-Nov-2005)
Added mechanism to share login for operating multiple Wizards
Version 5.1.03 (17-Oct-2005)
Fix to cope with extremely large numbers of Class Categories and Class Codes
Move DFF caching to post login processes
Suppress DFF buttons on toolbar when no DFFs configured
Version 5.1.02 (2-Sep-2005)
Fix for upload not occuring at multiples of 25kb upload size
Version 5.1.01 (16-Sep-2005)
Added error messages if required Asset/Assign Status columns missing
Version 5.1.00 (6-Aug-2005)
Switched XML object from Fixed Reference to Late Binding
Fix for certain DFF Value sets containing $Profiles$: and IN statements
Version 5.0.34 (27-Jul-2005)
Stop repeated DFF configuration caching when no columns defined
Version 5.0.33 (21-Jul-2005)
Certified for PA Family Pack M
WARNING: As at 15-August-2005 an AMG bug prevents Projects from being updated if Tasks are included in the update
Asset/Assignment loader was not detecting the project if the Project Name column is empty
Expired users removed from Named User LOV
Version 5.0.32 (21-Jul-2005)
Named user form was not handling over 32767 users
Version 5.0.31 (15-Jul-2005)
Create/Update only options applied to control Project Asset uploads
Version 5.0.30 (6-Jul-2005)
Fix for MLS code change affecting procedure calls including apostrophe characters
Support new login validation method
Fix for apostrophe in Asset Name
Version 5.0.29 (30-Jun-2005)
Fix to Copy Tasks from source for European users
Version 5.0.28 (25-Jun-2005)
Remove Digital Certificate
Version 5.0.27 (22-Jun-2005)
Fix DFF reference field issue
Version 5.0.26 (18-Jun-2005)
Code protecting against chr(0) characters was slowing query performance
Version 5.0.25 (17-Jun-2005)
MLS views used instead of base tables
Bug fix for character translation
Added Parent Asset Column
Asset upload was not stopping for DFF errors
Leave AMG to validate Asset Number to improve upload speed
Version 5.0.24 (14-Jun-2005)
Multi-language was not enabled due to forgetting to test for non-8i database
Version 5.0.23 (11-Jun-2005)
Fix for bug introduced for small project uploads
Version 5.0.22 (09-Jun-2005)
Fix bug in DFF form
Version 5.0.21 (08-Jun-2005)
Allow new Task search criteria to apply to project search
Multi-language support added
Version 5.0.20 (31-May-2005)
Bug Fix: Invalid subscript value used in A_CacheIdData array
Version 5.0.19 (25-May-2005)
Added additional Project and Task search criteria to download form
Version 5.0.18 (19-May-2005)
Error message fix for Asset upload
Version 5.0.17 (09-May-2005)
DFF module bug fix for Independant value sets
Bug fix for Task Start Date when copying Tasks from Source
Version 5.0.16 (03-May-2005)
Fix to download form for error if Organisation selected
Bug fix for ID incorrectly loaded into DFF column for independant value set items
Version 5.0.15 (21-Apr-2005)
Allow update without required DFF columns existing
Version 5.0.14 (19-Apr-2005)
Support Profile Option in DFF Context Reference field
Version 5.0.13 (14-Apr-2005)
Removed custom Asset/Assignment security. Use standard Oracle AMG function exclusions
Version 5.0.12 (12-Apr-2005)
Several DFF module enhancements
On-line Release Notes link added to About form
Version 5.0.11 (31-Mar-2005)
Fix for problem retaining Digital certificate
Login configuration hidden if Setup Toolbar not shown
Version 5.0.10 (16-Mar-2005)
Defaults were not applying for DFFs in upload process
Fix for Profile option defaults in Key Flexfields
Version 5.0.09 (10-Mar-2005)
Fix for missing optional DFF column with LOV validation
Version 5.0.08 (08-Mar-2005)
Minor fix to Assets module for missing DFF columns
Version 5.0.07 (05-Mar-2005)
Fix for European decimal character not being handled properly in Estimated Cost
Version 5.0.06 (01-Mar-2005)
Remove Function to Check for non-Ascii characters
Version 5.0.05 (22-Feb-2005)
Improve DFF module performance
Version 5.0.04 (21-Feb-2005)
DFF Context display fix, added support for Longs in value sets for older databases
Fix to DFF module - was not re-setting values for subsequent Tasks
Version 5.0.03 (17-Feb-2005)
Remove replace97 call for chr(0), Don't display error when context column missing
Added support for Named User Licence model
Version 5.0.02 (14-Feb-2005)
Skip dff column missing error if upload update mode
Version 5.0.01 (14-Feb-2005)
Fix bug with attribute dependancy pointer in the dff array
Version 5.0.00 (07-Feb-2005)
Add new Descriptive Flexfield functionality
Version 4.0.10 (07-Feb-2005)
Fix to new Key Member download option
Version 4.0.09 (04-Feb-2005)
Stopped trying to count assets copied during update
Added two Key Member download control options
Version 4.0.08 (03-Feb-2005)
Fix for copying Tasks from Project/Template for 11.5.8 and before
Change to download. Key Members must be current to match download criteria
Version 4.0.07 (02-Feb-2005)
Minor fix to forms searching for Employees
Version 4.0.06 (30-Jan-2005)
Performance improvements to Project Assets module
Batched Asset Assignment upload
Added Manufacturer, Serial Number, Model Number, Estimated Cost columns
Version 4.0.05 (20-Dec-2004)
Batched Asset upload
Added Work Type column
Version 4.0.04 (16-Dec-2004)
Added check for required SubMenu to prevent confusing AMG security message
Bug fix to Copy Tasks / Copy Transaction controls for null Task Start dates in Source
Improvement to upload performance for smaller Projects
Version 4.0.03 (07-Dec-2004)
Added Class Category description column to form LOVs
Version 4.0.02 (02-Dec-2004)
Increased size limits for Asset Name and Description from PA.L
Version 4.0.01 (23-Nov-2004)
Fix for space at end of Organization Name causing rejection during download/re-upload
Was not copying Transaction controls if Project ID column removed
Mod to allow Projects form to operate for updating when no Template column
Version 4.0.00 (07-Nov-2004)
Migrated to XLA model. Can now be used as an XLS or XLA with "Lite" front-end
Simplified login configuration setup
Version 3.0.25 (06-Nov-2004)
Moved Copy Tasks from spreadsheet to database to improve performance
Version 3.0.24 (03-Nov-2004)
Fix for error status not clearing for multiple project uploads
Prevent update of Project Templates where function not on responsibility
Version 3.0.23 (28-Oct-2004)
Fixes for Project Asset Loader module for Project Level Assignments
Version 3.0.22 (11-Oct-2004)
Added support for Classifications Code Percentage
Version 3.0.21 (16-Sep-2004)
Improvement to security - removed requirement to have VB project trusted
Fix for default Key Flex segment based on SQL statement
Login form changed to show Licence Name
Added support for Aliases in Key Flex fields
Version 3.0.20 (30-Aug-2004)
Fix for failing to set Project Start and Completion dates to null
Version 3.0.19 (20-Aug-2004)
Copy Transaction Controls procedure was missing a column for 11.5.8 (PA.J)
Version 3.0.18 (18-Aug-2004)
Increased number of Key Flexfield segments supported to 9
Version 3.0.17 (12-Aug-2004)
Added Date range criteria to download form
Removed startup error for no FA module installed/configured
Version 3.0.16 (09-Aug-2004)
Key Flexfield field values were not changing after Combinations form closed
Version 3.0.15 (28-Jul-2004)
Add Function to Check for non-Ascii characters
Check for duplicated column headings added
Update was not fetching new Task IDs
Version 3.0.14 (15-Jul-2004)
Fix for some error messages suppressed and stopped error message from wrapping in cell
Fixed message problem if Delete Project is rejected by AMG
Prevent chr(0) characters in database from crashing XML parser
Added support for secure socket connection
Version 3.0.13 (09-Jul-2004)
Added facility to export/import login configurations
Version 3.0.12 (30-Jun-2004)
Fixed message problem if Delete Project is rejected by AMG
Version 3.0.11 (29-Jun-2004)
Workaround added for illogical AMG treatment of Project level DFFs at project creation
AMG ignores DFFs if no Context used - even if no context is desired
Version 3.0.10 (22-Jun-2004)
Fix to Copy Project T.Controls to allow for Templates created from other templates
Version 3.0.09 (22-Jun-2004)
Change login data fixed array to dynamic and resolve excel97 split() func issue
Version 3.0.08 (21-Jun-2004)
Switched to different IE API to better handle UTF8 character set
Version 3.0.07 (09-Jun-2004)
New options added to copy Project and Task level Transaction Controls
Version 3.0.06 (03-Jun-2004)
Project Form was restricting Project Name to 25 characters. It should be 30
Login script change to allow for port numbers larger than integer size limit
Version 3.0.05 (02-Jun-2004)
Login script change to allow for port numbers larger than integer size limit
Test added to ensure dates are converted correctly
Fix for incorrect default date being retrieved from AMG
Fix for problem with Copy from Source/Template options
Version 3.0.04 (28-May-2004)
Upload would not work if no project ID column
Changes to handle apostrophes in descriptive columns
Upgraded Update Assignment function to new PA.L API
Version 3.0.03 (21-May-2004)
Minor bug fix for download if Upload Status column removed
Version 3.0.02 (20-May-2004)
Program was not stopping if trial version re-login was aborted
Version 3.0.01 (19-May-2004)
Minor improvements to error messaging
Version 3.0.00 (12-May-2004)
Change from ADO to XML HTTP data access method
Migrated Project Asset Loader module to new API in PA.L
Version 2.5.32 (18-Apr-2004)
Responsibility LOV change using applications language
Alternative LOV view for Organisations selected for 11.5.9
Version 2.5.31 (15-Apr-2004)
Change in Role Types view to PA_PROJECT_ROLE_TYPES_V
Cached Role Types to improve performance
Simplied Download Organizations LOV - was not working for 11.5.9
Version 2.5.30 (14-Apr-2004)
Change to Responsibility LOV for 11.5.9
Version 2.5.29 (06-Apr-2004)
Stopped program from getting Task Ids if upload errors
Version 2.5.28 (03-Apr-2004)
Options form did not work when operated from outside the Wizard workbook
Version 2.5.27 (23-Feb-2004)
Added ability to select a range of Projects to upload
Version 2.5.26 (19-Feb-2004)
New button on Setup toolbar allows show/hide of Template sheet
Minor improvement to Login form
Minor fixes to Download form behaviour
Added public code to enable double-click in external workbooks
Version 2.5.25 (30-Jan-2004)
Remove all references to PA_SECURITY.ALLOW_UPDATE
This Oracle procedure is not reliable and caused both Project and Budget Wizards to incorrectly reject update attempts.
Version 2.5.24 (08-Jan-2004)
Stopped all upload loops from attempting to go past bottom of worksheet = 65536 lines
Version 2.5.23 (05-Dec-2003)
Refinement to code requiring Search Criteria
Allowed for non-mandatory Key Flexfield segments in Assets module
Fix for misbehaving auto-complete in Key Flexfield form
Version 2.5.22 (02-Dec-2003)
Mod to Delete Project feature to use Project ID if available
Mod to About form to show logged in user
Task description loading changed to match Oracle's bug in this area
Oracle now stops us from being able to clear any unwanted task values
This is inconsistent with the Project API but Oracle must know better !!
Added Task ID column to allow Task Number update
Added Delete Task feature
Now requiring criteria in search boxes
Version 2.5.21 (28-Nov-2003)
Allowed Project Wizard to update/delete projects created by other sources
Version 2.5.20 (18-Nov-2003)
Enhance frmAbout form and password expiry feature
Allowed numeric characters at beginning of database password
Respect end-dates of Responsibility Assignment
Allowed direct entry into Flex fields on Assets form
Cosmetic changes to all forms
Version 2.5.19 (7-Nov-2003)
Bug fix - Long Project and Task Name parameters were too short.
Version 2.5.18 (4-Nov-2003)
Test added for database user's password expiry.
Version 2.5.17 (13-Oct-2003)
Cosmetic improvements to all date columns.
Version 2.5.16 (12-Oct-2003)
Better handling of compulsory/optional fields.
Cosmetic improvements to forms and sheet status fields.
Error handle added for blank project number if not auto-numbering.
Debugging code added for load_project.
Version 2.5.15 (08-Oct-2003)
Corrected bug in default start and completion dates.
Version 2.5.14 (06-Oct-2003)
Added Initialize proc call for PA_SECURITY.
Version 2.5.13 (09-Sep-2003)
Added login parameter fix for Oracle patch 3009044.
Version 2.5.12 (12-Aug-2003)
Separated problem PA_SECURITY check for upload process.
Version 2.5.11 (6-Aug-2003)
Added third option for Employee Reference "Employee ID". This is unique and cannot cause duplicate issues.
Version 2.5.10 (31-Jul-2003)
Added form to handle duplicate Employee Names or Numbers during upload.
Version 2.5.09 (23-Jul-2003)
Added option to use Employee Number or Employee Name.
Version 2.5.08 (15-Jul-2003)
Upgraded to cope with PA.K. Oracle added two parameters to SET_GLOBAL_INFO and long_name parameters to both LOAD_PROJECT and LOAD_TASK.
Did not add support for the new Project Structure columns.
Added better error handling than Oracle's for new PA.K constraint on WBS order.
Minor bug in Projects form fixed.
Added Logout button to toolbar.
Added memory feature for toolbar position - when you save the workbook it remembers the location of the toolbars for next time.
Added "Upload Error" column.
Version 2.5.07 (18-Mar-2003)
Message fix - Key Member R11i bug warning was showing for R11.0.3
Version 2.5.06 (17-Mar-2003)
New Feature added - Project Number range in Download form
Version 2.5.05 (07-Jan-2003)
Bug Fix - Was doing an update even if mode is Create only - (Proj ID exists in sheet)
Version 2.5.04 (23-Dec-2002)
Bug fix - Failed to handle missing Project name column for Upload All Projects option.
Version 2.5.03 (18-Dec-2002)
Enhancement at customer request - upload functions require to be called by external macros. Made all upload (8) and delete (3) procedures public.
Can now be called by macros with the following syntax:
Application.Run "'Project Wizard v25.xls'!Upload_Selected_Project"
Alternatively we have built a macro you can use in your custom application. It is better than the above in that it is tolerant of any filename you use for Project Wizard. The full text of this is in the section titled "Write your own Macros"
Requirement - the procedures must be called with the Wizard workbook loaded and cursor in an appropriate location on the datasheet (N/A for upload all on worksheet)
Version 2.5.02 (15-Dec-2002)
Bug fix - Upload all Projects function was stopping after project containing more than 500 tasks loaded (searching from line 2 of project rather than from bottom of project)
Version 2.5.01
Point releases now added frequently to improve version control.
Two minor bugs fixed in Key Flexfields form (called only in Assets form)
New form added for DBA to select default and temporary tablespaces for users.
Project Wizard now deletes its toolbar while exiting (unless there is still another copy of the product loaded)
Version 2.5
New functionality added to allow the overriding of the main LOVs by creating custom views.
The installer may create different versions of the spreadsheet showing different sets of data for the following Lists of Values:
* Organizations
* Customers
* Distribution Rules
* Project Statuses
* Class Categories and Codes
* Key Member Roles
* People
* Service Types
Version 2.4
New Project Asset and Asset Assignment loaders added.
A very large enhancement - so extensive we decided to price it separately rather than increase the price of the base product.
Several thousand lines of code have been added, plus a new template, four new forms and a separate toolbar. This is all enabled in the trial version. For a detailed description of the new functionality, please see the separate Project Asset Loader document.
Commitments
AMG does not check to see if there are any uninterfaced transactions in Payables or purchasing modules before it allows the project to be deleted.
Rather than wait for Oracle to process the enhancement request, we have added our own check to prevent the delete in this situation.
Warning for AMG Key Member Bug
Now Project Wizard will advise if you are about to corrupt your data (please read the AMG Bugs section in this document) and allow you to abort (advisable).
Flash New Calendars !!!!
Added to all forms containing dates to make typing them a thing of the past.
Late-binding technique introduced. Allows a machine running versions of MDAC_TYP other than 2.6 to operate successfully.
Licence Key. Now you can download the latest version and open it with your own private licence key. Includes the End User Licence agreement.
Deployment Package. No more zip files in the email. This package also contains the download licence agreement, and Microsoft's Code Checker utility.
Copy Organisation Decision for copying tasks from Source Project or Template. Read the section on Copying existing Tasks for clarification.
Support for altering Templates added in this release. Previously Project Wizard would not alter templates. Although it is still not possible to create a template, Project Wizard can now perform all modifications possible to Projects, to Templates.
Version 2.3
Added Task Level DFFs
Fixed bug - Failure to reset a variable meant the software always tried to load a new project once the first new one was discovered. i.e. Subsequent updates were attempted as new, causing an error. This big only existed in 2.2
Fixed bug - was not downloading Project level DFFs
Fixed bug - 1 employee only bug in Key Member LOV
Fixed bug - Form load errors (harmless) while loading Project form where no Customer or Distribution Rule data
Fixed bug - Mysterious intermittent failure to load anything but Project Header. New colour coding to help identify loaded / ignored data. Made line searches more tolerant.
Version 2.2
Added support for changing Project number with new optional Project ID column.
Version 2.1
Fixed bug - Task Org not working - always used project Org
Fixed bug - Not resetting empty values for new tasks (update mode)
Fixed bug - Not resetting empty values for new Key Members
Fixed bug - protect pm_task_ref from duplicate if older task renumbered then new task added with old number
Fixed bug - AMG doesn't like null pm_task_reference while updating tasks loaded using standard forms
