iDMS release notes: 2022 and 2023

The following features, enhancements, and fixes are included in the iDMS releases from 2022 and 2023, listed from newest to oldest.

iDMS 1.22 - November 2023

Release date: November 30, 2023.

Features

  • Generating renewals. See the iDMS documentation to learn more.
  • Updating product inventory. See the iDMS documentation to learn more.
  • Deleting subscriptions. Subscriptions can be deleted.
  • County field. The County field can be updated and inserted.
  • Modified the loading message. The message now indicates when the task is running.

Fixes

  • Fixed an issue where users logged in to iDMS for an extended period received the error "" is not a valid version" when they returned.
  • Fixed an issue where Limit the number of results returned in an IQA was not respected by the API endpoint. The value is honored.
  • Restricted the creation of an _ORG-ADMIN relationship between two individuals, which is not valid.
  • Fixed an issue where _ORG-ADMIN in iMIS 2017 was not correctly identified, resulting in a "Not a valid role" error.

iDMS 1.21 - September 2023

Release date: September 26, 2023.

Features

  • Changing IDs on multi-instance panels. If information was imported into the multi-instance panel of the wrong person, the ID can be switched or updated to the correct one.
  • Communication Message Type. The Communication Message Type can be set on the Communication Log source.
  • IsComplimentary flag. The IsComplimentary flag is available in the Subscriptions source mapping.
  • Appending data to multi-select fields. When updating a multi-select field, a single choice can be added while all previous values remain unchanged. See the documentation under "Selecting and Mapping a Field."
  • Email address validation. When importing or updating member email addresses, iDMS validates that the address is well formed.
  • Erasing dates. Previously, dates such as Birth_Date could not be erased. Use the option If text below is found in File, then field in iMIS will be blanked out to erase a date.

Fixes

  • Fixed an issue where entering a date while mapping an import saved the date as the previous day.
  • Fixed an issue where deleting an activity for a member also deleted their cart, if one existed.
  • Removed the Delete option for panels that combine multiple tables, which caused significant issues: AutoPayInstructionDetail, AutoPayMemberInstructionDetail, CsContact, CsName_Staff, CsNameFin, CsNameNote, FundraisingProfileDonorData, VolunteerAvailability, VolunteerHistory, VolunteerInformation, and VolunteerSkills.

iDMS 1.20 - June 2023

Release date: June 29, 2023.

Features

  • Import orders. iDMS can import orders. Pay close attention to the Order Grouping field.
  • Import pledges. Pledges can be imported, completing the fundraising feature set.
  • Committee attributes. The attributes on a committee product or group can be updated.
  • CompanyID removed from CsContact. The field is removed to prevent data corruption.
  • Failed notification. The "Failed" notification accounts for partial failures.
  • Client time zone. The client time zone is supported on date input.
  • Messaging when importing user credentials. User credentials must be created using Insert. The error message shown when attempting an Update has been clarified. Unlocking user credentials is still done using Update.
  • ID validation. iDMS checks that an ID of "0" is not submitted, which previously caused problems in iMIS.
  • Health check. The health check feature is enabled.
  • Sources redefined and grouped. Sources in iDMS are grouped into Records Management and Finance, making them easier to find.
  • Action buttons refreshed. The action buttons have been cleaned up to clarify when to use Insert with Matching and when to use Insert.
  • Skip Update if More Than One Record Found. This option defaults to on.

Fixes

  • Increased the client timeout to five minutes to allow client endpoints to reconnect and process. Previously, if iDMS waited longer than 100 seconds it returned an error and retried the action later. The error message now indicates that iDMS will retry the insert or update later, so the action is not retried accidentally.
  • Fixed relationship upsert for iMIS 2017 users.
  • Fixed an issue where creating a new task could duplicate it, resulting in two tasks pointing to the same import ID.
  • Fixed an issue where a user-defined table that is also set up as a business object caused iDMS to import it as a business object and error out.
  • Fixed the "Skipped BO" message, which should read "Created".
  • Fixed an issue running an IQA with parameters in EMS Professional.

Hotfixes

  • v1.20.1 (June 29, 2023): Fixed an issue where the message could falsely report multiple rows affected when Skip update if more than 1 record found was selected.
  • v1.20.2 (July 6, 2023): Fixed an output message, and fixed an issue in Groups where system groups were excluded.
  • v1.20.3 (August 7, 2023): Fixed an API error when unlocking a user account.

iDMS 1.19 - March 2023

Release date: March 27, 2023.

