knowledge base

SQL Script to detect invalid products in iMIS member type table

VanDamme Associates — Wed, 14 May 2008 14:45:06 GMT

iMIS does not have referential integrity between the member type table and the products table. We have recentely come across a number of iMIS implementations where products are listed on the member type table but have been deleted. This will

Incorrect Mail or Bill prefrences causing Customer Portfolio shutdown or iBO issues

VanDamme Associates — Wed, 14 May 2008 14:43:52 GMT

iMIS customer portfolio issues are often caused by incorrect setting of preferred mail or preferred bill address indicators. In particular an addreess may be designated as the preferred address indicator in the name table (Name.MAILADDRESSNUM or Name.BILLADDRESSNUM) but the preferred

Detecting and Fixing iMIS records with duplicate address purposes

VanDamme Associates — Wed, 14 May 2008 14:41:56 GMT

Ever see a record in iMIS with multiple tabs for the same address purpose. This query will detect records that have more than one address with the same address purpose SELECT ID, PURPOSE, Duplicates=count( ) FROM Name_Address GROUP BY ID,

Script to detect invalid prefixes in iMIS records

VanDamme Associates — Wed, 14 May 2008 14:41:09 GMT

The iMIS Business Objects (iBOs) often malfunction when invalid data is present within the iMIS database. How does this invalid information get in there in the first place? Typically this issue is a result of something being missed during a

Insert missing iMIS UDT records for user defined tables

VanDamme Associates — Wed, 14 May 2008 14:40:33 GMT

When iMIS user defined tables (UDTs) are marked as 'Always Create' there should be a corresponding record in the UDT for every record in the Name table. Unfortunately, this can get our of sync pretty easily. The most common reasons

Locate subscription records that references non-existent products in iMIS

VanDamme Associates — Wed, 14 May 2008 14:38:36 GMT

We had a situation last week week where VanGo was not able to process an online dues payment. We traced the issue to a product on the iMIS subscription table that did not exist in the iMIS product table. Unfortunately

Detect customer or dues setup reference to invalid or non-existant products in iMIS

VanDamme Associates — Wed, 14 May 2008 14:36:45 GMT

iMIS will let a user delete products from the Products table even if that product is referenced in the customer types setup. This will cause issues with the Dues processing in back end iMIS, iMIS Business Objects (iBOs), VanGo

Finding substring codes that are used in iMIS general lookup validation tables

Amy Button — Wed, 14 May 2008 13:57:01 GMT

iMIS has the ability to have a long string field that contains multiple values (driven from a general lookup validation table). One good rule for these codes is that no code value in a particular table is a substring of

Creating a Master Product for iMIS 15 Public View

Sig VanDamme — Fri, 02 May 2008 10:51:25 GMT

In iMIS 15 you can set up a master product (like 'Conference 2008 Tshirt') and tie that product to multiple product codes with various attributes (like Size, Color) so that your members only see

Applying Standard Tax to iMIS 15 Web View Orders

Sig VanDamme — Fri, 02 May 2008 10:42:11 GMT

In iMIS15, the logic for "standard" tax (that is, tax based on the state or city) for web view orders is applied based on the settings in Orders > Set up module > Web, as follows If the "Use customer's