iMIS Community

Not able to retrieve field from Gen_tables with CContact.GetContacts method.

When using the method "CContact.GetContacts((IiMISUser)user, addlFrom, where.ToString(), sqlParam)", is it acceptable to add the "Gen_Tables" in the following manner?

String addlFrom = String.Empty;
addlFrom = " INNER JOIN GHP_Company on Name.ID = GHP_Company.ID";
addlFrom = addlFrom + " INNER JOIN Gen_Tables ON GHP_Company.NAICS_1 = Gen_Tables.CODE";

StringBuilder where = new StringBuilder();
where.Append(" AND Name.ID = @ContactId");
where.Append(" AND Gen_Tables.TABLE_NAME = 'NAICS_DESCRIP'");

T don't get an error but, I'm not able to find the field "DESCRIPTION" from "Gen_Tables" in the results. I've tested this in sql to be sure that the field has a value.

Any suggestions?



Registration.Payment Error

When attempting to set the either the credit card #, security code, or expiration date of the "Payment" object under CRegistration an exception is thrown - "Could not load file or assembly 'Asi.Lexicon' or one of its dependencies. The system cannot find the file specified."

Code snippet:

var reg = new Asi.iBO.Events.CRegistration(IBOSystem.SystemUser, obj.EventCode, obj.RegistrantContactId, false, false) API and retrieving contact info from multiple tables.

I just want to retrieve some member company information from the imis database which would also include a couple user defined tables. I'm using C# and the api. How do I perform this task? I tried CContacts.getcontacts(), but I am unable to join the user-defined table to get all of the info returned. Is there a way to use a view that would include all the necessary tables.

I can do this in sql but I'm trying to stay with so that we don't have any upgrade problems in the future. We are just getting started and want to re-write many of our online functions. I've looked at iParts, but they are just not flexible enough for now.

removing CAG from content folders

We've recently run across a situation that has brought a recently discovered defect in iMIS (SMR 278719 "Imported content containing access settings other than the standard system access settings will cause an error when editing the imported content record.") into a project.

We've got a dev instance (running 15.2.15) of a couple WCM websites the content was originally migrated (using the migration tool) from eSeries. We've recently made a dry run to test a full upgrade (from 10.6 to 15.2.15), the content was exported from DEV and imported into PROD. The migrated content folders all had residual content authority group (CAG) settings from the eSeries content. Of course the CAGs are not exportable, so recreating them in the PROD instance doesn't work because the new CAG has a different GUID, so publishing is failing on virtually every content record due to the Foreign Key restraint. The game plan, at this point - to get things up and running in the PROD environment to continue user testing - is to remove the CAGs from the content. This requires a very tedious and manual process to remove the CAG setting from each folder.

Direct Debit - Mimimum reference of 6 digits

Taking Direct Debit - BACS

iMis ID's can be a minimum of 5 digits.  Has anyone managed to get around the problem of Direct Debit payments where the reference number needs to be a minimum of 6 digits?   I would greatly appreciate any advise on this.

Thank you


nice easy question (i hope)

This is probably a very stupid question so apologies in advance for asking it, as its a basic functionality, so expect it is quite easy to do when you know how.
With the Contact Sign In ipart - how do I set a separate page to be loaded when a member has logged in.
The ipart is on our homepage. When someone has logged in I want them to be taken to a page where they can check all their membership details (address, qualification details etc) and update them if necessary.

Introduction to iMIS SDK

Has anyone taken the Introduction to IMIS SDK course that ASI provides? Did you find it beneficial?

IQA - Concatenating Fields and Text as SQL expression

We're using

Have an IQA query and wish to display concatenated output using a SQL expression on Display tab.

I can get plain text to display.  For example, entering 'My test text' in quotes displays as expected.
I can get a field from my business objects to display.  For example, entering 'vBONetContact.FirstName' (without quotes) also works.

Attempts to concatenate both text and variables fails.  My syntax is in the form:-

Small Business Server 2011 and iMIS Error

When trying to install iMIS on a Windows Small Business Server 2011 Standard 6.1 With SQL add on, I received the following error: The version of this file is not compatible with the version of Windows you're running.   Check your computer's system information to see whether you need an x86 (32-bit) or X64(64-bit version of the program,
and then contact the software publisher.

User activity in WCM

We have an application that will be authenticating with the WCM login to provide access to some generated html pages.  We need to be able to keep track of the activity (clicks) on these html pages. In ASP.NET this activity could be captured in a Global.asax page. Since we don't have access to the Global.asax, I was wondering if there is a mechanism in WCM that keeps track of user activity? If not, is there a way to customize the functionality of the Global.asax so we can capture the request event?