Features

  • Dashboard filtering. Drill down into Completed, Failed, and Recurring jobs.
  • Guidance for unknown import errors. Step-by-step instructions are provided.
  • Enhanced action buttons. The action buttons (Insert, Insert with Matching, Update, Insert/Update, and Delete) provide a clearer user experience.
  • Examples for event registration questions and indexes. Clear examples are provided.
  • General UI and UX enhancements.
  • Relationship dates. Begin Date, End Date, and Description are available in the Relationship data source.
  • Interactions as a data source. Add, edit, and delete interactions using the Communication Log data source.
  • Adding group members. Group members can be added.
  • Chapter Administrator relationship. Chapter Administrator is available in the Relationship data source, allowing the role to be added, updated, or deleted within the relationship.
  • Internal database object improvements.
  • Clearer skipped-record description. The description is clearer when a record is skipped on an Update action and Skip update if more than 1 record found is selected.
  • IQA renaming. Renaming an IQA is recognized. Previously, renaming an IQA was not detected because the IQA's unique identifier was saved instead of its name. As a result of this change, IQAs with slashes in the name are no longer supported.

Fixes

  • Fixed an issue where tasks and jobs cancelled with different parameters.
  • Fixed an issue where the Insert/Update action did not work when supporting two or more data sources.
  • Fixed an issue where a failed import did not send a notification and did not trigger the disable job feature after the configured number of failed attempts.
  • Fixed an issue where viewing the summary details returned "Buffer cannot be null".
  • Fixed an issue where the Last Run date column was blank when viewing scheduled jobs.
  • Fixed an issue for iMIS Professional where the Payments data source was not valid for that version.

Hotfixes

  • v1.19.3 (April 10, 2023): Fixed an issue where updating relationship dates could fail to match because of the GroupMembershipId.
  • v1.19.4 (April 14, 2023): Fixed an error when changing the IQA in a scheduled job.
  • v1.19.4 (April 14, 2023): Fixed an error when matching on CsContact.ID.
  • v1.19.4 (April 14, 2023): Fixed an error where the Relationship source did not match on Type.
  • v1.19.5 (May 9, 2023): Fixed an issue with the Relationship source to allow use of Title and date settings.
  • v1.19.5 (May 9, 2023): Fixed a cart error on the Delete action.
  • v1.19.5 (May 9, 2023): Removed CsContact fields from the source that cannot be set by the API: Member Status, Member Status Date, Member Type Change Date, and Previous Member Type.

iDMS 1.18 - December 2022

Release date: December 28, 2022.

Features

  • Microsoft .NET 6. The Microsoft .NET 6 framework is implemented.

Hotfixes

  • v1.18.5 (December 31, 2022): Fixed an issue with POSTing feeds redirection.
  • v1.18.6 (February 9, 2023): Fixed an issue with missing match-on field detection.
  • v1.18.7 (February 10, 2023): Amended how the Update action found entities.
  • v1.18.8 (February 17, 2023): Fixed an issue where matching across entities did not produce the expected results.

iDMS 1.17 - November 2022

Release date: November 7, 2022.

Features

  • Triggering an iDMS job from another source. See the online documentation.
  • BillSubscription flag flexibility. When inserting subscriptions, the bill amount can be set, a subscription can be added without billing the contact, and more. See the enhancement details.
  • Handling unknown errors from the REST API. When iDMS receives a vague error from a REST API call, a stepped troubleshooting process is provided.
  • Full name tribute. When adding a gift, the full name tribute can be added instead of specifying the iMIS ID.
  • Clearing the shopping cart. The Delete action can be used to clear member shopping carts.
  • Skip Blank Match On. This option defaults to on. At runtime, if any match-on fields have a blank value, the record is skipped.
  • Adding files to File Content fields in panels. Only the public file URL is required when adding a file to a panel field.
  • Template sorting. iDMS templates are sorted alphabetically.

Fixes

  • Fixed an issue where, on Insert of a contact record, if the member type was not specified and the default member type did not have Is Member specified, the record was added as a company record. A person record is created.
  • Fixed an issue where the Gift Date was not set to the Transaction Date when importing fundraising records without a specified gift date.
  • Fixed an issue when deleting a Company Admin relationship.
  • Fixed an issue when creating inactive subscriptions.
  • Fixed an issue where updating a panel created a new record if one was missing.
  • Fixed an issue where iDMS attempted to process blank rows in the import.
  • Fixed an issue with the license check on iUpdate jobs. Jobs stop running when a client agreement becomes null or invalid.
  • Fixed an issue where iDMS did not recognize the value when using Limit Rows within an IQA.
  • Fixed an issue where iDMS defaulted date fields to 12:00:00 AM. The time value is read on import.
  • Fixed an issue when inserting a duplicate username or login. A clear message is returned to the user.

