http://www.vandamme.com/feeds/blogs/all.aspxhttp://www.vandamme.com/blog.aspx?id=1568 <p>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</p> VanDamme AssociatesWed, 14 May 2008 14:45:06 GMThttp://www.vandamme.com/blog.aspx?id=1566 <p>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</p> VanDamme AssociatesWed, 14 May 2008 14:43:52 GMThttp://www.vandamme.com/blog.aspx?id=1564 <p>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,</p> VanDamme AssociatesWed, 14 May 2008 14:41:56 GMThttp://www.vandamme.com/blog.aspx?id=1562 <p>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</p> VanDamme AssociatesWed, 14 May 2008 14:41:09 GMThttp://www.vandamme.com/blog.aspx?id=1560 <p>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</p> VanDamme AssociatesWed, 14 May 2008 14:40:33 GMThttp://www.vandamme.com/blog.aspx?id=1558 <p>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</p> VanDamme AssociatesWed, 14 May 2008 14:38:36 GMThttp://www.vandamme.com/blog.aspx?id=1556 <p>&#160;iMIS will let a user delete products from the Products table even if that product is referenced in the customer types setup. &#160; This will cause issues with the Dues processing in back end iMIS, iMIS Business Objects (iBOs), VanGo</p> VanDamme AssociatesWed, 14 May 2008 14:36:45 GMThttp://www.vandamme.com/blog.aspx?id=1550 <p>iMIS has the ability to have a long string field that contains multiple values (driven from a general lookup validation table).&#160; One good rule for these codes is that no code value in a particular table is a substring of</p> Amy ButtonWed, 14 May 2008 13:57:01 GMThttp://www.vandamme.com/blog.aspx?id=1542 <p>We are excited to announce that the Pennsylvania Bankers Association VanGo pop off site went live at the end of February, Now that the project has been officially closed we would like to share some of the project highlights Project</p> VanDamme AssociatesFri, 09 May 2008 13:21:48 GMThttp://www.vandamme.com/blog.aspx?id=1528 <p>Sometimes the simplest product can gain the most attention. This week the Thumbthing Nouse award for the coolest product. This device will let you hold open the pages of a book easily with just one hand. There was some tough</p> VanDamme AssociatesThu, 08 May 2008 16:00:22 GMT