Millennium 2014 Release Notes
The following items are included in Millennium 2014. Some items are enhancements to the software, some are changes, and some are corrections.
Enhancements and Changes New in Millennium 2014
ADE and ADE Import Tool
Function | Description |
---|---|
Add Correspondence to ADE and ADE Import Tool | Import new Correspondence rows into Millennium as well as update existing Correspondence rows by using the Advanced Data Examiner (ADE). Both constituent and non-constituent
Correspondence rows can be processed through the ADE. Pending Correspondence data is loaded into the
ADE through the ADE Import Tool as either new
data to insert into Millennium or as updates to existing Correspondence
data rows. The ADE will update existing stand-alone (unlinked) Correspondence
rows and existing Correspondence rows that are linked to Gift and Dues
transactions, Events, and Event Activities. But, only
stand-alone (unlinked) Correspondence rows can be inserted into Millennium
by the ADE. |
Default date columns to "Today" | A date field on an Advanced Data Examiner default insert form (a Defined Default) can be defined so that when a pending data row is processed, the date will default to the day that the row is processed. Remember, if the pending data row has a different value for the date field, the pending data will be used instead. |
Automatic Update available for Dues | If the
Membership Processing option for the Database Security Group to which you belong is set to Membership, then you can automatically insert new Dues records into Millennium by using the Advanced Data Examiner (ADE) Automatic Update feature. |
Events
Function | Description |
---|---|
Removing Java from Activity Sort Order | Change the order in which the list
of Activities will display on a Express Registration form by using the re-designed Define Activity Sort
Order tool. Use Drag and Drop, or the Move Up and Move Down buttons, to quickly sort the Activity list. The Define Activity Sort Order tool does not use Java, and it can be accessed (after the particular Event is selected) by using Millennium Explorer, . |
Removing Java from Event Activities assignment (after a Guest is registered). | Assign Event Activities to a Guest after the guest been registered by using the Activities Available to Guest tool. This tool does not use Java. It can also be used to unassign Event Activities from a guest. Use Drag and Drop or the Add and Remove buttons to assign (or unassign) one or more Event Activities at a time. To access the Activities Available to Guest tool: locate the Event, locate the Registration detail page for the constituent who registered the Guest, locate the details for the Guest on the Registration detail page, and locate the Attendance section for the Guest. Point to the Edit button in the Attendance section header, and click Insert. |
Removing Java from Event and Activity Items assignment (after a Guest is registered). | Assign Event Items to a Guest after the guest has been registered by using the Items Available for this Event tool. Assign Activity Items to a Guest after the guest has been registered by using the Items Available for this Activity tool. Both tools can also be used to unassign Guest Items, and neither tool uses Java. For both tools, use Drag and Drop or the Add and Remove buttons, to assign (or unassign) one or more Guest Items at a time. If menu items are available for the Event and/or Activity, then the tools will include a Menu Choice section to allow you to either assign a menu item to the Guest, or to change a menu item selection that was made when the Guest was initially registered. To access the Items Available for this Event tool: locate the Event, locate the Registration detail page for the constituent who registered the Guest, locate the details for the Guest on the Registration detail page and then locate the Event Items section for the Guest. Point to the Edit button in the Event Items section header, and click Insert. To access the Items Available for this Activity tool: once you locate the details for the Guest, locate the Attendance row and then locate the Activity Items section for that Attendance row. Point to the Edit button in the Activity Items section header, and click Insert. You can also access the Items Available for this Activity tool from the Guest's Attendee detail page. |
Favorites
Function | Description |
---|---|
My Prospects link | If you are a Prospect Manager, the My Prospects link will be displayed in the record header for every constituent. Click this link to quickly access your My Prospects Favorites list display. You are a Prospect Manager if the constituent ID number to which your Millennium User ID is linked has an active constituent Prospect Management relationship where you are the Prospect Manager. |
Millennium Mobile (SMM)
Function | Description |
---|---|
Inserting and updating data with Millennium Mobile | Insert and update Address, Phone Number, Internet Address, and Correspondence data by using Millennium Mobile. |
My Millennium
Function | Description |
---|---|
Removing Java from My Millennium Home Page setup | Customize the My Millennium Home Page by using the re-designed Home Page Setup tool. Select what items to display on the Home Page and determine the order in which they display by using the new Drag and Drop feature, as well as the tool's Add, Remove, Move Up and Move Down buttons. The Home Page Setup tool does not use Java, and it can be accessed by using Millennium Explorer, . |
Removing Java from Defined Display | Create (define)
your table display layout by using the re-designed Define Display tool. Select what tables to include
in your layout and determine the order in which you want to have them shown by using Drag and Drop as well as the tool's Add, Remove, Move Up and Move Down buttons. The re-designed Define Display tool does not use Java, and it can be accessed by using Millennium, . |
Profiles
Function | Category | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Removing Java when processing Bank Draft and Credit Card donations through Paya Payment Solutions and the Paya Exchange Vault. | Giving | Java is not used to process Real-time and Vault Only credit card and bank draft transactions. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Saving bank account numbers requires SSL | Giving | To save bank account numbers in Millennium (creditcard table) or in the Paya Exchange Vault, your organization must use a secure connection (in the form of an SSL Certificate) to access Millennium. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Track Blast email contacts in Correspondence | Biographical |
New Correspondence columns, a new lookup table (for the correspondence mode column) and new entries in several existing lookup tables allow you to track your organization's contacts with constituents when you use third-party blast email systems. New code/values are required in the following lookup tables. correspondence_mode is a new lookup table. The conversion will add the codes and values to correspondence_mode, and to the response_method, response_type, and source_types tables only if the codes do not already exist in those tables.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Coverage | Giving | Coverage is a relationship
between two constituents whereby when one constituent
in a Coverage relationship makes a Gift or Dues donation, the second constituent in
the relationship receives a soft credit for it. In a Coverage relationship,
the constituent who will be making the donations is called the covering
constituent, and the constituent who will be receiving the credits is called
the covered by constituent. Coverage relationships can be set up so that they
apply to a specific campaign, campaign year, and/or time period only. When a stand-alone gift or dues, bequest, pledge,
sustainer pledge, or expectancy transaction is created for the covering
constituent, the system automatically creates a credit transaction for
the covered by constituent. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Removing Java from Pledge Payment Schedules | Giving | The Payment Schedule tool, used to view and edit to existing Pledge Payment schedules, has been re-designed so that it no longer uses Java. The tool's one-screen payment schedule display will provide a more streamlined way to change existing payment schedules. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Removing Java from Multiple Allocation Pledge Payments | Giving | The Post Payment tool,used to distribute payments on multiple allocation Pledges, has been re-designed so that it no longer uses Java. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Removing Java from Sustainer Payment Schedules | Giving | The Sustainer Payment Schedule tool, used to create new schedules and to view and edit existing schedules, has been re-designed so that it no longer uses Java. The tool's one-screen payment schedule display will provide a more streamlined way to make changes to existing Sustainer Payment schedules. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
WealthEngine | Prospect Management |
Changes have been made to Millennium's WealthEngine integration in order to incorporate WealthEngine’s new online wealth research platform (FindWealth 8). WealthEngine has a new authentication model, has added new wealth attributes, and has new range and rating score values. Also, WealthEngine will no longer provide scores for several wealth attributes. The following columns are added to the finance table to capture the new range and rating score values when importing WealthEngine data: finwerange finwerating New code/value entries are required in the financial_types lookup table to capture the new wealth attributes when importing WealthEngine data. The conversion will add the required codes and values to financial_types lookup table only if the codes do not already exist.
New code/value entries are required in the demographic_type lookup table to capture the new wealth attributes when importing WealthEngine data. The conversion will add the required codes and values to the demographic_type lookup table only if the codes do not already exist.
WealthEngine will no longer provide scores for the following wealth attributes. The codes and values will remain in the lookup tables for historical purposes.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Workflow for Actions and Tasks | Prospect Management |
Create a custom one-screen data entry page (Workflow) to enter Actions and linked Tasks into the Prospect Management system. Access the Workflow Setup page by using Millennium Explorer, , point to the Edit button in the Actions Workflow Setup header, and click Insert. Use an Actions workflow to enter Actions and linked Tasks for a constituent by using Millennium Explorer, , point to the Edit button in the Actions section header, point to Insert Via Workflow, and then click on the workflow name. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Contact names for Corporations and Foundations | Biographical | When a Contact name (nametype = 'con') is inserted for a constituent who is a corporation or a foundation (coretbltyp = 'C' or 'F'), the system will automatically format the Salutation name in accordance with the formatting rules that are used for constituents who are individuals. As always, you can override the system's automatic name formatting behavior. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Additional medical suffixes | Biographical | The system will automatically include the Dr. title on Salutations, Combined Names, and Combined Salutations for the following name suffixes: DPH, PhD,
DPT,
DrOT,
PharmD,
D.O., and
DO
|
Reporting
Function | Description |
---|---|
Constituent ID numbers used in criteria and in prompted replies | In the Millennium Reporting World, when creating and editing lines of criteria, and answering prompted replies (when running a report), you can now enter ID numbers without the leading zeroes. The system will add the leading zeroes for you. And, if you use Paste functionality to enter ID numbers, the ID numbers in the file that you are pasting will not need leading zeroes. |
Search Reports | Quickly locate published
reports for viewing and previously saved report criteria for editing
and for running by using the Search Reports page. The Search Reports page can also generate
a list of your site's saved and published reports and display it on one
screen. The page includes a Report name search field and several options to limit what reports will be listed in the Search Reports results. Access the Search Reports page by using the Millennium Explorer, . |
System-wide
Function | Description |
---|---|
Display Comments and custom text fields on data maintenance forms as single line or as multi-line boxes. | The Custom Display Designer Multi-line option (active only for comments and custom text fields), allows your organization a choice in how to display (on data insert and update/delete forms) comments and custom text fields. Display them as either multiple-line or single-line text boxes. This option is set for each comment and custom text field individually. During the upgrade to Millennium 2014, this option will be set to Multi-Line for each comment and custom text field that is currently included on all default (standard) and custom insert and update/delete layouts. |
Removing Java from value-based lookup table fields on data insert and update forms. | On data insert and update forms, the lookup table fields that reference value-based (or super) lookup tables now use a Search box to find lookup table entries. Value-based lookup table fields are denoted by a Search button![]() |
Removing Java from Save Results and Load Tables |
Save Results been redesigned so that it no longer uses Java. Save Results is used to save the results of a Profiles Search, a My Staff Favorites list display, or a My Prospects Favorites list display to a database table. Load Tables has been redesigned so that it no longer uses Java. Load Tables opens saved worktables for those Millennium functions that use records from saved worktables. Loading saved search results, creating My Millennium Assignments for specific constituents, and importing Event Registrations are three examples of these functions. |
Log On to Millennium without Java | Java is not used when users log on to the Millennium if your organization uses a secure connection (in the form of an SSL Certificate) to access Millennium. |
Remove Duplicates from Search Results Displays | A constituent is listed in a Millennium search results set more than one time if he or she has more than one Lookup Name row. The Sort by ID and Display Unique List hyperlink sorts the results set by ID Number and removes the duplicates from the results set display (only). This hyperlink is available on most of the system's Search Results displays (the Relation ID Search Results, for example). |
Default date columns to "Today" | A date field on a default insert form (a Defined Default) can be defined so that when that defined default is used to insert a row into Millennium, the value of the date field will default to the day that the row is inserted. |
Tools
Function | Description |
---|---|
Removing Java from Group Maintenance | Create new, and edit existing, Millennium Database Groups by using the re-designed Group Maintenance tool. The tool does not use Java. New components on the tool provide a more straightforward way to assign and change a Group's views to the data tables. On the User Security main page, the Edit button to the left of any database group name can be used to access our re-designed Group Maintenance tool. |
Removing Java from User Maintenance | Add a new Millennium user or update an existing one by using the re-designed User Maintenance tool. On the User Security main page, the Edit
button to the left of any user name can be used to access the User Maintenance tool.If your organization uses a secure connection (in the form of an SSL certificate) to access Millennium, then the tool will not use Java to create new users and update existing users. But, if your organization does not use SSL, Java will still be used to encrypt the user passwords before they can be stored in the userlist system table. |
User Maintenance Change Password |
The process used to change a Millennium user's password is streamlined! Access the Change Password tool directly from the User Security main page. Point to the Edit button to the left of the name of the user, and click on Change Password. If your organization uses a secure connection (in the form of an SSL Certificate) to access Millennium, then the Change Password tool no longer uses Java. |
Removing Java from SPS Pledge Processing | Millennium does not use Java to process payments through the Paya Payment Solutions Pledge/Sustainer Payment Processing tool. |
Photos Location |
Added the Photos Location field to the System Information page. This field holds the UNC path to the Docs Virtual Directory. The Docs Virtual Directory is the location of the Millennium Attachments. The system will use this path to display photos on reports. When the Web Server (IIS) is installed or upgraded, the system administrator at your organization must configure the docs directory, or the virtual directory containing the docs folder, to have the appropriate shares and permissions, and then type the UNC path to the Docs Virtual Directory into the Photos Location field. |
Technology
Function | Description |
---|---|
Mobile Millennium directory change |
The Mobile Millennium directory is in a new location on the Web Server (IIS) computer. Each Mobile user will need to update his/her Shortcut or Favorite destinations to http://www.<Server Name>.com/mill/mobile. |
Millennium system files directory change | The Millennium system files, previously located in the inetpub\Scripts directory, have been moved to the following location on the Web Server (IIS) computer: inetpub/wwwroot/mill/bits. |
Online Constituent Directory files directory change | Files for use with the Online Constituent Directory, previously located in the inetpub/wwwroot/ecomm directory, have been moved to the following location on the Web Server (IIS) computer: inetpub/wwwroot/mill/ecomm. |
Java Removal | Java has been removed from several Millennium controls: Value-based lookup table fields on insert and update forms, User Maintenance, Group Maintenance, Save (Search) Results and Load Tables, Pledge Payment Schedules, Sustainer Pledge Payment Schedules, Multiple Allocation Pledge Payments, SPS Pledge Processing, processing Bank Draft and Credit Card donations through Paya Payment Solutions and the Paya Exchange Vault, User Options - Defined Display, My Millennium - Home Page Setup, Event Activity Sort Order, Event Activities assignment (after Guest is registered), and Event and Activity Items assignment (after Guest is registered). If your organization uses SSL, java is no longer used when users log on to Millennium. |
Database Changes
Function | Table/Directory | Description | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
New Columns | sysinfo |
New columns are added to for internal system use and to support auditing for the new Coverage table.
|
|||||||||
New Columns | correspondence |
New columns are added to track blast email, and to support adding correspondence to the Advanced Data Examiner.
|
|||||||||
New Lookup Table | correspondence_mode | Correspondence Mode is a new lookup table to be used to track the way in which your organization delivers a piece of correspondence to a constituent. | |||||||||
New Table | correspondence_pending | The correspondence_pending table is added to support the correspondence in the Advanced Data Examiner. | |||||||||
New Columns | finance |
New columns are added to support WealthEngine changes:
|
|||||||||
New Table | coverage | A new table is added to support the Coverage enhancement. |
|||||||||
New Lookup Tables |
coverage_lookup1 coverage_lookup2 coverage_lookup3 |
New custom lookup tables are added to support the Coverage enhancement. Table layouts conform to the Standard Lookup Table layout. | |||||||||
New Table | audit_coverage | A new table is added to support auditing for the new Coverage table. | |||||||||
New Table | def_coverage | A new table is added to support Defining Default Insert pages for the new Coverage table. | |||||||||
Column Length Change | demogrph | The length of the demovalue column is increased to 60 characters to support WealthEngine changes. | |||||||||
Column Length Change | sysinfo | The length of the we_password column is increased to 240 characters to support WealthEngine changes. | |||||||||
Column Length Change | we_clientid | The length of the client_password column is increased to 240 characters to support WealthEngine changes. |
Corrections included in Millennium 2014
The correction items describe system behavior as it will exist AFTER the installation of this release. Some items will also include a description of symptoms that you might have encountered BEFORE the installation of this release.
Unless otherwise noted, changes and corrections apply to both database platforms.
ADE and ADE Import Tool
Issue # | Function | Description |
---|---|---|
M16230 | Data Examiner Import and Processing | Joint with Spouse gifts can now be updated by using Automatic Update functionality |
Events
Issue # | Function | Description |
---|---|---|
M16738 | Event Items | Event items will now display with Event Guest details. |
M17011 | Event Guest | After an existing Event Guest record is updated, Event Guest details will now be displayed. |
My Millennium
Profiles
Issue # | Category | Description |
---|---|---|
M16225 | Giving | The Custom Display Designer (Customizer) can now be used to customize the maintenance (insert and update) forms for non-constituent Honoree data, and to customize the non-constituent Honoree data display. |
M16226 | Relations | Linking a relationship to a spouse will now occur when creating a second link to the Spouse. |
M16227 | Giving | The correct display page layout is now used to display the linked credit on a gift void transaction. |
M16229 | One Screen View | Linked records will now display in one screen view with the full context menu. |
M16431 | Event Log | Clicking a constituent's Event Log no longer boots the user out of Millennium. |
M16436 | Giving | Users can now link a Gift transaction to an existing Planned Gift from the constituent's Giving detail page. |
M16448 | Giving | Inactive Accounts (giftaccnm) are no longer cleared when editing a Gift allocation. |
M16450 | Attribute | Improvements to the speed in which Attributes are displayed. |
M16461 | Event Log | The option to insert a Guest Of record on a constituent's Event Log display has been removed. (Event Log is a display only feature.) |
M16481 | Address | When a constituent's address row is linked to a non-constituent employer, and the number of characters in the employer name is more than 56, the IIS will no longer crash when the address data display page for the constituent is shown. |
M16482 | Attachments | The Change Date + User ID field on Attachment records now display correctly. |
M16488 | Filters and Defined Display | Toggling the filters On and Off on a user's Defined Display will no longer crash the IIS when that display includes linked data (for examples, Attributes linked to Basic Data, Relationships linked to Tracking, Actions and Tasks linked to Proposals or Planned Giving). This symptom was previously seen only with Oracle databases and Windows Server 2003 IIS. |
M16541 | Actions Task | The Change Date + User ID field on Actions Tasks records now display correctly. |
M16594 | Relations | When a relationship row is updated, the reltype field will not be set to blank. |
M16605 | Giving - Membership | The automated Membership process now uses the Dues Effective Date (dueseffdat) instead of the Dues Process Date (duesprocdt) as the Membership Renewal date. Membership Expiration Date calculations will also use the Dues Effective Date instead of Dues Process Date. |
M16718 | Giving | Credits for pledge payments that pay down a multiple allocation pledge will display under each allocation. Prior to this correction all credits for pledge payments displayed under the first allocation only. |
M16725 | Giving | When editing an allocation for a Purpose (giftrest/duesrest) that has been set to Inactive (after the allocation was first created), the Purpose field will not be set to blank. |
M16744 | Relations | The IIS will no longer crash when inserting a Relation row via Default when the Relation insert form has been customized. |
M16762 | Search | Last Search will only display the results of the last Profiles search (Profiles > Next Search) that the user performed. Prior to this correction, Last Search was displaying the results of any constituent search (relationship, correspondence, employer, registration, and so forth). |
M16767 | Giving | Users can now link a Gift transaction to an existing Proposal from the constituent's Giving detail page. |
M16858 | Actions | When creating an Action and corresponding Task, the detail view for the newly created action and task now displays the correct record. Prior to this correction, the symptom was previously seen only with Oracle databases, and only when a constituent had a sufficient number of Action records to trigger Paging Data behavior. |
M16958 | Giving | View the detail display for one gift (Edit button menu: Display>Detail). Print the display and only the details for the gift that you are viewing will be printed. |
M17027 | Attribute | The Edit button menu "Link to" options are available for use when they should be. Prior to this correction, the Attribute 'Link to' options were not available when a constituent had a sufficient number of Attribute records to trigger Paging Data behavior. |
Millennium Mobile (SMM)
Issue # | Function | Description |
---|---|---|
M16538 | Linked Attribute Display | The system uses the Linked Attribute data display layout to display linked attributes in the mobile application. Prior to this correction, the system used the Standard Attribute data display layout to display linked attributes in the mobile application. |
M16547 | Citizenship display | When the Citizenship table is removed on the Table Options page, Citizenship data will no longer display in the mobile application. |
M16787 | Find Constituent - Attribute search | If using an attribute code to search for constituents, the search results will be filtered by the attribute codes that match the code that was entered. Prior to this correction, the search results were filtered by the attribute values that matched the code that was entered. |
Reporting
Issue # | Function | Description |
---|---|---|
M16452 | Run Report | Using a replicated reporting server, run a report and save the workfile. You can now run the report again, and use that saved workfile. |
M16483 | Queue | When scheduling the same report to run multiple times, without changing the report name for each scheduled time, the report will run each time that it is scheduled to run (Subsequent scheduled reports are no longer removed from the Queue after the report runs one time). |
M16491 | Visual Analyzer | Visual Analyzer server information will properly load into the cache even if an organization does not have a default SPS merchant account. |
M16755 | View Report | Photos on reports are now displayed when photos are stored in a virtual docs folder. |
M16959 | Print Criteria | Information about report criteria can be printed even if no format is specified. |
System Wide
Issue # | Function | Description |
---|---|---|
M16534 | Insert and Update forms | If the first field on an insert or update form is a drop down list, when the form is loaded, the system will now place the cursor on that first field. |
M16871 | Zipcodes | If the connection with the database is lost while inserting or updating a form that contains a zip code field, the system will display a message to tell the user that the zip codes table could not be read. Prior to this correction, the system displayed an invalid zipcode message. |
M16896 | System Reset/Reboot | If one of the following occurs - IIS server reboot, IIS reset, worker process recycle, or worker process crash - and a user who was logged into Millennium before one of the listed events occurred attempts to post a transaction to the database, the system will display a 'You are not properly logged in to Millennium' message. Prior to this correction, the IIS would crash. |
Tools
Issue # | Function | Description |
---|---|---|
M16233 | Lookups - Correspondence Name | When inserting or updating a Correspondence Name lookup table entry, Solicitation can be a non-required field even when an active blank entry does not exist in the Solicitation lookup table. |
M16451 | System Options - Paya Payment Solutions | The Allow accounts to be saved for future use check box now functions correctly. It the user clears it, it remains clear. If the user selects it, it remains selected. |
M16752 | Years Utility | The Include current year in consecutive years giving check box now functions correctly. If the user clears it, it remains clear. If the user selects it, it remains selected. |
M16999 | Custom Display Designer (Customizer) | The derived ALLOCATION field is no longer available for gifts and dues display page layouts. Prior to this correction, including the ALLOCATION field on the Detail display page layout would log the user out of the system when he/she switched from Detail display to either Mini, Short, or Long. |
M17079 | Lookups - Relation Pairs | An error will not longer occur when you try to insert or update an entry in the Relation Pairs lookup table on which you have limited Millennium User Group Access. |
Other
Issue # | Function | Description |
---|---|---|
M16426 | Community Brands Auto Update | The license expiration message no longer displayed. |
M16979 | Log On - System Security | Users are no longer able to inject SQL commands by using the User ID field on the Millennium log on page. |
M17066 | Log On - Java | For organizations that use a secure connection (SSL) to access Millennium, the system will not perform the Java and correct Java version check. |