iDMS 1.16 - September 2022

Features

  • Coming soon: linking Cloud IDs. Organizations with multiple Cloud IDs can link them within the cloud dashboard under My Account, then use iUpdate to run IQAs from the linked Cloud IDs.
  • Importing event registrations. Event registrations can be imported in bulk into EMS through iImport.

Fixes

  • Fixed an issue where Continue On Error did not work for scheduled tasks.
  • Added the Incurs Shipping Charges checkbox for the Products data source.
  • Fixed an issue where a panel record was created even when the ID did not exist in Contact.

iDMS 1.15 - August 2022

Features

  • Products in Cloud Professional. Commerce products and gift items can be created and updated in iMIS 100.3.

iDMS 1.14 - July 2022

This release focused on enhancing the user experience and adding the ability to work with invoices and dues payments.

Features

  • Paying open invoices. Open invoices can be paid by providing the relevant invoice information in the import file.
  • Overpaying dues payments. Dues payments that overpay what is owed can be imported. When a member's dues billing is overpaid, a pre-pay AR item is created for the member.
  • Enabling and disabling iSchedule tasks. iSchedule tasks can be enabled and disabled.

Enhancements

  • Match on this Field. The wording is improved for clarity.
  • iSchedule task sorting. iSchedule tasks can be sorted by column headers.

Fixes

  • Fixed an issue where job failure email notifications did not always execute as requested.
  • Fixed an issue where the Continue with Update button was not disabled when Require Match On was selected but no Match On field had been defined.
  • Fixed an issue where re-saving a template did not honor the previously saved category.
  • Fixed an issue where a scheduled task would not delete when its corresponding IQA query no longer existed.
  • Improved job detail logging where lengthy mappings made logged entries difficult to review.

iDMS 1.13.3 - May 2022

Release date: May 5, 2022.

This release focused on providing additional import destinations such as products and standalone panels, enhancing validation and error messaging, and adding safeguards.

Features

  • Match On Only One Record. This option builds a failsafe into jobs so that if more than one record with a particular ID would be affected, the job aborts.
    • This protects against unintended overwrites. For example, when importing activities, a mistake could otherwise overwrite all activities for the affected records. If a job should only look at one activity per ID, enabling this option ends the job as soon as a second match is found.
  • Importing products. Product variations, such as multiple color and size combinations, can be imported.
    • EMS: Product definitions can be imported.
    • iMIS 2017: Products can still be imported using the CsProduct business object. Other tables and objects, such as Product_Price and Product_Inventory, might also need to be updated in 2017.
  • Support for Insert/Update to standalone panels. Previously, an insert or an update could be done to a standalone panel, but not both at the same time. This is particularly useful for multi-instance standalone panels.
    • EMS: Single and multi-instance standalone panels can be a destination for the Insert/Update import type.

Enhancements

  • Billing payments. Billing payments support importing a check number.
  • Matching on contact fields. Matching is available on nearly any contact field to make the most of any dataset.
  • Validation checks on inserts. Validation ensures that the ID is mapped.
  • Validation checks on contact inserts. Validation ensures that either last name or company is mapped.
  • Speed improvements. Loading business objects is faster, making mapping quicker.
  • Error logging details. Error logging details can be accessed on the Log Summary screen.
  • Log housekeeping. Logs are kept clean and easy to read.
  • Miscellaneous updates. The iDMS infrastructure is updated.

Fixes

  • Clarified error messaging when matching iMIS ID on a user-defined table.
  • Clarified error messaging when importing billing products and matching on Major_Key.
  • Clarified error messaging when an iUpdate query has been deleted or its path has changed.
  • Fixed an issue where billing payments displayed for iMIS 2017 environments.
  • Fixed an issue when deleting scheduled tasks.
  • Fixed an issue with expression builder fields in a query.
  • Fixed an issue where retrying jobs failed when working with slow queries.
  • Fixed an issue when importing a product without a category.
  • Fixed an issue when importing to multi-instance panel sources.
  • Fixed an issue when retrieving Cloud IDs from the service fabric.
  • Fixed an issue where subscriptions displayed for iMIS 2017 environments. To import subscriptions in 2017, use the CsSubscriptions business object.

Hotfixes

  • May 12, 2022: Fixed an issue where IQA query filters incorrectly displayed as undefined.
  • May 19, 2022: Fixed an issue where IQA queries required aliases to process correctly. Field aliases are no longer necessary.
  • June 22, 2022: Fixed an issue where the state/province field was incorrectly cleared for addresses in the United Kingdom.

Did this page help you?