iMIS Version on a Windows 7 Dual Core Machine

  iMIS Version
  iMIS Version Date  07/16/2010
  Omnis Version  3.6.4
  Omnis AX Version  3.50

How to generate New and renewed CM members export report?

Our organization upload list of new and renewed corporate members to our website monthly and I'm trying to find a simple way to export these list to excel from iMIS. Is there iMIS built in report (crystal?) that shows new and renewed members? eg. all members who become new member by paying membership (from biling or on-line) in specific month and members who renewed in same month? We need to export report to excel file for web diretory update.  Currently,  I created two ad-hoc quaries; One using Join_Date (new member) field and renew with MT_CHANGE_DATE (member type change), but this search option is not accurate and doesn't pick up member when join_date value is missing...
Please advise me if you have better solution for this report. Thanks,
*We currently use iMIS V15.1.2

Replace SQL

I need your help. I have been tasked with a project of updating Address_1 and Address_2 in the Name_Address table. I found some script that will work but ran into a snag and need some help.

On a test table, I ran the following script to correct an address of 105 Drake Dr

UPDATE tempjohncross
SET Address_1=(
REPLACE (Address_1,

The script fixed the record as 105 Driveake Drive

Adding Java to ContentArea1

Below is Java Script that my organization would like to add to our website. It is nothing fancy just links to print, post to facebook , email content, etc. I can get this to work in plain html, but fails to work when I put this in WCM editor. Any help would be greatly appreciated.

<!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style ">
<a class="addthis_button_preferred_1"></a>
<a class="addthis_button_preferred_2"></a>
<a class="addthis_button_preferred_3"></a>
<a class="addthis_button_preferred_4"></a>
<a class="addthis_button_compact"></a>
<a class="addthis_counter addthis_bubble_style"></a>
<script type="text/javascript" src=""></script>
<!-- AddThis Button END -->

Business object designer error after creating object with wrong Properties.


I have created a business object in BOD and somehow saved it with the wrong properties and published. Now when I try to open BOD from iMIS I am getting following server error:


Server Error in '/iMIS15' Application.

MaxLength applies to string data type only. You cannot set Column 'DecisionDate1' property MaxLength to be non-negative number.


Business Object only returns column names.

The SQL returns 3 rows and the rows shows an array of 4 rows including the field names.

Normally the ds would be filled with a data adapter.


private DataSet getCommitteeCodesObject(Guid transactionID, string credentials, string error)

                DataSet ds = null;
                Asi.iBO.ContentManagement.CWebUser user = null;

SOA bindings and 'rest' service

A couple questions.

1) The SOA services are setup by default with a netTcp binding. I noticed right away the configuration changes they had made (amazingly high maximum lengths), and I'm wondering if there's a listing of other example bindings anywhere, say for SOAP connectivity.

(If not, I'm just going to continue with the plan of modifying a base configuration, which I assume will be fine, but having worked with iMIS ...)

Appyling patch generating error

Trying to install this patch I am getting the following error:

Truncating iMISTable...
Bulk-Loading iMISTable... 
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid format file version


Can anyone shed any light?

Method to Set LookupCodeDescription

This was an easy function to use GetLookupCodeDescription.


Is there a method to write to the gen_tables?

Is there a BO like

 Asi.Business.BusinessContainer container = new Asi.Business.BusinessContainer();
     Guid groupTypeKey = Asi.Business.Common.GroupType.iMISModuleUsers;         
     Asi.Business.Common.GroupController controller = Asi.Business.Common.GroupController.NewGroupController(container);
     Asi.Business.Common.Group newGroup = controller.Add(groupTypeKey);
     Asi.Business.Common.Group newCommitteeGroup = controller.Add(groupTypeKey);
     newGroup.Name = "My New Group";
     newGroup.Description = "Group for managing contacts";

ASP.NET MVC Web site authenticating against iMIS Membership Web service

We have a number of custom administrative tools that we're moving into a separate, internal-only, Web site.

Currently the applications use their own ASP.NET authentication tables, but it would be ideal to leverage the information contained within iMIS directly. Not single-sign on, but sign-on validating against iMIS.

Since we've already got the site setup, I wanted an addition that would impact the site as little as possible. For that reason, I decided to first look at the Membership Web services - methods returned by the service and some detail on as well - and see if we could successfully leverage that.

Syndicate content